Cash Flow Projection Example for a Small Business

A cash flow projection turns a business plan into a calendar. It shows when cash is likely to arrive, when it must leave, and whether the business has enough room between those dates to make the next commitment with confidence.

The useful part is not the spreadsheet itself. It is the moment the projection makes a decision more specific. A founder may see that a hire works if a customer pays in week two, but not if that payment lands in week six. An operator may find that a profitable project still needs a deposit because payroll and suppliers come first. A nonprofit leader may see that restricted funding does not solve the timing of an unrestricted expense.

The example below is deliberately simple and fictional. Its purpose is to show the questions a working projection should answer, not to suggest that every business has the same cash pattern. For a broader operating framework, start with Venturion's practical cash flow forecasting guide, then use an example like this to test the decisions in front of your business.

What a useful cash flow projection should answer

A projection starts with one question: what will the bank balance look like after the known and likely movements of cash? That sounds basic, but it requires a different discipline than looking at a profit and loss statement. Revenue can be earned before it is collected. Expenses can be recorded before they are paid. The bank balance only changes when money actually clears.

Strong projections keep that timing visible. Wells Fargo's cash flow projection guidance makes the same practical point: listing future shortfalls and surpluses lets an owner act before the gap becomes urgent. The specific action may be collection follow-up, a staged purchase, revised customer terms, delayed hiring, or a financing conversation.

The starting view should be close enough to reality that leadership trusts it, but simple enough to update every week. A 13-week horizon is often useful for operating cash because it is long enough to reveal a pattern and near enough that the team can still challenge the inputs. The U.S. Small Business Administration also treats sound financial management as an ongoing business responsibility, not a year-end cleanup task.

A cash flow projection example

Consider a fictional creative-services firm beginning April with $52,000 in available cash. It expects two customer payments, has regular payroll, and is deciding whether to place a $12,000 production deposit. The owner's first instinct is that the deposit is affordable because the month's expected revenue is strong. The projection tests whether the timing supports that instinct.

In this expected case, the business can place the deposit. The low point is $33,000 in week two. The important next question is not whether the final month-end balance looks acceptable. It is whether $33,000 is enough cushion for an unexpected expense, a slow collection, or a cost that has not yet appeared in the plan.

This is why ending cash is not the only number that matters. The minimum balance tells leadership how much flexibility the plan leaves. A projection that ends the month with $43,000 can still be too tight if it briefly drops to a level that puts payroll, taxes, debt service, or essential delivery at risk.

What changes when a customer pays late

Now change only one assumption. The $18,000 collection expected in week two slips to week four. Nothing else about the business has changed, but the timing has. Week two ends at $15,000 rather than $33,000, and week three falls to $1,000 before the delayed cash arrives. The owner has not discovered that the business is unprofitable. The owner has discovered that the current sequence of commitments is unsafe.

That is the value of a projection. It creates choices while there is still time to use them. The business might ask the customer for a partial payment, negotiate the deposit into two stages, move a discretionary purchase, draw on existing financing, or defer the commitment. Without the projection, the same choices may be available later, but under pressure and with less leverage.

Keep the estimated collection date separate from the invoice date. A signed contract, a submitted invoice, and cash in the bank are different events. The Australian government's cash flow statement guidance similarly emphasizes recording the timing of money in and out. That detail is where a projection becomes a decision tool instead of an optimistic revenue list.

How to build your own projection

1. Start with cleared cash. Use the available bank balance after accounting for payments already authorized but not yet cleared. Do not start with an accounting balance that includes cash the business cannot actually use.
2. Choose a time frame that matches the decision. Weekly periods are usually best for the next 13 weeks. Use daily detail only when a short cash constraint makes it necessary. Monthly periods can sit behind the near-term view for a longer hiring, expansion, or financing decision.
3. List incoming cash by realistic date. Include invoice collections, deposits, grant draws, financing proceeds, subscriptions, refunds, and any other receipts that will reach the bank. Label uncertain items so the team knows what needs active follow-up.
4. List the obligations that cannot be missed. Payroll, payroll taxes, debt payments, rent, insurance, major vendors, and supplier deposits deserve their own lines. Combine smaller items only when that does not hide a meaningful timing risk.
5. Calculate the rolling ending balance. Each period's ending cash becomes the next period's opening cash. This is the simple mechanic that makes the first pressure point visible.
6. Assign an owner to the assumptions that matter. Someone should own each uncertain collection, purchase timing, sales milestone, or financing event. A number without a source, date, and owner is not a useful planning assumption.

The goal is not a beautiful file. It is a view that a leadership team can challenge in ten minutes. If a forecast requires one person to decode it, it will not survive the moment a customer payment, staffing plan, or cost estimate changes.

Run three views before making a commitment

One projection is an expected case. It is not the whole decision. Create a slower case and a constrained case beside it. The slower case can push collections or sales starts out by a reasonable amount. The constrained case can assume a major payment slips, project costs rise, or financing takes longer than planned. There is no prize for making every scenario dramatic. The point is to find which assumptions actually change the answer.

In the example above, the deposit may be a clear yes in the expected case, a yes with revised terms in the slower case, and a no until a collection clears in the constrained case. That is a better leadership conversation than debating whether the project feels like a good opportunity. JPMorgan's overview of forecasts and projections also distinguishes the forward-looking exercise from a static historical report. Decisions improve when the model shows what could change, not just what happened last month.

Use the low point to make the decision

The lowest projected balance is where a cash flow projection becomes useful to an owner. Do not treat it as an automatic stop sign. Treat it as the point that requires a clear answer: what cash must remain available, what could change that number, and who is responsible for reducing the risk?

Before approving a hire, purchase, project deposit, owner draw, or expansion spend, ask five practical questions. Is the opening cash balance reconciled to the bank? Which expected collections are confirmed, and which are still estimates? Which payments can move, and which cannot? What is the first date the balance falls below the agreed cash cushion? What action will be taken if the delayed-case scenario becomes more likely?

A business does not need the same cushion every week. Payroll week, tax dates, a large vendor run, or an active financing process can justify a larger margin of safety. The point is to make the threshold deliberate. When the team has agreed on the minimum cash it needs to operate well, a proposal can be assessed against a shared standard instead of instinct or the current bank balance.

Write the decision next to the number. For example: “Approve the production deposit only after the $18,000 customer collection clears,” or “Proceed now if the supplier will split the deposit into two payments.” That keeps the projection connected to action. It also makes the next weekly review faster because the team can see which assumption must be checked first.

Turn the projection into a weekly management routine

Set a short recurring review. Compare the prior week's projected collections and payments with what actually cleared. Replace old assumptions with confirmed dates, then look forward for the first low-cash week. End the meeting with owners and actions: follow up on a receivable, ask for revised terms, pause a spend, approve a purchase, or prepare a financing option.

The result should be a few clear operating decisions, not a longer meeting. Venturion's Fractional CFO and FP&A work is built around this kind of decision-grade view: connecting actual operating data, forecasts, and the commitments leadership is considering.

When outside financial leadership helps

A spreadsheet can show the first low-cash week. It may not answer what to do about it. Outside financial leadership can help when the business needs a clearer operating model, a defensible cash cushion, reliable reporting, or a plan for financing, board, or investor conversations. That is especially valuable when cash decisions involve more than a single invoice or vendor payment.

Venturion helps leaders connect forecasts to operational choices, pressure-test assumptions, and build a view of cash that holds up in the meeting where a decision has to be made. The Fractional CFO services page outlines the support available when a working projection reveals that the decision needs more than a formula.

Related posts

Financial Leadership

Cash Flow Forecasting for Small Business: A Practical Guide

Build a working 13-week view of incoming and outgoing cash, then use it to make the next decision with more clarity.

Read article →

Financial Leadership

What Does a Fractional CFO Do? A Practical Guide

Understand the financial leadership work that helps turn reporting and forecasts into clearer choices.

Read article →