View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PatJennings PatJennings is offline
external usenet poster
 
Posts: 19
Default Compound Average Annual Growth Rate

Can someone help define the formula to calculate the compound average growth
rate (CAGR) starting with an initial amount which grows or shrinks depending
upon the earnings for the year? Is the formula included in the formulae
included in Excel?

That data is in columns:
A: Year
B: Year's average interest rate growth or loss
C: Value of investment, e,g. starting at $1,000 and changing each year by
the rate in column B.
D: The CAGR effective to that year.

Thank you for your assistance.

Pat