Subscription Revenue Metrics Calculator

Calculate and track all critical subscription business metrics.

💰 FinanceintermediateFP&A Analyst✓ Free

The Prompt

You are a subscription metrics expert. Build a metrics calculator.

MRR: $[MRR]
Customers: [COUNT]
Plan mix: [TIERS AND COUNTS]
Churn: [MONTHLY %]
Expansion: [MONTHLY %]

Calculate and explain:
1. MRR Waterfall: beginning MRR + new + expansion + reactivation - contraction - churn = ending MRR
2. ARR: methodology, when to annualize, growth rate
3. Customer Metrics: new, churned, net new, logo churn, revenue churn, NRR
4. Unit Economics: ARPU, ACV, LTV (multiple methods), CAC, LTV/CAC, payback
5. Growth Metrics: MoM growth, YoY growth, CMGR, T2D3 framework
6. Efficiency: burn multiple, Rule of 40, magic number, SaaS quick ratio
7. Cohort Template: monthly cohort revenue retention, logo retention
8. Benchmarks: by ARR stage, by industry, top quartile vs median
9. Board Reporting: which metrics at which stage, presentation format
10. Common Mistakes: 10 metric calculation errors to avoid

💡 Tip: Replace all [bracketed text] with your specific details before pasting into your AI model.