rate formula
For something "simple" like your example, perhaps the following idea...
=IRR({-200000,250000})
returns 25%
(Not array entered)
--
Dana DeLouis
Windows XP & Office XP
= = = = = = = = = = = = = = = = =
"scott" wrote in message
...
If I invest $200,000
And end up with $250,000
I've recieved a 25% rate of return(This is easy on
calculator)
If I know the beginning dollar value, and the ending
dollar value, what formula could I use to calculate this
25% ROR?
Thanks a lot. Scott
|