Thread: rate formula
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Dana DeLouis[_5_] Dana DeLouis[_5_] is offline
external usenet poster
 
Posts: 77
Default 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