Telecom Economics: ARPU, Churn, Network Capex & Tower Math
Roll a mobile subscriber base forward, measure ARPU and churn, value customers after handset subsidies, size busy-hour capacity and a coverage rollout, run tower and spectrum economics and bridge EBITDA – every cell checked as you go.
The first lesson is free — no account needed.
About this course
A telecom economics course that models one fictional mobile operator from subscribers to EBITDA in a spreadsheet, for telecom analysts, network planners, consultants and investors who cover the sector. You roll the subscriber base forward with gross adds, churn and net adds, calculate ARPU per plan and blended ARPU and see how the plan mix moves it, value prepaid, subsidised postpaid and SIM-only customers after handset subsidies with a payback month, forecast data traffic and busy-hour capacity per site, size a 5G coverage rollout by cell radius with its capex, analyse a tower company's tenancy ratio and EBITDA per tower, compare spectrum licences on price per MHz-pop and bridge EBITDA and margin from one year to the next in a waterfall chart. The first lab is free.
Lessons
- Subscriber Roll-Forward: Gross Adds, Churn and Net AddsFree
- ARPU by Plan and Blended ARPU: Why the Mix Matters Pro
- Churn, Customer Lifetime Value and Handset Subsidies Pro
- Network Traffic Growth and Busy-Hour Capacity per Site Pro
- Coverage Rollout: Sites Needed by Area and Cell Radius, and the Capex Pro
- Tower Economics: Tenancy Ratio, Rent per Tenant and EBITDA per Tower Pro
- Spectrum Cost per MHz-pop and the Annual Cost per Subscriber Pro
- EBITDA and Margin Bridge: From 2025 to 2026 in a Waterfall Pro