Thread: rate formula
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Phil Phil is offline
external usenet poster
 
Posts: 2
Default rate formula

Scott,

rate=(250-200)/200
obviously you can reference cells for initial investment
and ending value. If your dealing with multi year
investments and want the annual return you could divide
the results of rate by the number of periods
annualrate= ((250-200)/200)/(# of years)

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