Fixed rate loan equation
To calculate the periodic interest rate for a loan, given the loan amount, the number of payment periods, and the payment amount, you can use the RATE function. In the example shown, the formula in C10 is: = RATE ( C7 , C6 , - C5 ) * 12 Loans have If your interest rate is 5%, your monthly rate would be 0.004167 (0.05/12=0.004167) n = number of payments over the loan’s lifetime. Multiply the number of years in your loan term by 12 (the number