The True APR of a Loan With an Origination Fee: Using IRR to See the Real Cost
October 21, 2026
Two loans with the same interest rate can have very different costs if one charges an upfront fee. Origination fees, typically 1% to 8% of the loan amount for personal loans, are deducted from the proceeds or added to the balance. You pay interest on the full amount but receive less, so the effective rate of borrowing rises. The annual percentage rate (APR) is designed to capture this by including fees, and you can verify it yourself with the internal rate of return (IRR).
Take a $10,000 loan at 6% over 36 months. The monthly payment is $304.22 and the total interest is $951.90. If the lender charges a 5% origination fee ($500) and deducts it from the proceeds, you receive only $9,500 but repay the same $304.22 a month. The effective annual rate that makes the present value of the payments equal $9,500 is 9.48%.
Skip the math and get your answer instantly:
Open the Loan Calculator →How to Compute the True APR
Find the monthly rate r such that $9,500 = 304.22 × (1 − (1 + r)^−36) ÷ r. This cannot be solved with simple algebra, but a spreadsheet's RATE function does it: =RATE(36, -304.22, 9500) returns about 0.79% per month; multiplied by 12, that is 9.48% APR. Equivalently, calculate the IRR of the cash flows: +9,500 at time zero and −304.22 for each of 36 months.
The stated rate of 6% applies to the $10,000 face amount, but your net borrowing is $9,500, so the effective rate is higher. In lending regulations such as the US Truth in Lending Act, APR must include certain fees, which is why it is the best figure for comparing loans.
| Origination fee | Net proceeds | Total cost (interest + fee) | True APR |
|---|---|---|---|
| 0% | $10,000 | $952 | 6.00% |
| 2% | $9,800 | $1,152 | 7.36% |
| 5% | $9,500 | $1,452 | 9.48% |
| 8% | $9,200 | $1,752 | 11.38% |
| 10% | $9,000 | $1,952 | 13.22% |
The Effect of Loan Term
A fixed fee has a bigger impact on short loans, because you spread the fee over fewer years. A 5% fee on a $10,000 loan at 6% raises the APR to 15.7% on a 12-month term, 11.1% on 24 months, 9.5% on 36 months, and 8.2% on 60 months. For a $20,000 loan at 7% over 60 months, a 2% fee ($400) raises the APR to 7.85%, and a 5% fee ($1,000) to 9.17%. The same applies to points on a mortgage, though mortgage APR calculations assume the loan is held for the full term. If you refinance or sell early, the effective cost of the fees is higher.
Comparing Offers
Compare loans by APR and by total dollar cost. Consider a loan at 8% with no fee against one at 6% with a 5% fee on a $10,000 36-month term. The first has monthly payment $313.36 and total interest $1,281. The second has total cost (interest plus fee) of $1,452 and an APR of 9.48%. The 8% no-fee loan is cheaper. Also check whether the fee is deducted from proceeds or added to the loan balance: if added, the amount financed is larger and interest accrues on the fee as well. Ask about prepayment penalties and whether a portion of the fee is refunded if you repay early.
Fees to Watch For
Origination fees, application fees, processing fees, late-payment fees, and prepayment penalties. Credit insurance and add-ons sold with the loan can increase the cost; the law often requires them to be optional, so you can decline. Compare the APR on loan estimates and the Truth in Lending disclosure. For payday and title loans, the effective APR is often several hundred percent. Choose lenders carefully, and read the agreement.
A Quick Estimate
As a rough rule, spread the fee over the average balance and the term: because an amortizing loan's average balance is about half the original, a 5% fee on a 3-year loan adds roughly 5% ÷ (3 × 0.5) ≈ 3.3 percentage points to the rate (the exact figure here is 3.5). For a precise answer, use the RATE function. Use the true APR to rank offers, then choose on both cost and flexibility.
Frequently Asked Questions
What is the true APR of a loan with a fee?
The annual rate that equates the net proceeds you receive to the present value of your payments, found using IRR or the RATE function.
Why is APR higher than the interest rate?
Because APR includes fees, which raise the effective cost of borrowing.
Do fees matter more on short loans?
Yes. A fee spread over a shorter term has a larger effect on the annual rate.
How can I calculate APR in Excel?
Use RATE(nper, -payment, net proceeds) and multiply the result by 12.
Is the origination fee refundable?
Usually not, but check the terms.