dcsimg
We research, you save.

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

  • HSH.com on the latest move by the Federal Reserve

    The Federal Reserve concluded a meeting today with no change to the federal funds rate and no changes to other monetary policy tools.
  • Mortgage Rates Radar 04/26/2016: Fed impending, rates edge higher

    HSH.com releases its latest Weekly Mortgage Rates Radar showing a modest increase in mortgage rates during the seven-day period ending April 26, as markets prepare themselves for new interest rate messages from the Federal Reserve. 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).
  • How quickly can you refinance after a bankruptcy?

    We have received a lot of questions over the years regarding how quickly you can refinance a mortgage following bankruptcy.
  • Mortgage Rates Radar 04/19/2016: Mortgage rates fairly flat

    HSH.com releases its latest Weekly Mortgage Rates Radar showing almost no movement in average rates for popular mortgage types during the seven-day period ending April 19, as there is little news to move them strongly in one direction or the other. 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 04/12/2016: Mortgage rates still edging lower

    HSH.com releases its latest Weekly Mortgage Rates Radar showing another downturn in popular mortgage rates during the seven-day period ending April 12, as financial markets enjoy a period of relative quiet. 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).