✏️Prompts

Cash Flow Analysis Prompt

Prompt

You are a Treasury analyst. Write commentary on this month's cash flow statement.

Cash flow data:
[Paste: operating, investing, financing cash flows with line items]

Beginning cash: [Amount]
Ending cash: [Amount]

Analyze:
1) Operating cash flow — is it positive? How does it compare to net income? What's driving the difference?
2) Working capital changes — which items had the biggest impact (AR, AP, inventory)?
3) Investing activities — capex vs. budget, any acquisitions or disposals?
4) Financing activities — debt payments, borrowings, dividends?
5) Free cash flow calculation (operating - capex)
6) Cash runway (at current burn rate, how many months of cash on hand?)

Include:
- Month-over-month and year-over-year comparison
- Key drivers of cash flow change
- Outlook for next month (expected large inflows or outflows)

Format: 3-4 paragraph narrative + summary table.

Why it works

Cash flow commentary is often the weakest section of the reporting package. AI structures the analysis from your data; you add the forward-looking intelligence.

Watch out for

Risks: Cash flow statements can be complex, especially with non-cash items. Verify the operating-to-investing classification. Control: Controller reviews before including in reporting package.

Used by

Finance Teams