0% found this document useful (0 votes)
2 views12 pages

excel template

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1/ 12

DASHBOARD FOR COMPANY

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

$ 2,000,000 $ 3,000,000 50% $ 5,000,000 67% $ 4,000,000 -20%


$ 500,000 $ 600,000 20% $ 650,000 8% $ 650,000 0%
$ 23 $ 25 9% $ 21 -16% $ 21 0%
$ 2.40 $ 2.00 -17% $ 2.90 45% $ 2.90 0%
15% 16% 7% 20% 25% 20% 0%

ue/Profit Char t Title


600,000 4 0.25
400,000 3 0.2
200,000 0.15
2
- 0.1
1 0.05
12 13
/ 20 / 20 0 0
1 1
1/ 1/ 1/1/2010 1/1/2011 1/1/2012 1/1/2013

nue Profit EPS ROE

Y10 Y11 % change Y12 % change Y13 % change

11% 10% -9% 15% 50% 15% 0%


$ 48.00 $ 55.00 15% $ 50.00 -9% $ 50.00 0%
$ 3.00 $ 2.00 -33% $ 3.50 75% $ 3.50 0%
$ 5,000.00 $ 6,000.00 20% $ 6,500.00 8% $ 6,000.00 -8%
5.5 6.00 9% 5 -17% 5 0%
$ 1,000,000 $ 1,500,000 50% $ 1,510,000 1% $ 16,000,000 960%

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

$ 12,000 $ 12,500 4% $ 13,500 8% $ 13,500 0%


4.00 5.00 5% 6.00 20% 6.00 0%
$ 24.00 $ 23.00 -4% $ 23.00 0% $ 23.00 0%
11% 12% 9% 10% -17% 10% 0%
1,254 320 -74% 160.00 -50% 1,250.00 681%
11% 12% 9% 10% -17% 10% 0%

Y10 Y11 % change Y12 % change Y13 % change

1,528 1,600 5% 1,760 10% 1,760 0%


4 5 25% 3 -40% 3 0%
1,528 1,600 5% 1,760 10% 1,760 0%
$ 3.00 2 -33% 3 50% 3 0%
1,528 1,600 5% 1,760 10% 1,760 0%

Y10 Y11 % Y12 % Y13 %


11% 12% 9% 10% -17% 10% 0%
11% 12% 9% 110% 817% 110% 0%
$ 120 $ 125 4% $ 125 0% $ 125 0%
0 100 0% 100 0% 150 50%
12/31/2010 12/31/2011 12/31/2012 12/31/2013 12/31/2014
Revenue 2,000,000 3,000,000 5,000,000 4,000,000
Profit 500,000 600,000 650,000 650,000
Share 23 25 21 $ 21
12/31/2010 12/31/2011 12/31/2012 12/31/2013
EPS $ 2.40 $ 2.00 2.9 $ 3
ROE 15% 16% 0.2 $ 0

12/31/2010 12/31/2011 12/31/2012 12/31/2013


Market Sha 11% 10% 15% 15%
average pri $ 48.00 $ 55.00 $ 50.00 $ 50.00
Industry av $ 65.00 $ 57.00 $ 52.00 $ 54.00
Timeline Market Share Forecast(Market Share) Lower Confidence Bound(Market Share)
12/31/2010 11%
12/31/2011 10%
12/31/2012 15% 15% 15%
12/31/2013 16% 13%
12/31/2014 18% 14%

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

Market Share Forecast(Market Share)


Lower Confidence Bound(Market Share) Upper Confidence Bound(Market Share)
Timeline Revenue Forecast(Revenue) Lower Confidence Bound(Revenue)
12/31/2010 3,000,000
12/31/2011 3,000,000
12/31/2012 5,000,000 5,000,000 5,000,000
12/31/2013 5,741,601 3,451,322
12/31/2014 6,662,302 4,327,115
Upper Confidence Bound(Revenue) Statistic Value 10,000,000
Alpha 0.10 9,000,000
Beta 0.10 8,000,000
5,000,000 Gamma 0.00 7,000,000
8,031,880 MASE 0.40 6,000,000
8,997,489 SMAPE 0.11 5,000,000
MAE 399,666.67
4,000,000
RMSE 588,671.10
3,000,000
2,000,000
1,000,000
-
1/1/2010 1

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)

You might also like