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.
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.