APR Calculator (Including Fees)
Find a loan’s true annual percentage rate once origination fees and points are counted.
- Monthly payment
- Amount financed
- Total finance charge
- APR above note rate
- Excel check
- Total of Payments
Compare Offers
Items you add are saved in this browser.
| Offer | Rate | Fees | APR | Payment | Remove |
|---|
How APR Includes Fees
The annual percentage rate (APR) spreads up-front finance charges over the life of the loan. You make the same payments as on the full loan, but you effectively received less money (the loan minus the fees), so the true rate is higher than the note rate.
This is Excel's RATE(months, −payment, loan − fees) × 12, solved by iteration. It follows the actuarial method in the Truth in Lending Act (Regulation Z) for a standard fixed-rate loan with regular monthly payments.
Worked Example
Tips
Which fees count as finance charges is set by Regulation Z: lender origination fees and points usually do; appraisal, title and recording fees usually don't. Because fees are spread over the full term, APR overstates the cost if you'll sell or refinance early. Compare APRs only between loans with the same term.