Is there a formula to figure mortgage APR in excel?
The correct APR should be 7.4459
"Niek Otten" wrote:
<is close to the true answer
If you tell us what you think the "true answer" is, it might save a lot of time.
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"Toby" wrote in message ...
|I am trying to create a simple formula to accurately figure APR. Nothing
| have used so far is close to the true answer. Is there a formula for this?
| Example Paramaters:
|
| loan amount: 150,000
| Term: 30 years
| Rate: 6.5%
| Closing costs that affect APR: 2,000
|