Q: My mortgage balance is $37,500, the interest rate is 5.99 percent, the maturity date 2019. I have been making periodic principle payments. Do you have a calculator that will provide information on how to pay off my mortgage given my current balance and making principle payments?
A: Most of HSH.com's prepayment calculators allow for regular additional payments of principal and will tell you when the loan will end and what your savings will be. Specifically, HSH.com’s It's My Term Prepayment Calculator allows you to enter the date when you want your loan to end and will tell you how much you'll need to pay to make that happen.
If you are making occasional, irregular prepayments of principal, we do have a calculator you can use, but you will need to download it and install it locally on your windows-based computer. You should visit www.hsh.com/hbcalc-tips.html to get version 2.2.05 of HSH.com's Homebuyer's Calculator Suite.
Once you have downloaded and installed it, you can run your loan's amortization using the dropdown for "Amortization"; put in the basic loan parameters of start date, rate and term, then calculate payments.
Next, add your irregular prepayments one at a time on the dates you made them. Click "add prepayments," then using the "single payment" selection, select the payment number where you included extra cash and the amount, then click "apply extra." Repeat as needed for all the prepayments you made, and the updated results will appear at the bottom.
