B2B Metrics Calculator
Track every metric that matters. This comprehensive Google Sheets calculator helps you monitor MRR, ARR, retention rates, unit economics, and investor-ready growth metrics - all in one place.
- MRR, ARR & revenue tracking with auto-calculations
- GRR, NRR & retention analysis dashboard
- CAC, LTV & payback period calculations
- Quick Ratio, Magic Number, Rule of 40, Burn Multiple
- Executive dashboard with health indicators & benchmarks
What's Inside the Calculator
Monthly Data Input
Enter your monthly numbers in highlighted cells. Track new MRR, expansion, contraction, and churn.
Retention & Unit Economics
Auto-calculated GRR, NRR, CAC, LTV, LTV:CAC ratio, and CAC payback period.
Growth & Efficiency
Quick Ratio, Magic Number, Rule of 40, and Burn Multiple - the metrics investors ask for.
Executive Dashboard
Full summary with health indicators, benchmarks, and color-coded metrics for quick decisions.
Key Metrics Calculated
💰 Revenue Metrics
- MRR - Starting MRR + New + Expansion - Contraction - Churned
- ARR - MRR × 12
- ARPU - MRR / Total Customers
🔄 Retention Metrics
- GRR - (Starting MRR - Churned - Contraction) / Starting MRR
- NRR - (Starting MRR + Expansion - Contraction - Churned) / Starting MRR
🎯 Unit Economics
- CAC - Total S&M Spend / New Customers
- LTV - ARPU × Gross Margin / Monthly Churn Rate
- LTV:CAC - Target 3× or higher
- CAC Payback - CAC / (ARPU × Gross Margin) in months
🚀 Efficiency Metrics
- Quick Ratio - (New MRR + Expansion) / (Churned + Contraction)
- Magic Number - (Δ ARR × 4) / Previous Qtr S&M
- Rule of 40 - Growth Rate % + EBITDA Margin %
- Burn Multiple - Net Burn / Net New ARR
How to Use
Get the Calculator
Enter your email above to create your own editable copy in Google Sheets.
Enter Monthly Data
Go to Monthly Data Input tab and fill in the yellow cells with your numbers.
Review Metrics
Check Retention, Growth & Efficiency tabs for auto-calculated metrics.
Use the Dashboard
Open Dashboard for executive summary with health indicators and benchmarks.
Color Guide
Yellow cells
Your input
Blue text
Assumptions
Black text
Auto-calculated
Green indicator
At/above benchmark
Red indicator
Needs attention
Need Help Understanding Your Metrics?
Get expert guidance on improving your B2B metrics, optimizing unit economics, and preparing for investor conversations.