Worked Examples and Checklists
Calculating a personal loan's real APR when fees are deducted or added
Step-by-step Canadian examples showing how an administration or broker fee raises the APR above the stated rate, whether it is deducted from the advance or added to the balance.
When a lender charges a fee to set up a personal loan, your real cost is the APR on the money you actually receive, not the stated interest rate. If a $500 fee is deducted from a $10,000 loan at 18% over 3 years, you get $9,500 but repay about $361.52 a month as if you had $10,000, which works out to an APR of about 21.7%. If the fee is added to the balance instead, you pay interest on the fee too. The method below lets you check any offer in a few minutes with a spreadsheet, and it is the same test you use to see whether a loan stays under Canada's 35% APR limit.
Part of the personal loan cost worked examples. All figures illustrative.
Why fees change the APR
The APR expresses the whole cost of borrowing, interest plus required charges, as one yearly rate on the credit you receive. Federal rules for banks and provincial consumer protection rules for other lenders require the APR to include most non-interest charges, such as administration fees and brokerage fees. Some items are excluded, such as optional insurance and official registration fees; see the disclosure guide.
There are three common ways a fee is charged:
| How the fee is charged | What you receive | What you repay | Effect |
|---|---|---|---|
| Paid separately at signing | Full amount | Payments on full amount | APR rises because you paid cash up front |
| Deducted from the advance | Amount minus fee | Payments on full amount | APR rises; the most common pattern |
| Added to the balance (financed) | Full amount | Payments on amount plus fee | APR rises; you also pay interest on the fee |
Example 1: fee deducted from the advance
$10,000 at 18% over 36 months, with a $500 fee deducted.
- Payment on $10,000: 10,000 × 0.015 ÷ (1 − 1.015^−36) ≈ $361.52.
- Cash received: $10,000 − $500 = $9,500.
- Find the monthly rate that makes 36 payments of $361.52 worth exactly $9,500 today. In a spreadsheet:
=RATE(36, -361.52, 9500)gives about 1.81% a month. - Multiply by 12: APR about 21.7%.
Total cost of borrowing: interest of about $3,014.86 plus the $500 fee, about $3,515, against $9,500 of usable money.
Example 2: fee added to the balance
Same loan, but the $500 is financed: you borrow $10,500 and receive $10,000.
- Payment on $10,500 at 18% over 36 months: about $379.60.
- Cash received: $10,000.
=RATE(36, -379.60, 10000)*12gives an APR of about 21.6%.- Total repaid: about $13,665.61, so the total cost of borrowing is about $3,666.
The APRs in examples 1 and 2 are similar, but in example 2 you pay more dollars because you received $500 more and pay interest on the fee. Compare offers by APR and by total cost for the cash you actually need, as in comparing two offers.
Example 3: small loans and short terms
The same dollar fee hurts more when the loan is small or short. $3,000 at 20% with a $150 fee deducted:
| Term | APR on $2,850 received |
|---|---|
| 12 months | about 30.0% |
| 36 months | about 23.8% |
A 12-month loan that looks like "20%" is actually close to 30%. With a slightly higher stated rate or fee it could pass the 35% criminal limit; see the criminal interest rate.
Example 4: a larger loan with a modest fee
$15,000 at 10.5% over 60 months with a $750 fee deducted: payment about $322.41, cash received $14,250, APR about 12.75%. On larger, longer loans the fee is spread thinly, so the gap between rate and APR narrows, but more than 2 points is still significant when you compare offers.
Doing it without a spreadsheet
If you only have a calculator, you can bracket the answer:
- Compute the payment at the stated rate (or use the loan calculator).
- Enter the cash received as the amount and try higher rates until the calculator's payment matches the real payment.
- The rate at which they match is your APR.
For example 1, at 21% on $9,500 over 3 years the payment would be about $357.91; at 22% about $362.81. The real payment of $361.52 sits between, closer to 22%, consistent with the 21.7% result.
Questions to ask the lender
- Is any amount deducted from the money I receive? How much and why?
- Is any fee added to the balance?
- Which fees are included in the APR on the disclosure statement, and which are not?
- If I prepay, is any part of the fee refunded (see prepaying early)? (For bank loans, the federal regulations require a pro-rated refund of certain non-interest charges when you repay in full early; Ontario's Consumer Protection Act, 2002, section 76, contains a similar rule for fixed credit.)
- Is a broker involved, and is the broker paid by me or the lender?
Frequently asked questions
Does the lender have to show me this APR?
Lenders covered by federal or provincial disclosure rules must show an APR that includes the required charges. If your own calculation gives a much higher figure, ask how the lender calculated it.
Why does my result differ slightly from the disclosed APR?
Rounding, daily interest, and the exact timing of the first payment can move the result by a fraction of a point. Large differences usually mean a charge has been treated differently.
Are NSF fees part of the APR?
No. Default charges such as NSF fees are excluded because they depend on what happens after signing. They still matter: read the default section of the agreement.
Is a "processing fee" on an online loan legal?
Fees are legal if disclosed and if the total stays within the 35% APR limit and provincial rules. A fee demanded before you receive any money is not normal practice.
Sources
- Justice Laws Website — Financial Consumer Protection Framework Regulations (cost of borrowing, prepayment refunds); Criminal Code s. 347
- Ontario e-Laws — Consumer Protection Act, 2002, ss. 50 and 76
- Financial Consumer Agency of Canada — understanding the cost of a loan
