Subscription Revenue & Churn Analysis

Pathwise's leadership wants to understand current MRR and where churn is concentrated before the board meeting. The raw subscription export has inconsistent plan-name capitalization, duplicate customer records, and some missing region data. Practice MRR calculation, churn-rate analysis, and customer-lifetime math. **What you'll learn:** - MRR aggregation - Churn-rate math by segment - Customer lifetime calculations from signup/cancellation dates - Spotting high-value at-risk accounts

All Excel case studies · Excel interview prep · Excel formulas