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 →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 our network.