X

See what's happening with home values in more than 400 metropolitan areas with HSH's Home Value Tracker, just updated though the second quarter of 2022.

See what's happening with home values in more than 400 metropolitan areas with HSH's Home Value Tracker, just updated though the second quarter of 2022.

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)
Please enter a question.
Please enter name.
Please enter email.
Captcha code invalid
Q: How are mortgage interest rates determined?
AUG 18, 2022
A:

Mortgage rates fluctuate from day to day, depending on a number of factors related to the economy and to choices made by investors. While some mortgage money comes from deposits held by banks and credit unions, most of the funds for borrowers come from investors in capital markets.

Read More
Q: Will today's stock market influence tomorrow's mortgage rates?
AUG 16, 2022
A:

Mortgage rates are influenced by a variety of factors, rather than moving in lockstep with any one economic indicator. The stock market rises and falls for a wide variety of reasons, including global, economic and political issues, but as a broad rule of thumb, a rising stock market indicates optimism among investors about the economy.

Read More
Q: Should I pay private mortgage insurance out of pocket or finance the cost?
AUG 12, 2022
A:

For the most part, this is a discussion about time. You should compare the total costs of the difference in the two interest rates over your given time horizon.

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