It’s one of the Excel functions ... you can use the PMT function to create budgets, compare loan offers, plan your monthly payments, and create an amortization table. XIRR (Extended Internal ...

Amortization refers to how much of each loan payment goes to interest and ... payment (if you don't already know it), using Excel's PMT function. Following our example above, for a loan with ...