Welcome to City-Data.com Forum!
U.S. CitiesCity-Data Forum Index
Go Back   City-Data Forum > General Forums > Real Estate > Mortgages
 [Register]
Please register to participate in our discussions with 2 million other members - it's free and quick! Some forums can only be seen by registered members. After you create your account, you'll be able to customize options and access all our 15,000 new posts/day with fewer ads.
View detailed profile (Advanced) or search
site with Google Custom Search

Search Forums  (Advanced)
Reply Start New Thread
 
Old 01-15-2015, 03:53 PM
 
16 posts, read 19,891 times
Reputation: 10

Advertisements

My wife and I built a house and our mortage was 215k in Nov. 2011, we starting pay an extra 850 a month on our loan each month about a year ago.

Our current payoff date is Dec. 2041, and the payoff amount is 189k. I don't know how to set up a mortgage calculator to show me how much applying 10k extra next month would save as far as time and interest on our loan.

If I plug in our existing numbers of 189k and 322 months remaining the monthly payment doesn't match our base monthly payment of 1011.01 per month, so I'm not sure if I am figuring the amounts correct or not.

Can anyone please help me with this. Thanks so much.
Reply With Quote Quick reply to this message

 
Old 01-15-2015, 04:08 PM
 
Location: Boise, ID
8,046 posts, read 28,486,679 times
Reputation: 9470
Free Home Mortgage Calculator for Excel

Best calculator I've ever found for figuring this sort of thing, if you have Excel.
Reply With Quote Quick reply to this message
 
Old 01-15-2015, 05:27 PM
 
16 posts, read 19,891 times
Reputation: 10
By the way my interest rate is 3.875
Reply With Quote Quick reply to this message
 
Old 01-15-2015, 06:15 PM
 
913 posts, read 886,745 times
Reputation: 1747
I like to use Bankrate's mortgage calculaor. In order to be accurate, you would have to put in your info and also put in your principle payments. Then there is a spot where you can put in your one time 10,000 payment and see what it knocks off the end of your amortization schedule.

When you try to figure 189k at 3.875 for 322 months, it is giving you a lower payment because of the principal payments. When in reality, your principle payments just knock off months of payments at the end and do not lower you monthly payments.
Reply With Quote Quick reply to this message
 
Old 01-15-2015, 09:10 PM
 
16 posts, read 19,891 times
Reputation: 10
Quote:
Originally Posted by lauradrops View Post
I like to use Bankrate's mortgage calculaor. In order to be accurate, you would have to put in your info and also put in your principle payments. Then there is a spot where you can put in your one time 10,000 payment and see what it knocks off the end of your amortization schedule.

When you try to figure 189k at 3.875 for 322 months, it is giving you a lower payment because of the principal payments. When in reality, your principle payments just knock off months of payments at the end and do not lower you monthly payments.
So will the calculator be wrong since it's showing a smaller monthly payment than my minimum? Seems my mortgage company could tell me my savings on interest from a lump sum but they said they couldn't .
Reply With Quote Quick reply to this message
 
Old 01-15-2015, 11:56 PM
 
Location: Southern California
4,451 posts, read 6,802,921 times
Reputation: 2239
If you keep paying your extra $850 extra, you'll pay about $40,400 in interest over the next 10.25 years.

If you make a $10,000 extra payment and keep paying the extra $850 a month, you'll pay $36,600 in interest and finish in 117 months.

An ARM might be better.

It it late, I might be a bit off.

Last edited by thelopez2; 01-16-2015 at 12:07 AM..
Reply With Quote Quick reply to this message
 
Old 01-16-2015, 05:15 AM
 
913 posts, read 886,745 times
Reputation: 1747
Quote:
Originally Posted by jbpadgett09 View Post
So will the calculator be wrong since it's showing a smaller monthly payment than my minimum? Seems my mortgage company could tell me my savings on interest from a lump sum but they said they couldn't .
It should show the correct amount as long as you use origional numbers and accurate dates. You can't just plug in the balance because that will change monthly payment. You would have to start from day 1 and reflect the principal payments accurately. You would put in starting loan amount, on the date it started, with mortgage rate, for 30 yrs and add extra payments accordingly. Then put lump sum amount in and see the amortization schedule.

Just a question- when you say monthly payment, you are talking about just the principle and interest, right? The amount most people send includes their taxes and insurance all in one payment, but the mortgage itself is just the principle and interest.

Last edited by lauradrops; 01-16-2015 at 05:25 AM.. Reason: wanred to add something
Reply With Quote Quick reply to this message
 
Old 01-16-2015, 06:49 AM
 
Location: MID ATLANTIC
8,676 posts, read 22,927,256 times
Reputation: 10517
OP, if you like, shoot me a DM with your email address and I will send you a prepayment calculator.
Reply With Quote Quick reply to this message
 
Old 01-16-2015, 07:42 AM
 
16 posts, read 19,891 times
Reputation: 10
Ok, I was able to go back and track all my payments and used a calculator. An extra 10k payment next month would reduce the term of my mortgage by 8 months, and save me $4711 in interest, but this doesn't figure in the mortgage deduction lost which I guess is going to be 4711 x .28 ( my federal tax bracket), so I would actually save $3392 if I figured the tax deduction correctly.
Reply With Quote Quick reply to this message
 
Old 01-16-2015, 08:21 AM
 
Location: Boise, ID
8,046 posts, read 28,486,679 times
Reputation: 9470
Quote:
Originally Posted by jbpadgett09 View Post
Ok, I was able to go back and track all my payments and used a calculator. An extra 10k payment next month would reduce the term of my mortgage by 8 months, and save me $4711 in interest, but this doesn't figure in the mortgage deduction lost which I guess is going to be 4711 x .28 ( my federal tax bracket), so I would actually save $3392 if I figured the tax deduction correctly.
You didn't. You don't pay 28% in taxes just because you are in the 28% bracket. Your effective or average tax is going to be less than that. I don't even itemize, and while my bracket is 15%, my effective tax was only 8% last year.
Reply With Quote Quick reply to this message
Please register to post and access all features of our very popular forum. It is free and quick. Over $68,000 in prizes has already been given out to active posters on our forum. Additional giveaways are planned.

Detailed information about all U.S. cities, counties, and zip codes on our site: City-data.com.


Reply
Please update this thread with any new information or opinions. This open thread is still read by thousands of people, so we encourage all additional points of view.

Quick Reply
Message:


Over $104,000 in prizes was already given out to active posters on our forum and additional giveaways are planned!

Go Back   City-Data Forum > General Forums > Real Estate > Mortgages

All times are GMT -6. The time now is 05:18 PM.

© 2005-2024, Advameg, Inc. · Please obey Forum Rules · Terms of Use and Privacy Policy · Bug Bounty

City-Data.com - Contact Us - Archive 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37 - Top