A flat-rate loan quotes interest on the original amount for the whole term, so the quoted rate understates the real cost. To find the real yearly rate (the APR), you need the monthly rate that makes the instalments you pay equal to the cash you received. This page shows the method with a worked example, a trial-and-error check and a one-line spreadsheet formula.
Step 1: Work out the instalment
Loan: 1,000,000 over 6 months at 3% per month flat.
- Total interest = 1,000,000 x 0.03 x 6 = 180,000
- Total repayment = 1,180,000
- Instalment = 1,180,000 / 6 = 196,667
Step 2: Find the monthly rate that fits
You are looking for the rate r that solves:
loan = instalment x (1 - (1 + r) ^ -n) / rHere n is the number of months. Try rates until the right side equals 1,000,000.
| Trial monthly rate | Value of 6 instalments of 196,667 |
|---|---|
| 4.0% | 1,030,954 (too high, so the true rate is higher) |
| 5.0% | 998,219 (slightly low, so the true rate is a bit lower) |
| 4.94% | 1,000,138 (very close) |
The true monthly rate is about 4.94%, not 3%.
Step 3: Annualise it
- APR (nominal) = 4.94% x 12 = about 59.3%
- Effective annual rate = (1.0494 ^ 12) - 1 = about 78.4%
Which figure a country calls “APR” depends on its rules. Many use the nominal figure (monthly rate x 12). State clearly which one you quote.
The spreadsheet shortcut
In a spreadsheet, the RATE function does the trial and error for you:
=RATE(6, -196667, 1000000) * 12The result is about 0.593, which is 59.3%. For the effective rate:
=(1 + RATE(6, -196667, 1000000)) ^ 12 - 1Add fees
If the lender deducts a 2% fee (20,000) from the loan upfront, you receive 980,000 but still pay the same instalments.
=RATE(6, -196667, 980000) * 12- Monthly rate rises to about 5.58%
- APR (nominal) is about 66.9%
- Effective annual rate is about 91.8%
Fees raise the cost because you borrow less cash but repay the same amount.
A second example: 12% flat for a year
Loan 1,000,000, 12 months, 12% a year flat.
- Total interest = 120,000
- Instalment = 1,120,000 / 12 = 93,333
=RATE(12, -93333, 1000000) * 12gives about 21.5% (nominal APR)- Effective annual rate is about 23.7%
A “12%” flat loan costs roughly 21.5% to 23.7% a year on the balance you actually owe.
Related
- How loan instalments are calculated: savings group loan calculator explained
- Why flat costs more: flat vs reducing-balance interest
- What to compare when choosing a loan: APR vs interest rate
This is general information, not financial advice. Definitions of APR vary by country.