<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