Skip to content

Formula for Calculating APR on FHA Loan (Excel)

I'm working on a spreadsheet that automatically calculates the APR for a variety of loan scenarios on our loan officer's rate sheet. I'm trying to create a formula (or series of formulas) in Excel that will calculate the APR on an FHA loan with PMI. Can anyone help me with that?

Randy Carey

If you can figure out how to accurately calculate an APR using excel, then you are better than most people. I have never seen an Excel product that was accurate.


Richard Insley

All of the math is spelled out in Appendix J of Reg. Z. It's not simple. There is a general equation and several special variations, however in all cases the solution is rendered by the process of iteration.

First published on 10/20/2014

Filed under: 
Filed under lending as: 

Banker Store View All

From training, policies, forms, and publications, to office products and occasional gifts, it’s available here:

Banker Store

hot right now

image description

Looking for effective, convenient training on a particular subject?

BOL Learning Connect offers more than 200 courses ON-DEMAND or on CD ROM from AML to Reg Z and every topic in between.

Search Topics