Understanding the loan interest rate calculator — concept and principle
This calculator works backwards from a loan you already know: the amount borrowed, the fixed monthly payment and the number of payments. It finds the interest rate hidden in those numbers. Use it when a car dealer, store or lender quotes only a monthly payment, or when you want to check the rate on an existing loan.
How it is calculated
For a loan repaid in equal monthly payments:
Loan amount = payment × (1 − (1 + i)^−n) ÷ i
- i is the monthly interest rate and n the number of monthly payments.
- No algebraic formula isolates i, so the calculator finds it by bisection, halving a search range of rates many times.
- Annual rate (APR) = i × 12. Effective annual rate = (1 + i)^12 − 1.
- Total of payments = payment × n; total interest = that total − loan amount.
The principle
Each payment is worth less to the lender the further in the future it arrives. Discounting every payment at the monthly rate i and adding them up gives the present value of the payment stream. The correct rate is the one at which that present value equals exactly the money you received. The APR quoted in the US under Regulation Z for monthly loans is this monthly rate times 12; the effective rate adds interest on interest within the year.
Worked example
Default inputs: loan 25,000 USD, payment 495 USD, 60 payments.
- Total of payments = 495 × 60 = 29,700.00 USD, so total interest = 29,700 − 25,000 = 4,700.00 USD.
- Bisection finds the monthly rate at which 495 × (1 − (1 + i)^−60) ÷ i = 25,000: i ≈ 0.5831%.
- APR = 0.5831% × 12 ≈ 6.9975%, shown as 7%.
- Effective annual rate = (1.005831)^12 − 1 ≈ 7.23%.
How to read the result
Compare the APR with offers from other lenders for the same term; even half a point matters on a large loan. If you enter the amount you actually received after fees, the rate rises and shows the true cost. If the result is far above advertised rates, check whether the payment includes insurance, warranties or other add-ons.
Common mistakes
- Entering the price of the item instead of the amount financed after the down payment.
- Using a payment that includes insurance or service contracts, which inflates the rate.
- Comparing an APR with an effective annual rate as if they were the same measure.
Frequently asked questions
Why does my rate come out higher than the lender quoted?
Fees deducted upfront or extra charges added to the payment raise the true rate. The lender's APR should already include most finance charges.
Is 7% APR the same as 7% effective?
No. 7% APR compounded monthly equals about 7.23% effective a year.
Can I use this for a mortgage?
Yes, as long as the payment is principal and interest only, without taxes and insurance.
Sources: Consumer Financial Protection Bureau, Regulation Z, 12 CFR Part 1026, Appendix J (annual percentage rate computations) · Brealey, Myers & Allen, Principles of Corporate Finance (present value of annuities)