LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default 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!

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to: average annual growth [email protected] Excel Worksheet Functions 0 May 2nd 06 07:11 PM
Calculating average annual change in real estate value James Hobart Excel Discussion (Misc queries) 5 March 28th 06 04:54 AM
average annual return rathersurf Excel Worksheet Functions 1 July 22nd 05 04:48 AM
Compound Annual Growth Rate Stash Excel Discussion (Misc queries) 2 March 30th 05 07:49 PM
Compound annual growth rate [CAGR] Paul Excel Discussion (Misc queries) 2 March 17th 05 11:17 PM


All times are GMT +1. The time now is 01:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"