Cash Flow Forecast Template
90-day cash flow projection template. Predict future cash position and avoid cash crunches.
What's Included:
- 90-day projection grid organized by week with auto-summing totals
- Scenario toggle for best-case, expected, and worst-case outcomes
- Color-coded conditional formatting that flags negative cash weeks
- Summary dashboard with minimum cash, average weekly burn, and runway
Available Formats:
Download Free Template
Enter your email to download this template instantly. We'll also send you tips on financial management.
A 90-day cash flow projection gives you enough visibility to make proactive financial decisions without the guesswork. This template is designed for small business owners who need a medium-term view—long enough to plan for seasonal dips or large upcoming expenses, but short enough that projections remain reliable.
The built-in scenario analysis lets you stress-test your cash position. Toggle between best-case and worst-case to see how sensitive your runway is to changes in revenue timing. This is especially valuable before taking on new debt, hiring staff, or committing to a large purchase.
How to Use This Template
Set Your Forecast Start Date
Enter today's date and your current cash-on-hand in the setup section; the template auto-populates all weekly dates for the next 90 days.
Input Revenue and Expense Assumptions
Fill in expected customer receipts and fixed/variable costs for each week. Use the scenario dropdown to toggle between optimistic and pessimistic assumptions.
Analyze the Dashboard
Switch to the Summary tab to see your projected minimum cash balance, average weekly burn rate, and estimated runway in weeks.
Frequently Asked Questions
How far ahead should I forecast my cash flow?
For most small businesses, 90 days strikes the right balance between accuracy and planning horizon. Shorter forecasts miss upcoming obligations; longer ones rely on too many assumptions. Extend to 6 or 12 months only for strategic planning.
How do I handle uncertain revenue in my cash flow forecast?
Use the scenario toggle to create best-case and worst-case projections. For the expected scenario, only include revenue you have a high confidence of receiving—signed contracts, recurring subscriptions, or invoices already sent.
Related Financial Resources
Tired of manual spreadsheets?
FiscalInsights automates everything this template does—plus cash flow forecasting, expense categorization, and real-time insights.
Try FiscalInsights Free