Comparing FTTP and FTTN costs for NBN Australia

These models (xls, Numbers for Mac OS X, csv) compare the Capital costs (CAPEX), Operating costs (OPEX) and revenue generated for a single household. The aim primarily is to compare the upfront and continuing costs and revenues of a household connected to FTTN (Fibre to the Node) and FTTP (Fibre to the Premises). Original analysis in OSX Numbers (one page), translated into XLS (multi-page), CSV (multi-file). <br>Variables include: (1) CAPEX, (2) annual OPEX, (3) annual revenue, (4) Life of asset.The model also compares FTTP not starting until (5) Year X, where X is supplied by the user. The model also allows (in Numbers) to set yearly period of output e.g. annual, each decade, half-decade etc.<br>V2 Now updated with discounted cash flow and discounted GDP impact in DCF files. 08.01.16<br>V3 Now updated with GDP boost (externality 1%, 2% variable) in DCF_Externality files. 25.01.16.<br>The model calculates breakeven; based on CAPEX, OPEX and Revenue. The model calculates yearly Cash balance (net costs and revenues), profit (adding depreciation and subtracting CAPEX), and GDP impact i.e. Revenue, plus costs, plus profit/loss of NBN Operator.<br><br>Current issues with model:- life span of FTTN (est = 10 years; FTTP set conservatively to 25 years)- current Revenue and OPEX figures are assumed annual with no changes over time- FTTN figures after ten years, especially for revenue are not likely to be stable- customer satisfaction for FTTN likely to decline as relative speed compared to FTTP declines, not accounted for- does not account for HFC<br><br>Further description in blog post attached.NBN is the National Broadband Network, a 2007 project to connect all Australians to faster broadband. The 2009 ALP Government proposed connecting 93% to FTTP, while the 2013 Liberal National Coalition proposed connecting 25% of household to FTTN, 25% to FTTP and 40% to HFC. Remainder is wireless and satellite like the ALP proposal. The NBN is expected to complete in 2020 under the Coalition and 2025 under ALP proposals.