13-Week Cash Flow Forecast for Seasonal Businesses
The essential weekly cash flow forecasting tool for managing seasonal businesses. Build forecasts that extend through your complete seasonal cycle.
Construction
26 weeks (one full season in cold climates)
Retail
52 weeks (full annual cycle)
Agriculture
52 weeks (planting through harvest)
Tourism
26-52 weeks depending on seasonality type
Key Takeaways
- •For seasonal businesses, 13-week forecasts must extend through your full seasonal cycle, not just 13 weeks
- •Update weekly and track forecast vs. actual to improve accuracy over time
- •Build three scenarios (optimistic, expected, pessimistic) for each forecast period
- •Set specific cash balance triggers that initiate predetermined actions
- •Use forecast to plan reserve builds and credit facility draws proactively
The 13-week cash flow forecast is the essential treasury management tool for any business. But for seasonal businesses, a standard 13-week forecast isn't enough—you need visibility through your complete seasonal cycle, which may span 18 months or more.
As part of our seasonal business finance guides, this article covers how to build and use 13-week forecasts specifically adapted for seasonal businesses.
Why Standard 13-Week Isn't Enough
A traditional 13-week forecast covers roughly three months. For seasonal businesses, this may only capture part of your peak or slow season—not the full picture.
The Seasonal 13-Week Forecast
For seasonal businesses, the forecast should cover enough weeks to show your complete operating cycle. This might be 26, 39, or even 52 weeks.
Construction (cold climate): 26 weeks (cover one full season)
Retail: 52 weeks (full annual cycle)
Agriculture: 52 weeks (planting through harvest)
Tourism: 26-52 weeks depending on seasonality type
The Key Insight
The goal isn't just to see 13 weeks ahead—it's to see far enough to know whether you'll need credit facilities, when you can build reserves, and whether you'll have surplus cash to deploy.
Building the Seasonal Forecast
A seasonal forecast has the same structure as any 13-week forecast, but with adjustments for known seasonal patterns.
Forecast Structure
Seasonal Adjustments
Unlike a standard business, you must adjust each line item for expected seasonal variation:
- Revenue: Use historical patterns adjusted for trends. If Q4 represents 40% of revenue, ensure weekly forecasts reflect this.
- Payroll: Seasonal businesses often have different staffing levels by season. Build payroll on expected headcount.
- Inventory: For retail and wholesale, inventory builds in anticipation of seasonal sales. Plan purchases to match.
- One-time expenses: Insurance premiums, property taxes, annual contracts—these hit at specific times. Build into the right weeks.
Scenario Planning
Never forecast a single number. Build three scenarios to understand your range of outcomes and plan accordingly.
| Scenario | Revenue Assumption | Expense Assumption | Use Case |
|---|---|---|---|
| Optimistic | 115% of historical average | 100% of planned | Capital allocation, bonuses |
| Expected | 100% of historical average | 100% of planned | Operating baseline |
| Pessimistic | 80% of historical average | 90% (can cut) | Contingency planning |
What to Do With Scenarios
If All Scenarios Are Positive
Great position. Plan for reserve building, debt paydown, or strategic investments.
If Expected Is Positive But Pessimistic Is Negative
You have a cushion but need contingency plans. Pre-arrange credit facilities. Identify discretionary costs that can be cut.
If Even Optimistic Is Negative
Urgent action needed. Draw on credit facilities immediately. Consider emergency cost reductions. Talk to bankers before you need money.
Setting Action Triggers
The most effective seasonal forecasts include predetermined triggers—specific cash balances that initiate specific actions. This removes emotion from difficult decisions.
Example Trigger Matrix
Green (>$300K): Normal operations. Build reserves at 10% of revenue.
Yellow ($200K-$300K): Pause discretionary spending. Suspend non-essential hiring.
Orange ($100K-$200K): Draw on line of credit. Freeze all capital expenditures.
Red (<$100K): Emergency measures. Reduce payroll (Furlough? Reduced hours?).
Critical: Engage banker immediately. Discuss additional financing.
Why Triggers Work
When cash is tight, emotions run high. Having predetermined triggers means you don't have to make difficult decisions under stress. You've already decided what to do—now you're just executing the plan.
Tracking and Improving Accuracy
The value of forecasting improves dramatically when you track accuracy and learn from variance.
Weekly Process
- Update weekly: Refresh the forecast every week with actual results and new information.
- Compare to actual: Review last week's forecast vs. actual. Understand variance.
- Adjust assumptions: If revenue consistently comes in 10% below forecast, adjust future assumptions.
- Document learnings: Track why forecasts were wrong. This builds institutional knowledge.
Accuracy Benchmarks
Week 1 forecast: Should be within 5% of actual
Week 4 forecast: Should be within 10% of actual
Week 13 forecast: Should be within 15% of actual
Seasonal businesses may have more variance due to factors outside their control (weather, market prices). Adjust expectations accordingly.
The Most Important Metric
Track cash at week 52 (or whatever your cycle length). This shows your true seasonal position. If you consistently run low at the same point each year, you know exactly where to focus planning efforts.
Tools and Templates
You don't need expensive software to build effective seasonal forecasts. A well-structured spreadsheet works for most businesses.
Spreadsheet Approach
- • Week-by-week columns (extend to 52+)
- • Separate sections for receipts, disbursements
- • Scenario tabs (optimistic, expected, pessimistic)
- • Conditional formatting for triggers
- • Charts showing projected cash position
Software Solutions
- • Excel with integrated forecasting
- • Float (cash flow forecasting)
- • Agicap (SMB cash flow)
- • Cashforce (treasury management)
- • Treasury management systems (enterprise)
Most businesses with $5-50M revenue can manage effectively with a well-built spreadsheet. Add software when the time investment in spreadsheet maintenance exceeds the cost of automation.
Related Resources
Seasonal Business Finance
Complete guide to seasonal cash management
13-Week Cash Forecast
General 13-week forecasting guide
Construction Cash Flow
Industry-specific application
Credit Facilities
Lines of credit for seasonal needs
Need Help Building Seasonal Forecasts?
Eagle Rock CFO helps seasonal businesses build and maintain cash flow forecasts that provide real visibility through seasonal cycles. Let's discuss your forecasting challenges.