Published August 2026 · 8-minute read · Category: Business & Finance
Cash flow kills more small businesses than lack of profit ever does. A profitable company can still go under if it runs out of cash at the wrong moment — payroll is due, a supplier needs payment, and the bank account is empty. A cash flow forecast Excel template is the simplest tool to predict these gaps weeks or months before they happen.
This guide covers everything you need: what a cash flow forecast is, how to build one in Excel (or skip the work and use a ready-made template), how to calculate break-even and runway, and what to look for when choosing a template. By the end, you'll have a clear system for knowing exactly when money comes in, when it goes out, and whether your business can survive the next 12 months.
A cash flow forecast Excel template is a pre-built spreadsheet that projects your business's cash inflows and outflows over a set period (usually 12 months). It automates calculations for revenue, expenses, net cash flow, cumulative balance, and runway so you can predict cash shortages before they happen. A good template includes a dashboard, revenue and expense forecast tabs, a cash flow statement, break-even analysis, and a runway calculator.
To create a cash flow forecast in Excel, set up a 12-month grid with rows for opening balance, cash inflows (sales, investments, loans), cash outflows (fixed and variable expenses), net cash flow, and closing balance. Use formulas to carry the closing balance forward as the next month's opening balance. Add charts for net cash flow and cumulative cash. A ready-made template like the Cash Flow Forecast & Break-Even Calculator handles all of this automatically.
A quality cash flow forecast Excel template costs between $10 and $30 USD for a one-time purchase. The Cash Flow Forecast & Break-Even Calculator costs $12 USD and includes 8 tabs, 6 auto-updating charts, a break-even analysis with a sensitivity table, and a runway calculator. Free templates exist but typically lack break-even analysis, scenario planning, and visual dashboards.
The best cash flow forecast Excel template for small businesses is the Cash Flow Forecast & Break-Even Calculator because it combines an 8-tab structure with auto-calculating formulas, a visual dashboard, break-even analysis, a runway calculator, and a 3-scenario planner (best/base/worst case). It works in Excel, Google Sheets, and LibreOffice Calc with no macros or plugins required.
To calculate break-even point in Excel, divide your total fixed costs by your contribution margin (selling price per unit minus variable cost per unit). The result is the number of units you must sell to cover all costs. A good template also calculates break-even revenue (break-even units × selling price) and margin of safety (actual sales minus break-even sales). The Cash Flow Forecast & Break-Even Calculator includes all of these plus a 30-cell sensitivity table.
Cash runway is the number of months your business can survive on its current cash balance if expenses continue at the current rate. Calculate it by dividing your current cash balance by your monthly burn rate (monthly expenses minus monthly revenue). A good template computes this automatically and shows an 18-month depletion timeline.
Yes. A well-built cash flow forecast Excel template in .xlsx format opens directly in Google Sheets with all formulas, charts, and conditional formatting intact. The Cash Flow Forecast & Break-Even Calculator uses only standard Excel formulas (no macros), so it works seamlessly in Google Sheets, LibreOffice Calc, and Apple Numbers.
A cash flow forecast is a financial projection that estimates when money will enter and leave your business over a specific period. Unlike a profit and loss statement (which shows whether you're profitable on paper), a cash flow forecast shows whether you'll actually have cash in the bank when bills are due.
The difference matters. If you invoice a client $10,000 in March but they pay in May, your P&L shows revenue in March — but your bank account is empty until May. A cash flow forecast accounts for that timing gap, which is the single most common reason profitable small businesses fail.
A cash flow forecast Excel template automates this process. Instead of manually building formulas for opening balances, closing balances, and cumulative cash, the template does the math for you. You enter your expected revenue and expenses; the spreadsheet handles the rest.
According to a U.S. Bank study, 82% of small business failures are linked to poor cash management. The businesses that survive aren't necessarily more profitable — they're better at predicting when cash will be tight and acting before it becomes a crisis.
Here's what a cash flow forecast tells you that a P&L can't:
The best time to fix a cash flow problem is 6 months before it happens. A forecast gives you that window.
If you want to understand how a cash flow forecast works under the hood, here's how to build one from scratch. (If you'd rather skip the setup, download the ready-made template and jump to the next section.)
Create a table with months across the top (Jan through Dec) and the following rows down the left side:
List every revenue stream your business has. For each, estimate monthly income based on historical data, signed contracts, or conservative growth assumptions. Be realistic — overestimating revenue is the most common forecasting mistake.
A good template separates revenue into categories (e.g., product sales, services, recurring subscriptions) so you can see which streams are growing and which are shrinking.
Split expenses into two categories:
This split matters because it feeds directly into your break-even analysis. Fixed costs don't change with sales; variable costs do.
The core formula is simple:
Closing Balance = Opening Balance + (Total Inflows − Total Outflows)
Then carry the closing balance to the next month:
Next Month's Opening Balance = This Month's Closing Balance
This creates a running cumulative cash position that shows your bank balance projection across all 12 months.
Two charts make the forecast instantly readable:
This is where most DIY templates stop — and where a professional template adds real value. Calculate:
Not all templates are created equal. Here's what to look for when choosing a cash flow forecast Excel template for your small business:
| Feature | Free Templates | Basic Paid ($5-10) | Premium ($12-30) |
|---|---|---|---|
| 12-month projection | ✅ Sometimes | ✅ Yes | ✅ Yes |
| Visual dashboard with charts | ❌ Rarely | ⚠️ Basic | ✅ Full dashboard |
| Break-even analysis | ❌ No | ⚠️ Basic formula | ✅ With sensitivity table |
| Runway / burn rate calculator | ❌ No | ❌ No | ✅ Yes |
| Scenario planning (best/base/worst) | ❌ No | ❌ No | ✅ Yes |
| Pre-loaded sample data | ❌ No | ⚠️ Minimal | ✅ Yes |
| Conditional formatting | ❌ No | ⚠️ Limited | ✅ Full (color-coded) |
| Instructions tab | ❌ No | ⚠️ Sometimes | ✅ Yes |
| Works in Google Sheets | ✅ Usually | ✅ Yes | ✅ Yes |
The gap between a free template and a $12 premium template is significant. Free templates give you a grid and basic formulas. A premium template gives you the complete decision-making system: break-even, runway, scenarios, and a visual dashboard that turns numbers into actionable insight.
For small businesses that want a complete financial planning tool without building it from scratch, the Cash Flow Forecast & Break-Even Calculator is the best option. It's an 8-tab Excel template that covers everything described above — plus features most templates don't include.
The template comes pre-loaded with 12 months of realistic sample data (5 revenue streams, 10 expense categories) so you can see exactly how it works before entering your own numbers. It includes 6 auto-updating charts and uses only standard Excel formulas — no macros, no plugins, no external dependencies.
8 tabs · 6 charts · break-even + runway + scenarios · $12 USD one-time
Download from Gumroad →Break-even analysis is the most underused tool in small business finance. It tells you the exact number of units (or dollars) you need to sell to cover all your costs. Below that number, you're losing money. Above it, you're profitable.
Break-even Units = Fixed Costs ÷ Contribution Margin
Where Contribution Margin = Selling Price − Variable Cost per Unit
Say you run a small e-commerce business:
Now you know: if you're getting fewer than 114 orders a month, you're burning cash. If you're above 114, every additional order adds $37 to your profit.
The Cash Flow Forecast & Break-Even Calculator includes a 30-cell sensitivity table that shows break-even at different price points and variable cost levels — so you can model "what if I raise prices by 10%?" or "what if my supplier costs go up 15%?" in seconds.
Runway is the metric that keeps founders and small business owners awake at night — in a good way. It tells you exactly how long your business can survive if revenue stops tomorrow.
Runway (months) = Current Cash Balance ÷ Monthly Burn Rate
Where Monthly Burn Rate = Monthly Expenses − Monthly Revenue
If you have $48,000 in the bank, monthly expenses of $9,000, and monthly revenue of $3,000:
This means you have 8 months to either increase revenue or cut costs before the money runs out. The Cash Flow Forecast & Break-Even Calculator's runway tab shows this automatically, along with an 18-month depletion timeline with visual progress bars that make the urgency obvious at a glance.
If your runway is under 6 months, you need a plan today — not next quarter. A forecast shows you this months before it becomes an emergency.
A cash flow forecast is a living document. Here's a review schedule that works for most small businesses:
You can find free cash flow forecast templates online. They'll give you a basic grid and some formulas. But here's what you'll spend hours building yourself if you go the free route:
That's 6-9 hours of work. At even $25/hour, that's $150-225 of your time to build what a $12 template already provides. The Cash Flow Forecast & Break-Even Calculator is ready to use the moment you download it.
Know your cash position, break-even point, and runway — before it's too late.
Get the Template — $12 →A cash flow forecast Excel template is not a luxury — it's a survival tool. The businesses that thrive in 2026 aren't the ones with the best products or the most customers. They're the ones who know their numbers, predict cash gaps before they happen, and make decisions based on data instead of hope.
The Cash Flow Forecast & Break-Even Calculator gives you everything you need in one file: a 12-month forecast, break-even analysis, runway calculator, scenario planner, and visual dashboard. It's $12, works in Excel and Google Sheets, and is ready to use the moment you download it.
Don't wait until you're scrambling to cover payroll. Get the template now and know exactly where your business stands.