| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | https://docs.google.com/file/d/0B1GLdfqdwpNQamRkS1BTNGNUVzQ/edit?usp=sharing | From Bgnd doc: NBN Co Plan | Coalition NBN Plan | |||||||||||||||
2 | ($ million) | FY2010 | FY2011 | FY2012 | FY2013 | FY2014 | FY2015 | FY2016 | FY2017 | FY2018 | FY2019 | FY2020 | FY2021 | Sum 2012-2021 | ||||
3 | Revenue | $0 | $2 | $18 | $53 | $275 | $825 | $1,624 | $2,438 | $3,164 | $3,344 | $4,256.56 | $8,399 | $16,000 | $16,000 | |||
4 | Implied Active Subscribers | 0 | 7,421 | 52,743 | 198,413 | 903,654 | 2,496,369 | 4,572,072 | 6,431,360 | 7,844,887 | ||||||||
5 | Yrly Active Subs | 7,421 | 45,322 | 145,670 | 705,241 | 1,592,715 | 2,075,703 | 1,859,288 | 1,413,527 | |||||||||
6 | OpEx | -$337 | -$521 | -$1,093 | -$1,061 | -$1,397 | -$2,560 | -$3,516 | -$3,667 | -$3,335 | -$2,425 | -$2,425 | -$17,150 | -$22,000 | -$22,000 | |||
7 | EBITDA | -$337 | -$519 | -$1,075 | -$1,008 | -$1,122 | -$1,735 | -$1,892 | -$1,229 | -$171 | ||||||||
8 | CapEx | -$463 | -$888 | -$3,190 | -$2,842 | -$3,064 | -$3,386 | -$2,981 | -$2,505 | -$2,127 | ||||||||
9 | Cashflow | -$100 | -$729 | -$1,154 | -$3,715 | -$3,569 | -$4,088 | -$5,371 | -$5,157 | -$4,045 | -$2,402 | postive | ||||||
10 | Calculated Missing CashFlow | $71 | $253 | $550 | $281 | $98 | -$250 | -$284 | -$311 | -$104 | ||||||||
12 | Cumm Cash Position | -$100 | -$829 | -$1,983 | -$5,698 | -$7,734 | -$11,822 | -$17,193 | -$22,350 | -$26,395 | -$28,796 | $29,500 | ||||||
13 | ARPU ($/month) | $0 | $22.46 | $28.44 | $22.26 | $25.36 | $27.54 | $29.60 | $31.59 | $33.61 | $34.79 | $36.00 | ||||||
14 | REAL ARPU ($2012) | $0 | $22.46 | $27.75 | $21.19 | $23.55 | $24.95 | $26.16 | $27.24 | $28.28 | $29.36 | $30.48 | ||||||
15 | ||||||||||||||||||
16 | Rollout numbers | |||||||||||||||||
17 | Wireless | 572,000 | ||||||||||||||||
18 | Satellite | 372,000 | ||||||||||||||||
19 | Fibre | 2,802,000 | ||||||||||||||||
20 | DSL | 8,968,000 | ||||||||||||||||
21 | ||||||||||||||||||
22 | Claims in Policy Document | |||||||||||||||||
23 | Total Funding of $29.5 billion | |||||||||||||||||
24 | Revenue over 2012‐2021 is $16 billion, versus $23 billion in the current NBN Co plan. | |||||||||||||||||
25 | Opex over 2012‐2021 is $22 billion, versus $26 billion in the current NBN Co plan. | |||||||||||||||||
26 | Capex over 2012‐2021 is $22 billion, versus $37.4 billion in the current NBN Co plan. | |||||||||||||||||
27 | Capex to 2019, when the rollout reaches 100 per cent coverage, is about $20.4 billion. | |||||||||||||||||
28 | The NBN is projected to be cash flow positive in 2020‐21. | |||||||||||||||||
29 | ||||||||||||||||||
30 | ||||||||||||||||||
31 | ||||||||||||||||||
32 | ||||||||||||||||||
33 | ||||||||||||||||||
34 | ||||||||||||||||||
35 | ||||||||||||||||||
36 | ||||||||||||||||||
37 | ||||||||||||||||||
38 | ||||||||||||||||||
39 | ||||||||||||||||||
40 | ||||||||||||||||||
41 | ||||||||||||||||||
42 | ||||||||||||||||||
43 | ||||||||||||||||||
44 | ||||||||||||||||||
45 | ||||||||||||||||||
46 | ||||||||||||||||||
47 | ||||||||||||||||||
48 | ||||||||||||||||||