Created this small xl utility tool for a friend which gives the Current Value of an investment over a period of time based on compounded annual rate of interest or return.

Second tab in this utility does the reverse of it i.e. computes the Compounded Annual Rate of Return for an investment based on invested amount and current value.

Try out yourself!!