Value Investing Forum

Discuss value investing stock ideas

 You must be logged in to post
Search Forums:


 






Wildcard Usage:
*    matches any number of characters
%    matches exactly one character

Home Tools and Resources rolling median growth calculation

rolling median growth calculation
Page:   1  
UserPost

11:47 pm
September 8, 2011


Jae Jun

Admin

posts 1464
2

Hi saalu3

What you are referring to isn't the rolling median. It is the CAGR growth from 2006 to 2008.

http://www.investopedia.com/te…..c/cagr.asp

If you use that formula, you will get the growth rate.

 

The rolling median is the median value of all the multiyear periods.

11:36 pm
September 8, 2011


saalu3

New Member

posts 1
1

Hi ,

 

 Can anyone please explain how the EPS rolling growth calculation is done.

The calculation that Iam using does not seem to match the result in old school value Excel. Please let me know what's wrong in my calculation.

 

For EX: for MDT stock :

EPS 2006    2.09

EPS 2007    2.41   15.31% (growth rate)

EPS 2008    1.95   -19.09 % (growth rate)

 

average growth  : -1.89 . (15.31 -19.09 /2 )

But the growth in Excel sheet  is – 3.04 .

 

What is wrong in my way of calculation ?

 

Thanks,

Saalu.
Page:   1  


About the Stock Valuation Software forum

Forum Timezone: America/Los_Angeles

Most Users Ever Online: 170

Currently Online: Jae Jun, nell
16 Guests

Currently Browsing this Topic:
1 Guest

Forum Stats:

Groups: 4
Forums: 40
Topics: 766
Posts: 4121

Membership:

There are 958 Members
There have been 9 Guests

There is 1 Admin
There are 3 Moderators

Top Posters:

somrh – 336
Graeme – 183
nell – 100
zehua – 96
valueinvestortoday – 80
krackerjack121 – 69

Recent New Members: autocats, silverfox, jman, matias091, foundos, pberardi

Administrators: Jae Jun (1463 Posts)

Moderators: Jae Jun (1463 Posts), VANYA (1 Post), djsun (0 Posts)