Cash Flow Forecast Calculator

The Cash Flow Forecast Calculator helps you project whether your business will have enough cash to cover upcoming expenses. It takes your current cash balance, your expected monthly income, and your expected monthly expenses, then projects your cash position out several months — so you can catch a potential shortfall while there’s still time to act.

How the Cash Flow Forecast Calculator Works

The calculator builds its projection from five core concepts:

• Beginning cash balance — your current cash on hand at the start of the forecast.
• Expected cash inflows — sales revenue and any other monthly income.
• Expected cash outflows — payroll, rent, utilities, marketing, taxes, loan payments, and other expenses.
• Net cash flow — inflows minus outflows for the period.
• Ending cash balance — what’s left after net cash flow is applied.

This calculator uses a flat monthly model: it applies the same monthly income and expense figures across every month in your chosen forecast period (3, 6, 12, or 24 months), then carries the running balance forward month by month — each month’s ending balance becomes the starting point for the next. If your business has income or expenses that change significantly from month to month, treat this as a baseline projection rather than a month-by-month plan; the calculator’s CSV export is a reasonable starting point if you want to build a more detailed, variable month-by-month version in a spreadsheet.

If your projected balance drops below zero in any month, the calculator flags it directly with a cash shortfall warning, naming the specific month and the projected balance at that point.

How to Use the Cash Flow Forecast Calculator

Use the Cash Flow Forecast Calculator above to estimate your projected cash position, and adjust your inputs to test different scenarios.

Cash Flow Forecast Formula

Cash inflows are the money coming into the business — sales revenue and other income. Cash outflows are the money going out — payroll, rent, and every other expense. Net cash flow is simply the difference between the two, and it can be positive or negative depending on whether inflows or outflows are larger.

Cash Flow Forecast Example

Here’s a hypothetical example using the calculator’s own default monthly figures, projected over 12 months:

Now compare a tighter scenario: a business starting with $5,000, earning $20,000/month, and spending $23,000/month. Net cash flow is −$3,000/month. By Month 1, the balance is $2,000; by Month 2, it drops to −$1,000 — the calculator would flag this as the first shortfall month, giving the owner an early signal to act before the cash runs out.

Why Cash Flow Forecasting Matters

• Avoiding unexpected cash shortages before they happen
• Planning for upcoming expenses like payroll or tax payments
• Managing working capital more deliberately
• Timing large purchases around periods of stronger cash flow
• Preparing for slow sales periods in advance
• Planning debt payments around projected cash availability
• Understanding your cash runway — how long your current balance will last
• Deciding when additional financing may become necessary
• Maintaining adequate liquidity to operate without disruption
• Making better-informed day-to-day financial decisions overall

Cash Flow Forecast vs. Cash Flow Statement

Short answer: a cash flow forecast looks forward and estimates what might happen; a cash flow statement looks backward and reports what actually happened. Both are useful, but they answer different questions.

Cash Flow Forecast vs. Cash Flow Projection

In everyday business usage, “cash flow forecast” and “cash flow projection” are generally used interchangeably — both describe an estimate of future cash inflows and outflows. Some practitioners use “projection” for a broader, longer-range estimate (like a 12-month outlook) and reserve “forecast” for a more frequently updated, near-term estimate, but this distinction isn’t consistently applied across the industry. For most small businesses, treating the two terms as synonyms is reasonable.

What Counts as Cash Inflows?

Common business cash inflows include:

• Customer payments and cash sales
• Accounts receivable collections (payments on past credit sales)
• Loans and business financing proceeds
• Owner contributions
• Investment proceeds
• Asset sales
• Other operating receipts, such as grants or interest income

Revenue and cash inflows aren’t always the same thing. If you make a sale on credit, you record revenue immediately under standard accounting, but the actual cash doesn’t arrive until the customer pays — which could be weeks or months later. A cash flow forecast tracks when the money actually lands, not when the sale is recorded.

What Counts as Cash Outflows?

Common business cash outflows include:

• Payroll
• Rent
• Utilities
• Inventory purchases
• Supplier payments
• Loan payments
• Taxes
• Insurance
• Marketing
• Equipment purchases
• Software subscriptions
• Other operating expenses

Timing matters here too. An expense might be recorded on the books in one month but actually paid in another, depending on payment terms. A cash flow forecast should reflect when the cash actually leaves your account, not just when the expense is incurred.

Operating, Investing, and Financing Cash Flows

Cash flow is often broken into three broad categories:

• Operating activities — day-to-day cash movements from running the business: customer payments, payroll, rent, and other routine expenses.
• Investing activities — cash related to long-term assets, like buying or selling equipment or property.
• Financing activities — cash related to borrowing, equity investment, or owner contributions and withdrawals.

For most small businesses, day-to-day forecasting focuses heavily on operating cash flow, since that’s where the bulk of monthly activity happens — but a major loan, equipment purchase, or investor contribution should still be accounted for in the relevant month.

How to Improve Your Cash Flow Forecast

• Use realistic, not overly optimistic, sales assumptions
• Base forecasts on actual historical data when it’s available
• Account for typical payment delays from customers
• Separate committed expenses from discretionary spending
• Include taxes and loan payments — it’s easy to forget these
• Factor in seasonality if your revenue isn’t steady year-round
• Build a cash buffer into your assumptions where possible
• Update your forecast regularly rather than setting it once
• Create best-case, expected, and worst-case versions to see your range of outcomes
• Monitor accounts receivable collections closely
• Review major upcoming expenses before they hit

None of this guarantees a perfectly accurate forecast — the goal is a well-informed estimate, not a prediction. Pairing your forecast with a Business Budget Planner can help you keep your underlying assumptions consistent across both tools.

Common Cash Flow Forecasting Mistakes

How Far Ahead Should You Forecast Cash Flow?

• 13-week cash flow forecast — a short, rolling window often used by businesses managing tight cash positions closely.
• Monthly cash flow forecast — useful for ongoing, general-purpose planning.
• 6-month forecast — a reasonable middle ground for tracking near-term trends and seasonal shifts.
• 12-month forecast — useful for annual planning, budgeting, and spotting longer seasonal patterns.

This calculator supports 3-, 6-, 12-, and 24-month horizons. The right choice depends on your business, current cash position, seasonality, and how much financial uncertainty you’re managing — businesses with tighter cash positions often benefit from shorter, more frequently updated forecasts.

Cash Flow Forecasting for Small Businesses

Cash flow forecasting is especially important for small businesses, which often face:

• Limited cash reserves to absorb surprises
• Irregular or unpredictable customer payments
• Seasonal revenue swings
• Large, lumpy supplier payments
• Fixed payroll obligations that don’t flex with slow months
• Potential financing needs that take time to arrange

Small businesses generally have less room for error than larger companies with bigger cash reserves. Reviewing your forecast regularly — and checking your Business Valuation Calculator results if you’re also thinking about longer-term planning — helps you stay ahead of problems rather than reacting to them after the fact.

What Does Positive or Negative Cash Flow Mean?

Positive cash flow means more cash came into the business than went out during the forecast period. Negative cash flow means more cash went out than came in.

What If My Forecast Shows a Cash Shortage?

If the calculator’s shortfall warning flags a negative projected balance, consider these steps:

1. Review your assumptions — make sure your income and expense estimates are realistic.
2. Identify the timing of the shortfall — knowing which month matters gives you time to prepare.
3. Accelerate receivables where appropriate — follow up on outstanding customer payments.
4. Delay or reduce nonessential spending during the tight period.
5. Negotiate supplier payment terms where appropriate, to shift outflow timing.
6. Review inventory purchases to avoid tying up cash unnecessarily.
7. Consider available financing options, such as a Business Loan Calculator, if additional capital may be needed.
8. Build or preserve a cash reserve to reduce the risk of future shortfalls.

Borrowing isn’t automatically the right answer to every projected shortfall — reviewing assumptions and adjusting spending or collections timing first is often the more direct fix.

Frequently Asked Questions

Key Takeaways

Related Calculators