Business
Customer Retention Forecast Calculator
This calculator begins with active customers, removes the entered churn or leakage share, calculates opening revenue and contribution, solves break-even and target customer counts, and extends the constant unit economics through a monthly growth forecast.
Effective retained or realized driver-
Opening realized revenue-
Opening variable cost-
Contribution per realized unit-
Opening contribution after fixed cost-
Opening contribution margin-
Gross driver required for break-even-
Gross driver required for target contribution-
Realized revenue through horizon-
Contribution through horizon-
Final-month gross driver-
Decision view
Customer pool retention and replenishment tank
Customer pool retention and replenishment tankThe opening customer pool is reduced by entered loss, replenished by growth, and compared with break-even and target customer levels across the forecast horizon.
Exact scenario comparisonOpening active customers changes while all other entered assumptions remain constant.
| Opening active customers | Effective retained or realized driver | Opening realized revenue | Opening variable cost | Contribution per realized unit | Opening contribution after fixed cost | Opening contribution margin | Gross driver required for break-even | Gross driver required for target contribution | Realized revenue through horizon | Contribution through horizon | Final-month gross driver |
|---|
Period-by-period detail
Customer Retention Forecast monthly forecast
How to use Customer Retention Forecast Calculator
- Use one cohort definition and decide whether churn is logo, account, subscriber, or revenue churn.
- Enter revenue and service cost per active customer for the same period.
- Compare opening contribution, break-even customer count, target count, and closing customer forecast.
Calculator guide
Understanding Customer Retention Forecast Calculator
Retention planning links the active customer base, churn, per-customer revenue and service cost, program fixed cost, growth, and the customer count required for break-even or target contribution.
Calculation method
How the calculation works
Model customer retention forecast from a gross operating driver, leakage, unit revenue, unit cost, fixed cost, growth, break-even, and target-contribution assumptions. Reduce the opening customer driver by churn, multiply retained customers by revenue and service cost, subtract fixed retention cost, solve required gross customer counts, and project the driver across the entered months.
Cohort reservoir
Track retained customers, leakage, and required scale
The reservoir view separates the opening customer pool, churn leakage, retained customers, break-even level, and target-contribution level.
Worked situations
Practical examples
- A retention program can improve gross retention while lowering contribution if service cost rises faster than revenue.
- Expansion revenue from retained accounts should not be mislabeled as lower logo churn.
- A small monthly change compounds across the forecast and can produce a large final customer difference.
Better inputs
Useful tips
- Separate new acquisition, reactivation, contraction, and churn in a detailed cohort model.
- Track retention by customer age, plan, acquisition source, geography, and product use.
- Use observed cohort transitions rather than a permanently constant average churn rate.
Before relying on the result
Limitations and common mistakes
- The model applies constant unit economics and one monthly growth path across the forecast.
- Cohort aging, seasonality, acquisition, expansion, contraction, reactivation, capacity steps, and discounting are not separately modeled.
- A growth-rate forecast does not prove that the retention program caused the change.
Reference
Key terms
- Retained driver
- Opening active customers remaining after entered churn or leakage.
- Unit contribution
- Monthly revenue per active customer minus service cost per active customer.
- Break-even customer count
- Gross active customers required to cover fixed program cost.
- Target customer count
- Gross customers required to cover fixed cost plus target contribution.
Important note
Calculated from the entered values using the displayed accounting method. Reconcile material decisions with source records and applicable accounting policy.
Frequently asked questions
Does growth mean retention improvement?
Not necessarily; it is the entered net monthly driver change and may include acquisition or other effects.
Can I use revenue churn?
Only after converting the driver and unit economics to a consistent revenue-based model.
Why is break-even count rounded up?
A fraction of a customer cannot cover the remaining fixed cost.
Does the forecast use cohorts?
No; it applies one blended path to the opening driver.