Cash Flow Forecaster — 12-Month Projection with Seasonality
Enter your starting cash, expected monthly inflows, and outflows to see your projected cash position over the next 12 months. Quickly identify months where you might run short.
Cash in bank right now
Average revenue collected
Rent, payroll, supplies, etc.
Seasonal Adjustments (optional)
Adjust the percentage for months that differ from your average. 100% = normal, 150% = 50% higher, 75% = 25% lower.
12-Month Cash Flow Projection
Month-by-Month Breakdown
| Month | Starting | Inflows | Outflows | Net | Ending |
|---|
Using This Forecast
- • Use 80% of expected inflows to be conservative
- • Update monthly with actual numbers
- • Flag any month where ending cash drops below 2 months of expenses
- • Plan financing needs 2-3 months before cash gets tight
💡 Learn More
Understanding cash flow is critical for business survival. Our guide covers why profitable businesses fail and how to manage cash effectively.
Read Cash Flow Basics →Why Cash Flow Kills Profitable Businesses
A 2019 JPMorgan Chase Institute study analyzing over 597,000 small business checking accounts found that the median small business holds just 27 cash buffer days — meaning if inflows stopped tomorrow, half of small businesses would exhaust their operating cash in under a month. Only 25% of small businesses carry more than 62 days of cash reserves. This is the structural reason profitable businesses fail: positive accrual profit does not equal positive cash in the bank. Invoices paid on Net 30 or Net 60 terms, seasonal revenue dips, and upfront inventory purchases routinely push working capital negative long before the P&L shows distress.
According to a QuickBooks survey of small business owners, 61% report cash flow problems at some point, and 32% report being unable to pay vendors, loans, themselves, or employees due to cash flow. The SBA recommends maintaining a minimum cash reserve of 3 to 6 months of operating expenses, yet Federal Reserve Small Business Credit Survey data shows that 43% of employer firms seek financing primarily to cover operating expenses rather than expansion — a clear signal that cash buffers are thin across the economy, not just among struggling firms.
Forecasting monthly cash 12 months out is the single highest-leverage planning exercise for a small business owner. It surfaces gaps before they become crises, exposes the real cost of slow-paying customers, and lets you negotiate from strength rather than desperation. Use the projection above to model three scenarios — best case, expected, and a 20% revenue shortfall — and identify the lowest point in your cash balance across the year. That trough, not your average, determines how much working capital or credit line you actually need.
When to Use This Calculator
Planning a Major Hire
Before adding a salaried employee, model the impact on your 12-month cash position. A hire that looks affordable month-to-month can create a serious crunch when combined with slow-revenue months.
Seasonal Businesses
Retailers, landscapers, tourism operators, and others with revenue peaks need to confirm they have enough cash to survive low months. Use seasonal adjustments to model realistic monthly inflows.
Applying for a Line of Credit
Banks want to see cash flow projections before extending credit. Run this forecast and export or screenshot it as supporting documentation for your loan application.
Industry Benchmarks
Recommended cash reserve levels by business type, based on SBA and SCORE guidance.
| Business Type | Recommended Reserve | Warning Level |
|---|---|---|
| Freelance / Solo | 3 months expenses | Below 1 month |
| Service Business | 3–4 months expenses | Below 6 weeks |
| Retail / E-commerce | 4–6 months expenses | Below 2 months |
| Restaurant / Seasonal | 6–9 months expenses | Below 3 months |
Common Mistakes
Using revenue instead of collections
Cash flow is about when cash actually hits your bank — not when you invoice. If you have 30–60 day payment terms, model inflows based on collection timing, not invoice dates.
Using optimistic inflow estimates
Use 80% of expected revenue as your inflow projection. Conservative modeling prevents cash crises. Being pleasantly surprised beats running short on payroll.
Forgetting lump-sum annual expenses
Insurance renewals, annual software licenses, tax payments, and quarterly estimated taxes all create irregular outflows. Add them to the relevant months, not spread evenly.
Not updating the forecast monthly
A forecast created once and never updated is useless by month 3. Update actuals each month and roll the projection forward to maintain a live 12-month view.
Data Sources
Cash reserve benchmarks and financing patterns for small businesses from Federal Reserve's Small Business Credit Survey.
Small business failure rates and cash flow as root cause data from SBA annual economic research.
Cash management guidelines and reserve recommendations from SCORE mentors working with 1,200+ businesses annually.
Frequently Asked Questions
Why do profitable businesses run out of cash?
Profit is an accounting concept; cash is what pays bills. A profitable business can run out of cash if customers pay late, inventory is tied up, or growth is funded without adequate financing. Cash flow forecasting reveals these gaps before they become crises.
How much cash reserve should a small business keep?
The SBA recommends 3-6 months of operating expenses as a cash reserve. Service businesses can often manage with 3 months, while retail, restaurants, and seasonal businesses should target 6-9 months due to inventory requirements and revenue variability.
What is the difference between cash flow and profit?
Profit = Revenue - Expenses (accounting concept). Cash flow = Cash in - Cash out (timing-based). You can be profitable but cash-negative if customers pay 60 days late while you must pay suppliers upfront. Cash flow forecasting accounts for actual payment timing.
How do I handle seasonal revenue in a cash flow forecast?
Use the seasonal adjustment feature in this calculator. Enter the percentage of your average revenue expected each month (e.g., 150% for peak months, 60% for slow months). The calculator will apply these factors to your base inflows while keeping outflows at their base level.
What should I do if my cash flow forecast shows a negative balance?
Immediate options: (1) Accelerate collections — offer early payment discounts, tighten payment terms. (2) Delay non-critical purchases. (3) Arrange a line of credit before you need it — banks will not lend to businesses already in crisis. (4) Reduce fixed costs. Plan financing 2-3 months before the projected shortfall.
Related Calculators
Explore More Business Data
Ground your cash flow projections in real-world data from federal primary sources.