Skip to content
LoveToCalc

APR calculator

The effective interest rate on a consumer loan, once the fees are folded into the nominal rate.

Your numbers

Charged once when the loan is paid out. Not a lender’s price we know for you — check your own offer.

What the lender charges for each payment. Not a lender’s price we know for you — check your own offer.

Repayment

The same amount every month. Usual for personal and car loans.

Result

Effective interest rate (APR)

8.6%

Put a second set of numbers beside this one and see the difference.

First payment
$101
Total cost
$1,110
Total you repay
$6,110

A nominal rate of 7% plus fees works out to an effective rate of 8.6%. Borrowing $5,000 over 60 months costs $1,110 in all, $101 a month, $6,110 repaid in total.

The effective rate follows Annex III of Directive (EU) 2023/2225: a nominal annual rate compounded monthly, the arrangement fee counted at payout and the monthly fee on every instalment from the first. It covers a fixed-term consumer loan only — not a mortgage, not a credit card or overdraft, and it assumes the rate stays fixed for the whole term. The fee fields are illustrative and yours to edit to your own offer; they carry no source.

What you pay each year

Show year-by-year table
YearPrincipalInterestFeesRemaining
1$865$323$74$4,135
2$928$260$24$3,206
3$995$193$24$2,211
4$1,067$121$24$1,144
5$1,144$44$24$0
Download the month-by-month cash flow

The CSV uses commas between fields and a decimal point. In the Excel file the numbers are plain numbers, which Excel shows in your own format.

APR in Excel: RATE and EFFECT

The same calculation in one cell, with your numbers. Paste it into Excel:

=EFFECT(RATE(60,-(PMT(7%/12,60,-5000)+2),5000-50)*12,12)

In Swedish Excel the functions are called EFFRÄNTA, RÄNTA, and BETALNING. There the arguments are separated by semicolons and decimals written with a comma. Google Sheets uses the English names whatever the language.

The minus sign is not a mistake. Excel tells money coming in from money going out by its sign, so one of the amounts is negative. Flip the signs and the answer flips too.

The answer comes out as a fraction, 0.035 for 3.5 %. Format the cell as a percentage and Excel shows it the way the page does.

One number that counts everything

The APR, or effective interest rate, is the price of a loan expressed as an annual rate with the fees counted in. The nominal rate says what interest you pay on the debt; the APR says what the loan costs you altogether, as if all of it were interest. That is why it is the figure to compare two offers on, and why lenders have to publish it.

It comes out higher than the nominal rate for two reasons:

Formula

The APR X is the annual rate that makes what you receive and what you pay back worth the same, once every amount is discounted to the day the loan is paid out:

L − U = Σ (Bk + M) · (1 + X)−k/12

The equation cannot be solved for X by hand. The calculator narrows it down until both sides agree, then rounds to one decimal, half up, as the rules require. The simple effective interest rate formula only converts a nominal rate to an effective one, without fees.

Example

You borrow 5,000 at a 7% nominal rate over 60 months, repaid as an annuity. The arrangement fee is 50 and the monthly fee 2:

The same loan with no fees has an APR of 7.2%, so the fees add well over a percentage point. The term matters: over 12 months the APR is 10.2%. The fees are about the same, but on a short loan they are spread over fewer years.

Which APR this is

This is the APR as the EU defines it, in Annex III of the Consumer Credit Directive (EU) 2023/2225 and its predecessor 2008/48/EC. Every EU country uses this method for consumer credit. Other countries define their own.

The United States is the one to know about. Regulation Z, Appendix J, takes the monthly rate and multiplies it by twelve instead of compounding it. The regulation’s own example is a loan of 5,000 repaid in 24 monthly payments of 230: its US APR is 9.69%, while the EU method gives 10.1% for the same payments. Same loan, same cost, two different numbers, so only compare APRs worked out under the same rules.

What the calculator assumes

The calculator is for consumer credit with a fixed term: personal loans, car loans and other loans repaid monthly. It does not cover mortgages, which have a calculation of their own, nor credit cards or overdrafts, where the amount you owe changes over time.

The rate is taken to be the same for the whole term, which is also what the rules tell a lender to assume when the rate can change. Insurance, reminder charges and late fees are not included. The fee fields hold example values; enter the fees from your own offer.

Frequently asked questions

Why does my figure differ from the lender’s? Usually because the lender counts a fee that is not here, such as insurance required for the loan, or uses exact dates rather than whole months. Lenders also round every payment to the cent.

Is the lowest APR always the best deal? It tells you which loan is cheapest per year. What a loan costs in total also depends on how long you borrow for: a longer loan can have a lower APR and still cost more. The total cost of a loan shows the amount.

How is it different from the nominal rate? The nominal rate is the interest rate on the debt, without fees and without compounding. It is what the loan calculator uses. The APR starts from it and adds everything else you pay.

Can I use it for a mortgage? No. Mortgages have their own APR calculation, with costs this calculator does not ask for.

Method

Last reviewed September 25, 2026 ·How pages are reviewed

The formula behind this

All loans calculators

Put this calculator on your site

Copy the code into your page where the calculator should appear. It loads from lovetocalc.com, so it stays current on its own — all we ask is that the credit line comes with it.