Practical guide
Understanding small-business cash flow — sensitivity table
Everyday editorial team · GEOINNOVATION CO., LTD · Published · Updated
What this calculation is for
A business cash forecast tracks collected money rather than accounting profit. Receivables that have not been collected cannot pay this month’s bills simply because they were recognized as revenue.
How the method works
Opening cash changes each month by the entered receipts and recurring expenses. The named growth assumption changes the modeled receipts stream, and the lowest balance highlights a potential cash squeeze. The displayed model uses: Forecast cash balance by month from opening cash, collected receipts and recurring expenses.
A worked example
For an illustrative small-business cash flow scenario, use Available business cash: 45000 $; Monthly collected revenue: 28000 $; Monthly operating expenses: 24000 $; Expected monthly receivables: 6000 $; Expected monthly change in receipts: 0 %; Projection horizon: 12 months. The modeled projected cash after horizon is $165,000. These are example assumptions, not current prices, official benefit amounts or personalized advice.
Assumptions and real-world differences
Revenue and additional receivables should not contain the same payment twice. Inventory timing, tax, debt service, seasonality and delayed collections require explicit allowances outside a simplified constant-expense scenario. Taxes, inventory, debt, timing and seasonal receipts need separate estimates; not accounting advice.
Reading the available business cash sensitivity table
The tool evaluates the same model across a range of available business cash values while holding other assumptions constant. Choose a realistic low value, high value and number of points. Each row reports the same headline measure; the table is a set of conditional calculations, not a probability distribution or a forecast. Input-step rounding can make nearby rows equal.
Reproduce this tool’s example
These fixed example inputs are independent of edits you make above. Enter them in this tool to reproduce the result, then replace them with your own assumptions.
- Minimum available business cash
- 22,500 $
- Maximum available business cash
- 67,500 $
- Number of comparison points
- 5 points
- Monthly collected revenue
- 28,000 $
- Monthly operating expenses
- 24,000 $
- Expected monthly receivables
- 6,000 $
- Expected monthly change in receipts
- 0 %
- Projection horizon
- 12 months
Sensitivity analysis: 5 comparison points
Available business cash ranges from $22,500 to $67,500.
- Available business cash: $22,500: $142,500
- Available business cash: $34,000: $154,000
- Available business cash: $45,000: $165,000
Frequently asked questions
- Can a profitable business still run out of cash?
- Yes. Collection delays, inventory and debt payments can create a cash shortage even when reported profit is positive.
- Which inputs should I check before using this small-business cash flow estimate?
- Check available business cash, monthly collected revenue, monthly operating expenses, expected monthly receivables, expected monthly change in receipts, projection horizon. Match each field’s unit and time period, then compare the detailed rows rather than treating the headline alone as the complete answer.
- Does the most favorable row show the most likely outcome?
- No. The table assigns no likelihood to any row. It shows how the result responds to the chosen assumption, and you remain responsible for selecting a plausible range.