PROFITTHEORY
← Back to blog

Cash Flow Forecast: How to Build One for Your Business

Cash flow forecast paperwork beside a calculator

A cash flow forecast is a forward-looking estimate of the cash that will enter and leave your business, week by week or month by month, so you can see your bank balance before you get there. The core formula is simple: beginning cash plus projected inflows minus projected outflows equals ending cash. This guide shows you the layout, a worked example, and how to use the result when you plan for working capital, equipment or an acquisition.

Disclosure: Profit Theory is an education resource, not a lender. We may be compensated if you ask to be introduced to a financing or payments provider and move forward. That compensation is disclosed and consent-based, and nothing here is a promise of funding or results.

Profit-theory
Plan Ahead for Cash Flow Gaps
Profit Theory explains working capital options and offers tailored financing plans to help business owners prepare for financing conversations.
Explore financing guidance

TL;DR

  • Formula: ending cash = beginning cash + projected inflows − projected outflows. Each period’s ending cash becomes the next period’s beginning cash.

  • Record income in the week the money is expected in your bank account, not the week you send the invoice.

  • Use weekly columns for the near term and monthly columns for the longer view. Update the forecast regularly and compare it with actual results.

  • A forecast that shows a gap early gives you time to collect faster, adjust spending, or talk to a financing specialist before cash is tight.

  • Lenders look at cash flow closely, so a clean forecast also supports a financing conversation.

Table of Contents

What a cash flow forecast is, and what it is not

A forecast estimates the cash coming in and going out of your business for a future period. It is not a profit and loss statement, and it is not the cash flow statement in your year-end financials. The FDIC’s small business training guide on managing cash flows separates the two: a cash flow statement records actuals and looks backward, while a cash flow projection (also called a pro-forma cash flow statement) looks forward.

Past actuals compared with future cash projections

The difference between profit and cash is why owners build forecasts at all. A job can be profitable on paper while the customer’s payment is still 45 days away and your payroll is due Friday. Profit tells you whether the business model works. Cash tells you whether you can pay for it this month.

What owners use it for

The common uses are practical:

  • Spotting a shortfall weeks before it happens.

  • Timing equipment purchases, hires or inventory buys.

  • Planning your own pay and owner distributions.

  • Seeing which customers pay late and what that costs you.

  • Supporting a financing request with numbers instead of guesses.

That last use matters. Federal bank supervisors’ guidance on small business lending, published by the FDIC, notes that the primary source of repayment for most small business loans is the borrower’s cash flow, and that a cash flow analysis should look at current and expected cash flows under a reasonable range of future conditions. A forecast is your version of that analysis.

What goes into a cash flow forecast

Every forecast has four anchors: an opening balance, cash inflows, cash outflows and a closing balance. The details under inflows and outflows depend on your business.

Cash inflows

  • Customer payments on invoices you have already sent

  • Expected payments on work you have not yet billed

  • Card and ACH deposits, after processing fees are taken out (see our guide to payment reconciliation to match deposits to sales)

  • Loan proceeds, grants, tax refunds and owner contributions, only when they are actually expected

Cash outflows

  • Payroll and payroll taxes

  • Rent and utilities

  • Inventory and supplier invoices

  • Loan and lease payments

  • Marketing, insurance and software

  • Estimated tax payments

  • Equipment purchases or other one-time spending

The FDIC’s template adds one useful structure: it groups cash into operating activities (customers, inventory, salaries, interest, income taxes), investing activities (buying or selling equipment) and financing activities (borrowing). If you are planning a purchase or a loan, separating these three makes the picture easier to read.

The formula

For each period:

Net cash flow = total inflows − total outflows
Ending cash = beginning cash + net cash flow
Next period's beginning cash = this period's ending cash

The formula

The OpenStax finance textbook describes the same logic: start with beginning cash, add anticipated inflows, deduct anticipated outflows, and look for surpluses and shortages. A negative net cash flow in one week is not a problem by itself. It becomes one when the ending balance falls below what you need to operate.

How to build the forecast, step by step

  1. Pick a period and a horizon. For day-to-day control, use weekly columns over 13 weeks. For planning a purchase or financing, add monthly columns out 12 months. The U.K. government-backed British Business Bank advises choosing a period at least as long as your cash-flow cycle, the time between paying for inputs and getting paid.

  2. Enter your opening balance. Use the combined cash in all business bank accounts at the start of the first period.

  3. List inflows by when cash lands. Use known payment patterns. If a customer usually pays 30 days after invoice, the money belongs in that week, not the invoice week.

  4. List outflows by when cash leaves. Payroll on the 15th and 30th goes in those weeks. Quarterly tax payments, annual insurance and software renewals go in the periods they hit.

  5. Calculate net cash flow and the closing balance. Carry the closing balance forward as the next opening balance.

  6. Mark your minimum cash cushion. Pick the lowest balance you are comfortable with and highlight any period that falls below it.

  7. Update and compare. Replace estimates with actuals as they arrive, and note where you were off.

The layout is a grid. Columns are weeks or months. Rows run: opening balance, receipts by category, total receipts, payments by category, total payments, net cash flow, closing balance. A spreadsheet is enough to start.

A worked example

Here is an illustrative four-week forecast for a made-up service business. The numbers are invented to show the mechanics, not benchmarks for any industry.

  • Week 1

    • Inputs: opening cash $20,000; receipts $9,000; payments $14,000 (payroll, rent).

    • Math: net = 9,000 − 14,000 = −$5,000; ending = 20,000 − 5,000 = $15,000.

    • Why it matters: the first week sets the baseline. Payroll and rent land together, so cash drops even in a normal week.

  • Week 2

    • Inputs: opening cash $15,000; receipts $6,000; payments $8,000 (supplies, utilities, software).

    • Math: net = −$2,000; ending = $13,000.

    • Why it matters: a quiet collections week. Receipts depend on customers paying, so this is the line you re-check most.

  • Week 3

    • Inputs: opening cash $13,000; receipts $7,000; payments $16,000 (payroll, quarterly estimated taxes, insurance).

    • Math: net = −$9,000; ending = $4,000.

    • Why it matters: this is the low point. If your cushion is $5,000, the forecast tells you three weeks ahead that you are short.

  • Week 4

    • Inputs: opening cash $4,000; receipts $18,000 (a large invoice is expected); payments $9,000.

    • Math: net = +$9,000; ending = $13,000.

    • Why it matters: the recovery depends on one customer paying on time. If that invoice slips a week, week 3’s low point stretches into week 4.

The lesson is in the timing, not the total. Over the four weeks the business ends $7,000 below where it started, but the real risk sits in week 3, and the forecast shows it while you can still act.

What to do when the forecast shows a gap

A shortfall on paper is information, not failure. Your options, roughly in the order owners try them:

  • Speed up receivables. Send invoices the day work is done, follow up before the due date, and offer easy payment options. Our working capital calculator shows what slow collections cost you in tied-up cash.

  • Move payments. Ask suppliers about longer terms, or time a purchase after a big receipt instead of before it.

  • Defer spending. Push non-urgent purchases out of the tight weeks.

  • Arrange financing before you need it. Getting a credit line in place while the business looks healthy is easier than scrambling during a squeeze. For overdue invoices specifically, see how invoice factoring works and what it can cost in advance rate and fees, so you can compare it with other options.

If the forecast shows a surplus, you can decide whether to build a reserve, pay down debt or fund growth.

How often to update it

A forecast goes stale quickly. The Association of Corporate Treasurers says operational cash forecasts generally run on a rolling 13-week horizon and are updated weekly or monthly. It also advises using reliable data, regular updates, and comparison with actual figures so the next forecast improves.

A simple weekly routine:

  1. Replace last week’s estimates with actual bank figures.

  2. Note the biggest variances and why they happened (a late payer, a surprise repair).

  3. Add a new week at the end so the horizon stays at 13 weeks.

  4. Revisit the assumptions for the next few weeks.

Business Victoria, an Australian government service, adds a detail worth copying: the closing balance of one period becomes the opening balance of the next, and estimates should be compared with actual cash flows. Spreadsheets break when someone overwrites that link, so protect the formula cells.

Build in scenarios

One forecast is a guess. Three are a plan. Keep your base case, then copy the sheet and change the assumptions that worry you:

  • Slow-pay case: your largest customers pay 15 days late.

  • Soft-sales case: receipts come in a set percentage below your base case.

  • Cost-spike case: a key expense rises, or a repair or replacement arrives unexpectedly.

If the slow-pay case still clears your cushion, you are resilient. If it does not, you now know which lever to prepare.

Common mistakes

  • Using invoice dates instead of payment dates. This makes cash look healthier than it is.

  • Forgetting irregular costs. Quarterly taxes, annual insurance, equipment repairs and seasonal inventory buys are the usual culprits.

  • Ignoring processing fees. Card sales reach your bank net of fees, so forecast the deposit, not the sale. A payment review can show what your business pays today.

  • Treating a loan as income. Borrowed money is cash in, but repayments are cash out in every later period.

  • Never checking actuals. A forecast you do not compare to reality never gets better.

Forecasting when you plan to borrow or buy

If you are considering a purchase, equipment or a business acquisition, add the new payments to your forecast before you commit. The question is whether your cash flow can carry the extra obligation in your slowest weeks, not only in an average one. Our guide on how much debt your cash flow can afford walks through that test, and the business cash flow and runway calculator lets you try the numbers. Buyers can start with our owner’s guide to financing a business acquisition.

Lenders may ask for your forecast along with other documents. Our bank-ready loan package overview shows how a forecast fits into a complete file.

A note on taxes: estimated tax payments belong in the forecast, but how much you owe and when depends on your entity type, state and situation. Keep that part general in your model and confirm the amounts with a CPA. For anything legal, such as contract terms or collection rights, talk to an attorney.

Perspective: why we treat the forecast as step one

We see the same pattern when owners come to us about financing: the question is rarely “can I get a loan?” It is “what can my cash flow carry?” A forecast answers that before anyone fills out an application.

That is why our education starts with the numbers you already have. Our calculators and plan-building tools need no Social Security numbers or bank logins, so you can test timing, payments and cushions privately. We are not owned by any lender or payment processor, so our job is to help you understand your options, not to push one product.

When you are ready to talk to someone, a dedicated financing specialist guides your engagement, and a clear forecast makes that conversation faster and more useful. Compensation, if any, is disclosed and consent-based.

Profit Theory Team

Take your forecast into a financing plan

If your forecast shows a recurring gap, or you are planning an acquisition, expansion or equipment purchase, a tailored financing plan turns those numbers into a structured next step. A dedicated specialist guides each engagement, and you can read how it works on our how we work page.

Profit-theory

Prefer to get documents ready first? Start with a loan package built around your cash flow. Profit Theory may be compensated if you ask to be introduced to a provider and move forward, which is disclosed and consent-based. We never promise funding or specific results.

FAQ

What is the formula for a cash flow forecast?

Beginning cash plus projected inflows minus projected outflows equals ending cash. Calculate it for each week or month, then carry the ending cash into the next period as its beginning cash.

How far ahead should a small business forecast?

Most owners use 13 weekly columns for operations and a 12-month monthly view for planning. Choose a horizon at least as long as the time between paying for inputs and collecting from customers. Roll it forward as each week closes.

What is the difference between a cash flow forecast and a cash flow statement?

The statement records cash that actually moved in a past period. The forecast estimates cash that will move in a future one. You use the statement to learn your patterns and the forecast to plan.

What is a 3-way forecast?

It links the income statement, balance sheet and cash flow forecast into one connected model, so a change in one flows through the others. A standalone cash flow forecast is a good start for most small businesses, and you can add the other two statements as your planning gets more detailed. Your accountant can help set it up.

Can a forecast help with a loan application?

It can support one. Lenders evaluate whether cash flow can cover repayment, and a forecast shows your expected cash under realistic conditions. Approval depends on the lender and your full file, so treat it as preparation, not a promise.

Profit-theory
Discuss Your Financing Questions
Email Profit Theory to ask about working capital, financing plans, or preparing a lender-ready loan package for your business.

Sources

Disclosure: This article is educational. It is not an offer of credit, a rate quote or a promise of approval. Profit Theory may receive compensation if you ask to be introduced to a lender or other financing provider and move forward with them. Introductions happen only with your consent, and lenders alone decide approval, rates and terms. For advice on your situation, talk to your CPA or attorney.

← Back to blog
Build my financing plan How we get paid