Premium

Formula version history

Each calculator is versioned so methodology changes can be reviewed and linked with ?v=.

Customer Acquisition Cost Calculator

v1

CAC = Sales and marketing spend / New customers acquired

Initial tracked version. Future changes will show formula diffs here.

CAC Payback Calculator

v1

CAC payback = CAC / (ARPA * Gross margin)

Initial tracked version. Future changes will show formula diffs here.

LTV / CLTV Calculator

v1

LTV = ARPA * Gross margin / Monthly churn rate

Initial tracked version. Future changes will show formula diffs here.

LTV:CAC Ratio Calculator

v1

LTV:CAC = LTV / CAC

Initial tracked version. Future changes will show formula diffs here.

Net Revenue Retention Calculator

v1

NRR = (Beginning revenue - churn - contraction + expansion) / Beginning revenue * 100

Initial tracked version. Future changes will show formula diffs here.

Gross Margin Calculator

v1

Gross margin % = (Revenue − COGS) / Revenue × 100

Initial tracked version. Future changes will show formula diffs here.

EBITDA Margin Calculator

v1

EBITDA margin % = EBITDA / Revenue × 100

Initial tracked version. Future changes will show formula diffs here.

Free Cash Flow Margin Calculator

v1

FCF margin % = Free cash flow / Revenue × 100

Initial tracked version. Future changes will show formula diffs here.

Gross Revenue Retention Calculator

v1

GRR = (Beginning revenue - churn - contraction) / Beginning revenue * 100

Initial tracked version. Future changes will show formula diffs here.

SaaS Churn Calculator

v1

Logo 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

v1

ARR = 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

v1

Rule of 40 = Revenue growth % + EBITDA margin %

Initial tracked version. Future changes will show formula diffs here.

SaaS Magic Number Calculator

v1

Magic 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

v1

Burn multiple = Net burn / Net new ARR

Initial tracked version. Future changes will show formula diffs here.

SaaS Quick Ratio Calculator

v1

Quick ratio = (New MRR + Expansion MRR) / (Churned MRR + Contraction MRR)

Initial tracked version. Future changes will show formula diffs here.

Revenue Growth Calculator

v1

Revenue growth % = (Current revenue − Prior revenue) / Prior revenue × 100

Initial tracked version. Future changes will show formula diffs here.

Revenue per Employee Calculator

v1

Revenue per employee = Revenue / FTEs

Initial tracked version. Future changes will show formula diffs here.

Rule of X Calculator

v1

Rule of X = (Revenue growth % × growth weight) + Free cash flow margin %

Initial tracked version. Future changes will show formula diffs here.

Net New ARR Calculator

v1

Net new ARR = New ARR + Expansion ARR - Churned ARR - Contraction ARR

Initial tracked version. Future changes will show formula diffs here.

Runway and Scenario Calculator

v1

Runway (months) = Cash on hand / Monthly net burn

Initial tracked version. Future changes will show formula diffs here.

Pipeline Coverage Calculator

v1

Pipeline coverage = Qualified pipeline / Revenue target

Initial tracked version. Future changes will show formula diffs here.

Sales Velocity Calculator

v1

Sales velocity = Opportunities × Average deal size × Win rate / Sales cycle days

Initial tracked version. Future changes will show formula diffs here.

Win Rate Calculator

v1

Win rate = Won deals / Total closed deals × 100

Initial tracked version. Future changes will show formula diffs here.

GTM Efficiency Score Calculator

v1

GTM 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

v1

New ARR per GTM FTE = Net new ARR / GTM FTEs

Initial tracked version. Future changes will show formula diffs here.

Sales Capacity Calculator

v1

Ramped quota capacity = Ramped AEs × Average quota per AE × Attainment assumption

Initial tracked version. Future changes will show formula diffs here.

Ramped Quota Coverage Calculator

v1

Ramped quota coverage = Ramped quota capacity / Bookings plan

Initial tracked version. Future changes will show formula diffs here.

New ARR Mix by Source Calculator

v1

New ARR mix = Each source ARR / Total new ARR × 100; concentration = largest single-source share

Initial tracked version. Future changes will show formula diffs here.

Command Palette

Search for a command to run...