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.

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.