| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to: average annual growth
Hi,
I'd would like to know if there is a worksheet function that will allow me to calculate the average annual dividend growth for the last 5 years. Here's my example: YEAR ---- ANNUAL DIVIDEND 2001 ---- $0.12 2002 ---- $0.18 2003 ---- $0.29 2004 ---- $0.44 2005 ---- $0.69 Is there a quick way to calculate the average annual dividend growth? thanks in advance! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating average annual change in real estate value | Excel Discussion (Misc queries) | |||
| average annual return | 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) | |||
Linear Mode
