Build a consistent SaaS operating snapshot
Use this dashboard to place recurring revenue, account economics, retention, and acquisition cost on one monthly scenario. Supply MRR and CAC in dollars, active accounts as a positive whole-number count, and gross margin, monthly churn, and expansion as percentages. MRR and active accounts must describe the same month and customer population.
Metrics included
The supported product-defined relationships are:
ARR = 12 × MRRandARPA = MRR / active accounts.- Monthly gross profit per account is
ARPA × gross margin. - Gross-profit LTV is that monthly amount divided by monthly churn.
LTV:CAC = LTV / CAC; CAC payback isCAC / monthly gross profit per account.- Net revenue retention is
100% - churn + expansion; logo retention is100% - churn.
These are a simplified scenario, not a universal SaaS reporting standard. Churn and expansion are entered as direct monthly rates; no cohort weighting, contraction, reactivation, annualization of retention, acquisition timing, or cash-flow discounting is added.
Reproduce the default dashboard
For $60,000 MRR, 400 accounts, 75% gross margin, 4% monthly churn, 1.5% expansion, and $800 CAC: ARPA is $150, ARR is $720,000, gross-profit LTV is $2,812.50, LTV:CAC is 3.52:1, and payback is 7.11 months. NRR is 97.5% and logo retention is 96%. Recheck the dashboard after substituting a segment-specific account count and churn rate; the side-by-side change shows which assumption drives the result.
At least one active account and positive churn are required. Percentages are limited to 0%–100%, with churn no lower than 0.01%. Zero CAC leaves LTV:CAC unavailable, and zero monthly gross profit leaves payback unavailable rather than implying a meaningful zero. Negative, blank, unknown-option, or invalid numeric inputs are rejected.
Use the SaaS LTV calculator to examine dollar expansion separately. Treat all outputs as internal scenario estimates, not valuation, investment, or accounting advice.
Align the account and revenue snapshot
Use MRR and active-account figures from the same reporting cutoff and save the margin, churn, expansion, and CAC assumptions. Compare a changed retention scenario without also changing the customer-count basis. This keeps an input-based metrics illustration separate from a verified cohort analysis.