New Plan your 2027 growth with the free Marketing Projection Template

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
B2B Metrics Calculator

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

1

Get the Calculator

Enter your email above to create your own editable copy in Google Sheets.

2

Enter Monthly Data

Go to Monthly Data Input tab and fill in the yellow cells with your numbers.

3

Review Metrics

Check Retention, Growth & Efficiency tabs for auto-calculated metrics.

4

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.