Thread: rate formula
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default rate formula

=(250000-200000)/200000

=(end-start)/start

format as %

will provide the percentage you describe.



Regards,
Tom Ogilvy


"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