|
Navigation |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Topline Model |
Îê |
|
|
|
|
|
|
|
|
|
Product_B 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 |
|
|
|
|
|
|
Customers BoP |
000s |
|
|
- |
190.0 |
370.5 |
542.0 |
704.9 |
859.6 |
1 006.7 |
1 146.3 |
1 279.0 |
1 405.1 |
1 524.8 |
1 638.6 |
1 746.6 |
1 849.3 |
1 946.8 |
2 039.5 |
2 127.5 |
2 211.1 |
2 290.6 |
2 366.1 |
|
|
Additions |
000s |
|
|
200.0 |
200.0 |
200.0 |
200.0 |
200.0 |
200.0 |
200.0 |
200.0 |
200.0 |
200.0 |
200.0 |
200.0 |
200.0 |
200.0 |
200.0 |
200.0 |
200.0 |
200.0 |
200.0 |
200.0 |
|
|
Churn |
% pa / 000s |
|
|
20% |
|
(10.0)
|
(19.5)
|
(28.5)
|
(37.1)
|
(45.2)
|
(53.0)
|
(60.3)
|
(67.3)
|
(74.0)
|
(80.3)
|
(86.2)
|
(91.9)
|
(97.3)
|
(102.5)
|
(107.3)
|
(112.0)
|
(116.4)
|
(120.6)
|
(124.5)
|
(128.3)
|
|
|
Customers EoP |
000s |
|
|
190.0 |
370.5 |
542.0 |
704.9 |
859.6 |
1 006.7 |
1 146.3 |
1 279.0 |
1 405.1 |
1 524.8 |
1 638.6 |
1 746.6 |
1 849.3 |
1 946.8 |
2 039.5 |
2 127.5 |
2 211.1 |
2 290.6 |
2 366.1 |
2 437.8 |
|
|
|
|
|
|
|
|
| |
Average Customers |
000s |
|
|
|
95.0 |
|
456.2 |
623.4 |
782.3 |
933.1 |
1 076.5 |
1 212.7 |
1 342.0 |
1 464.9 |
1 581.7 |
1 692.6 |
1 798.0 |
1 898.1 |
1 993.2 |
2 083.5 |
2 169.3 |
2 250.9 |
2 328.3 |
2 401.9 |
|
| |
Annual Growth Rate |
% per annum |
|
|
|
|
780.0% |
251.2% |
146.6% |
101.9% |
77.2% |
61.4% |
50.6% |
42.7% |
36.6% |
31.9% |
28.1% |
24.9% |
22.3% |
20.0% |
18.1% |
16.5% |
15.0% |
13.8% |
13% |
|
|
Average Price |
USD |
|
|
100.0 |
101.3 |
102.5 |
103.8 |
105.1 |
106.4 |
107.7 |
109.1 |
110.4 |
111.8 |
113.2 |
114.6 |
116.1 |
117.5 |
119.0 |
120.5 |
122.0 |
123.5 |
125.1 |
126.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% |
|
|
Revenue |
USD 000s |
|
|
9 500.0 |
28 375.3 |
46 771.5 |
64 709.8 |
82 210.7 |
99 293.9 |
115 978.6 |
132 283.1 |
148 225.1 |
163 821.5 |
179 089.0 |
194 043.3 |
208 699.7 |
223 073.0 |
237 177.5 |
251 026.9 |
264 634.4 |
278 012.8 |
291 174.6 |
304 131.5 |
|
|
Annual Growth Rate |
% per annum |
|
|
794.8% |
259.3% |
153.4% |
108.2% |
83.1% |
67.2% |
56.2% |
48.2% |
42.1% |
37.3% |
33.4% |
30.2% |
27.5% |
25.3% |
23.4% |
21.7% |
20.2% |
18.9% |
17.8% |
|
|
|
|
|
|
|
|
|
COGS |
|
|
|
|
|
|
Materials |
USD 000s |
|
|
3 800.0 |
11 350.1 |
18 708.6 |
25 883.9 |
32 884.3 |
39 717.6 |
46 391.5 |
52 913.2 |
59 290.0 |
65 528.6 |
71 635.6 |
77 617.3 |
83 479.9 |
89 229.2 |
94 871.0 |
100 410.8 |
105 853.8 |
111 205.1 |
116 469.8 |
121 652.6 |
|
|
Materials / Av. Customer |
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 |
% |
|
|
|
|
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 |
|
|
950.0 |
2 837.5 |
4 677.1 |
6 471.0 |
8 221.1 |
9 929.4 |
11 597.9 |
13 228.3 |
14 822.5 |
16 382.2 |
17 908.9 |
19 404.3 |
20 870.0 |
22 307.3 |
23 717.8 |
25 102.7 |
26 463.4 |
27 801.3 |
29 117.5 |
30 413.2 |
|
|
Personnel / Av. Customer |
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 |
% |
|
|
|
|
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 |
|
|
2 000.0 |
2 025.0 |
2 050.3 |
2 075.9 |
2 101.9 |
2 128.2 |
2 154.8 |
2 181.7 |
2 209.0 |
2 236.6 |
2 264.5 |
2 292.8 |
2 321.5 |
2 350.5 |
2 379.9 |
2 409.7 |
2 439.8 |
2 470.3 |
2 501.2 |
2 532.4 |
|
|
Utilities / Av. Customer |
USD |
|
|
5.0 |
7.2 |
4.5 |
3.3 |
2.7 |
2.3 |
2.0 |
1.8 |
1.6 |
1.5 |
1.4 |
1.4 |
1.3 |
1.2 |
1.2 |
1.2 |
1.1 |
1.1 |
1.1 |
1.1 |
|
|
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 / Av. Customer |
USD |
|
|
5.3 |
1.8 |
1.1 |
0.8 |
0.7 |
0.6 |
0.5 |
0.4 |
0.4 |
0.4 |
0.4 |
0.3 |
0.3 |
0.3 |
0.3 |
0.3 |
0.3 |
0.3 |
0.3 |
0.3 |
|
|
Annual Growth Rate |
% |
|
|
|
5.3% |
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 / Revenue |
USD |
|
|
1.6 |
0.5 |
0.3 |
0.2 |
0.2 |
0.2 |
0.2 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
|
|
Annual Growth Rate |
% |
|
|
|
1.6% |
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 |
|
|
|
7 400.0 |
16 870.8 |
26 102.4 |
35 105.5 |
43 890.3 |
52 466.8 |
60 844.4 |
69 032.3 |
77 039.4 |
84 874.2 |
92 545.0 |
100 059.7 |
107 425.9 |
114 651.0 |
121 742.1 |
128 706.2 |
135 549.9 |
142 279.5 |
148 901.3 |
155 421.2 |
|
|
Product Gross Margin |
USD 000s |
|
|
|
2 100.0 |
11 504.5 |
20 669.1 |
29 604.3 |
38 320.3 |
46 827.1 |
55 134.3 |
63 250.8 |
71 185.6 |
78 947.3 |
86 544.0 |
93 983.6 |
101 273.9 |
108 422.1 |
115 435.4 |
122 320.6 |
129 084.5 |
135 733.3 |
142 273.2 |
148 710.3 |
|
|
Gross Margin |
% |
|
|
|
22.1% |
40.5% |
44.2% |
45.7% |
46.6% |
47.2% |
47.5% |
47.8% |
48.0% |
48.2% |
48.3% |
48.4% |
48.5% |
48.6% |
48.7% |
48.7% |
48.8% |
48.8% |
48.9% |
48.9% |
|
|
|
>> End of Sheet |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|