Cash Flow Forecast Calculator

How to Use This Tool

Enter your starting cash balance and monthly financial projections. For COGS and taxes, you can enter either a percentage of sales or a fixed dollar amount. Select a projection period (3-24 months) and seasonality adjustment if your business has regular fluctuations. Click "Calculate Forecast" to see month-by-month cash flow, cumulative balance, and identify potential shortfalls. Use the "Copy Results" button to export your forecast for sharing or record-keeping.

Formula and Logic

The calculator uses standard cash flow forecasting methodology:

• Monthly Sales: Your projected revenue before returns/discounts. Adjusted by seasonality factor.
• COGS: Direct costs (materials, production, direct labor). If entered as percentage, calculated as % of monthly sales. If fixed, uses the exact amount each month.
• Gross Profit = Sales - COGS
• Operating Expenses: Fixed monthly overhead (rent, salaries, marketing, utilities).
• Loan Payments: Monthly principal + interest on business loans.
• Operating Profit (EBIT) = Gross Profit - Operating Expenses - Loan Payments
• Taxes: Calculated on positive operating profit. If percentage, applied to profit; if fixed, added monthly.
• Net Cash Flow = Operating Profit - Taxes
• Cumulative Balance = Starting Balance + sum of all previous net cash flows

Practical Notes

For E-commerce & Retail: Monitor your gross margin (Sales - COGS). Aim for at least 40-50% gross margin in most retail sectors. Factor in payment processing fees (2-3% of sales) in your COGS or operating expenses. Account for chargeback reserves (0.5-1% of sales) if you have high return rates.

For Service Businesses: COGS is often direct labor costs. Track utilization rates (billable hours vs. total hours). If you have project-based revenue, consider using an average monthly figure but run scenarios for best/worst case months.

For Trade & Construction: Include materials, subcontractor costs, and equipment rentals in COGS. Account for progress billing delays—customers may pay net 30 or net 60, so adjust your starting cash to cover the gap. Consider retainage (5-10% withheld on contracts) as a separate line item.

Seasonality: The seasonality presets are based on typical retail patterns (Q4 peak, Q1 low). Adjust manually if your business differs (e.g., tourism peaks in summer, agriculture in harvest seasons). For precise forecasting, input actual monthly sales variations instead of using the preset.

Cash Buffer: Maintain at least 3-6 months of operating expenses in reserve. If your forecast shows negative cumulative balance, plan to secure a line of credit before the shortfall occurs. Lenders typically require 6-12 months of positive cash flow history.

Why This Tool Is Useful

Cash flow problems cause 82% of small business failures (U.S. Bank study). This tool helps you anticipate liquidity issues months in advance, giving you time to arrange financing, negotiate payment terms with suppliers, or adjust spending. It also helps with strategic planning—knowing when you'll have surplus cash allows you to time equipment purchases, inventory builds, or expansion initiatives. For e-commerce sellers, it prevents stockouts during peak seasons by ensuring you have cash to purchase inventory. For service businesses, it helps manage contractor payments and client billing cycles.

Frequently Asked Questions

How do I account for irregular expenses like annual insurance or quarterly tax payments?

Enter the monthly equivalent in operating expenses. For example, if your annual insurance is $12,000, enter $1,000/month. For quarterly taxes, divide the estimated annual amount by 12. Alternatively, use the "Other Monthly Cash Outflows" field for months when these occur, but this requires manual entry each month.

What's the difference between COGS as percentage vs. fixed amount?

Use percentage if your COGS scales directly with sales (e.g., retail: 60% of sales goes to inventory cost). Use fixed if COGS is relatively stable regardless of sales volume (e.g., salaried production staff, rent on production facility). Most manufacturers use a mix—variable costs as percentage, fixed costs as fixed amount. For accuracy, separate variable and fixed COGS and run two scenarios.

How do I factor in accounts receivable delays?

This tool assumes cash sales. If you have credit terms (net 30, net 60), adjust your starting cash balance downward by the amount of receivables that haven't been collected. Alternatively, reduce monthly sales by the percentage of sales that are on credit and add a separate "Collections" line in future months. For example, if 70% of sales are on net 30 terms, treat only 30% as cash sales in month 1, and add the 70% in month 2.

Additional Guidance

Scenario Planning: Run at least three scenarios—conservative (10-20% lower sales, 10% higher expenses), realistic (your best estimate), and optimistic (10-20% higher sales, 5% lower expenses). Compare the outcomes to understand your cash flow sensitivity.

Key Benchmarks:

• Operating Cash Flow Margin (Net Cash Flow / Sales): Aim for 10-20% in most businesses. Below 5% indicates high risk.
• Cash Conversion Cycle: Time between paying suppliers and receiving customer payments. Aim for less than 60 days. Longer cycles require more cash buffer.
• Current Ratio (Current Assets / Current Liabilities): Should be above 1.5. Below 1.0 signals liquidity problems.

Monthly Review: Update your forecast monthly with actual results. Variances will highlight areas where your assumptions were off—adjust future months accordingly. If actual sales are consistently below forecast, revise your sales assumptions downward. If expenses are higher, investigate cost drivers.

For Lenders: When applying for a loan, bring a 12-24 month cash flow forecast showing positive net cash flow and a healthy ending balance. Lenders look for consistent profitability and sufficient cash to cover debt service (loan payments). A common requirement is debt service coverage ratio (DSCR) > 1.2.