Build a cash flow forecast for a funding decision

The business context

Forecast cash receipts, not just invoiced revenue. A profitable month can still contain a week when payroll is due before customers pay. The FDIC's cash flow materials distinguish cash moving into and out of a business from the wider financial picture.^[1]

Choose a forecast period that matches the decision

A weekly forecast over thirteen weeks is a useful working format for a near term funding decision. Extend it when the investment, seasonality, or repayment period requires a longer view. A multi year commitment also needs projections beyond the first quarter.

Use actual dates for large receipts and payments. Weekly totals can conceal a Monday payroll shortfall that a Friday collection would later repair. Where balances are tight, add a daily view for the critical weeks.

Set a minimum operating cash balance. This is a planning choice based on payroll, taxes, supplier needs, and uncertainty, not a universal percentage. The amount borrowed should be assessed against that reserve as well as against zero cash.

Establish opening cash and expected receipts

Start with reconciled unrestricted cash available at the beginning of the period. Exclude restricted funds and avoid counting an undrawn facility as bank cash. Show available credit separately and model a draw only when it is expected and permitted.

Build customer receipts from invoices, collection history, processor settlement dates, and realistic sales assumptions. Use the accounts receivable aging report to identify outstanding invoices, but do not assume every overdue amount will arrive immediately. Intuit's aging reports provide the balance and overdue detail needed for that review.^[3]

Separate operating receipts from financing, owner contributions, asset sales, and tax refunds. This makes it possible to see whether the core business generates cash or relies on one time support.

List cash payments when they actually occur

Include suppliers, payroll, rent, taxes, subscriptions, insurance, necessary capital spending, owner distributions, and existing debt payments where relevant. Distinguish fixed expenses from costs that vary with sales. Use actual obligations and dates rather than spreading every annual cost evenly across months.

Reconcile the categories to the accounting records so that expenses are not omitted or counted twice. An accounting profit and loss statement is a useful starting point, but unpaid expenses, inventory purchases, and debt principal create timing differences. Financial statements and cash projections serve related but different purposes.^[2]

Add the proposed financing as its own inflow and each related payment as an outflow. Show fees withheld separately or use the net cash receipt, but do not do both in a way that deducts the fee twice.

A worked four week forecast

Assume the business starts with $20,000 of cash. It expects a $30,000 net financing receipt in week one after any withheld fees. Existing debt is $2,000 weekly, and the new financing requires $1,500 weekly starting immediately. All figures below are hypothetical dollars.

Each closing balance equals opening cash plus receipts and funding, less all stated payments. The next week starts with that closing balance. Parentheses indicate cash leaving the business.

This view shows positive balances with the proposed financing. It does not prove the full $30,000 is required. Removing both the funding and its related payments produces closing balances of $12,000, $20,000, $22,000, and $29,000. Against a $15,000 minimum reserve, the lowest prefinancing position has a $3,000 gap. The stated $30,000 proposal therefore deserves review unless later weeks or additional project spending justify it.

Any smaller proposed facility must be modeled again with its own fees and payments. The $3,000 gap is not automatically the final borrowing amount.

Stress test collections and sales separately

First, delay a material customer payment. If $15,000 of the base case week two receipts arrives in week four instead, the funded closing balances become $40,500, $32,000, $32,500, and $53,000. The final balance is unchanged, but the interim liquidity is weaker.

Then test a genuine shortfall. If customer receipts are 15% lower in every week and all stated payments remain fixed for this test, funded closing balances become $36,750, $37,250, $32,950, and $32,750. The four week reduction is $20,250 because total original customer receipts were $135,000.

In your own downside case, reduce variable costs only where there is a credible mechanism and timing. Do not assume rent, payroll, or committed inventory falls immediately with sales. Add operational responses you can actually implement.

Adapt the forecast to the financing structure

For an installment loan, insert the contractual dates and include a variable rate sensitivity if relevant. For a credit line, model draws, fees, interest, repayments, and any maturity obligation.

For invoice factoring, show the initial advance and later reserve release separately, after fees and adjustments. For a revenue based arrangement, calculate remittances from the contract's definition of eligible receipts, including any reconciliation, minimums, or final payment requirements.

For a refinancing, remove only the obligations that will actually be satisfied and add the new ones. Show fees and any timing overlap. Use how to compare business financing offers to keep the assumptions consistent across alternatives.

Update the forecast with actual results

Each week, replace the completed period with actual receipts and payments, explain material differences, and extend the forecast. A repeated collection delay may require a revised assumption rather than the same optimistic date rolled forward.

Record the source of major assumptions and who owns each action. A forecast is more useful when a missed collection has an assigned follow up and an upcoming tax payment has a verified amount.

Common questions about cash flow forecasting

Is cash flow the same as profit?

No. Profit reflects income and expenses under the accounting method. Cash flow reflects receipts and payments. Credit sales, inventory, capital purchases, and loan principal can make the two differ significantly.

Should I include the funding before it is approved?

Model it as a clearly identified scenario, not as certain cash. Keep an unfunded case and test a delayed funding date. Do not commit spending that depends on an unconfirmed disbursement without understanding the consequences.

What if the forecast becomes negative?

Identify the week, cause, and size of the shortfall. Options may include collecting earlier, staging spending, changing payment terms, reducing the project, or reconsidering the financing. Recalculate the result after each change rather than simply adding an unexplained cash plug.

Choose funding from the forecast

Bring the base case, downside case, minimum reserve, and payment assumptions to a Westwind funding advisor. We can help discuss financing structures against the cash cycle. Use business funding preparation to connect the forecast to the rest of the application.