Skip to main content
skill CX Codex

sec-cash-flow-review — Claude Code skill: cash flow analysis

sec-cash-flow-review extracts cash flow data and working capital changes from SEC filings. Builds trends for operating, investing, and financing cash flows, calculates free cash flow, and evaluates liquidity.

MIT 266 installs ★ 132 updated 2026-06-05

Install into Claude Code · Skills CLI (Vercel) All methods and platforms ↓
npx skills add OctagonAI/skills --skill sec-cash-flow-review -a claude-code
Open on GitHub

What sec-cash-flow-review does

The skill operates through Octagon MCP: you provide a ticker and filing type (10-K or 10-Q), and it returns a breakdown of three cash flow categories — operating, investing, financing — plus working capital changes and metrics like cash conversion ratio. It calculates free cash flow (operating cash flow minus capital expenditures), cash conversion cycle, and liquidity runway in months.

Under the hood, it calls the octagon-agent tool with an English prompt, which routes the request among octagon-financials-agent, octagon-sec-agent, and octagon-web-search-agent. Octagon MCP must be configured beforehand. The skill returns tables of cash flow components (depreciation, taxes, receivables and payables changes, share buybacks, dividends) and quality flags: if operating cash flow trails net income for several quarters, it signals reporting quality concerns.

What it helps with

  • extract cash flow trends from a company's 10-Q or 10-K
  • calculate free cash flow over several quarters
  • break down working capital changes and cash conversion cycle
  • evaluate liquidity and cash runway in months
  • assess cash flow quality by comparing it to net income

Example prompts for the agent

  • Extract and analyze cash flow trends and working capital changes from NFLX's latest 10-Q
  • Calculate and analyze free cash flow trends for AAPL over the last 4 quarters
  • Evaluate TSLA's liquidity position and cash runway from the latest quarterly filing

How to install sec-cash-flow-review

1Skills CLI (Vercel)

npx skills add OctagonAI/skills --skill sec-cash-flow-review -a claude-code

2Manually: put the files in place

~/.claude/skills/sec-cash-flow-review/SKILL.md

Copy the whole skill folder; for one project use .claude/skills/sec-cash-flow-review/

Step by step, with commands for each platform: How to install skills in Claude Code: five ways

Questions about sec-cash-flow-review

How to install sec-cash-flow-review in Claude Code?

Run npx skills add OctagonAI/skills --skill sec-cash-flow-review -a claude-code, the skill file will appear in ~/.claude/skills/sec-cash-flow-review/SKILL.md.

What does sec-cash-flow-review do?

It extracts data from SEC filings for three cash flow categories (operating, investing, financing), calculates free cash flow, analyzes working capital changes, and evaluates company liquidity.

What does sec-cash-flow-review require to work?

Octagon MCP must be configured in the agent — the skill calls the octagon-agent tool, which routes requests to SEC data and financial agents.

Source text

SKILL.md · MIT
---
name: sec-cash-flow-review
description: Extract and analyze cash flow trends and working capital changes from SEC filings using Octagon MCP. Use when researching operating cash flow, investing activities, financing activities, free cash flow, liquidity, and working capital dynamics from 10-K and 10-Q filings.
---

# SEC Cash Flow Review

Extract and analyze cash flow trends and working capital changes from SEC filings for public companies using the Octagon MCP server.

## Prerequisites

Ensure Octagon MCP is configured in your AI agent (Cursor, Claude Desktop, Windsurf, etc.). See [references/mcp-setup.md](references/mcp-setup.md) for installation instructions.

## Workflow

### 1. Identify Analysis Parameters

Determine the following before querying:
- **Ticker**: Stock symbol (e.g., AAPL, MSFT, GOOGL)
- **Filing Type** (optional): 10-K (annual) or 10-Q (quarterly)
- **Focus Area** (optional): Operating, investing, financing, working capital

### 2. Execute Query via Octagon MCP

Use the `octagon-agent` tool with a natural language prompt:

```
Extract and analyze cash flow trends and working capital changes from <TICKER>'s latest 10-Q.
```

**MCP Call Format:**

```json
{
  "server": "octagon-mcp",
  "toolName": "octagon-agent",
  "arguments": {
    "prompt": "Extract and analyze cash flow trends and working capital changes from NFLX's latest 10-Q."
  }
}
```

### 3. Expected Output

The agent returns structured cash flow analysis including:

**Cash Flow Trends:**
- Operating Cash Flow: Increased 37.87% YoY
- Investing Cash Flow: -$2.08B (CapEx, investments)
- Financing Cash Flow: Mixed ($1.04B inflow, -$2.18B outflow)

**Working Capital Changes:**
- Change in Working Capital: -$456M
- Cash and Equivalents: Decreased $1.193B in 6 months

**Key Observations:**
- Operating cash flow growth outpaces investing/financing
- Working capital contraction from content investments
- Liquidity sufficient for 12+ months

**Data Sources**: octagon-financials-agent, octagon-sec-agent, octagon-web-search-agent

### 4. Interpret Results

See [references/interpreting-results.md](references/interpreting-results.md) for guidance on:
- Understanding cash flow components
- Evaluating cash flow quality
- Analyzing working capital trends
- Assessing liquidity position

## Example Queries

**Full Cash Flow Analysis:**
```
Extract and analyze cash flow trends and working capital changes from NFLX's latest 10-Q.
```

**Free Cash Flow Focus:**
```
Calculate and analyze free cash flow trends for AAPL over the last 4 quarters.
```

**Working Capital Deep Dive:**
```
Analyze working capital changes and cash conversion cycle for AMZN from the latest 10-K.
```

**Liquidity Assessment:**
```
Evaluate TSLA's liquidity position and cash runway from the latest quarterly filing.
```

**CapEx Analysis:**
```
Extract capital expenditure trends and investment priorities from GOOGL's cash flow statement.
```

**Financing Activities:**
```
Analyze debt repayments, share buybacks, and dividend payments from MSFT's latest 10-K cash flow.
```

## Cash Flow Statement Components

### Operating Activities

| Component | Description |
|-----------|-------------|
| Net Income | Starting point |
| Depreciation/Amortization | Non-cash add-back |
| Stock Compensation | Non-cash expense |
| Deferred Taxes | Timing differences |
| Working Capital Changes | Current asset/liability changes |
| Other Adjustments | Non-cash items |

### Investing Activities

| Component | Description |
|-----------|-------------|
| Capital Expenditures | Property, equipment purchases |
| Acquisitions | Business combinations |
| Investment Purchases | Securities bought |
| Investment Sales | Securities sold |
| Asset Dispositions | Property, equipment sales |

### Financing Activities

| Component | Description |
|-----------|-------------|
| Debt Issuance | Borrowings |
| Debt Repayment | Principal payments |
| Share Issuance | Stock offerings |
| Share Repurchases | Buybacks |
| Dividends | Shareholder distributions |

## Key Cash Flow Metrics

### Profitability vs. Cash

| Metric | Calculation | What It Shows |
|--------|-------------|---------------|
| Operating Cash Flow | From statement | Cash from operations |
| Free Cash Flow | OCF - CapEx | Cash after investment |
| FCF Margin | FCF / Revenue | Cash generation rate |
| Cash Conversion | OCF / Net Income | Earnings quality |

### Liquidity Metrics

| Metric | Calculation | What It Shows |
|--------|-------------|---------------|
| Cash Position | Cash + equivalents | Available liquidity |
| Cash Runway | Cash / Monthly Burn | Months of runway |
| Quick Ratio | (Cash + Receivables) / Current Liabilities | Short-term coverage |
| Current Ratio | Current Assets / Current Liabilities | Working capital |

### Investment Metrics

| Metric | Calculation | What It Shows |
|--------|-------------|---------------|
| CapEx Intensity | CapEx / Revenue | Investment level |
| CapEx / D&A | CapEx / Depreciation | Maintenance vs. growth |
| Acquisition Spend | From investing | M&A activity |
| Investment Returns | Sales / Purchases | Portfolio activity |

## Working Capital Analysis

### Components

| Component | Increase Means | Decrease Means |
|-----------|----------------|----------------|
| Accounts Receivable | Cash used | Cash provided |
| Inventory | Cash used | Cash provided |
| Prepaid Expenses | Cash used | Cash provided |
| Accounts Payable | Cash provided | Cash used |
| Accrued Liabilities | Cash provided | Cash used |
| Deferred Revenue | Cash provided | Cash used |

### Cash Conversion Cycle

| Metric | Calculation |
|--------|-------------|
| Days Sales Outstanding | (AR / Revenue) × 365 |
| Days Inventory Outstanding | (Inventory / COGS) × 365 |
| Days Payables Outstanding | (AP / COGS) × 365 |
| Cash Conversion Cycle | DSO + DIO - DPO |

### Working Capital Trends

| Trend | Interpretation |
|-------|----------------|
| Declining CCC | Improved efficiency |
| Rising CCC | Cash tied up longer |
| Negative CCC | Customer-funded model |
| Stable CCC | Consistent operations |

## Cash Flow Quality Assessment

### Quality Indicators

| Factor | High Quality | Low Quality |
|--------|-------------|-------------|
| OCF vs. Net Income | OCF > NI | OCF < NI |
| Sustainability | Recurring sources | One-time items |
| Working Capital | Stable trends | Erratic changes |
| Non-Cash Charges | Reasonable D&A | Excessive add-backs |

### Red Flags

1. **OCF < Net Income persistently** - Earnings quality concern
2. **Negative FCF** - Cash consumption
3. **Rising receivables** - Collection issues
4. **Inventory buildup** - Demand weakness
5. **Declining payables** - Supplier pressure
6. **Heavy stock compensation** - Dilution concern

## Trend Analysis

### Period-over-Period

| Metric | Prior Period | Current | Change |
|--------|--------------|---------|--------|
| Operating CF | | | |
| Investing CF | | | |
| Financing CF | | | |
| Free Cash Flow | | | |
| Working Capital | | | |

### Multi-Year Trends

Track over time:
- OCF growth trajectory
- FCF conversion rate
- Working capital efficiency
- CapEx patterns
- Capital return trends

## Liquidity Assessment

### Cash Position Analysis

| Factor | Assessment |
|--------|------------|
| Absolute Level | Adequate for operations |
| Trend | Growing or declining |
| vs. Obligations | Coverage of debt, commitments |
| vs. Investment | Ability to fund growth |

### Runway Calculation

| Scenario | Calculation |
|----------|-------------|
| Conservative | Cash / Average Monthly Burn |
| Including Revolver | (Cash + Available Credit) / Burn |
| Stress | Cash / Peak Monthly Burn |

### Covenant Considerations

| Factor | What to Check |
|--------|---------------|
| Debt/EBITDA | Leverage limits |
| Interest Coverage | Payment ability |
| Minimum Cash | Required balances |
| CapEx Limits | Investment constraints |

## Financing Activity Analysis

### Capital Structure Changes

| Activity | Implication |
|----------|-------------|
| Debt Issuance | Leverage increase |
| Debt Repayment | Deleveraging |
| Equity Issuance | Dilution, capital raise |
| Buybacks | Return to shareholders |
| Dividends | Cash distribution |

### Capital Allocation Assessment

| Priority | What It Signals |
|----------|-----------------|
| Heavy CapEx | Growth investment |
| Heavy Buybacks | Mature, returning cash |
| Debt Focus | Deleveraging priority |
| M&A | External growth |
| Balanced | Diversified approach |

## Analysis Tips

1. **Compare OCF to earnings**: Divergence signals quality issues.

2. **Track FCF trends**: More important than net income.

3. **Analyze working capital drivers**: Understand component changes.

4. **Consider seasonality**: Quarterly patterns affect cash flow.

5. **Read footnotes**: Capital commitments disclosed there.

6. **Check management discussion**: Cash flow commentary in MD&A.

## Use Cases

- **Investment analysis**: Assess cash generation quality
- **Credit analysis**: Evaluate debt service capability
- **Valuation**: FCF-based models
- **Liquidity monitoring**: Track cash position
- **Working capital efficiency**: Operational assessment

© OctagonAI · MIT · OctagonAI/skills

Similar skills

All skills for Finance and business →

From the same set67

The whole set →
income-statement-growth income-statement-growth — a skill for Claude Code, Codex, Cursor and other agents that pulls year-over-year growth rates for key income statement lines via Octagon MCP. CX Codex +1 269installs industry-pe-ratios industry-pe-ratios is a Claude Code skill that fetches P/E ratios by industry and exchange. It runs for peer valuation comparisons and sub-sector research. CX Codex +1 267installs earnings-conf-call-sentiment earnings-conf-call-sentiment evaluates management tone, confidence, and forward-looking statements during earnings conference calls. Works with company tickers to spot shifts across quarters. CX Codex +1 267installs industry-performance-snapshot industry-performance-snapshot is a Claude Code skill that retrieves daily industry figures for an exchange through Octagon MCP. It activates for requests about price moves, average changes, or industry trends. CX Codex +1 267installs sec-business-desc-analysis sec-business-desc-analysis — a skill for Claude Code, Codex, Cursor, GitHub Copilot, and Gemini CLI that pulls business descriptions and competitive landscape data from SEC filings via Octagon MCP. CX Codex +1 266installs balance-sheet-growth balance-sheet-growth fetches year-over-year changes for major balance-sheet lines. Use it to examine liquidity, leverage, assets, equity, cash, and inventories. CX Codex +1 266installs stock-price-change Fetches stock price changes across ten periods — from one day to ten years. Builds a picture of momentum and trends on all horizons. CX Codex +1 266installs company-market-cap company-market-cap fetches the market capitalization of one publicly traded company through Octagon MCP. Use it to check company size or put a valuation in context. CX Codex +1 266installs

Project sponsors

Companies that keep this analytics open