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.

private loans, or a combination of both. Amortization refers to the way a loan is repaid over time, breaking down your monthly payment into portions that go toward the interest and the principal ...