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.

similar to mortgages or auto loans, with a fixed interest rate and scheduled payments. As such, they follow an amortization schedule. At the start of your repayment term, a larger portion of your ...