How to Calculate APR on a Loan
To calculate APR on a loan, start with the loan amount, the note rate, the term, and every upfront fee. Work out the monthly payment at the note rate, subtract the fees from the loan amount to get the amount financed, then find the rate that makes those payments pay off the amount financed — that rate, annualised, is the APR. On a $20,000 loan at 6.5% over five years with an $800 origination fee, the payment is $391.32 a month and the APR works out to 8.22%, not 6.5%.
This guide runs that example end to end, so you can repeat it with your own numbers. It also shows why the simple APR formula in most guides gives the wrong answer on a normal installment loan, which fees count toward APR and which do not, and how to use APR to pick between two offers — including the case where the loan with the lower interest rate is the worse deal.
Key takeaways
- APR is the all-in yearly cost of borrowing: interest plus the fees you must pay to get the loan.
- The simple formula in most guides — (interest + fees) ÷ principal ÷ days × 365 × 100 — understates the real APR on an installment loan, because the balance falls over time.
- Lenders must disclose the actuarial figure: the rate that makes your payments equal the amount financed. Here it gives 8.22%; the simple formula gives 4.28%.
- $20,000 at 6.5% for five years with an $800 fee: $391.32 a month, APR 8.22%, total cost of credit $4,279.38.
- A lower interest rate can carry a higher APR once fees are counted — compare APRs, not headline rates.
- The same fee pushes APR up far more on a short loan than a long one: $800 lifts APR to 10.56% over two years but only 7.42% over ten.
What APR actually measures
The interest rate is the price of the money itself — it decides your monthly payment and nothing else. APR is a wider measure: it takes the interest rate and folds in the charges you pay to get the loan — origination fees, points, broker fees — then expresses the whole lot as a single yearly rate. The Consumer Financial Protection Bureau (CFPB) puts it plainly: the APR “reflects the interest rate, any points, mortgage broker fees, and other charges that you pay to get the loan,” and is usually higher than the interest rate.
That difference is the point of APR. Two loans can advertise the same 6.5% rate and cost very different amounts, because one charges $800 in fees and the other charges nothing. The interest rate hides that; APR shows it. On a mortgage, both numbers appear on the Loan Estimate — the interest rate on page 1 under “Loan Terms,” and the APR on page 3 under “Comparisons.”
The APR formula — and why there are two of them
The formula you will find everywhere is this:
APR = ((Interest + Fees) ÷ Principal ÷ Days in loan term) × 365 × 100
Run it on the worked example: total interest is $3,479.38 and the fee is $800, so interest plus fees is $4,279.38. Divide by the $20,000 principal (0.2140), then by the 1,825 days in five years (0.0001172), then multiply by 365 and by 100: the answer is 4.28%.
That is well below the real APR of 8.22% — the formula suits a different kind of loan. It works well enough for a single-payment loan, where you hold the full amount for the whole term and repay it in one go. On an installment loan it goes wrong in one specific way: it divides by the full $20,000 as though you owed all of it for all five years. You do not. Each monthly payment chips away at the balance, so the average amount outstanding over the term is $10,705.78 — roughly half the loan. Divide by that average balance instead and the same formula gives 7.99%, much closer to the true figure.
Lenders disclose a different number, from the actuarial method set out in Regulation Z, the rule behind the Truth in Lending Act. It finds the monthly rate that makes the present value of your payments exactly equal to the amount financed — the loan minus the upfront fees — and annualises it by multiplying by 12. It has no neat closed-form formula; it is solved by iteration, which is why calculators and spreadsheets do the work. Under the Truth in Lending Act, a disclosed APR is considered accurate if it lands within one-eighth of a percentage point of the actuarial value.
So there are two formulas: a simple one that is easy to do by hand and wrong on installment loans, and the actuarial one that is the number that counts.
Worked example: $20,000 at 6.5% for 5 years, $800 fee
Step 1 — Set the inputs. P = $20,000. Note rate 6.5% a year. Term five years, so n = 60 monthly payments. Upfront fee $800, taken out of the money you receive.
Step 2 — Work out the monthly payment at the note rate. The monthly rate is r = 0.065 ÷ 12 = 0.0054167. Using the payment formula from the guide to calculate loan payments monthly: (1 + r)60 = 1.3828, so the payment is 20,000 × 0.0054167 × 1.3828 ÷ 0.3828 = $391.32 a month, calculated on the full $20,000 at 6.5% — the fee does not change the payment.
Step 3 — Work out the amount financed. The fee comes out of the loan proceeds, so you actually receive $20,000 − $800 = $19,200. You repay a $20,000 loan but only ever held $19,200 — that gap is what pushes APR above the note rate.
Step 4 — Find the rate that makes those payments pay off $19,200. The monthly rate at which 60 payments of $391.32 have a present value of exactly $19,200 is 0.685% a month — × 12 = 8.22% APR.
Step 5 — Check the totals. Over the full term you pay 60 × $391.32 = $23,479.38: $3,479.38 interest plus the $800 fee, so the total cost of credit is $4,279.38 on $19,200 actually received.
The simple formula said 4.28%. The actuarial method says 8.22%. The difference is not a rounding choice: the simple formula spreads the cost over $20,000 held for five years, while the real calculation prices it against the $19,200 you received, repaid month by month. When a guide quotes an APR from the simple formula on an installment loan, treat it as a rough estimate, not the number your lender will disclose.
What counts toward APR — and what doesn’t
Not every dollar you pay to get a loan goes into the APR: charges you must pay to obtain the credit count, while optional charges and charges that only arise later do not.
| Usually included in APR | Usually not included |
|---|---|
| Origination fee | Late payment fees |
| Discount points | Optional insurance you choose to add |
| Mortgage broker fees | Appraisal, title, and recording fees — often excluded, though you still pay them |
| Prepaid interest | Fees for a service you can decline |
| Required mortgage insurance | Charges that arise only if something goes wrong |
The exact list follows Regulation Z, and the lender’s disclosure is the final word. When you compare two APRs, check both lenders counted the same fees — if one leaves out a charge the other included, the comparison is tilted. Ask for an itemised fee list and run both offers through an APR calculator with the same inputs.
The same fee hits short loans much harder
A fee is a fixed sum, and APR spreads it over the term. Squeeze the same $800 fee into fewer months and its yearly cost rises sharply. Take the same $20,000 loan at 6.5% with the same $800 fee, and change only the term:
| Term | Monthly payment | APR |
|---|---|---|
| 2 years (24 payments) | $890.93 | 10.56% |
| 5 years (60 payments) | $391.32 | 8.22% |
| 10 years (120 payments) | $227.10 | 7.42% |
The fee never changes, but its effect falls from 4.06 points over the note rate on a two-year loan to 0.92 points over ten. That is why short-term loans with flat fees can carry APRs in the hundreds of percent — and why comparing APRs only makes sense between loans with the same term.
Comparing two offers: the lower rate can be the worse loan
Two lenders offer the same $20,000 over five years: Lender A quotes 6.5% with an $800 origination fee; Lender B quotes 7.0% with no fees.
| Lender A | Lender B | |
|---|---|---|
| Note rate | 6.5% | 7.0% |
| Upfront fees | $800 | $0 |
| Monthly payment | $391.32 | $396.02 |
| Amount you receive | $19,200 | $20,000 |
| Total paid over 5 years | $23,479.38 | $23,761.20 |
| Total cost of credit | $4,279.38 | $3,761.20 |
| APR | 8.22% | 7.00% |
Lender A’s payment is $4.70 a month lower, and on the headline rate it looks like the better offer. It is not: because the $800 fee comes out of what you receive, Lender A’s loan costs $518.18 more in total — and its APR, 8.22% against 7.00%, says so at a glance. A low rate with heavy fees beats a slightly higher rate with no fees only when the fees are small relative to the loan and the term is long.
A mortgage example: $250,000, $5,000 in fees, 6.5%, 30 years
The same method works at mortgage scale. A $250,000 mortgage at 6.5% over 30 years with $5,000 in points and fees has a monthly principal-and-interest payment of $1,580.17. The amount financed is $245,000, and the APR works out to 6.70% — only 0.2 points above the note rate, because $5,000 is small next to $250,000 and is spread over 30 years. Total interest over the full term is $318,861.22.
A mortgage calculator for the payment and an APR calculator for the true rate should agree with these figures to the cent.
Calculate APR in Excel, Google Sheets, or a calculator
The fastest way to get the actuarial APR is the RATE function, which solves the same equation as step 4 above. In Excel or Google Sheets, type:
=RATE(60, -391.32, 19200) * 12
That returns 8.22%. The arguments are the number of payments (60), the monthly payment with a minus sign (-391.32), and the amount financed (19,200).
If you would rather not build the spreadsheet, an APR calculator does the same job: enter the loan amount, total upfront fees, quoted rate, and term, and it returns the APR, the monthly payment, and the total interest. Either way, use the amount financed — the loan minus the fees — not the headline loan amount.
When APR misleads
First, APR spreads fees over the full term. If you sell or refinance after three years, you will not have had 30 years to spread the points you paid, so a loan with a slightly higher APR but almost no upfront fees can leave you with more cash. For short holds, compare what you will actually pay over the time you hold the loan.
Second, on an adjustable-rate mortgage the APR does not reflect the maximum rate the loan can reach. The CFPB warns against comparing adjustable-rate APRs with fixed-rate APRs, or with each other, without understanding the caps and adjustment rules — the APR on an adjustable loan is based on the initial rate only.
Third, do not compare the APR of a closed-end loan, which includes fees, with a home equity line of credit, which does not — the two numbers are built differently.
Mistakes that give you the wrong number
- Using the simple formula on an installment loan. It gave 4.28% where the real APR is 8.22%. Use the actuarial method, a RATE formula, or a calculator.
- Leaving fees out. An APR with the fees left out is just the note rate again.
- Using the APR as the rate in the payment formula. The payment is calculated at the note rate; using the APR overstates it. Keep the note rate for the payment and the APR for comparing offers.
- Comparing APRs across different terms. The same fee produces very different APRs at two, five, and ten years — compare like with like.
- Forgetting the fee comes out of what you receive. The amount financed is the loan minus the fees; using the full loan amount understates the APR.
- Assuming the payment never changes. The payment above is fixed only on a fixed-rate loan; on a variable-rate loan it is recalculated whenever the rate changes.
A short note for UK readers
The maths is identical in the UK. Personal loans are usually fixed-rate repayment loans quoted with a representative APR — the rate at least 51% of successful applicants receive — and the lender must show the total amount payable. UK car finance is often a PCP agreement, where the monthly payment covers only part of the car’s value with a large final balloon payment, so the payment formula above does not apply directly.
Frequently asked questions
What is the formula to calculate APR on a loan?
The simple formula is APR = ((Interest + Fees) ÷ Principal ÷ Days) × 365 × 100, but it understates the APR on installment loans. Lenders disclose the actuarial figure: the rate that makes the present value of your payments equal the amount financed (loan minus fees), annualised by 12 — in Excel, =RATE(nper, -payment, amount financed) × 12.
Why is my APR higher than my interest rate?
Because of fees. Points and origination charges reduce the amount you effectively receive while payments stay based on the full loan amount, so the effective rate rises — and the bigger the fees relative to the loan, the wider the gap. A no-fee loan has an APR nearly equal to its note rate.
Can I calculate APR in Excel?
Yes: =RATE(number of payments, -monthly payment, amount financed) × 12. For this guide’s example, =RATE(60, -391.32, 19200) × 12 returns 8.22% — and the same function works in Google Sheets.
Is a lower APR always the better loan?
For loans kept to full term, yes — lower APR means lower total cost. But APR spreads fees over the whole term, so if you sell or refinance in a few years, compare the total cash over your holding period instead.
Does APR include all fees?
No. It includes charges you must pay to obtain the loan — origination fees, points, broker fees, prepaid interest — and leaves out late fees, optional insurance, and some third-party charges such as appraisal and title fees. Check the lender’s disclosure for the full list.
Work out the APR on each offer before you sign, and compare APRs — not headline rates — between loans with the same term. The rate tells you the payment; the APR tells you the cost.
This article is general information, not financial advice. Rates, fees, and terms change, and the figures here are illustrative — check your lender’s quote and disclosure before borrowing.
