Burn Multiple: The Formula, a Worked Example, and Where the Inputs Come From
Burn multiple asks how many dollars you burn to add a dollar of recurring revenue. The formula is one division. The inputs live in two different systems, which is why it tends to get calculated once a quarter, by hand, before a board meeting.
Burn multiple = net burn ÷ net new ARR. It tells you how many dollars the company burned for each dollar of recurring revenue it added. The division is trivial. The trouble is that net burn comes from your books and net new ARR comes from your billing system, so the figure usually gets assembled by hand, once a quarter, and nobody quite trusts it.
A worked example
The figures are illustrative: one quarter for a small subscription company.
Net burn Cash at start of quarter 1,200,000 Cash at end of quarter 960,000 Funding received in the quarter 0 Net burn 240,000 (80,000 a month) Net new ARR New customers 180,000 Expansion 30,000 Churned and contracted -60,000 Net new ARR 150,000 Burn multiple = 240,000 / 150,000 = 1.6 Runway = 960,000 / 80,000 = 12 months
A multiple of 1.6 means the company spent $1.60 for each dollar of ARR it added. The runway is twelve months, so the useful question is whether the multiple can improve before then. Cutting churn from $60,000 to $30,000 would take net new ARR to $180,000 and the multiple to 1.33 with no change in spend.
Where it goes wrong
- Counting raised money as a cash inflow. That makes burn look smaller than it is.
- Counting one-off fees as ARR. Setup fees and services are not recurring.
- Forgetting churn. Gross new ARR flatters the multiple. Net new ARR is the figure to divide by.
- Mixing periods. Use the same three months for burn and ARR, and annualize ARR the same way you do for MRR. See how to calculate MRR.
The spreadsheet version
Two inputs from your books and one from billing:
Net burn =StartCash-EndCash+FundingRaised
Net new ARR =NewARR+ExpansionARR-ChurnedARR
Burn multiple =IF(NetNewARR>0,NetBurn/NetNewARR,"n/a")
Runway (months) =EndCash/(NetBurn/3)
The ARR inputs come out of a subscription export or your churn and retention work: net revenue retention and churn rate use the same building blocks.
Putting the two sources in one question
With QuickBooks and Stripe connected, Quiriz reads net burn from one and ARR from the other. The definitions, which cash accounts count and what is ARR, are held in Company Context. In Google Sheets, with the Sheets add-in:
=QUIRIZ("burn multiple last quarter: net burn from QuickBooks, net new ARR from Stripe", "table")
Check this first. Try the cross-source answer on a quarter you have already calculated by hand, and compare. If the two differ, the definitions are the reason, and they are worth fixing once.
Burn multiple without the quarter-end scramble
Try the questions on sample company data with no signup, then connect QuickBooks and Stripe and check one quarter against your own figure.
Try Quiriz free →