Calculating Cash Runway and Break-Even Point
The 12-Week Rolling Forecast
Read this before answering the questions.
A 12-week rolling cash flow forecast is a weekly liquidity management tool. You start with a reconciled opening cash balance, forecast all near-term inflows and outflows by week, calculate the closing balance each week, and then roll the model forward every week using actual results.
The core runway calculation is simpler than the forecast itself:
- Cash runway in weeks = Current cash ÷ Average weekly burn
- Cash runway in months = Current cash ÷ Average monthly burn
For a rolling forecast, runway is often better measured from the forecasted minimum closing cash balance rather than today's balance, because the forecast shows when cash may dip below a safe threshold.
A practical way to combine both is:
- Opening cash
- + forecasted inflows
- − forecasted outflows
- = closing cash for each week
Then estimate runway from the burn rate: Burn rate = average monthly cash outflows − average monthly cash inflows if your business is cash-negative, or simply net monthly cash outflow.
A startup has $120,000 in cash. Its average weekly burn is $10,000. How many weeks of runway does it have?
- 8 weeks
- 12 weeks
- 10 weeks
- 15 weeks
A company has $60,000 in cash and a monthly burn rate of $15,000. Its cash runway is ____ months.
- 2
- 4
- 3
- 5
In a 12-week rolling forecast, the opening cash balance should reflect a reconciled cash position, not just the raw bank balance.
Which of the following is the most accurate way to measure runway in a rolling forecast?
- Using today's cash balance divided by average monthly burn
- Using the forecasted minimum closing cash balance over the horizon
- Using the highest projected cash balance in the forecast
- Using the average of all weekly closing balances
Identifying Common Forecasting Errors
Where Forecasts Go Wrong
Read this before answering the questions.
Common cash flow forecasting mistakes for early-stage startups are usually timing errors, assumption errors, and missing costs rather than spreadsheet math problems.
The most common mistakes are:
- Treating revenue as cash: founders often forecast when a deal is signed or revenue is recognized instead of when the money actually lands in the bank. Delayed customer payments, installment schedules, and accounts receivable can create a large gap between sales and cash.
- Assuming all burn is evenly spread: payroll, vendor bills, taxes, and other obligations hit on specific dates, so a "monthly burn" number can hide short-term cash crunches.
- Overly optimistic sales assumptions: startups frequently overestimate close rates, revenue timing, or how quickly customers pay.
- Ignoring working capital needs: growth can consume cash because inventory, receivables, and other working-capital needs rise as the business scales.
- Forgetting irregular or non-monthly expenses: annual insurance, software renewals, tax payments, capex, and other lumpy costs are easy to miss in simple forecasts.
- Using only one scenario: relying on a single "base case" forecast creates false confidence; best-case, base-case, and worst-case models are standard practice.
- Not updating the forecast often enough: stale models miss changes in sales, hiring, spending, or payment delays; many sources recommend weekly or at least regular rolling updates.
- Mixing profitability with liquidity: a startup can look profitable on paper and still run out of cash if collections are slow or expenses are front-loaded.
A founder records a $50,000 sale in the forecast the day the contract is signed, but the customer won't pay for 60 days. What is the primary error here?
- Overestimating the sale amount
- Treating revenue as cash
- Forgetting variable costs
Liquidity Management Strategies
Responding to Cash Shortfalls
Read this before answering the questions.
When cash gets tight, founders need to act quickly and strategically. Effective liquidity management involves a combination of:
- Accelerating receivables: invoice faster, offer early-payment discounts, or tighten credit terms.
- Delaying payables: negotiate extended payment terms with suppliers, but be careful not to damage relationships.
- Reducing fixed costs: renegotiate rent, cut non-essential subscriptions, or delay hiring.
- Securing short-term financing: lines of credit, invoice factoring, or bridge loans.
- Selling assets: liquidate unused equipment or inventory.
- Adjusting operations: pause growth initiatives, reduce inventory levels, or shift to a leaner operating model.
The key is to act before cash runs out, not after. Set trigger levels and actions: define thresholds for when cash gets tight and assign owners for corrective actions.
A practical approach is to model multiple scenarios and identify the point where cash dips below a safe threshold, then plan the response in advance.
A startup's forecast shows cash dipping below its safe threshold in 6 weeks. Which action is most effective to close the gap?
- Waiting to see if sales improve
- Accelerating receivables and delaying payables
- Increasing marketing spend
- Hiring more sales staff
It is better to wait until cash is nearly depleted before taking corrective action.
Which of the following is a short-term financing option that can bridge a cash gap?
- Selling equity to a new investor
- Invoice factoring
- Reducing product prices
- Delaying product launch
Setting ____ levels and actions means defining thresholds for when cash gets tight and assigning owners for corrective actions.
- profit
- trigger
- revenue
- growth
Fuentes
Referencias
Frequently asked questions
What is a 12-week rolling cash flow forecast?
A 12-week rolling cash flow forecast is a weekly liquidity management tool. You start with a reconciled opening cash balance, forecast all near-term inflows and outflows by week, calculate the closing balance each week, and then roll the model forward every week using actual results.
How do I calculate cash runway in weeks or months?
Cash runway in weeks equals Current cash divided by Average weekly burn. Cash runway in months equals Current cash divided by Average monthly burn. For a rolling forecast, runway is often better measured from the forecasted minimum closing cash balance rather than today's balance.
Why measure runway from the forecasted minimum closing cash balance?
The forecast shows when cash may dip below a safe threshold, so measuring runway from today's balance can hide an approaching shortfall. Using the forecasted minimum closing cash balance gives a more accurate picture of when cash may run low.
How often should a rolling cash flow forecast be updated?
A 12-week rolling cash flow forecast is rolled forward every week using actual results. Each week you replace forecast figures with real outcomes and extend the model by one week, keeping the horizon at 12 weeks.