How far ahead should I forecast cash flow?

Most businesses benefit from a rolling 13-week (weekly) forecast for near-term cash management and a 12-month (monthly) forecast for strategic planning. The weekly forecast catches immediate shortfalls. The monthly forecast identifies seasonal patterns, large outflows, and minimum reserve breaches months in advance. Both should be updated with actual figures weekly or monthly.

What is the difference between cash flow and profit?

Profit is an accounting measure that matches revenues to expenses regardless of when cash moves. Cash flow tracks actual cash received and paid. A business can be profitable but cash-poor when customers pay slowly, inventory builds up, or large capital expenditures precede revenue. Conversely, a business can have positive cash flow while reporting a net loss (e.g., from collecting prepayments). Both measures are important -- they answer different questions.

What is a minimum cash reserve?

A minimum cash reserve (or cash buffer) is the lowest acceptable cash balance before the business takes financing or operational action. Common guidelines suggest 60 to 90 days of operating expenses for established businesses, or 3 to 6 months for startups. The right minimum depends on your revenue predictability, access to credit, and how quickly cash outflows can be reduced if needed.

How do I improve a negative cash flow forecast?

The lever set is specific: accelerate inflows (tighten payment terms, offer early payment discounts, improve collections), defer outflows (negotiate extended supplier payment terms, delay non-essential capex), reduce outflows (cut discretionary spending), or arrange financing (line of credit, invoice factoring) ahead of the projected shortfall. The forecast is only useful if you act on what it shows.

Business Finance

Cash Flow Forecast Calculator

Project monthly cash inflows, outflows, and ending balances over a customizable forecast period.

Cash Flow Inputs

Opening Cash Balance ($)

Monthly Revenue ($)

Monthly Revenue Growth (%)

Fixed Monthly Expenses ($)

Variable Expense Rate (% of Revenue)

Forecast Period (Months)

Embed This Calculator on Your Website

Add this free calculator to your blog, website, or CMS with a simple copy-paste embed code.

Introduction

More businesses fail from cash flow problems than from lack of profit. A company can be profitable on paper and insolvent in its bank account simultaneously -- a reality that catches many small business owners off guard. The U.S. Bank study on small business failure found that 82% of businesses that fail do so because of cash flow mismanagement, not insufficient revenue. A cash flow forecast projects the actual movement of cash in and out of your business over a future period -- not revenue recognized, not invoices sent, but cash received and cash paid. This matters because a $200,000 invoice issued in March may not be collected until May, while payroll, rent, and supplier payments continue every month regardless. This calculator builds a rolling monthly cash flow projection so you can identify shortfalls before they become emergencies -- and plan financing, collections, or spending reductions accordingly.

What This Calculator Does

This cash flow forecast calculator projects cash inflows (cash sales, receivables collections, loans, other income) and cash outflows (payroll, rent, cost of goods, marketing, loan repayments, taxes, and other expenses) on a monthly basis. Enter your opening cash balance and your projected monthly inflows and outflows to generate net cash flow per period, cumulative cash position, and a flag for any months where cash drops below your minimum reserve threshold.

The Formula

Net Cash Flow (Period) = Total Cash Inflows - Total Cash Outflows | Closing Cash Balance = Opening Cash Balance + Net Cash Flow

Cash inflows include all cash actually received: payments collected from customers, proceeds from loans or investment, asset sales, and any other cash income. Cash outflows include all cash actually paid: payroll, rent, supplier invoices settled, loan principal and interest, tax payments, and capital expenditures. The forecast uses cash timing -- when cash moves -- not accrual accounting recognition dates. A sale recognized in January but paid in March appears in the March inflow column, not January.

Step-by-Step Example

Enter opening cash balance

A retail business begins Q2 with $48,500 in its operating account. Enter $48,500 as the April opening balance.

Enter monthly cash inflows

April projected inflows: Cash sales $62,000. Accounts receivable collections from March invoices: $18,400. Total April inflows: $80,400.

Enter monthly cash outflows

April projected outflows: Payroll $24,800. Rent $6,200. Supplier payments $31,500. Utilities and misc $2,100. Loan payment $3,400. Total: $68,000.

Calculate net cash flow and closing balance

Net cash flow: $80,400 - $68,000 = $12,400. Closing April balance: $48,500 + $12,400 = $60,900. Repeat for May and June. If May shows a projected closing balance below the $20,000 minimum reserve, flag it for action -- either accelerate collections or defer discretionary spend.

Real-World Use Cases

Seasonal Business Managing a Revenue Trough

A landscaping company earns 70% of annual revenue from April through September. The October to March period has minimal inflows but full payroll and overhead. The cash flow forecast built in September projects a February closing balance of $8,200 against a $15,000 minimum reserve requirement. The shortfall ($6,800) is identified 5 months in advance -- giving the owner time to arrange a seasonal line of credit at favorable rates rather than emergency borrowing.

Startup Identifying Runway Before a Large Receivable

A technology services startup signs a $180,000 contract in January, payable 50% on delivery (March) and 50% on acceptance (May). Monthly outflows are $38,000. The forecast shows the starting $95,000 cash balance depletes to $19,000 by late February -- before the first $90,000 collection arrives. The founder arranges a $40,000 bridge draw from a credit facility in February, preventing a payroll shortfall.

Planning a Capital Expenditure

A manufacturer wants to invest $75,000 in new equipment in Q3. The 12-month cash flow forecast shows that making the purchase in July produces a September closing balance of $3,400 -- dangerously low. Shifting the purchase to October, after the seasonal revenue peak, maintains minimum balances above $25,000 throughout the year. The timing decision is made with data, not intuition.

Comparison

Cash Flow Type	Definition	Example	Included in Forecast
Operating Cash Flow	Cash from core business operations	Customer payments, payroll, supplier invoices	Yes
Investing Cash Flow	Cash from asset purchases or sales	Equipment purchase, property sale	Yes (capital expenditures)
Financing Cash Flow	Cash from borrowing or equity	Loan drawdown, investor injection, loan repayment	Yes
Accrual Revenue	Revenue recognized, not yet collected	Invoice sent but unpaid	No -- appears when collected
Depreciation	Non-cash accounting charge	Annual equipment write-down	No -- cash paid at purchase

Common Mistakes to Avoid

Confusing revenue with cash inflow. Revenue is recognized when earned under accrual accounting. Cash arrives when the customer pays. If your average collection period is 45 days, a March revenue figure does not belong in the March cash inflow column -- it belongs in mid-May. Forecasting cash inflow from revenue without adjusting for collection timing is the most common reason forecasts are misleading.
Omitting irregular but predictable outflows. Annual insurance premiums, quarterly tax payments, annual software renewals, and periodic equipment maintenance are real cash outflows that do not appear every month. Omitting them from the forecast makes some months look cash-positive when they are actually cash-negative.
Not tracking the variance between forecast and actual. A forecast that is never compared to actual results gives no feedback on forecast quality. Track actual vs. projected each month and investigate the largest variances. Over time, this improves forecast accuracy and identifies structural problems in billing, collections, or cost control.

Frequently Asked Questions

Accuracy and Disclaimer

Cash flow forecasts are projections based on user-provided assumptions about timing and amounts of inflows and outflows. Actual results will differ from projections. This calculator does not account for interest income on cash balances, bank fees, or more complex financing structures. Results are for planning purposes only and do not constitute financial advice. Consult a licensed accountant or financial advisor for business financial planning.

Conclusion

A cash flow forecast is only useful if it is updated with actual results. Build the habit of comparing forecast to actual cash flows monthly and identifying the variance drivers. Most cash flow crises are telegraphed weeks or months in advance in a properly maintained forecast. To understand the working capital that drives your collection timing, use the Working Capital Calculator. For businesses with variable revenue, pair the forecast with the Burn Rate and Runway Calculator to understand how long your current cash reserves support operations.