prompt
Cash Flow Forecast Helper
Builds a simple month-by-month cash flow forecast scaffold from inflows and outflows.
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.
Variables
{{starting_cash}}Starting cash{{inflows}}Expected inflows{{outflows}}Expected outflows{{horizon}}Forecast horizonExample 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.
Calculates monthly burn rate and cash runway from balances and spend. Educational, not financial advice.
Builds a simple month-by-month cash flow forecast from your inputs.
Turns P&L or financial figures into a plain-language summary stakeholders can read.
Builds a break-even analysis scaffold from fixed costs, variable costs, and price. Educational, not financial advice.
Builds a simple revenue and cost model with assumptions.
Builds a clear monthly or project budget from income and expenses, with a summary.
Audit before you install
Run any source through our checks - AI visibility, security, performance, and stack detection.
Automated Web Security Scan
security
PageSpeed Analyzer
performance
AI Content Quality Test
arabic content
AI Agent / MCP Server Tester
ai testing
Site Stack Detector
migration
AI SEO / AEO / GEO Audit
ai visibility
llms.txt Generator
ai visibility
Readability Score
arabic content
Schema / JSON-LD Builder
ai visibility
AI Cost Calculator
ai testing
Headline Analyzer
arabic content