Yes, you can calculate the interest rate from an amortization schedule if you know the loan amount, the monthly payment, and the number of payments. The rate is the annual percentage rate (APR) that makes the present value of all those payments equal to the loan amount.
Formula
The amortization formula that links these four variables is:
P = PMT × [1 − (1 + r)^−n] / r
- P = loan principal (the amount borrowed, in dollars)
- PMT = monthly payment (in dollars)
- r = monthly interest rate (APR divided by 12, as a decimal)
- n = total number of monthly payments (loan term in years × 12)
To solve for the rate, you cannot rearrange the formula algebraically to isolate r—it appears both in the numerator and in an exponent. Instead, you use a numerical method (like the rate function in a spreadsheet) that tries different rates until the right side of the equation equals the loan amount. The calculator above does exactly that, then multiplies the monthly rate by 1200 to express it as an annual percentage rate (APR).
Worked Example
Using the default values from the calculator:
- Loan amount (P) = $20,000
- Monthly payment (PMT) = $405
- Term (n) = 5 years × 12 = 60 months
We need to find the monthly rate r that satisfies:
$20,000 = $405 × [1 − (1 + r)^−60] / r
Trying r = 0.0075 (0.75% per month, or 9% APR):
1.0075^−60 ≈ 0.6387
1 − 0.6387 = 0.3613
0.3613 / 0.0075 = 48.17
405 × 48.17 = $19,509 (too low)
Trying r = 0.0070 (0.70% per month, or 8.4% APR):
1.0070^−60 ≈ 0.6573
1 − 0.6573 = 0.3427
0.3427 / 0.0070 = 48.96
405 × 48.96 = $19,829 (still low)
Trying r = 0.0065 (0.65% per month, or 7.8% APR):
1.0065^−60 ≈ 0.6763
1 − 0.6763 = 0.3237
0.3237 / 0.0065 = 49.80
405 × 49.80 = $20,169 (too high)
The true rate lies between 0.65% and 0.70%. With more precise iteration, the calculator finds r ≈ 0.00675, which is 8.10% APR. Total paid = $405 × 60 = $24,300. Total interest = $24,300 − $20,000 = $4,300.
Assumptions
- The interest rate is fixed for the entire term.
- Payments are made at the end of each month (ordinary annuity).
- Interest compounds monthly at APR/12.
- The payment amount is constant and exactly covers interest plus principal each month.
- No fees, taxes, insurance, or other charges are included—only principal and interest.
How to Read the Result
The calculated rate is the effective annual percentage rate that makes the payment exactly amortize the loan. If the payment you entered is higher than the minimum required, the calculated rate will be higher than the lender’s nominal rate—because you are paying extra principal. Conversely, if the payment is lower, the rate will appear lower, but the loan would not be fully repaid by the end of the term (the calculator would show an error).
This rate is useful for comparing loan offers when you know the payment but not the APR, or for reverse-engineering the cost of a loan you already have. It is not the same as the total cost of the loan—that is the total paid, which includes principal and interest.
Common Mistakes and Pitfalls
- Mixing up monthly and annual rates: Always divide the APR by 12 before using it in the formula. A 12% APR is 1% per month, not 12% per month.
- Using the wrong number of payments: If the term is in years, multiply by 12. If payments are biweekly, the number of payments doubles and the rate calculation changes.
- Ignoring fees: If the loan has origination fees, the true APR is higher than the rate that only considers principal and interest. This calculator does not include fees.
- Rounding too early: Rounding the payment to the nearest cent before calculating the rate can shift the result by a few basis points. Use the exact payment from your lender.
- Assuming the rate is the same as the monthly rate × 12: Due to monthly compounding, the effective annual rate is slightly higher than the APR. The calculator outputs the APR, not the effective annual yield.
When to Use This Calculation
You might use this calculator when:
- You have a loan offer that lists the payment but not the APR, and you want to know the true interest cost.
- You are comparing a loan with a low payment but a long term versus a higher payment with a shorter term—the rate tells you which is actually cheaper.
- You want to verify the interest rate on an existing loan by using your current payment and remaining balance.
- You are considering refinancing and want to know what rate you would need to achieve a target monthly payment.
Remember that the rate is only one part of the cost. A loan with a lower rate but a longer term can still cost more in total interest than a higher-rate loan paid off quickly.
Limitations of the Formula
The standard amortization formula assumes a fixed interest rate and equal payments. It does not apply to adjustable-rate mortgages, interest-only loans, balloon payments, or loans with payment holidays. For those, you need a more complex model that accounts for rate changes and irregular payments.
Also, the calculated rate is only as accurate as the inputs. If the payment includes escrow for taxes and insurance, you must subtract those amounts before entering the payment. If the loan has a prepayment penalty or other fees, the true cost is higher than what this calculation shows.
Frequently Asked Questions
Can I calculate the interest rate if I only know the payment and the loan amount?
Yes, you need the loan amount, the monthly payment, and the number of payments (or the term). With those three, the rate is uniquely determined. If you don’t know the term, you cannot solve for the rate because there are infinitely many combinations of rate and term that produce the same payment.
Why does the calculator sometimes show an error for the rate?
If the monthly payment you enter is less than the interest that would accrue on the loan in the first month, the loan will never be paid off—the balance grows instead of shrinking. In that case, there is no real interest rate that satisfies the equation, so the calculator displays an error. This happens when the payment is too low relative to the loan amount and term.
Is the APR the same as the interest rate?
APR (Annual Percentage Rate) is a standardized measure that includes the nominal interest rate plus certain fees and costs, expressed as a yearly rate. This calculator computes the nominal rate that matches the payment, excluding fees. The APR from a lender may be higher if fees are included. For a loan with no fees, the APR equals the nominal rate.
How do I calculate the interest rate for a loan with biweekly payments?
For biweekly payments, you need to adjust the formula. The number of payments per year is 26, and the periodic rate is APR/26. The same numerical method applies, but you must use the biweekly payment and the total number of biweekly periods (term in years × 26). The calculator above is set up for monthly payments only.
What if my loan has a variable rate?
This calculator assumes a fixed rate. For a variable-rate loan, the payment changes over time, so there is no single rate that applies to the entire term. You can use this calculator to find the rate for a specific period, but you would need to model each rate period separately to get the full picture.
The result from this calculator is an estimate based on the inputs you provide; the exact figures, including any fees or adjustments, will be shown in the lender’s official disclosure.
Related
Formula used
in p | Loan amount | $ | 20000 | 1 | 100000000 in pmt | Monthly payment | $ | 405 | 1 | 100000000 in yrs | Loan term | years | 5 | 0.0833 | 50 out rate | Annual interest rate (APR) | % | rate(yrs * 12, pmt, p) * 1200 | 2 out tot | Total paid | $ | pmt * yrs * 12 | 2 out int | Total interest | $ | pmt * yrs * 12 - p | 2
Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work
Method: the standard loan formula for this calculation, fixed rate and monthly compounding unless stated, rounded as each result states. Not financial advice; no lender, rate or product is recommended. See formulas and assumptions, the disclaimer or report an error.
More in this section
- Federal Schedule B: What It Is & How to Use It$405.53
- Federal Form Schedule C Part V: What It Is$45,000.00
- Form 5471 Schedule O: What It Is & How to Fill It$405.53
- Federal 1120 Schedule O: What It Is & How to File$50,000.00
- Form 1065 Schedule L: Balance Sheet Instructions$0.00
- Federal 1065 Schedule K: What Goes on Each Line$405.53