|
Navigation |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Topline Model |
Îê |
|
|
|
|
|
Product_A Operating
Assumtions |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Projected
Fiscal Period Ending |
|
(USD in 000s, except otherwise stated) |
|
|
|
|
|
Jun.14 |
Sep.14 |
Dec.14 |
Mar.15 |
Jun.15 |
Sep.15 |
Dec.15 |
Mar.16 |
Jun.16 |
Sep.16 |
Dec.16 |
Mar.17 |
Jun.17 |
Sep.17 |
Dec.17 |
Mar.18 |
Jun.18 |
Sep.18 |
Dec.18 |
Mar.19 |
|
|
|
Volume |
000s |
|
800.0 |
808.0 |
816.1 |
824.2 |
832.5 |
840.8 |
849.2 |
857.7 |
866.3 |
874.9 |
883.7 |
892.5 |
901.5 |
910.5 |
919.6 |
928.8 |
938.1 |
947.4 |
956.9 |
966.5 |
|
Annual Growth Rate |
% per annum |
|
|
4.0% |
4.0% |
4.0% |
4.0% |
4.0% |
4.0% |
4.0% |
4.0% |
4.0% |
4.0% |
4.0% |
4.0% |
4.0% |
4.0% |
4.0% |
4.0% |
4.0% |
4.0% |
4.0% |
|
|
Sales % by Channel |
|
|
|
|
Retail |
% of Sales by
Volume |
|
45.0% |
45.0% |
45.0% |
45.0% |
45.0% |
45.0% |
45.0% |
45.0% |
45.0% |
45.0% |
45.0% |
45.0% |
45.0% |
45.0% |
45.0% |
45.0% |
45.0% |
45.0% |
45.0% |
45.0% |
|
Wholesail |
% of Sales by
Volume |
|
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
|
Promo |
% of Sales by
Volume |
|
10.0% |
10.0% |
10.0% |
10.0% |
10.0% |
10.0% |
10.0% |
10.0% |
10.0% |
10.0% |
10.0% |
10.0% |
10.0% |
10.0% |
10.0% |
10.0% |
10.0% |
10.0% |
10.0% |
10.0% |
|
Overstock |
% of Sales by
Volume |
|
20.0% |
20.0% |
20.0% |
20.0% |
20.0% |
20.0% |
20.0% |
20.0% |
20.0% |
20.0% |
20.0% |
20.0% |
20.0% |
20.0% |
20.0% |
20.0% |
20.0% |
20.0% |
20.0% |
20.0% |
|
Total |
% of Sales by
Volume |
|
100.0% |
100.0% |
100.0% |
100.0% |
100.0% |
100.0% |
100.0% |
100.0% |
100.0% |
100.0% |
100.0% |
100.0% |
100.0% |
100.0% |
100.0% |
100.0% |
100.0% |
100.0% |
100.0% |
100.0% |
|
|
Average List Price |
USD |
|
100.0 |
101.3 |
102.0 |
102.8 |
103.5 |
104.3 |
105.1 |
105.9 |
106.7 |
107.5 |
108.3 |
109.1 |
109.9 |
110.7 |
111.6 |
112.4 |
113.3 |
114.1 |
115.0 |
115.8 |
|
Annual Growth Rate |
% per annum |
|
|
5.0% |
3.0% |
3.0% |
3.0% |
3.0% |
3.0% |
3.0% |
3.0% |
3.0% |
3.0% |
3.0% |
3.0% |
3.0% |
3.0% |
3.0% |
3.0% |
3.0% |
3.0% |
3.0% |
|
|
Discount to List Price by Channel |
|
|
|
|
Retail |
% of List Price |
|
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
|
Wholesail |
% of List Price |
|
20.0% |
20.0% |
20.0% |
20.0% |
20.0% |
20.0% |
20.0% |
20.0% |
20.0% |
20.0% |
20.0% |
20.0% |
20.0% |
20.0% |
20.0% |
20.0% |
20.0% |
20.0% |
20.0% |
20.0% |
|
Promo |
% of List Price |
|
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
|
Overstock |
% of List Price |
|
30.0% |
30.0% |
30.0% |
30.0% |
30.0% |
30.0% |
30.0% |
30.0% |
30.0% |
30.0% |
30.0% |
30.0% |
30.0% |
30.0% |
30.0% |
30.0% |
30.0% |
30.0% |
30.0% |
30.0% |
|
Average |
% of List Price |
|
13.5% |
13.5% |
13.5% |
13.5% |
13.5% |
13.5% |
13.5% |
13.5% |
13.5% |
13.5% |
13.5% |
13.5% |
13.5% |
13.5% |
13.5% |
13.5% |
13.5% |
13.5% |
13.5% |
13.5% |
|
|
Revenue |
USD 000s |
|
|
69 200.0 |
70 765.7 |
72 009.4 |
73 274.9 |
74 562.7 |
75 873.2 |
77 206.6 |
78 563.5 |
79 944.3 |
81 349.3 |
82 779.0 |
84 233.9 |
85 714.3 |
87 220.7 |
88 753.6 |
90 313.5 |
91 900.7 |
93 515.9 |
95 159.4 |
96 831.8 |
|
Annual Growth Rate |
% per annum |
|
9.0% |
7.0% |
7.0% |
7.0% |
7.0% |
7.0% |
7.0% |
7.0% |
7.0% |
7.0% |
7.0% |
7.0% |
7.0% |
7.0% |
7.0% |
7.0% |
7.0% |
7.0% |
7.0% |
|
|
|
|
|
|
COGS |
|
|
|
|
Materials |
USD 000s |
|
32 000.0 |
32 724.0 |
33 464.4 |
34 221.5 |
34 995.8 |
35 787.6 |
36 597.2 |
37 425.3 |
38 272.0 |
39 137.9 |
40 023.4 |
40 928.9 |
41 855.0 |
42 801.9 |
43 770.3 |
44 760.6 |
45 773.3 |
46 808.9 |
47 868.0 |
48 951.0 |
|
Materials / Unit of Sales |
USD |
|
40.0 |
40.5 |
41.0 |
41.5 |
42.0 |
42.6 |
43.1 |
43.6 |
44.2 |
44.7 |
45.3 |
45.9 |
46.4 |
47.0 |
47.6 |
48.2 |
48.8 |
49.4 |
50.0 |
50.6 |
|
Annual Growth Rate |
% per annum |
|
|
|
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
|
Personnel |
USD 000s |
|
|
8 000.0 |
8 181.0 |
8 366.1 |
8 555.4 |
8 748.9 |
8 946.9 |
9 149.3 |
9 356.3 |
9 568.0 |
9 784.5 |
10 005.9 |
10 232.2 |
10 463.7 |
10 700.5 |
10 942.6 |
11 190.2 |
11 443.3 |
11 702.2 |
11 967.0 |
12 237.8 |
|
Personnel / Unit of Sales |
USD |
|
10.0 |
10.1 |
10.3 |
10.4 |
10.5 |
10.6 |
10.8 |
10.9 |
11.0 |
11.2 |
11.3 |
11.5 |
11.6 |
11.8 |
11.9 |
12.0 |
12.2 |
12.4 |
12.5 |
12.7 |
|
Annual Growth Rate |
% per annum |
|
|
|
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
|
Utilities |
USD 000s |
|
|
4 000.0 |
4 090.5 |
4 183.0 |
4 277.7 |
4 374.5 |
4 473.4 |
4 574.7 |
4 678.2 |
4 784.0 |
4 892.2 |
5 002.9 |
5 116.1 |
5 231.9 |
5 350.2 |
5 471.3 |
5 595.1 |
5 721.7 |
5 851.1 |
5 983.5 |
6 118.9 |
|
Utilities / Unit of Sales |
USD |
|
5.0 |
5.1 |
5.1 |
5.2 |
5.3 |
5.3 |
5.4 |
5.5 |
5.5 |
5.6 |
5.7 |
5.7 |
5.8 |
5.9 |
5.9 |
6.0 |
6.1 |
6.2 |
6.3 |
6.3 |
|
Annual Growth Rate |
% per annum |
|
|
|
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
|
Contractors |
USD 000s |
|
|
500.0 |
506.3 |
512.6 |
519.0 |
525.5 |
532.0 |
538.7 |
545.4 |
552.2 |
559.1 |
566.1 |
573.2 |
580.4 |
587.6 |
595.0 |
602.4 |
609.9 |
617.6 |
625.3 |
633.1 |
|
Contractors / Unit of Sales |
USD |
|
0.6 |
0.6 |
0.6 |
0.6 |
0.6 |
0.6 |
0.6 |
0.6 |
0.6 |
0.6 |
0.6 |
0.6 |
0.6 |
0.6 |
0.6 |
0.6 |
0.7 |
0.7 |
0.7 |
0.7 |
|
Annual Growth Rate |
% per annum |
|
|
|
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
|
Other COGS |
USD 000s |
|
|
150.0 |
151.9 |
153.8 |
155.7 |
157.6 |
159.6 |
161.6 |
163.6 |
165.7 |
167.7 |
169.8 |
172.0 |
174.1 |
176.3 |
178.5 |
180.7 |
183.0 |
185.3 |
187.6 |
189.9 |
|
Other COGS / Unit of Sales |
USD |
|
0.2 |
0.2 |
0.2 |
0.2 |
0.2 |
0.2 |
0.2 |
0.2 |
0.2 |
0.2 |
0.2 |
0.2 |
0.2 |
0.2 |
0.2 |
0.2 |
0.2 |
0.2 |
0.2 |
0.2 |
|
Annual Growth Rate |
% per annum |
|
|
|
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
|
Total COGS |
USD 000s |
|
|
44 650.0 |
45 653.6 |
46 679.9 |
47 729.3 |
48 802.3 |
49 899.5 |
51 021.5 |
52 168.8 |
53 341.9 |
54 541.5 |
55 768.2 |
57 022.5 |
58 305.0 |
59 616.6 |
60 957.7 |
62 329.0 |
63 731.3 |
65 165.1 |
66 631.4 |
68 130.7 |
|
Product Gross Margin |
USD 000s |
|
|
24 550.0 |
25 112.0 |
25 329.5 |
25 545.7 |
25 760.4 |
25 973.6 |
26 185.1 |
26 394.8 |
26 602.4 |
26 807.8 |
27 010.9 |
27 211.4 |
27 409.2 |
27 604.2 |
27 796.0 |
27 984.5 |
28 169.5 |
28 350.7 |
28 528.0 |
28 701.2 |
|
Gross Margin |
% |
|
|
35.5% |
35.5% |
35.2% |
34.9% |
34.5% |
34.2% |
33.9% |
33.6% |
33.3% |
33.0% |
32.6% |
32.3% |
32.0% |
31.6% |
31.3% |
31.0% |
30.7% |
30.3% |
30.0% |
29.6% |
|
|
>> End of Sheet |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|