FREE TOOLS

RevOps calculators, with the formula published

Four numbers that get quoted constantly and computed inconsistently. Each one here shows its arithmetic, defines every input precisely, and states plainly what the result does not capture.

Most disagreements about these metrics are not disagreements about the maths. They are disagreements about what went into it — whether payback was calculated on revenue or gross profit, whether the retention cohort was fixed, whether the pipeline included deals closing next quarter. So every field below carries a definition, and every result carries its limits.

Pipeline coverage calculator

Pipeline coverage = open pipeline ÷ quota for the period

Coverage is the ratio of open pipeline to the number you have to hit. It is the most quoted number in revenue operations and the most easily gamed, because both halves of the ratio can be wrong at once.

CAC payback period calculator

CAC payback (months) = CAC ÷ (monthly ARPA × gross margin)

How many months of gross profit it takes to earn back what you spent acquiring a customer. It is the closest thing revenue operations has to a cash-efficiency number, and it is routinely quoted on revenue rather than gross profit, which makes it look better than it is.

Net revenue retention calculator

NRR = (starting ARR + expansion − contraction − churn) ÷ starting ARR

NRR measures what happened to the revenue you already had, before any new customers. It is the single most informative number about a subscription business, and the one most often computed on a cohort chosen to flatter it.

LTV:CAC ratio calculator

LTV = (monthly ARPA × gross margin) ÷ monthly churn rate · Ratio = LTV ÷ CAC

How much gross profit a customer relationship produces for every dollar spent acquiring it. The arithmetic is trivial; the judgement is entirely in the lifetime assumption, which is the input people are most willing to invent.

Ramp-adjusted quota capacity calculator

Capacity = (ramped reps × quota × period/12) + (ramping reps × quota × productive months/12), where a linearly ramping rep averages half productivity during ramp

How much quota your headcount can actually carry once ramp is accounted for. Planning against headcount multiplied by quota is the most common way an annual plan is set to a number the team was never able to produce.

Rule of 40 calculator

Rule of 40 = revenue growth rate (%) + profit margin (%)

Growth rate plus profit margin. A single number for the trade-off between growing fast and making money, and a convention rather than a law — which matters, because it is quoted as though it were physics.

Forecast accuracy calculator

Accuracy = 1 − |actual − forecast| ÷ actual · Bias = (forecast − actual) ÷ actual

How close the forecast was, and — more usefully — which direction it was wrong in. A team that misses by 10% every quarter in the same direction has a bias problem, which is fixable. A team that misses by 10% in random directions has a variance problem, which is harder.

Magic number calculator

Magic number = (current quarter ARR − prior quarter ARR) × 4 ÷ prior quarter S&M spend

How much new recurring revenue each dollar of sales and marketing bought. It is the bluntest efficiency measure in the set and the quickest to expose a go-to-market motion that is spending its way to growth.

One number is a reading. An audit is a diagnosis.

These answer one question each. The courses build the whole picture and export it as a workbook you can put in front of a leadership team — and the 24 audit templates are free too.

COMMON QUESTIONS

Are these calculators free?
Yes, and ungated — no email address, no account, no export wall. A blank spreadsheet behind a form gets linked by nobody; the same tool in the open gets linked, embedded and used, which is what it is for. The same applies to the 24 audit templates and the glossary.
Why do you publish the formula?
Because a calculator that hides its arithmetic is asking to be trusted rather than checked, and most disagreements about these metrics turn out to be disagreements about what went into them rather than about the maths. Publishing the formula and defining every input precisely is the only way the output means the same thing to two people.
Where are the industry benchmarks?
Deliberately absent. Most widely circulated RevOps benchmarks trace back to a vendor citing its own survey, and we do not publish figures we cannot trace to a primary source. Where a band is shown, it is either an arithmetic consequence — coverage of 4× is break-even at a 25% win rate, which is division, not a benchmark — or a stated operating convention, labelled as one.
Can I embed or link to these?
Please do. They are free, ungated and stable URLs. If you are writing about pipeline coverage or CAC payback and want a tool to point readers at, that is exactly what these are for.