 |
04-18-2008, 03:38 PM
|
#1
|
|
Recycles dryer sheets
Join Date: Oct 2007
Posts: 463
|
Mortage Refinance Math?
Okay, how does this work? (Numbers are made up; I'm looking for the underlying math.)
Assume I took out a $200,00 30-year fixed mortage at 6% several years ago, have been making extra principal payments, and the statement now shows that I have ten years to go if no more extra principle payments are made.
If a ten-year fixed mortage at 6% is available with no closing costs, if I refinance with it for the remaining principal balance, do I come out ahead, exactly even, or behind? How does the math work on this? :confused:
__________________
TickTock Rule Of Finance - heavily discount any promises of money/benefits to be paid to you in the future
"I've traded love for pennies, sold my soul for less" -Jim Croce, Age
|
|
|
 |
Join the #1 Early Retirement and Financial Independence Forum Today - It's Totally Free!
Are you planning to be financially independent as early as possible so you can live life on your own terms? Discuss successful investing strategies, asset allocation models, tax strategies and other related topics in our online forum community. Our members range from young folks just starting their journey to financial independence, military retirees and even multimillionaires. No matter where you fit in you'll find that Early-Retirement.org is a great community to join. Best of all it's totally FREE!
You are currently viewing our boards as a guest so you have limited access to our community. Please take the time to register and you will gain a lot of great new features including; the ability to participate in discussions, network with our members, see fewer ads, upload photographs, create a retirement blog, send private messages and so much, much more!
|
|
04-18-2008, 03:49 PM
|
#2
|
|
Thinks s/he gets paid by the post
Join Date: Jun 2006
Location: Boise
Posts: 4,924
|
Depends on how you mean "the statement now shows that I have ten years to go" and what you mean by "ahead" and "behind".
If you mean that if you continue to make the original scheduled monthly payment then your balance will be zero in ten years, then refinancing to the new mortgage would put you basically even. The one caveat is that usually in a refinance you will end up with an extra month in there where you don't pay down the balance, so in all likelihood you would pay the new 10 year loan off in something like 10 years and 1 month from now.
2Cor521
__________________
"At times the world can seem an unfriendly and sinister place, but believe us when we say there is much more good in it than bad. All you have to do is look hard enough, and what might seem to be a series of unfortunate events, may in fact be the first steps of a journey." Violet Baudelaire.
|
|
|
|
|
04-18-2008, 05:48 PM
|
#3
|
|
Thinks s/he gets paid by the post
Join Date: Jan 2007
Posts: 1,177
|
In case you want to fool around with scenarios:
Karl's Mortgage Calculator
|
|
|
|
|
04-18-2008, 07:36 PM
|
#4
|
|
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
Join Date: Mar 2003
Posts: 18,085
|
The treasure trove, from a finance professor who spent his whole career studying all things mortgage: The Mortgage Professor's Website
__________________
"All animals are equal, but some animals are more equal than others."
- George Orwell
Ezekiel 23:20
|
|
|
|
|
04-18-2008, 07:42 PM
|
#5
|
|
Recycles dryer sheets
Join Date: Dec 2006
Posts: 427
|
I would do the math in Excel using the PMT function and do your own amortization, however, 2Cor521 is right - you would break even.
|
|
|
|
|
04-19-2008, 04:31 PM
|
#6
|
|
Recycles dryer sheets
Join Date: Oct 2007
Posts: 463
|
Thanks for the replies!
__________________
TickTock Rule Of Finance - heavily discount any promises of money/benefits to be paid to you in the future
"I've traded love for pennies, sold my soul for less" -Jim Croce, Age
|
|
|
|
|
04-19-2008, 08:32 PM
|
#7
|
|
Administrator
Join Date: Jul 2005
Location: N. Yorkshire
Posts: 28,119
|
 Quote:
Originally Posted by JohnDoe
I would do the math in Excel using the PMT function and do your own amortization, however, 2Cor521 is right - you would break even.
|
This is what I used when calculating my mortgage and it worked great - you can play all sorts of scenarios for yourself. Many moons ago when DD was 5 years away from college I wanted to know how much per month to pay so that my mortgage ended at the same time I started paying college fees. I used my Excel spreadsheet and paid it off in exactly the time table it calculated for me.
__________________
Retired in Jan, 2010 at 55, moved to England in May 2016
Enough private pension and SS income to cover all needs
|
|
|
|
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
|
|
|
| Thread Tools |
Search this Thread |
|
|
|
| Display Modes |
 Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
» Recent Threads
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
» Quick Links
|
|
|
