ISP / WISP planning tool
ISP churn and subscriber lifetime value calculator
Estimate subscriber lifetime, gross-margin LTV, installation payback and 12-month growth. Compare a free installation or a cheaper plan using your own assumptions.
Your assumptions
Calculations stay in this browser. Nothing is sent or saved. Currency selection changes the display, not the amounts.
Estimated results
- Monthly subscriber churn
- 2 %
- Average lifetime (months)
- 50
- Monthly gross profit per subscriber
- USD 15.00
- Total acquisition cost
- USD 100.00
- Gross-margin lifetime value
- USD 750.00
- LTV after acquisition cost
- USD 650.00
- Churn-adjusted payback month
- 8
| Month | At start | Cancelled | New | At end |
|---|---|---|---|---|
| 1 | 500 | 10 | 20 | 510 |
| 2 | 510 | 10.2 | 20 | 519.8 |
| 3 | 519.8 | 10.4 | 20 | 529.4 |
| 4 | 529.4 | 10.6 | 20 | 538.8 |
| 5 | 538.8 | 10.8 | 20 | 548 |
| 6 | 548 | 11 | 20 | 557.1 |
| 7 | 557.1 | 11.1 | 20 | 565.9 |
| 8 | 565.9 | 11.3 | 20 | 574.6 |
| 9 | 574.6 | 11.5 | 20 | 583.1 |
| 10 | 583.1 | 11.7 | 20 | 591.5 |
| 11 | 591.5 | 11.8 | 20 | 599.6 |
| 12 | 599.6 | 12 | 20 | 607.6 |
Expected counts shown to one decimal; calculations keep full precision. New subscribers join at month end and first face churn the following month.
How to read the calculation
- Monthly churn = cancellations ÷ subscribers at the start. A cancellation count sets a constant churn rate for the projection; it is not a fixed count repeated each month. New additions stay constant.
- Average lifetime = 1 ÷ monthly churn as a fraction. At 0% churn, lifetime is not bounded; at 100%, it is one paid month. This assumes a constant cancellation probability, with the first month paid before churn.
- ARPU is monthly revenue per subscriber, excluding tax. Monthly gross profit = ARPU × gross margin. Gross-margin LTV = monthly gross profit ÷ churn. It excludes fixed overhead, discounting, price changes, bad debt and future cost changes.
- Total acquisition cost = install/acquisition cost + additional subsidy. Enter each cost once: if free installation is already included in your install cost, leave subsidy blank. All money inputs use the selected currency; no exchange rates are applied.
- Payback is the first whole month when expected cumulative gross profit covers acquisition cost, allowing for churn: G × [1 − (1 − c)^n] ÷ c. At zero churn it is G × n. If cost reaches the asymptotic LTV, finite payback is never reached (except 100% churn, paid in month one).
- Zero gross profit means zero LTV even at zero churn. Positive cost then never pays back. Money displays round to the currency exponent (XOF/XAF: 0 decimals, USD/EUR: 2, TND: 3); decisions use unrounded amounts.
Example: 500 subscribers, 10 cancellations, ARPU 25 and 60% margin give 2% churn, 50 months of average lifetime and LTV 750. An acquisition cost of 100 pays back in month 8 after churn. Adding a subsidy of 50 moves it to month 12.
Questions from operators
Does free installation pay back?
Add only the extra subsidy not already in your acquisition cost. Compare the payback month and LTV after acquisition cost. These are expected cohort outcomes, not a guarantee that an individual subscriber stays long enough.
Can I test a cheaper plan?
Reduce ARPU and update gross margin to match the new plan. Compare the outputs, then test a different churn assumption. The calculator does not assume that a price cut reduces churn.
Why can payback be never reached?
Churn reduces expected contributions over time. A positive upfront cost cannot be recovered when gross profit is zero or expected lifetime contributions are insufficient. At the LTV limit, a partial-churn cohort only approaches payback.
Discuss your operating workflow
This is a standalone planning calculator. ISPAgents CRM and customer-billing foundations are available only through a guided pilot with explicit limits. This calculator does not connect to subscriber records or provide automated retention workflows.
Review guided pilot scope