Cash Flow Forecast Calculator
See where your cash position will be in 6, 12, or 24 months based on real numbers.
What Is a Cash Flow Forecast?
Most businesses fail because they run out of cash, not because they are unprofitable. A cash flow forecast takes your current revenue and expenses, applies a growth rate, and shows you month by month where you will stand over 6, 12, or 24 months. You will see your projected monthly cash flow at the end of the period, your cumulative surplus or deficit, when you hit breakeven, and your average monthly surplus. This is the single most useful planning tool you can build. It tells you when you will need financing, how much you will need, and when you can pay it back. SBA and bank lenders routinely require 12-24 month projections with loan applications. A realistic forecast proves you can carry new debt without choking the business.
How to Use This Calculator
Enter Monthly Revenue
Use your current average monthly revenue. If your business is seasonal, a trailing 3-month average gives you a more honest starting point than any single month.
Enter Monthly Expenses
Include everything: payroll, rent, utilities, inventory/COGS, debt payments, insurance, marketing, and all other operating costs. Do not leave anything out or the forecast is useless.
Set Your Growth Rate
Pick a monthly growth rate, and be honest. Lenders will laugh at aggressive projections. For most established businesses, 2-5% monthly growth is realistic. If you are declining, enter a negative number.
Choose Projection Period
6 months for near-term planning, 12 months for annual budgeting, 24 months for long-term debt service analysis. Lenders usually want 12 or 24.
Analyze the Results
If the cumulative number is negative, you will need outside capital to cover the gap. The breakeven month tells you when the business starts sustaining itself at the growth rate you entered.
Key Concepts
Growth Rate Sensitivity
Tiny differences in growth rate blow up over time. 2% monthly compounds to 27% annually. 5% monthly compounds to 80% annually. Very few businesses sustain above 5% monthly for more than a quarter -- do not kid yourself.
Cash Flow vs. Profit
Profit and cash flow are different animals. You can show a profit on paper and still be cash-negative because customers pay late, inventory eats capital, or debt payments outrun what you are actually collecting.
Expense Scaling
Some costs scale with revenue (COGS, commissions) and others stay flat (rent, insurance). This calculator holds expenses constant. If you want more precision, break out your fixed vs. variable costs and adjust accordingly.
Seasonal Adjustments
This model runs a straight line -- it does not factor in seasonal ups and downs. If your business is seasonal, run separate forecasts for peak and off-peak months so you know when your working capital needs spike.
Expert Insights
Run three scenarios, not one: optimistic, realistic, and pessimistic. Then size your financing needs off the pessimistic case. If you can survive the downside, the upside takes care of itself.
When you hand a forecast to a lender, back every assumption with data: historical growth rate, signed contracts, pipeline value, industry benchmarks. "We think we can grow 5% monthly" gets ignored. "We have averaged 4.2% monthly over 18 months with a signed contract adding $15K/month in Q2" gets funded.
Keep debt payments under 20% of projected monthly cash flow at every point in the forecast. If they creep above that, either the repayment term is too short or you are borrowing more than the business can handle.
Frequently Asked Questions
This calculator provides estimates for educational purposes only. Actual results depend on your specific business financials, lender terms, and market conditions. Consult a qualified financial advisor before making major business financing decisions.
Run These Numbers Too
Working Capital Calculator
Check whether your business has enough cash to cover what's due in the next 12 months.
Business Debt-to-Income Ratio Calculator
See where your business stands with lenders before you apply for anything.
Business Loan Payment Calculator
See your monthly payment, total interest, and what a business term loan will really cost you.
Plan Your Business Financing
Use your forecast to compare financing options that match your cash flow timeline.
Compare Financing Options