SaaS Metrics Calculator

Prompt

Build a SaaS metrics calculator and dashboard in Excel for [COMPANY NAME].

Business context:
- Business model: [B2B SAAS / B2C SUBSCRIPTION / USAGE-BASED]
- Current MRR: [AMOUNT]
- Number of customers: [NUMBER]
- Average contract value: [AMOUNT]
- Sales cycle length: [DAYS]
- Customer acquisition cost: [AMOUNT]

**METRICS TO CALCULATE**

For each metric, provide the formula, Excel implementation, and benchmarks for [INDUSTRY]:

1. **MRR / ARR** — Total, new, expansion, contraction, churned MRR
2. **MRR Growth Rate** — Month-over-month and year-over-year
3. **Net Revenue Retention (NRR)** — Including expansion and churn
4. **Gross Revenue Retention (GRR)** — Churn only
5. **Customer Churn Rate** — Monthly and annualized
6. **Customer LTV** — Using both simple and DCF-adjusted methods
7. **CAC Payback Period** — Months to recover acquisition cost
8. **LTV:CAC Ratio** — With health benchmarks (3:1 = good, 5:1 = great)
9. **Quick Ratio** — (New MRR + Expansion MRR) / (Contraction + Churn MRR)
10. **Rule of 40** — Growth rate + profit margin

**DASHBOARD DESIGN**
Build a single-page SaaS health dashboard with all key metrics, trend charts, and RAG status vs. benchmarks.