X

It's a question almost everyone is asking: "Should I refinance my mortgage?" If so, what's the best way to pay for my mortgage refinance

It's a question almost everyone is asking: "Should I refinance my mortgage?" If so, what's the best way to pay for my mortgage refinance

Do you have a calculator that will track my prepayments?

Q: I need a good calculator program to be able to enter in a loan from 2008 where I paid different amounts of extra principal along the way and would like to be able to see the amortization schedule.  I want to rerun it every month as I pay different amounts of extra principal.  I don't mind keying in everything, as long as it's only one time per transaction. Any suggestions?

A: Our downloadable (windows-based) Homebuyer's Calculator Suite will do irregular amortization, but as you note, it is a slow process.

You can download the calculator and install it on a local machine. Run the calculator, and refer to our tips page to find out how to input the irregular prepayments you describe.

However, the mortgage calculator does not have a "save" feature, so you would need to re-do all the calculations each time you make an additional prepayment.

Microsoft Excel does have a mortgage payment/amortization function, and what you want can be built for you, but you'll need someone who is adept at Excel. Alternately, you might search on the Internet to see if someone has a shareware/freeware version you can obtain.

Ask the expert
Keith Gumbinger
Keith Gumbinger
Mortgage Expert
Vice President, HSH.com
About Keith: Mortgage market observer and analyst with 35 years experience... (more)
Submitting your question...

Question received! Check back later to see if your
question gets published.

Q: Can I get forbearance for my mortgage?
MAY 19, 2020
A:

The answer is "possibly." It depends on the situation.

Read More
Q: Is mortgage insurance tax deductible?
JAN 08, 2020
A:

Tax deductibility for PMI premiums or MI premiums for FHA loans has been an on-again, off-again kind of thing. For 2019 and 2020, it's back on.

Read More
Q: How many times can I use my VA home loan?
OCT 31, 2019
A:

There are three ways you can restore your VA eligibility so that you can take advantage of it more than once.

Read More
Add to Homescreen?
X
X
Install this web app on your phone :tap and then Add to homescreen