Subscribers
Each month the churn share of last month's subscribers leaves, then the new ones join. Fractions are kept in the sum and rounded on screen.
Plan a new tower: see the month it pays back what it cost to put up, and the cash it returns over three years. Nothing you type is sent anywhere.
Tower, radios and installation.
Backhaul, power, rent and staff.
Per subscriber.
Payback period: 1 year 7 months
| Month | Subscribers | Revenue | Profit | Cumulative cash |
|---|---|---|---|---|
| 1 | 23 | $451 | -$449 | -$12,449 |
| 12 | 92 | $1,841 | $941 | -$8,625 |
| 24 | 146 | $2,910 | $2,010 | $10,004 |
| 36 | 183 | $3,652 | $2,752 | $39,217 |
A simple monthly model: subscribers come and go, each pays the average fee, and the tower's running costs come off the top.
Each month the churn share of last month's subscribers leaves, then the new ones join. Fractions are kept in the sum and rounded on screen.
Revenue is subscribers times the average fee. Profit is revenue less the monthly costs, before tax and loan repayments.
Cumulative cash starts at minus the up-front cost. Break-even is the first month it reaches zero, and the payback period is that month in years and months.
Radios fail, prices move and growth slows as a sector fills. Treat the answer as a plan, not a promise, and try a slower case too.
Centipid bills your subscribers, provisions MikroTik and collects the payments that pay the tower back.