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.