Account

What new tool do you want?

Business & E-commerce

12-Month Cash Flow Forecast

Project your business's cash balance month by month for a year from starting cash, revenue growth and fixed and variable costs — and spot when it runs low.

How to use

  1. 1Enter starting cash, monthly revenue and its monthly growth rate.
  2. 2Enter fixed monthly costs and variable costs as a share of revenue.

How it's calculated

Each month: revenue grows by the growth rate; net cash flow = revenue − fixed costs − revenue × variable %; closing balance = opening + net flow.

Frequently asked questions

What's the difference between profit and cash flow?

Profit counts sales when made; cash flow counts money when it moves. Slow-paying customers can make a profitable business run out of cash.

What is burn rate?

How much cash you lose per month when costs exceed revenue. Runway = cash ÷ burn rate.

How often should I update the forecast?

Monthly, replacing forecasts with actual figures as each month closes.

Why a profitable-looking business can still run out of cash

This forecast tracks money actually moving in and out each month, not revenue recognized on paper — a company with solid monthly revenue can still see its cash balance decline every month if fixed and variable costs consistently exceed that revenue, eventually running negative regardless of how healthy the top line looks.

Worked example: 12-Month Cash Flow Forecast

Starting with $1,000 cash, $1,000 in monthly revenue with 0% growth, $1,100 in fixed costs and no variable cost percentage: every month loses exactly $100 ($1,000 revenue − $1,100 costs), so the cash balance falls $1,000 → $900 → $800 and so on, crossing zero in month 11 and ending year one at −$200. Because revenue growth was set to 0% in this example, there's nothing to offset the steady monthly loss — a small amount of revenue growth would change when, or whether, the balance goes negative.

Why this is worth re-running monthly with real numbers

A forecast built once at the start of the year drifts further from reality every month that passes without being updated — replacing each month's forecast figures with the actual revenue and costs as they close keeps the remaining months' projections honest, and often reveals a cash problem (or a cash cushion) months before it would otherwise become obvious.

Why a small change in the growth rate assumption swings the whole year

Because revenue growth compounds month over month across the full 12-month forecast, the difference between assuming 3% and 5% monthly growth becomes large well before year-end, even though the two numbers look similar typed into a single field. It's worth running this forecast at least twice — once with a conservative growth assumption and once with an optimistic one — to see the realistic range of outcomes rather than anchoring on a single growth rate that happened to feel reasonable, since the gap between the two scenarios often reveals exactly how much cash cushion is actually needed to survive a slower-than-hoped first year — a business that only survives under the optimistic growth assumption is effectively betting its runway on a forecast turning out right, which is a risk worth naming explicitly rather than discovering by accident mid-year.

The warning names the first month the balance goes negative

The sheet walks twelve months. Each month subtracts fixed costs and the variable percent of that month's revenue, then the next month's revenue is the current revenue grown by the monthly growth rate, which opens at 5 percent. Starting cash opens at 50,000. The headline is the cash after those twelve months. The low balance names which month was the worst, even if it never went negative. The warning says the cash runs out in a specific month the first time the balance crosses below zero, or that it does not happen within twelve months. Growth compounds, so a small change in the percent moves month twelve more than month two. Currency changes the symbol. The walk always stops at twelve. It does not extend the year.

Related tools

More: Business & E-commerce