If you want to figure out the payment amounts, interest rate, or term for a loan, you can use a few handy Excel functions.
Loan Payment, Interest, and Term Functions in Excel You’ll immediately see the amortization table update with all the details you need to keep up with your loan payments, principal, balance, interest, and cumulative interest.