Cash
Runway and burn
This template categorizes bank and card transactions, rolls them into monthly gross and net burn, and calculates runway from trailing three-month net burn.
A separate 13-week forecast tracks weekly receipts, payments and closing cash, with checks for the cash roll-forward.
Reads from
Mercury
Brex
Ramp- Any bank CSV
Sheets
- Runway
- Calculates cash runway, a zero-cash date and burn multiple from the monthly model.
- Monthly Burn
- Rolls categorized transactions into monthly receipts, gross burn and net burn.
- 13-Week Forecast
- Projects weekly cash receipts, payments and closing cash for thirteen weeks.
- Transactions
- Keeps normalized bank and card rows with their categories and inclusion flags.
- Categories
- Groups transaction categories into receipts, operating expenses and excluded activity with counts and totals.
- Assumptions
- Stores model dates, scenarios, runway thresholds, account balances, MRR history and forecast rules.
- Checks
- Tests transaction coverage and the cash roll-forward for breaks.
- Sources
- Records the demo exports, coverage dates, row counts and burn and runway calculation methods.
Formulas
Runway!B6
=IF(B5<=0,"Cash-flow positive",B4/B5)Divides available cash by trailing average net burn.
Runway!B11
=IF(B10<=0,"n/a",B9/B10)Calculates burn multiple from net burn and net new ARR.
'13-Week Forecast'!B19
=B18+B17Adds the week's net cash movement to opening cash.
Questions
How is runway calculated?
Runway is available cash divided by the trailing three-month average net burn. When burn is zero or negative, the sheet labels the company cash-flow positive.
What feeds the monthly burn model?
The Transactions sheet accepts bank and card activity from Mercury, Brex, Ramp or a bank CSV and records which rows count toward burn.
Does the workbook include a weekly cash forecast?
Yes. The 13-Week Forecast sheet rolls weekly receipts and payments into closing cash.