Useful journalism to understand, manage and grow a business.
SearchCohort without new additions. Monthly revenue uses opening customers; churn occurs at close. Final MRR loss and cumulative loss are separate.
Estimate based on your assumptions
| Period | Cohort customersunits | Closing MRREUR | Recognized revenue over horizonEUR | Expected churned customersunits | Customers at alternative rateunits |
|---|---|---|---|---|---|
| 1 | 950 | 19,000 | 20,000 | 50 | 970 |
| 2 | 902.5 | 18,050 | 19,000 | 47.5 | 940.9 |
| 3 | 857.38 | 17,147.5 | 18,050 | 45.12 | 912.67 |
| 4 | 814.51 | 16,290.12 | 17,147.5 | 42.87 | 885.29 |
| 5 | 773.78 | 15,475.62 | 16,290.12 | 40.73 | 858.73 |
| 6 | 735.09 | 14,701.84 | 15,475.62 | 38.69 | 832.97 |
| 7 | 698.34 | 13,966.75 | 14,701.84 | 36.75 | 807.98 |
| 8 | 663.42 | 13,268.41 | 13,966.75 | 34.92 | 783.74 |
| 9 | 630.25 | 12,604.99 | 13,268.41 | 33.17 | 760.23 |
| 10 | 598.74 | 11,974.74 | 12,604.99 | 31.51 | 737.42 |
| 11 | 568.8 | 11,376 | 11,974.74 | 29.94 | 715.3 |
| 12 | 540.36 | 10,807.2 | 11,376 | 28.44 | 693.84 |
Save your scenarios in My company and continue working on them later.
Up to three private scenarios saved in this tab until it closes. Export a copy to keep it; they are not published or saved to your account.
Cohort without new additions. Monthly revenue uses opening customers; churn occurs at close. Final MRR loss and cumulative loss are separate.
Examples are illustrative. Profitability excludes recoverable indirect taxes; use consistent periods. Results depend on your inputs. No automatic legal rates are applied.
Nₜ = N × (1 − c)ᵗ
A new regulation can create needs for analysis, training, technology, or process redesign. However, a commercial opportunity exists only if customers are willing to pay to address them.
Read story