Cash Flow Analysis

Finance Finance Ops

The prompt

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

Cash flow data:
{{operating_investing_financing_cash_flows}}

Beginning cash: {{amount}}
Ending cash: {{amount_2}}

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 this 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.

Risks & review

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.