Calculate annual compounded rate of interest

[MC1954]

I am a rookie and need some help.

I need to calculate what the annual compounded rate of interest would be if I have an investment in year 1 which is $1,000 and would like it to be $2,500 in a five year period.

January 1, 2007 $1,000 value
January 1, 2012 $2,500 value

 

[goldfish]

=(2500/1000)^(1/5)-1

Value 1 is in B1 and Value 2 is in B2 Then use:
=(B1/B2)^(1/5)-1

Don't forget to give it a percent formating (just highlight the cell and click the percent button in the formatting toolbar)

HTH,
~Gold Fish

 

[MC1954]

Thank you very much for your time.

Best regards,