Back to prompts
Netsuite Cash Flow Report
Generates a comprehensive Cash Flow Analysis
Latest Model Recommendation
Sonnet 4.5
Latest Use Case
Financial Analysis
Prompt
Version 2 · Updated 10/8/2025, 1:10:20 PM
Generates a comprehensive Cash Flow Analysis
Analyze the cash flow of [Company Name] based on the following data: **Cash Flow Statement Data:** [Insert cash flow statement data here - Operating, Investing, and Financing activities] **Time Period:** [Specify period - e.g., Q1 2024, FY 2023, etc.] **Additional Context (if available):** - Industry: [Industry sector] - Company size: [Revenue range, employee count] - Business model: [Brief description] Please provide a comprehensive cash flow analysis covering: ## 1. Operating Cash Flow Analysis - Assess the quality of operating cash flow - Compare operating cash flow to net income (quality of earnings) - Identify trends in working capital changes - Evaluate cash conversion efficiency - Flag any concerning patterns in receivables, inventory, or payables ## 2. Free Cash Flow Assessment - Calculate free cash flow (Operating CF - CapEx) - Evaluate sustainability of free cash flow generation - Assess the company's ability to fund growth internally - Compare to industry benchmarks if possible ## 3. Liquidity Analysis - Evaluate short-term liquidity position - Assess cash burn rate (if negative) - Calculate cash runway (if applicable) - Identify potential liquidity risks ## 4. Capital Allocation Review - Analyze investing activities (CapEx, acquisitions, investments) - Evaluate financing decisions (debt, equity, dividends) - Assess management's capital allocation priorities - Comment on dividend sustainability (if applicable) ## 5. Red Flags and Strengths - Identify any warning signs in the cash flow patterns - Highlight positive indicators - Note any unusual or one-time items affecting cash flow ## 6. Key Metrics Calculate and interpret: - Operating Cash Flow Margin (OCF/Revenue) - Cash Flow to Debt Ratio - Cash Flow Coverage Ratios - Days Sales Outstanding (DSO), Days Inventory Outstanding (DIO), Days Payables Outstanding (DPO) - Cash Conversion Cycle ## 7. Recommendations - Provide 3-5 actionable recommendations for improving cash flow - Suggest areas requiring immediate attention - Identify opportunities for optimization ## 8. Executive Summary Provide a brief 3-4 sentence summary of the overall cash flow health and the most critical findings. **Output Format:** Please structure your response with clear headers and bullet points for readability. Use specific numbers and percentages where relevant.
Model
Sonnet 4.5
Use case
Financial Analysis