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