Back to prompts

Netsuite Cash Flow Report

Generates a comprehensive Cash Flow Analysis

Fby freddy
Version 2
1 Follower
10/6/2025

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