Interview Questions156

    Cohort Analysis and Churn in SaaS

    How to analyze customer retention by cohort, the difference between gross and net churn, logo vs. revenue churn, and why cohort economics predict long-term value.

    |
    7 min read
    |
    2 interview questions
    |

    Introduction

    Aggregate churn metrics tell you that a SaaS company is losing customers. Cohort analysis tells you which customers, when, and why. This distinction is critical for TMT investment bankers, because the quality of a SaaS company's retention pattern, not just the headline churn rate, determines whether the business is compounding value or slowly eroding. A company with 5% annual churn concentrated in its smallest customers and first-year cohorts is a fundamentally different asset than one with 5% churn spread evenly across all customer sizes and tenures, even though the aggregate metric is identical.

    For M&A analysis, cohort-level retention data is one of the most valuable datasets a TMT banker can access during due diligence. It reveals whether retention is improving or deteriorating, which customer segments are most durable, and how much of the company's growth depends on new customer acquisition versus expansion within the existing base.

    Logo Churn vs. Revenue Churn

    SaaS companies track two distinct churn metrics that can diverge significantly.

    Logo Churn vs. Revenue Churn

    Logo churn (also called customer churn) measures the percentage of customers who cancel their subscriptions in a given period. Revenue churn (also called MRR churn or dollar churn) measures the percentage of recurring revenue lost to cancellations and downgrades. A company could have 8% annual logo churn but only 3% revenue churn if the customers leaving are predominantly small accounts, while large customers retain and expand. Conversely, a company could have low logo churn (2%) but high revenue churn (6%) if a few large enterprise customers downgrade significantly. Both metrics matter, but for different reasons: logo churn signals product-market fit breadth, while revenue churn directly impacts financial projections.

    The logo vs. revenue churn divergence is particularly important in PE due diligence. A company may present a reassuring 3% annual revenue churn number, but if its logo churn is 12%, it means the customer base is churning rapidly while a few large accounts are expanding enough to mask the losses. This is a fragile growth model: if those large accounts reduce spending or leave, the revenue impact is sudden and severe. TMT bankers should always request both metrics and analyze the gap between them.

    Gross Churn vs. Net Churn

    Beyond the logo/revenue distinction, churn metrics also separate into gross and net variants.

    Gross revenue churn measures the total revenue lost to cancellations and downgrades, without accounting for any expansion from remaining customers. It represents the worst-case revenue impact if the company's expansion engine stopped working entirely. Strong enterprise SaaS companies target gross revenue churn below 5-7% annually (equivalent to gross revenue retention of 93-95%).

    Net revenue churn accounts for expansion revenue from surviving customers. If a company loses $5 million in churned and contracted revenue but gains $8 million in expansion from existing customers, its net churn is negative (meaning the existing base is actually growing). Negative net churn is the hallmark of a world-class SaaS business.

    Churn MetricWhat It Captures2025 Enterprise Benchmark
    Annual logo churn% of customers who cancel5-10% (enterprise), 15-25% (SMB)
    Annual gross revenue churn% of revenue lost to cancellations + downgrades5-10%
    Annual net revenue churnGross churn minus expansion revenueNegative for strong companies (NRR > 100%)
    Monthly MRR churnMonthly revenue churn rateBelow 1% (enterprise), 2-3% (SMB)

    The 2025 average annual B2B SaaS churn rate is approximately 3.8-4.9%, though this varies dramatically by customer segment. Enterprise SaaS with multi-year contracts and high switching costs achieves annual churn rates of 1-2%, while SMB-focused SaaS with monthly contracts can see annual churn of 15-30%.

    How Cohort Analysis Works

    A cohort analysis groups customers by their acquisition period (typically month or quarter) and tracks how each cohort's revenue evolves over time. The standard visualization is a left-justified retention table or curve, where each cohort starts at 100% and the chart shows how much revenue remains after 3, 6, 12, 24, and 36+ months.

    The value of cohort analysis is that it separates structural retention trends from aggregate noise. A company's overall churn rate might appear stable at 8% annually, but cohort analysis could reveal that older cohorts have 95% retention while newer cohorts have only 85%. This pattern would indicate that the company's recent customer acquisition is targeting lower-quality accounts or that product-market fit is weakening, either of which has significant implications for valuation and growth sustainability.

    Cohort Analysis in M&A and Deal Evaluation

    For TMT investment bankers, cohort analysis serves multiple purposes across different deal types.

    In sell-side processes, presenting cohort retention data is one of the most effective ways to demonstrate business quality. A CIM that shows improving retention across successive cohorts, with mature cohorts achieving 95%+ gross retention and 115%+ NRR, provides concrete evidence that the customer base is durable and expanding. This data directly supports the valuation narrative and can justify a premium multiple.

    In PE due diligence, buyers reconstruct cohort analysis from raw contract data to verify management's retention claims. The due diligence team examines retention by customer segment (enterprise vs. mid-market vs. SMB), by acquisition channel (direct sales vs. partner vs. inbound), and by product line. This segmented cohort analysis reveals where the business is strongest and where risks exist, informing both the valuation and the post-acquisition operational plan.

    In [LBO modeling](/blog/lbo-modeling-explained), cohort-level retention rates produce more accurate revenue projections than a single aggregate churn assumption. A PE firm can model each annual vintage of customers separately, applying cohort-specific retention and expansion rates, and sum the projections to build a bottom-up revenue forecast. This approach captures the compounding nature of a high-retention SaaS business and produces more defensible assumptions than a top-down growth rate.

    Involuntary Churn: The Hidden Factor

    Not all churn represents a customer's deliberate decision to leave. Involuntary churn, caused by expired credit cards, failed payment processing, or administrative lapses, accounts for a meaningful portion of total churn, particularly in SMB and self-service SaaS. Industry data suggests involuntary churn represents approximately 20-30% of total churn for many SaaS companies. This is important because involuntary churn is largely addressable through operational improvements (payment retry logic, dunning email sequences, pre-expiration reminders) and represents a quick-win margin improvement for PE acquirers.

    Interview Questions

    2
    Interview Question #1Medium

    What is logo churn vs. revenue churn, and why can they tell different stories?

    Logo churn (customer churn) measures the percentage of customers lost over a period. Revenue churn (dollar churn) measures the percentage of ARR lost over a period.

    They can tell very different stories because customer size varies. A company might lose 15% of its logos (high logo churn) but only 5% of its revenue (low revenue churn) if the churned customers were small accounts while large enterprise customers stayed and expanded. Conversely, losing one large customer could create high revenue churn even if logo churn appears modest.

    Net revenue churn incorporates expansion from surviving customers. If a company loses $3 million in ARR from churned customers but existing customers expand by $5 million, net revenue churn is negative (meaning net expansion), which is the ideal scenario.

    In interviews, always clarify whether the question refers to gross or net churn, and logo or revenue churn. The distinction reveals whether the business has a "leaky bucket" problem with small customers while the core enterprise base remains strong.

    Interview Question #2Medium

    A SaaS company starts the year with 200 customers and $40 million in ARR. It loses 30 logos worth $4 million in ARR but the remaining 170 customers expand from $36 million to $42 million. Calculate logo churn, gross revenue churn, and net revenue retention.

    Logo churn = 30 / 200 = 15%.

    Gross revenue churn = $4 million / $40 million = 10%.

    Expansion ARR = $42 million - $36 million = $6 million.

    Net revenue retention = ($40M - $4M + $6M) / $40M = $42M / $40M = 105%.

    The story: despite losing 15% of logos (concerning at first glance), the remaining customers expanded by $6 million, more than offsetting the $4 million in churned ARR. This suggests the company has a "land and expand" model where small customers churn but enterprise accounts grow significantly. The 105% NRR is healthy but could be stronger. Management should investigate why small customer churn is elevated.

    Explore More

    Off-Cycle vs On-Cycle IB Recruiting: Timeline & Strategy

    Key differences between on-cycle and off-cycle investment banking recruiting. Which path fits your profile, how timelines compare, and how to maximize your chances in each process.

    November 1, 2025

    Investment Banking Diversity Programs: Complete Guide

    Navigate diversity recruiting programs at major banks. Learn about freshman and sophomore diversity programs, application timelines, what banks look for, and how to maximize your chances.

    January 29, 2026

    Healthcare Investment Banking: Deals, Skills, and Recruiting

    Master healthcare investment banking covering pharma, biotech, medical devices, and healthcare services. Learn about deal types, valuation approaches, top banks, and how to break in.

    December 20, 2025

    Ready to Transform Your Interview Prep?

    Join 3,000+ students preparing smarter

    Join 3,000+ students who have downloaded this resource