A point of churn looks like a point of revenue. Because every retained customer stays in the base and keeps paying, it compounds into more than four times that by exit.
Model the revenue base year by year, with churn applied to the base and new bookings added on top, and run the old and new churn rates side by side to exit. On an illustrative company bought at 10.0x with $100.0m of revenue, cutting gross revenue churn from 15 to 14 per cent adds $0.40m of EBITDA in year 1 but $1.71m by year 5, worth $17.1m of exit value plus $4.06m of extra cash: $21.2m of equity value, or 0.21x of MOIC on $100.0m of equity.
Worked in full in The Private Equity Operating Partner by Julian R. Sterling, with every figure reproduced in a free workbook.See the book on Amazon →
Churn reduction appears in most value creation plans for recurring revenue businesses: B2B services, software, subscription distribution, maintenance contracts. It is also one of the initiatives most often valued wrongly, as one point of revenue times the margin times the multiple. That gives $4.0m here. The right answer is five times larger, because churn acts on a base that the initiative itself keeps enlarging.
| Input | Value |
|---|---|
| Revenue at entry | $100.0m |
| Gross revenue churn, share of opening revenue lost each year | 15% |
| New bookings in year 1, growing 3% a year | $21.0m |
| Contribution margin on revenue | 40% |
| Fixed costs at entry, growing 3% a year | $20.0m |
| EBITDA at entry; margin | $20.0m; 20% |
| Entry and exit multiple | 10.0x |
| Entry enterprise value; equity; debt | $200.0m; $100.0m; $100.0m |
| Hold; tax rate on extra cash | 5 years; 25% |
Revenuet = Revenuet−1 × (1 − churn) + new bookingst
EBITDAt = Revenuet × 40% − fixed costst
In Excel, with revenue in row 5 and bookings in row 6: =C5*(1-Churn)+D6, copied across.
| Year | Revenue at 15% | Revenue at 14% | Extra revenue | EBITDA at 15% | EBITDA at 14% | Extra EBITDA |
|---|---|---|---|---|---|---|
| 1 | 106.00 | 107.00 | 1.00 | 21.80 | 22.20 | 0.40 |
| 2 | 111.73 | 113.65 | 1.92 | 23.47 | 24.24 | 0.77 |
| 3 | 117.25 | 120.02 | 2.77 | 25.05 | 26.15 | 1.11 |
| 4 | 122.61 | 126.16 | 3.55 | 26.53 | 27.95 | 1.42 |
| 5 | 127.85 | 132.14 | 4.28 | 27.96 | 29.67 | 1.71 |
The extra revenue grows every year, from $1.00m to $4.28m, because each year's saved revenue is itself retained at 86 per cent the next year and added to the next year's saving. The EBITDA effect at exit is 4.3 times the year-1 effect. An initiative that "adds a million of revenue" in the first-year budget is a four-million initiative by exit.
The long-run arithmetic makes the same point more starkly. If new bookings stayed flat, revenue would converge to new bookings divided by churn: $140.0m at 15 per cent, $150.0m at 14 per cent. One point of churn is worth 7.1 per cent of steady-state revenue.
Of the $21.2m, 81 per cent comes from the exit multiple applied to the run-rate gain. That is why retention initiatives pay best when they are implemented early in the hold: each year of delay removes a year of compounding from the exit EBITDA, not just a year of cash. The interest saved on the repaid debt is ignored, which slightly understates the gain.
Retention is bought: customer success managers, onboarding, service credits, a price held for a multi-year renewal. Put the cost in the fixed cost line and rerun. A programme costing $0.8m a year, $4.0m over the hold, cuts the gain from $21.2m to $10.2m, still 0.10x of MOIC. Half the value disappears because the cost is also a run-rate item and is capitalised at 10.0x at exit. The break-even is about $1.54m a year: above it, the programme costs more equity value than the retention it buys.
| Churn | Exit revenue, $m | Exit EBITDA, $m | Exit EV, $m | Equity value created, $m | MOIC added |
|---|---|---|---|---|---|
| 15% | 127.9 | 28.0 | 279.6 | 0.0 | 0.00x |
| 14% | 132.1 | 29.7 | 296.7 | 21.2 | 0.21x |
| 13% | 136.6 | 31.4 | 314.5 | 43.1 | 0.43x |
| 12% | 141.2 | 33.3 | 332.9 | 65.8 | 0.66x |
| 10% | 150.9 | 37.2 | 371.9 | 113.6 | 1.14x |
Each point is worth slightly more than the one before, $21.2m, then $21.9m, then $22.7m, because a larger retained base compounds on itself. At an 8.0x exit the first point is worth $17.8m; at 12.0x, $24.6m. The gain moves less than in proportion to the multiple, because the cash part of it does not depend on the multiple.
The common mistake is the one in the introduction: valuing a point of churn as one point of year-1 revenue at the margin and the multiple, $4.0m here, against $21.2m. It treats retention as a one-off saving rather than a change in the slope of the revenue line. The opposite mistake is to count it twice, once as lower churn and again as higher net revenue retention or as higher growth in the bridge. In a value creation bridge, retention belongs in revenue growth, and the initiative tracker should show it as the gap between the two revenue lines above, not as a separate bucket. Monthly churn figures from a dashboard must be compounded to an annual rate first, as in how to convert monthly churn to annual churn.
A one-point cut in revenue churn adds $1.71m of EBITDA after five years, not the $0.40m it shows in year 1, and $21.2m of equity on a $200.0m buyout: 6.1 per cent more exit EBITDA. Start it early, cost it as a run-rate item, and track it as a revenue line. The operating partner's bridge that attributes it, built in full on the book's Vireo case, is in the free workbook for this case.
Model revenue as last year's revenue times one minus churn, plus new bookings, then run the base and the improved churn side by side to exit. In the illustrative case one point of churn adds $1.00m of revenue in year 1 and $4.28m by year 5; at a 40 per cent contribution margin and 10.0x that is $17.1m of exit value, plus the extra cash generated.
Because a retained customer stays in the base and is exposed to churn again only on what remains. With flat new bookings, revenue converges to new bookings divided by churn: $140.0m at 15 per cent and $150.0m at 14 per cent in the illustrative case, 7.1 per cent more, not 1 per cent.
Up to the spend at which the equity gain falls to zero. In the illustrative buyout a one-point cut in churn is worth $21.2m over five years; a retention programme costing $0.8m a year still leaves $10.2m, and the break-even is about $1.54m a year, because every dollar of running cost is also capitalised at the exit multiple.
This article is one calculation from The Private Equity Operating Partner. The book takes the same case from first principles to the decision, chapter by chapter, and every figure it prints is a live formula in the free companion workbooks.
Get the book on Amazon →Free companion files
Also on Amazon UK · Amazon Germany · Amazon France · Amazon Canada
Reading guide: private equity and private markets → · All 1682 articles →
If this book helped, or didn’t, a few lines on Amazon are worth more than they look: they are what the next reader goes on. Write a review. The workbook stays free either way.