All templates
Infrastructure

Fibre Network Deployment ModelFree Financial Model Download

Model fiber network deployment with route optimization, subscriber ramp, and payback period. No ignoring construction delays or the drag of low early take rates on financing coverage.

Free download. No sign-up required.

Loading...

About this model

A fiber-to-the-premises (FTTP) network model projects the deployment of broadband infrastructure to 100,000 homes over seven years, with residential subscribers ramping from zero to 30,000+ through a 35% penetration rate on the addressable base. Revenue comes from residential broadband subscriptions ($60/month, with 3% CPI-linked inflation), enterprise services ($500/month per dedicated lease line), and installation fees ($100 per new connection). The network build capex is $650 per home passed (cost per home passed, CPHP) for the fiber and passive infrastructure, plus $250 per connection (cost per connected, CPHC) for customer drop and activation.

The model tracks the build schedule (homes passed) and the subscription ramp (homes ready for service, with a one-year lag post-build). Churn is modeled at 1.2% monthly (effective ~7-year customer lifetime). Operating expenses include IP transit and interconnect ($3% of revenue), network operations and maintenance ($3% of revenue), sales and marketing ($200 per gross new subscriber), staff ($15% of revenue at maturity), and corporate overhead ($15% of revenue). The network reaches EBITDA-positive in Year 4–5 as the subscriber base scales and fixed costs are diluted.

Capital intensity is brutal in early years (capex peaks at 200%+ of revenue during the build phase). The model is financed with $50 million debt at 7.5% and $60 million sponsor equity. This template is suitable for infrastructure funds, PE investors, and regional broadband companies evaluating FTTP network deployments.

income_statement.xlsx
Income statement, brown brand palette
income_statement.xlsx
Income statement, green brand palette
income_statement.xlsx
Income statement, red brand palette

Recolor to your brand.
Formatted to IB standards.

Named theme colors repaint the whole workbook in one click, on top of an investment-banking structure with blue inputs, black formulas, and green cross-sheet links.

  • Brand-ready
  • Institutional grade
  • Fully auditable

What's included

  • Network design: backbone, distribution, feeder, and drop miles with unit capex
  • Total network capex and phased buildout schedule
  • Subscriber acquisition: residential, business, and anchor tenants
  • ARPU by customer type and service tier
  • Operating costs: maintenance, customer support, and network operations

Phased buildout by network segment

Plan deployment in stages from backbone through drops to match market demand and manage capital draw efficiently.

Subscriber take rate and churn modeling

Forecast customer acquisition and churn in competitive markets against existing cable and DSL alternatives.

Debt capacity and project financing

Model capex drawdown, debt service coverage, and payback period to support project financing and bond issuance.

Frequently asked

What is a fibre network deployment model?+

A project finance model that forecasts network capex by segment, subscriber ramp, revenue by customer type, and payback period for a fiber broadband buildout.

What is fiber route mile capex?+

Fiber capex typically ranges $1k-3k per mile depending on terrain, rights-of-way, and labor costs. Rural areas generally cost more than urban deployments.

What is take rate or market penetration?+

The percentage of serviceable households that subscribe. Realistic rates are 20-40% in competitive markets and 40-60% in less competitive markets.

How long until a fiber network is cash-flow positive?+

Typically 8-15 years depending on capex intensity, take rate, and ARPU. Some mature networks with strong take rates generate positive cash flow sooner.

Who uses fibre network models?+

Telecom operators, regional ISPs, infrastructure investors, and broadband developers use them for buildout planning, financing, and M&A valuation.

Alex Tapio, founder of Finamodel and ex-Deloitte financial modelling expert

Alex Tapio

Founder of Finamodel • Professional Financial Modeller • Ex-Deloitte