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.

spreadsheet software packages (such as Microsoft Excel), or online amortization calculators. When entering into a loan agreement, the lender may provide a copy of the amortization schedule (or at ...

By understanding how to calculate a loan amortization schedule, you'll be in a better ... If you're a do-it-yourselfer, you can also use an Excel spreadsheet to come up with the payment.