[DaGoof]

...mortgage payments left on my loan?

[Kathryn]

The easiest way is to use an online calculator, like on Bankrate.com. The link is below. You just need to input the amount you currently owe (your mortgage balance), the annual interest rate you pay, and today's date. Then you have to put in your best guess at the amount of time you have left to pay. The calculator will then give you a payment amount. If the amount they give you is more than your current payment, then it will take you longer than your guess. If the amount they give you is less than your current payment, then it will take you less time than your guess. Adjust your guess accordingly and try again. Keep doing this until the payment amount is close to your payment amount, and that will be the amount of time left on your loan.Another way is to set up a spreadsheet in Excel. You can calculate the amount of your next payment that goes toward interest by multiplying your current balance by your annual interest rate and dividing by 12 (because there are 12 months in a year). The remaining amount of your payment reduces the principal, giving you a new beginning balance. You can set up the spreadsheet so that each row represents a month and copying your formulas down from the first row. Stop when your beginning balance drops to zero or negative. Then count the number of rows and that is the number of payments you have left.

[NiceT]

You don't need a special formula to determine number of payments. You loan has an end date which should be easily obtainable from your statement. You probably pay once a month. Multiply number of years x12 and then add number of months in the odd year.