I need to find someon who has some mastery with excel. Im a mortgage consultant, and I am trying to explain the "mortgage cycling" process to one of my clients. Would you be able to help me customize the work already performed in the attach excel spreadsheet so that my clients could easily understand the mortgage cycling payoff years?
You see...i want something like this attached - a customized solution...the graph is not really nessesary unless you know how to do it. This is a screen shot from one of the hundreds of companies that are popping up these days selling software which is no more than just glorified excel sheet - to keep track of mortgage cycling.
I just want to be able to show my clients with an excel spreadsheet, what affect a lump sum payment of $10,000 every six months would have on their mortgage. I have found many bi-weekly excel mortgage calculators, and amortization schedules, but none that is displayed in the formatting like I like it to be. This is going to require that you edit the amortization schedule to reflect the repayment time in "years".
I want to being able to illuminate for the client that they can shave xxxxxx amount of years off their mortgage by applying 10,000 additional lump sum payment each year (that sum will of course be editable - along with the frequency of that optional extra payment - whether its monthly, quarterly, annually,etc). The main thing is that the client is able to instantly realize with a side by side comparison of a Conventional mortgage program vs. a $10,000 every 6 months type program as displayed in picture , what affect that is having on the pay off of their mortgage (in YEARS, not in months - months is too confusing for them) and then displaying the TOTAL interest paid over life of the loan when doing $10,000 lump sum payment every six months. If I can effectively communicate this to them, then selling the interest cancelation account idealogy is easy, as far as using a HELOC as the primary checking account.
Is this something you would have the the time to help me with if I paid you in paypal? thanks a lot! -taylor
p.s. here is the link to download what I have already been trying to shape and form - u will find the orginal one which is a good starting point, and then my attempt...: http://www.loopwise.com/loan_calc.zip
You see...i want something like this attached - a customized solution...the graph is not really nessesary unless you know how to do it. This is a screen shot from one of the hundreds of companies that are popping up these days selling software which is no more than just glorified excel sheet - to keep track of mortgage cycling.
I just want to be able to show my clients with an excel spreadsheet, what affect a lump sum payment of $10,000 every six months would have on their mortgage. I have found many bi-weekly excel mortgage calculators, and amortization schedules, but none that is displayed in the formatting like I like it to be. This is going to require that you edit the amortization schedule to reflect the repayment time in "years".
I want to being able to illuminate for the client that they can shave xxxxxx amount of years off their mortgage by applying 10,000 additional lump sum payment each year (that sum will of course be editable - along with the frequency of that optional extra payment - whether its monthly, quarterly, annually,etc). The main thing is that the client is able to instantly realize with a side by side comparison of a Conventional mortgage program vs. a $10,000 every 6 months type program as displayed in picture , what affect that is having on the pay off of their mortgage (in YEARS, not in months - months is too confusing for them) and then displaying the TOTAL interest paid over life of the loan when doing $10,000 lump sum payment every six months. If I can effectively communicate this to them, then selling the interest cancelation account idealogy is easy, as far as using a HELOC as the primary checking account.
Is this something you would have the the time to help me with if I paid you in paypal? thanks a lot! -taylor
p.s. here is the link to download what I have already been trying to shape and form - u will find the orginal one which is a good starting point, and then my attempt...: http://www.loopwise.com/loan_calc.zip
