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

Mortgage rates are rising but do you know where they're going? Check out our latest Two-Month Forecast.

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

  • Will the debt forgiven from my loan modification be treated as income and taxed?

    Mortgage debt forgiven via due to principal reductions in HAMP and other mortgage modifications aren't subject to tax, but there are conditions you should know.
  • 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; the target range for the key policy tool remains 1.25 to 1.5 percent.
  • How to refinance when you are self-employed

    Refinancing rules aren't the same when you are self-employed. This article explains how self-employed borrowers can successfully refinance.
  • Can home price trends predict a Super Bowl winner?

    But is there any specific relationship between home prices, mortgage rates and success in the NFL? Of course not. However, it's fun to forecast the winner of Super Bowl LII based off certain housing market characteristics!
  • Advantages of a FHA mortgage in 2018

    Although the cost of an FHA-backed mortgage isn't likely to get any cheaper in 2018, access to credit for homebuyers with less-than-stellar credit should improve.