Amortization Calculating Excel Loan Calculating Loan Amortization In Excel Calculating Loan Amortization In Excel . For this example, we want to find the payment for a $5000 loan with a 4.5% interest rate, and ...