Calculating Compound Growth

Posted by Carmen on November 30, 2000 9:12 AM

I have a multiple series of dollar amounts over
5 years and need to calculate compound growth. I've
used Goal Seek, however, I'm hoping someone knows
a formula I can use. I don't have solver or the
analysis tool-pak. Thanks for any and all help.

Posted by lOREN on November 30, 2000 12:39 PM

Look up functions Linest; Logest; Growth
in the excel help

Posted by Loren on December 01, 2000 4:46 AM

Re: Compound Growth -quick & dirty

Using only the first and last year data:
=(C4/B4)^(1/E3)
B4 and C4 are the $ amounts, E3 is the number of
years of growth, apparently 4. If the result is a number
like 1.13, the annual % is 13