prompt

Cash Flow Forecast Helper

Builds a simple month-by-month cash flow forecast scaffold from inflows and outflows.

VettedUpdated June 2026
The prompt
You are a finance assistant. Build a simple month-by-month cash flow forecast from the inputs below.

Inputs:
- Starting cash balance: {{starting_cash}}
- Expected inflows (source + timing): {{inflows}}
- Expected outflows (item + timing): {{outflows}}
- Forecast horizon: {{horizon}} (e.g. 6 months)

Produce:
1. A month-by-month table: opening balance, total inflows, total outflows, net change, closing balance \u2014 carry the closing balance into next month's opening.
2. Show the arithmetic so it's auditable.
3. Flag any month where closing balance goes negative (a cash gap) and by how much.
4. A one-line read: tightest month and rough runway.
5. Assumptions list \u2014 anything you treated as fixed or estimated.

Rules: do the math and chain the balances correctly; flag missing/uncertain timing in [brackets] rather than guessing; treat this as a planning scaffold, not a guarantee. Note: this is a planning tool, not financial advice.
Did it work? Rate this prompt

Variables

{{starting_cash}}Starting cash
{{inflows}}Expected inflows
{{outflows}}Expected outflows
{{horizon}}Forecast horizon

Example output

Starting cash: 10,000. Horizon: 3 months. Inflows: 6,000/mo. Outflows: 7,500/mo, plus a 4,000 tax payment in month 2. | Month | Opening | Inflows | Outflows | Net | Closing | |---|---|---|---|---|---| | 1 | 10,000 | 6,000 | 7,500 | -1,500 | 8,500 | | 2 | 8,500 | 6,000 | 11,500 | -5,500 | 3,000 | | 3 | 3,000 | 6,000 | 7,500 | -1,500 | 1,500 | No month goes negative, but month 2 is the tightest (closing 3,000 after the tax payment). At a steady -1,500/mo burn, runway from month 3's 1,500 is about one more month before a gap. Assumptions: inflows flat at 6,000; the 4,000 tax hits month 2; no financing. Validate the tax timing \u2014 if it slips to month 1, month 1 closes much lower. This is a planning tool, not financial advice.

Details

Author

AI Khazna

License

Security

Vetted

Type

prompt

Related assets

More curated picks in Finance & Accounting.

Audit before you install

Run any source through our checks - AI visibility, security, performance, and stack detection.

More in Finance & Accounting