Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
rate formula
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
I think I got it
-----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 . I just ended up dividing the equity by the original investment. I think this should be OK. Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to calculate billable rate using base rate and percentage | Excel Worksheet Functions | |||
Calculating a daily rate when the rate could be fixed or variable | New Users to Excel | |||
Prime rate/Liber rate into sheet automatically? | Excel Discussion (Misc queries) | |||
Real RATE of return using =RATE illusive, inflation adjusted inflo | Excel Worksheet Functions | |||
APR - Annual Percentage Rate to Actual Interest Rate | Excel Worksheet Functions |