I have tried google and found several but none that show what I want.

All of the ones I have found tell me when I will pay off my mortgage based on how much extra I pay.

I want to know how much extra I should pay to have my house paid off by a certain date and the ability to compare 10 vs 15 vs 20 years.

Any one know of a calculator like this or have an excel sheet made up?

JD

Try dinkytown.net

Vertex42.com is what you want.

I thought my bank had one online but can't find it now.
Savings can be significant. I kept the same monthly payment, but was able to drop my rate and slice off 7 years by going from 30 to 15, and the savings come to 80K

I guess I may not understand. Can't you use your current balance and interest rate and make the term of the mortgage coincide with the date you wish? Then just use a simple mortgage calculator.

Try bankrate
Use their amortization calculator

A simple spreadsheet with one month per row can be very accurate
month #, balance, bal+apr/12, -pmt, -extra pmt, +/-?, =new bal

https://www.daveramsey.com/mortgage-payoff-calculator

Edit: I see it isn't quite what you want, but a few minutes trial and error entering different extra payment amounts should tell you the info. The amount I randomly entered was an exactly 15 year sooner payoff, so a bit less for 20, more for 10.

Email Sent.

I can build a spreadsheet to do what you are looking for. I did it for myself once upon a time. I've done similar for friends as well.

-s

as stated above:

try here:

https://www.dinkytown.net/mortgage.html

---------------------------------

Man, it’s amazing the difference it makes just adding $50-100 extra a month to your mortgage payment.

Also remember to pay towards “principal balance only”, otherwise it may not get applied properly.
Make sure there is no “early pay off penalty”.
Good luck, this is a great way to reduce your debt and increase credit rating.
Especially if done at the beginning of a loan.

quote:

Originally posted by cooger:
Man, it’s amazing the difference it makes just adding $50-100 extra a month to your mortgage payment.

IIRC, what also makes a difference is making two half payments a month versus a single full payment.

Amortization schedule is the word.
Try putting in amounts until you get the desired outcome.
I paid off a 30yr in 15.
There isn't any savings on the back end of a loan so it's important to get it going asap.
Payment on principle had to be stipulated on check. I wrote 2 separate checks a month. (Back when checks were used)

Tagged.

https://www.bankrate.com/calcu...yoff-calculator.aspx

You can adjust any parameter with this one.