Excel 2007 formula for % yield when known are PV, FV and time held of a one-time investment

Formula for the % yield when known are the presnt value, future value and time held of a one-time investment?

--------------------------------------------------------------------------------

Why does Microsoft not have such a formula? On Excel 2000 it was: "=RATE(FV,PV,TimePeriod)"; but, Office 2007 Excel calls that a formula for an annuity & requires a notional % entry and a lot of incomprehensible "iterration". Useless for a once simple calculation formula.
This just in 5/25/2010: Nowhere have I been able to find what's wrong, until someone showed the formula with a hyphen (minus sign) in front of the PV.
That does the trick, & without any of those Type & Guess requirements or iteration stuff.
Don't understand why Microsoft or anyone else never shows that hyphen in all their RATE formulas.
wljohnson
Asked May 14, 2010
Edited May 25, 2010

TIP: If it's not your answer to this question, please click "Leave a Comment" button under the question to communicate with the question owner.

Categories