This comprehensive Excel model provides a bottom-up financial forecast and valuation framework for a facilities-based mobile network operator, or MNO. It connects network deployment, subscriber acquisition, retention, usage, operating costs, capital investment and financing into a fully integrated 10-year financial model.
After purchase, you will be immediately taken to the download page and emailed the download link. This is also included in the industry-specific financial models bundle, the recurring revenue models bundle, and the Super Smart Bundle.
Key Features
- 10-year connected income statement, balance sheet and cash flow statement
- Detailed 120-month operating forecast
- Monthly subscriber acquisition and retention cohort modeling
- Paid, organic/referral and partner-generated subscriber additions
- Subscriber churn based on cohort age and retention behavior
- Network-capacity constraints on new subscriber activations
- ARPU-driven recurring service revenue
- Explicit variable direct costs, including:
- Data usage and cost per GB
- Roaming and interconnection
- Billing and payment-processing fees
- Regulatory and pass-through charges
- Customer support
- Bad debt and refunds
- SIM and activation fulfillment
- Fixed network and operating expenses
- Site rollout, subscriber capacity and network utilization
- Spectrum, site, core-system and maintenance capex
- Depreciation and amortization schedules
- Accounts receivable, accounts payable and other working-capital drivers
- Tax-loss carryforwards and cash-tax calculations
- Scheduled equity funding and capped equity backstop contributions
- Construction facility, term debt and revolving credit facility
- Interest, facility fees, principal repayment and refinancing
- CFADS, DSCR, leverage and facility-headroom calculations
- Project-level unlevered DCF valuation
- Gordon-growth and exit-EBITDA terminal-value methods
- WACC calculation and midyear discounting
- Football field valuation analysis
- WACC/terminal-growth and operating sensitivities
- KPI dashboard with financial and operational visualizations
- Integrated reconciliation, funding and valuation checks
How the Model Works
The model begins with editable operating, commercial, network and financing assumptions. These assumptions drive a monthly subscriber forecast covering the full 10-year period.
New subscribers are generated through paid acquisition, organic referrals and distribution partners. Paid additions are calculated using marketing expenditures and customer acquisition cost. Actual activations are then constrained by the amount of installed network capacity.
Every month’s new subscribers become a separate retention cohort. Each cohort declines over time using age-specific churn assumptions, allowing the model to calculate active subscribers and churn more accurately than applying a single churn percentage to the entire customer base.
Average active subscribers and ARPU determine recurring service revenue. Subscriber counts, gross additions and data usage then drive variable expenses such as network usage, roaming, billing, customer support, bad debt and SIM fulfillment.
The network rollout schedule determines site deployment, installed subscriber capacity and capital expenditures. As subscriber demand increases, the company must continue investing in coverage, capacity, spectrum and core-network infrastructure.
The monthly operating results are aggregated into annual financial statements. The model then calculates working capital, taxes, depreciation, debt balances, interest, funding requirements and ending cash.
When operating cash flow, debt availability and scheduled equity are insufficient to maintain minimum liquidity, the model calculates a capped equity backstop contribution. If all available financing is insufficient, the model produces a funding-shortfall warning rather than allowing cash to remain unsupported.
The valuation section uses unlevered free cash flow to calculate enterprise value independently of the financing structure. It evaluates both a perpetual-growth terminal value and an exit-EBITDA multiple. Additional EV/revenue, EV/subscriber and replacement-cost approaches provide valuation cross-checks through the football field analysis.
Benefits of the Model
Understand Subscriber Economics
The model connects acquisition spending, CAC, churn, ARPU and variable costs to the lifetime profitability of each subscriber. This makes it possible to evaluate whether subscriber growth is economically attractive rather than focusing only on total user counts.
Model Churn More Accurately
Retention cohort modeling distinguishes between recently acquired and mature subscribers. This is particularly useful when early customer churn differs significantly from long-term churn.
Connect Demand to Network Capacity
Subscriber growth cannot exceed installed network capacity. This allows the user to see whether the planned rollout can support customer demand and when additional network investment may be required.
Identify Total Funding Requirements
The model shows how much capital is required before the network becomes self-funding. It separates scheduled equity, contingency equity, construction debt, term financing and revolver usage.
Evaluate Debt Capacity
Lenders and investors can review facility utilization, debt repayment, CFADS, DSCR and leverage. This helps identify periods when the company may have difficulty supporting its debt obligations.
Understand Operating Leverage
An MNO has significant fixed infrastructure costs but potentially strong incremental margins once sufficient scale is reached. The model shows when subscriber contribution begins to cover the network and corporate cost base.
Compare Valuation Methods
The football field analysis prevents reliance on a single valuation methodology. Users can compare DCF, exit multiple, revenue multiple, subscriber value and replacement-cost approaches.
Test Assumptions and Downside Cases
The sensitivity analyses show how changes in WACC, terminal growth, ARPU and variable network costs affect valuation and profitability. Users can also change any primary operating or financing assumption to create custom scenarios.
Support Investor and Lender Discussions
The connected financial statements, funding schedule, debt metrics, valuation analyses and KPI dashboard provide a structured foundation for business plans, fundraising materials, lender presentations and investor diligence.
Improve Strategic Planning
Management can use the model to evaluate:
- Subscriber-acquisition budgets
- Pricing and ARPU
- Churn-reduction initiatives
- Partner distribution strategies
- Network rollout timing
- Capacity expansion
- Capital requirements
- Debt-versus-equity funding
- Potential exit values
- Long-term profitability
Why It Is Useful
A cellphone network cannot be evaluated using a simple revenue-growth forecast. Subscriber demand, churn, capacity, network investment, operating costs and financing are interdependent.
This model brings those components together in one auditable framework. It helps users understand not only how large the business could become, but also how much capital it requires, when it may become profitable, whether the debt structure is supportable and what the completed network may ultimately be worth.
All major assumptions are editable, calculations are formula-driven and dedicated model checks help identify broken links, capacity issues, financing shortfalls and valuation inconsistencies. The result is a flexible planning, fundraising and valuation tool for analyzing the development of a facilities-based mobile network.
Similar Templates:
- Data-as-a-Service
- Product-as-a-Service
- EV Charging Station Buildout
- Fitness Studio Scaling
- Solar Panel Installer
- Trucking Service (fleet scaling)
