ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
This is an example of how GuruFocus calculates Wal-Mart Stores Inc (WMT)'s revenue growth rate (5-Y, 10-Y, 1-Y, 3-Y)
2
3
Annual Data
4
5-Year
Growth Rate
Fiscal PeriodJan 2001Jan 2002Jan 2003Jan 2004Jan 2005Jan 2006Jan 2007Jan 2008Jan 2009Jan 2010Jan 2011Jan 2012Jan 2013Jan 2014Jan 2015
5
6
Revenue per Share42.6745.952.1159.1566.7474.5283.5892.95102.35105.26114.95128.66138.29145.08149.75
7
8
5-year and 10-year growth rates are calculated with least-square regression based on the 6-year and 11-year numbers.
9
10
log10 of (rev per share)
=log10()2.0222633662.0605089762.1094435472.1407907772.1616075472.175366831
11
year012345
12
linear coefficientsy-intercept
13
Linest
=LINEST(L10:Q10,L11:Q11)
0.031433150582.033080631
14
10^Linest-1=10^G13-1
5-year Growth Rate
7.5%
15
16
Annual Data
17
10-Year
Growth Rate
Fiscal PeriodJan 2001Jan 2002Jan 2003Jan 2004Jan 2005Jan 2006Jan 2007Jan 2008Jan 2009Jan 2010Jan 2011Jan 2012Jan 2013Jan 2014Jan 2015
18
19
Revenue per Share42.6745.952.1159.1566.7474.5283.5892.95102.35105.26114.95128.66138.29145.08149.75
20
21
5-year and 10-year growth rates are calculated with least-square regression based on the 6-year and 11-year numbers.
22
23
log10 of (rev per share)
=log10()1.8243862021.8722728461.9221023671.9682493942.0100878472.0222633662.0605089762.1094435472.1407907772.1616075472.175366831
24
year012345678910
25
linear coefficientsy-intercept
26
Linest
=LINEST(G23:Q23,G24:Q24)
0.035464696461.84695649
27
10^Linest-1=10^G26-1
10-year Growth Rate
8.5%
28
29
30
Quarterly Data
31
1-Year / 12M
Growth Rate
Fiscal PeriodOct 2013Jan 2014Apr 2014Jul 2014Oct 2014Jan 2015Apr 2015Jul 2015Oct 2015
32
33
Revenue per Share35.3739.8735.3937.0636.7340.5735.4137.2136.47
34
35
36
We use quarterly data to calculate 12m growth rate.
37
12-month growth rate is calculated with the per share revenue (EBITDA, FCF, earnings, dividends) of the last 12 months over the per share revenue (EBITDA, FCF, earnings, dividends) over the previous 12 months
38
39
12m Revenue per Share ending in Oct 2015
=sum(H33:K33)
149.66
40
12m Revenue per Share ending in Oct 2014
=sum(D33:G33)
149.05
41
42
12m Growth Rate
=G39/G40-1
0.4%
43
44
Annual Data
45
3-Year
Growth Rate
Fiscal PeriodJan 2001Jan 2002Jan 2003Jan 2004Jan 2005Jan 2006Jan 2007Jan 2008Jan 2009Jan 2010Jan 2011Jan 2012Jan 2013Jan 2014Jan 2015
46
47
Revenue per Share42.6745.952.1159.1566.7474.5283.5892.95102.35105.26114.95128.66138.29145.08149.75
48
49
3-year growth rate is calculated using expontential compound based on the latest four year annual data
50
51
Jan 2015 Revenue per Share
=Q47149.75
52
Jan 2012 Revenue per Share
=N47128.66
53
54
3-Year Growth Rate
=(G51/G52)^(1/3)-1
5.2%
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100