Private equity commercial diligence interview
Diagnose whether weak customer retention is concentrated in one segment before deciding how to revise a subscription business forecast.
Wall Street Playbook ·
Worked case
Beginning recurring revenue is $20m. Small accounts start at $8m and lose $2m. Large accounts start at $12m and lose $0.6m. Portfolio gross revenue retention before expansion is (20 − 2.6) / 20 = 87%. Small-account retention is 75% and large-account retention is 95%. Small accounts account for nearly 77% of losses.
Investment judgment
Request retention by customer size and tenure, the reason codes for cancellations, and a reconciliation to invoices. Ask whether small accounts have lower margins or unusually costly acquisition. If losses are economically concentrated, build separate cohort assumptions and use those assumptions in the downside case. A change in customer mix could alter the blended result even if segment retention holds steady.
PE Recruiting Playbook
Get the complete guide when you’re ready for more practice.
Sale price $41.65 Original price $49