A mortgage amortization schedule is calculated using the loan amount, loan term, and interest rate. If you know these three things, you can use Excel’s PMT function to calculate your monthly ...

A loan amortization schedule is calculated using the loan amount, loan term, and interest rate. If you know these three things, you can use Excel’s PMT function to calculate your monthly payment.

By understanding how to calculate a loan amortization schedule ... If you're a do-it-yourselfer, you can also use an Excel spreadsheet to come up with the payment. The PMT function gives you ...