Step 1 — Historical Data (Last 3 Months)
Monthly Revenue & Expenses
Enter actuals for the last 3 months — oldest to most recent
3 Mo. Ago
2 Mo. Ago
Last Month
Revenue
$
$
$
Expenses
$
$
$
$
Step 2 — One-Time Events (optional)
Expected One-Time Inflows / Outflows
Big customer payment coming? Equipment purchase? Annual insurance bill? Add them here.
Add expected one-time cash movements within the next 6 months
Step 3 — Revenue Scenario
Apply a modifier to the projected revenue trend:
Ending Cash (Mo. 6)
—
vs. today's balance
—
Lowest Cash Month
—
—
6-Mo. Total Revenue
—
—
—
6-Mo. Total Expenses
—
—
—
6-Month Cash Flow Projection
Linear trend extrapolated from 3-month actuals
Cash Balance
Revenue
Expenses
Danger Zone
Month-by-Month Breakdown
Projected figures based on trend extrapolation
| Month | Revenue | Expenses | Net Cash Flow | One-Time Events | Cash Balance |
|---|