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