To calculate mortgage APR, find the monthly payment on your full loan amount at the quoted interest rate, subtract all finance charges from that loan amount to get your net proceeds, and then solve for the interest rate that would produce the same monthly payment on the smaller net amount. That rate is the APR. Because fees shrink what you actually receive while leaving your payment untouched, the APR always comes out higher than the quoted rate whenever any finance charges exist.
Which Fees Count as Finance Charges
The APR captures every cost the lender imposes as a condition of giving you the loan. If a charge wouldn’t exist without the mortgage, it almost certainly counts. The federal definition is any charge payable by the borrower and imposed by the lender as a condition of credit, unless a specific exclusion applies.1eCFR. 12 CFR 1026.4 – Finance Charge
The common ones in a mortgage:
- Origination fees, often 0.5% to 1% of the loan amount.
- Discount points. Each point equals 1% of the loan amount and buys down the rate.
- Mortgage insurance premiums, including private mortgage insurance on conventional loans with less than 20% down and FHA mortgage insurance.1eCFR. 12 CFR 1026.4 – Finance Charge
- Mortgage broker fees paid to a broker who arranged the loan.
- Prepaid interest covering the days between closing and your first full payment period.
FHA loans are worth flagging. The upfront mortgage insurance premium of 1.75% of the loan amount is financed into the balance and included in the APR, which is why FHA APRs often look markedly higher than the quoted rate.
Costs You Should Not Include
Several closing costs stay out of the APR because you’d pay them even without financing the purchase. Leaving them in will give you a number that’s too high.
- Title examination and title insurance.
- Appraisal fees.
- Credit report fees.
- Home inspection fees.
- Government recording fees.
- Document preparation fees.
These exclusions apply when the fees are genuine and reasonable in amount.1eCFR. 12 CFR 1026.4 – Finance Charge Attorney’s fees are also excluded unless the lender requires you to use a specific attorney.
The Four Numbers You Need
Every APR calculation runs on the same inputs:
- Loan amount: the full principal you’re borrowing before any fees are deducted.
- Interest rate: the nominal rate quoted by the lender.
- Loan term: the repayment period, typically 15 or 30 years.
- Total finance charges: the sum of every fee that qualifies under the list above.
All of these appear on the Loan Estimate your lender must deliver within three business days after you apply.2Consumer Financial Protection Bureau. TILA-RESPA Integrated Disclosure FAQs The itemized fees sit on page 2, and the lender’s disclosed APR appears on page 3 in the Comparisons section.3eCFR. 12 CFR 1026.37 – Content of Disclosures for Certain Mortgage Transactions
The Formula and Why It Needs Iteration
Federal regulation requires the actuarial method. In plain terms: you’re looking for the interest rate that makes the present value of all your future monthly payments equal to the amount you actually received after fees were deducted.4Consumer Financial Protection Bureau. Appendix J to Part 1026 – Annual Percentage Rate Computations for Closed-End Credit Transactions
The intuition is simple. The lender approves you for $300,000. After $6,000 in finance charges, you walk away with $294,000 in effective value. Your monthly payment is still calculated on the full $300,000 at the quoted rate. The APR is the rate that would produce those same payments if you had actually borrowed only $294,000. Same payments against a smaller starting balance means a higher rate.
The regulation defines APR as a nominal annual rate — the monthly periodic rate multiplied by 12.5Consumer Financial Protection Bureau. 12 CFR 1026.22 – Determination of Annual Percentage Rate There’s no closed-form solution. You guess a rate, check whether it balances the equation, adjust, and repeat until the numbers line up. That’s why lenders use software, and why doing it by hand takes patience.
A Worked Example
Take a $300,000 loan at 6.5% interest for 30 years with $6,000 in total finance charges.
Step 1: Monthly Payment on the Full Loan
Compute the monthly payment using the full $300,000 loan amount at 6.5% annual interest (about 0.5417% per month) over 360 payments. The standard amortization formula gives a monthly payment of roughly $1,896.
Step 2: Net Proceeds
Subtract total finance charges from the loan amount. $300,000 minus $6,000 equals $294,000. This is the “amount financed.”
Step 3: Solve for the Rate
Find the monthly interest rate where 360 payments of $1,896 have a present value of exactly $294,000. Try 6.6% as a first guess. Compute the present value of the payment stream at that rate. If it’s higher than $294,000, raise the rate. If lower, cut the rate. Repeat.
In this example, the APR lands around 6.64%. That 14-basis-point gap above the 6.5% quoted rate reflects the $6,000 in fees being spread over 30 years. Larger fees widen the gap. A shorter loan term also widens it, because the fees amortize over fewer years.
Doing It in Excel
Excel’s RATE function performs the iteration for you.6Microsoft Support. RATE Function The syntax is:
RATE(nper, pmt, pv, [fv], [type], [guess])
Using the same example:
- nper: 360 (months in a 30-year loan)
- pmt: -1896 (the monthly payment, entered as negative because the money flows out)
- pv: 294000 (net proceeds, not the full loan amount)
- fv: 0 (loan is fully paid off at the end)
The formula =RATE(360, -1896, 294000) * 12 returns the annual APR. Multiplying by 12 converts the monthly periodic rate to the nominal annual rate. If the result matches the APR on your Loan Estimate within roughly an eighth of a percentage point, the lender’s disclosure checks out. A larger gap is worth asking about.
Adjustable-Rate Mortgages Work Differently
An adjustable-rate mortgage has an initial rate that holds for a fixed period, often 5 or 7 years, then adjusts based on a market index plus a lender-set margin.7Consumer Financial Protection Bureau. For an Adjustable-Rate Mortgage (ARM), What Are the Index and Margin, and How Do They Work? Since no one knows where the index will be years from now, the APR is computed from a blended payment stream: the initial rate during the fixed period, then the fully indexed rate (index at origination plus margin) for the remaining years. Plug that composite payment stream and the finance charges into the same present-value method.
The result can look strange. A 5/1 ARM at 5.5% initial might disclose an APR of 6.8% because the fully indexed rate dominates 25 of the 30 years in the calculation. Treat an ARM’s APR as a worst-case comparison tool rather than a prediction.
What APR Doesn’t Capture
APR assumes you keep the loan for its full term. Most people don’t. If you pay $6,000 in upfront fees but sell or refinance after seven years, those fees are effectively spread over seven years instead of thirty, so your real borrowing cost is higher than the disclosed APR suggests. This matters most when choosing between a low-rate, high-fee loan and a higher-rate, low-fee loan: the first can show a lower APR over 30 years yet cost more in total if you move in five. Calculating the break-even point for your expected time in the home is often more useful than comparing APRs directly.
A few other costs sit outside the APR framework entirely, including escrow requirements, separately charged rate-lock fees, and the opportunity cost of a larger down payment. The APR is a strong starting filter, not the final word.
How Close Does the Lender’s APR Have to Be
Federal law doesn’t demand a mathematically perfect APR. For a standard mortgage, the disclosed APR is considered accurate if it falls within one-eighth of one percentage point (0.125%) of the true calculated rate. For irregular transactions with features like multiple advances or uneven payments, the tolerance widens to one-quarter of one percentage point.5Consumer Financial Protection Bureau. 12 CFR 1026.22 – Determination of Annual Percentage Rate If your Excel check comes out more than 0.125% off from the lender’s figure, something is worth investigating — most often, a fee that should or shouldn’t have been included in the finance charge total.
A materially inaccurate APR on a refinance or home equity loan can also extend your three-business-day right of rescission to as long as three years from closing or until you sell the property, whichever comes first.8GovInfo. 15 USC 1635 – Right of Rescission as to Certain Transactions After closing, the final APR appears on the Closing Disclosure, and if it exceeds the allowed tolerance, the lender has to issue a corrected disclosure and restart the three-business-day waiting period before the loan can close.2Consumer Financial Protection Bureau. TILA-RESPA Integrated Disclosure FAQs