Given fixed rate mortgages APR and no closing fees
=(1+5%/12)^12-1


"marlia" wrote in message
...
What is the Excel formula for computing an APR on a mortgage? I have the
formulas for computing payments, etc., but have never found one for the
APR.

Thanks!