| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding Annual Growth Rate | Excel Worksheet Functions | |||
| How to get compound annual growth rates in pivot tables. | Excel Worksheet Functions | |||
| Compound Annual Growth Rate | Excel Discussion (Misc queries) | |||
| What formula do I use to calculate compound annual growth rate (C. | Excel Discussion (Misc queries) | |||
| Compound annual growth rate [CAGR] | Excel Discussion (Misc queries) | |||
Threaded Mode
