LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #7   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.misc
JC
 
Posts: n/a
Default Mortgage calculation after a large extra payment

On Sun, 16 Apr 2006 01:15:07 GMT, "Gary Wachs" wrote:


Ok good - outstanding, that's exactly what I needed.

In your opinion is it a good idea to make this contribution.
Having crunched the numbers it certaintly looks worthwhile. It makes PMI go
away, it saves $80k and it shortens the loan by 6 yrs.
Historic S&P growth of about 12% annually, if it continues, would outperform
the above savings. Maybe I should put the money into the market instead of
the principal.


You have a few things to consider with your extra payment.

1. Repayment
What happens is that you make the extra payment when your $1 is worth $1 but the
return on that investment doesn't come back to you until the end of the loan
period when the $1 is worth say $0.80. In your case if the $1 was worth $0.80
at the end of the loan period and you invested $25,000 you would need to save
paying in excess of $31,250 due to shortening the loan period to make it
worthwhile.

2. Investing
If you invested the $25,000 for the period of the loan you would also have to
consider how much tax you would need to pay on the investment.

What you then need to do is to deduct the tax from the interest earned each year
for the period of the loan and do a present worth analysis over the shortened
period of the loan on the difference each year to take into account that the $1
in say 10 years is worth say $0.80 and compare this with the amount returned by
the repayment in 1. above to finally have your answer.
--

Cheers . . . JC
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
need template on mortgage loan with extra paymts where can i find Raine Charts and Charting in Excel 0 March 14th 06 03:18 AM
need a function to calculate a mortgage payment bpeltzer Excel Worksheet Functions 0 November 7th 05 12:09 AM
monthly mortgage payment calculator Raza Excel Discussion (Misc queries) 2 October 17th 05 01:35 PM
Trying to Manipulate a Mortgage Payment (HELP!) DC Excel Worksheet Functions 1 February 4th 05 05:49 PM
how do you get a positive number payment with a mortgage payment . sam Excel Worksheet Functions 1 February 2nd 05 05:32 AM


All times are GMT +1. The time now is 02:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"