excel template
excel template
excel template
Summary Measure
profit growth slowed --reason why Revenue
Profit
Introduction Share
Strategy low: cost leader/differentiation EPS
ROE
Revenue/Profit
6,000,000
600,000
4,000,000
400,000
2,000,000 200,000
- -
10 11 12 13
/ 20 / 20 / 20 / 20
1 1 1 1
1/ 1/ 1/ 1/
Revenue Profit
Customer analytics
key issues market share
any negative changes average price per pair
Rebate
Retailer Support - wholesale p
fall in market share average star rating
star rating relative to average price marketing costs
Chart Title
$70.00
$60.00
$50.00
$40.00
$30.00
$20.00
$10.00
$-
average price per pair Industry average price pe
Operations
Cost of production $m
star rating
cost per pair shoes
plant upgrades
inventory
reject rate
Human resources
productivity per worker
star rating
cost per pair shoes
incentives
avg remuneration
Financial
profit percentage
% dividend paid
loans outstanding $m
Share buy back
Y10 Y11 % change Y12 % change Y13 % change
Chart Title
16%
14%
12%
10%
8%
6%
4%
2%
0%
ce per pair Industry average price per pair Market Share
Y10 Y11 % change Y12 % change Y13 % change
25%
20%
15%
10%
5%
0%
1/1/2010
Market
Lower C
Upper Confidence Bound(Market Share) Statistic Value
Alpha 0.10
Beta 0.10
15% Gamma 0.00
20% MASE 0.40
22% SMAPE 0.10
MAE 0.01
RMSE 0.02
25%
20%
15%
10%
5%
0%
1/1/2010 1/1/2011 1/1/2012 1/1/2013 1/1/2014
Revenue
Lower Confidenc
00
00
00
00
00
00
00
00
00
00
-
1/1/2010 1/1/2011 1/1/2012 1/1/2013 1/1/2014
Revenue Forecast(Revenue)
Lower Confidence Bound(Revenue) Upper Confidence Bound(Revenue)
Timeline Share Forecast(Share) Lower Confidence Bound(Share)
12/31/2010 23
12/31/2011 25
12/31/2012 21 21 21.00
12/31/2013 20.775197 16.67
1/31/2014 20.7104704438356 16.60
30
25
20
15
10
0
1/1/2010 1/1/2011 1/1/2012 1/1/2013 1/1/2014
Share Forecast(Share)
Lower Confidence Bound(Share) Upper Confidence Bound(Share)
Upper Confidence Bound(Share)
21.00
24.88
24.83
1/1/2013 1/1/2014
cast(Share)
er Confidence Bound(Share)