dcsimg
We research, you save.
Got Questions On Rates? (855) 610-2972

Do you have a calculator that will track my prepayments?

By   |  Posted in Ask The Expert

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.

More help from HSH.com

  • Mortgage Rates Radar 05/24/2016: Mortgage rates see upward bump

    HSH.com releases its latest Weekly Mortgage Rates Radar showing a small increase in popular mortgage rates during the seven-day period ending May 24, as minutes from the most recent Federal Reserve meeting suggests that a change in short-term rates may come sooner than later. The Weekly Mortgage Rates Radar reports the average rates and points offered by lenders for the two most popular types of mortgages, the conforming 30-year fixed-rate mortgage and the conforming 5/1 adjustable-rate mortgage (ARM).
  • The salary you must earn to buy a home in 27 metros

    Here’s how much salary you would need to earn in order to afford the median-priced home in your city.
  • Mortgage Rates Radar 05/17/2016: Mortgage rates flat

    HSH.com releases its latest Weekly Mortgage Rates Radar showing virtually no movement in popular mortgage rates during the seven-day period ending May 17, as financial markets are mostly directionless at the moment. The Weekly Mortgage Rates Radar reports the average rates and points offered by lenders for the two most popular types of mortgages, the conforming 30-year fixed-rate mortgage and the conforming 5/1 adjustable-rate mortgage (ARM).
  • Mortgage Rates Radar 05/10/2016: Mortgage rates wander downward

    HSH.com releases its latest Weekly Mortgage Rates Radar showing a modest decline in mortgage rates in the seven-day period ending May 10, as financial markets settle in to a quiet period with little economic data to consider. The Weekly Mortgage Rates Radar reports the average rates and points offered by lenders for the two most popular types of mortgages, the conforming 30-year fixed-rate mortgage and the conforming 5/1 adjustable-rate mortgage (ARM).
  • Mortgage Rates Radar 05/03/2016: Mortgage rates mostly steady this week

    HSH.com releases its latest Weekly Mortgage Rates Radar showing almost no change but perhaps, the beginning of another decline in popular mortgage rates during the seven-day period ending May 3, as the financial markets turn their focus from the Federal Reserve to incoming data. The Weekly Mortgage Rates Radar reports the average rates and points offered by lenders for the two most popular types of mortgages, the conforming 30-year fixed-rate mortgage and the conforming 5/1 adjustable-rate mortgage (ARM).