How to Calculate the APR of a Flat-Rate Loan (Worked Example)

How to calculate the APR of a flat-rate loan: find the true monthly rate from the instalments, annualise it, add fees, with a spreadsheet shortcut.

By The AvenaHold Team
 ·  3 min read

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) / r

Here n is the number of months. Try rates until the right side equals 1,000,000.

Trial monthly rateValue 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) * 12

The result is about 0.593, which is 59.3%. For the effective rate:

=(1 + RATE(6, -196667, 1000000)) ^ 12 - 1

Add 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) * 12 gives 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.

This is general information, not financial advice. Definitions of APR vary by country.

Good to know

How do you convert a flat rate to APR?
Work out the monthly instalment, then find the monthly rate that makes the present value of those instalments equal the cash you received. Multiply that monthly rate by 12 for the APR.
Is there a spreadsheet function for it?
Yes. Use RATE(number of months, -instalment, cash received) and multiply the result by 12.
Do fees change the APR?
Yes. Fees deducted upfront reduce the cash you receive while the instalments stay the same, which raises the APR.