Answers / Financial Due Diligence
How would you use cohort and retention analysis to assess the durability of a subscription business's revenue in QoE?
An advanced Financial Due Diligence question — expect it in final rounds and case-heavy interviews (IB, PE, Big-4 Transaction Services).
THE SHORT ANSWER
Headline ARR growth can hide a leaky bucket, so I'd cut the revenue by cohort — group customers by the period they signed and track each cohort's revenue over time. That reveals gross and net retention: gross retention shows churn (revenue lost from a cohort), net retention adds expansion/upsell and can exceed 100% if existing customers grow. Durable, high-quality recurring revenue shows flat-to-rising cohort curves and net retention above ~100%; declining cohorts mean growth is just new-customer acquisition masking heavy churn — far lower quality and value. I'd also separate new logos from expansion in the growth bridge, check whether retention is deteriorating in recent cohorts, and look at logo vs revenue churn. The takeaway for the buyer is how much of the ARR will still be there in three years without constant re-acquisition.
WHAT INTERVIEWERS LISTEN FOR
- ✓Cut revenue by signing cohort, track over time
- ✓Gross retention (churn) vs net retention (incl. expansion)
- ✓Flat/rising cohorts + net retention >100% = durable
- ✓Separate new logos from expansion in the growth bridge
COMMON MISTAKES
- ✗Judging quality on headline ARR growth alone
- ✗Ignoring cohort decay/churn
- ✗Confusing gross and net retention
Reading isn't the same as answering under pressure.
Interviewers don't hand you the model answer — you deliver yours on a clock. Practice this and 1,000+ questions with AI feedback on every answer.
RELATED QUESTIONS
- Give me 3 examples of QoE adjustments.
- A company shows 30% revenue growth. What would you investigate?
- How would you handle a situation where management proposes a large add-back?
- How do you analyze revenue quality for a SaaS company?
- How do you handle a company with significant related-party transactions?
- What metrics would you use to assess the quality of earnings for a company with a high proportion of recurring revenue, and how would you use these metrics to identify potential risks or areas for improvement?