How to Calculate Cash Runway With Real Cash Data

A business can show a healthy profit and still miss payroll. The gap is usually timing: a card processor settles next week, an invoice pays in 45 days, and payroll clears Friday. To understand how to calculate cash runway, start with money that is actually available, then model when each expected inflow and outflow reaches the bank.
Runway is not a P&L ratio. It is the length of time before available cash reaches a defined minimum balance under a specific operating plan. That definition matters because a runway number without a cash threshold, a burn assumption, and dated transactions is only a rough estimate.
How to Calculate Cash Runway
The simple formula is:
Cash runway = Available cash / Net cash burn per period
If available cash is $600,000 and average monthly net cash burn is $100,000, the business has six months of runway.
That calculation is useful for a quick management view, but it has a major limitation: it assumes cash leaves and arrives evenly through the month. Most businesses do not operate that way. Payroll may be biweekly, annual insurance may be paid in one month, and a large customer may settle late. A reliable runway calculation needs both a headline ratio and a time-phased cash forecast.
Define available cash before you divide
Available cash is not always the cash total displayed across every connected account. Start from reconciled bank and card balances, then remove amounts that cannot fund normal operations. Examples include restricted cash, customer deposits that must be held separately, funds reserved for tax remittances, and balances trapped in accounts with practical withdrawal limits.
You should also establish a minimum operating balance. A company with $600,000 in cash may decide that $150,000 must remain untouched to cover payroll variance, chargebacks, or an expected tax debit. In that case, usable cash for runway is $450,000, not $600,000.
This is a policy decision, not an accounting rule. The key is to document it, apply it consistently, and expose the underlying accounts and exclusions. Every number should trace back to its rows.
Calculate net cash burn, not net loss
Net cash burn is the cash leaving the business less the cash entering it during a period. For an operating runway view, use actual cash receipts and actual cash payments, not revenue and expenses recognized under accrual accounting.
A practical monthly formula is:
Net cash burn = Operating cash outflows - Operating cash inflows
Operating outflows commonly include payroll, payroll taxes, contractor payments, rent, software, inventory, vendor bills, insurance, interest, and tax payments. Operating inflows include customer collections, processor settlements, and other recurring operating receipts.
Whether to include debt principal, capital expenditures, owner distributions, or planned financing depends on the question you are asking. If the question is, “How long can the current business operate without raising capital?” include required debt service and committed capital spending, and exclude hypothetical financing. If you are measuring core operating efficiency, present these items separately. Do not silently mix definitions month to month.
Use a direct cash forecast for the decision-grade answer
A monthly average can hide the month that actually breaks the business. The stronger method is to project cash by day or week until the ending balance falls below the minimum cash threshold.
Start with the reconciled opening balance. Add expected receipts on their expected receipt dates. Subtract scheduled and projected payments on their expected payment dates. The runway endpoint is the first date the projected balance breaches your threshold.
| Date | Cash inflow | Cash outflow | Ending cash | |---|---:|---:|---:| | Opening balance | | | $450,000 | | April 5 | $0 | $86,000 payroll | $364,000 | | April 12 | $72,000 invoice collection | $18,000 vendors | $418,000 | | April 19 | $0 | $91,000 payroll and taxes | $327,000 | | April 30 | $45,000 processor settlement | $64,000 rent and software | $308,000 |
Continue that schedule through the planning horizon. If the forecast crosses a $150,000 minimum balance on August 16, runway is approximately four and a half months from April 1, even if a simple average suggests five or six months.
Direct-method forecasting is especially valuable for businesses with processor settlement delays, milestone invoices, seasonal collections, or irregular vendor terms. It represents the actual timing of money entering and leaving accounts instead of estimating cash backward from net income.
Use historical averages carefully
Historical burn is a starting point, not a forecast. A trailing three-month average can be misleading when a one-time tax payment, annual renewal, inventory purchase, or delayed customer collection sits inside the period.
Use history to establish a baseline, then replace averages with known future facts. Payroll should come from the payroll calendar. Rent should come from the lease. Loan payments should come from the amortization schedule. Known invoices should be forecast from due dates, payment behavior, dispute risk, and processor settlement timing.
For recurring but variable categories such as utilities, contractor spend, or marketing, a rolling average may be appropriate. State the rule explicitly. For example: use the trailing 90-day average, exclude annual insurance, and apply a 10% seasonal increase during the peak operating period. Deterministic rules make the forecast reproducible when someone asks why a number changed.
Stress-test the runway, not just the base case
A base-case runway answers one question: what happens if the plan performs as expected? Finance leaders also need to know which assumptions create a cash breach.
Build a small set of scenarios around the timing and magnitude of cash flows. A delayed collections scenario might shift the top five customer receipts by 15 days. A downside sales scenario might reduce future processor settlements by 20%. A hiring scenario might add salary, payroll tax, benefits, recruiting costs, and the date each cost begins.
Avoid a forecast with dozens of unlabeled manual overrides. Scenario inputs should be visible and replayable. If a forecast changes because collections moved by two weeks, users should be able to see which invoices moved, what rule applied, and how the ending cash path changed.
The most useful output is often not a single runway number. It is a range: for example, six months in the base case, four months if collections slip, and eight months if a planned hire is delayed. That range gives operators a decision window while there is still time to act.
Common errors that overstate runway
Runway becomes dangerous when it looks precise but rests on incomplete data. Watch for these four errors:
- Using an unreconciled bank balance that includes duplicated feeds, missing transactions, or stale account data.
- Treating booked revenue or open invoices as cash without modeling collection dates and payment probability.
- Omitting lumpy obligations such as payroll taxes, annual renewals, debt payments, sales tax, or insurance.
- Counting a planned fundraise, line draw, or refinancing as certain before the cash is contractually available.
There is also a subtler error: using a monthly forecast when the business can fail inside a month. If payroll and debt debits occur before a customer settlement, month-end cash may look positive while the daily balance goes negative. The forecast cadence should match the operational risk.
Make runway an operating control
A useful runway model is updated as new transactions clear and expected receipts change. Reconcile actual bank activity to the ledger, compare forecasted and actual cash movements, and investigate material variances. If a customer repeatedly pays 12 days late, that pattern belongs in the forecast rule, not in an analyst's memory.
This is where a unified financial system matters. In Shekl, transaction-level evidence, a reconciled ledger, direct-method cash forecasting, and scenario controls can operate from the same underlying data. The aim is not a prettier spreadsheet. It is a calculation that can be replayed, challenged, and reconciled to $0.00.
Treat runway as a live boundary condition for decisions. Before approving a hire, changing vendor terms, accelerating an inventory order, or extending customer credit, test the dated cash impact against the minimum balance. The best time to discover a cash constraint is while the decision is still optional.