Customer Acquisition Cost Calculator
v1CAC = Sales and marketing spend / New customers acquired
Initial tracked version. Future changes will show formula diffs here.
Methodology
Formula versions
The current version of every calculator formula. Each is versioned so methodology changes can be reviewed and linked with ?v=. Dated updates are recorded in the changelog.
CAC Payback Calculator
v1CAC payback = CAC / (ARPA * Gross margin)
Initial tracked version. Future changes will show formula diffs here.
LTV / CLTV Calculator
v1LTV = ARPA * Gross margin / Monthly churn rate
Initial tracked version. Future changes will show formula diffs here.
LTV:CAC Ratio Calculator
v1LTV:CAC = LTV / CAC
Initial tracked version. Future changes will show formula diffs here.
Net Revenue Retention Calculator
v1NRR = (Beginning revenue - churn - contraction + expansion) / Beginning revenue * 100
Initial tracked version. Future changes will show formula diffs here.
Gross Margin Calculator
v1Gross margin % = (Revenue − COGS) / Revenue × 100
Initial tracked version. Future changes will show formula diffs here.
EBITDA Margin Calculator
v1EBITDA margin % = EBITDA / Revenue × 100
Initial tracked version. Future changes will show formula diffs here.
Free Cash Flow Margin Calculator
v1FCF margin % = Free cash flow / Revenue × 100
Initial tracked version. Future changes will show formula diffs here.
Gross Revenue Retention Calculator
v1GRR = (Beginning revenue - churn - contraction) / Beginning revenue * 100
Initial tracked version. Future changes will show formula diffs here.
SaaS Churn Calculator
v1Logo churn = Churned customers / Starting customers; gross revenue churn = lost MRR / starting MRR
Initial tracked version. Future changes will show formula diffs here.
ARR / MRR / ARPA / ACV Calculator
v1ARR = MRR * 12; ARPA = MRR / paying accounts; ACV = annual contract value / annual contracts
Initial tracked version. Future changes will show formula diffs here.
Rule of 40 Calculator
v1Rule of 40 = Revenue growth % + EBITDA margin %
Initial tracked version. Future changes will show formula diffs here.
SaaS Magic Number Calculator
v1Magic Number = (Current quarter ARR - Prior quarter ARR) / Prior quarter sales and marketing spend
Initial tracked version. Future changes will show formula diffs here.
Burn Multiple Calculator
v1Burn multiple = Net burn / Net new ARR
Initial tracked version. Future changes will show formula diffs here.
SaaS Quick Ratio Calculator
v1Quick ratio = (New MRR + Expansion MRR) / (Churned MRR + Contraction MRR)
Initial tracked version. Future changes will show formula diffs here.
Revenue Growth Calculator
v1Revenue growth % = (Current revenue − Prior revenue) / Prior revenue × 100
Initial tracked version. Future changes will show formula diffs here.
Revenue per Employee Calculator
v1Revenue per employee = Revenue / FTEs
Initial tracked version. Future changes will show formula diffs here.
Rule of X Calculator
v1Rule of X = (Revenue growth % × growth weight) + Free cash flow margin %
Initial tracked version. Future changes will show formula diffs here.
Net New ARR Calculator
v1Net new ARR = New ARR + Expansion ARR - Churned ARR - Contraction ARR
Initial tracked version. Future changes will show formula diffs here.
Runway and Scenario Calculator
v1Runway (months) = Cash on hand / Monthly net burn
Initial tracked version. Future changes will show formula diffs here.
Pipeline Coverage Calculator
v1Pipeline coverage = Qualified pipeline / Revenue target
Initial tracked version. Future changes will show formula diffs here.
Sales Velocity Calculator
v1Sales velocity = Opportunities × Average deal size × Win rate / Sales cycle days
Initial tracked version. Future changes will show formula diffs here.
Win Rate Calculator
v1Win rate = Won deals / Total closed deals × 100
Initial tracked version. Future changes will show formula diffs here.
GTM Efficiency Score Calculator
v1GTM efficiency = (Net new ARR / Sales and marketing spend) × NRR × Gross margin
Initial tracked version. Future changes will show formula diffs here.
New ARR per GTM FTE Calculator
v1New ARR per GTM FTE = Net new ARR / GTM FTEs
Initial tracked version. Future changes will show formula diffs here.
Sales Capacity Calculator
v1Ramped quota capacity = Ramped AEs × Average quota per AE × Attainment assumption
Initial tracked version. Future changes will show formula diffs here.
Ramped Quota Coverage Calculator
v1Ramped quota coverage = Ramped quota capacity / Bookings plan
Initial tracked version. Future changes will show formula diffs here.
New ARR Mix by Source Calculator
v1New ARR mix = Each source ARR / Total new ARR × 100; concentration = largest single-source share
Initial tracked version. Future changes will show formula diffs here.
Segment Concentration Calculator
v1Top-segment share = largest segment revenue / total revenue × 100; HHI = sum of (segment share)² across all segments
Initial tracked version. Future changes will show formula diffs here.
Integration Coverage Calculator
v1Coverage = integrations live / integrations a target customer expects × 100; attach rate = customers using top integration / total customers × 100
Initial tracked version. Future changes will show formula diffs here.
Price Realization Calculator
v1Price realization = realized ARPA / list ARPA × 100
Initial tracked version. Future changes will show formula diffs here.
Discount Waterfall Calculator
v1Realized ARPA = list ARPA × (1 − average discount %); discount dollars = list ARPA − realized ARPA
Initial tracked version. Future changes will show formula diffs here.