sec-cash-flow-review

Compare original and translation side by side

🇺🇸

Original

English
🇨🇳

Translation

Chinese

SEC Cash Flow Review

SEC现金流分析

Extract and analyze cash flow trends and working capital changes from SEC filings for public companies using the Octagon MCP server.
使用Octagon MCP服务器从上市公司的SEC文件中提取并分析现金流趋势与营运资本变化。

Prerequisites

前置条件

Ensure Octagon MCP is configured in your AI agent (Cursor, Claude Desktop, Windsurf, etc.). See references/mcp-setup.md for installation instructions.
确保你的AI代理(Cursor、Claude Desktop、Windsurf等)中已配置Octagon MCP。安装说明请参阅references/mcp-setup.md

Workflow

工作流程

1. Identify Analysis Parameters

1. 确定分析参数

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
查询前需确定以下内容:
  • 股票代码(Ticker):股票符号(例如:AAPL、MSFT、GOOGL)
  • 文件类型(可选):10-K(年度报告)或10-Q(季度报告)
  • 重点领域(可选):Operating、investing、financing、working capital

2. Execute Query via Octagon MCP

2. 通过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."
  }
}
使用
octagon-agent
工具,配合自然语言提示词:
Extract and analyze cash flow trends and working capital changes from <TICKER>'s latest 10-Q.
MCP调用格式:
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

3. 预期输出

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
代理会返回结构化的现金流分析内容,包括:
现金流趋势:
  • Operating Cash Flow:同比增长37.87%
  • Investing Cash Flow:-20.8亿美元(CapEx、投资)
  • Financing Cash Flow:混合情况(流入10.4亿美元,流出21.8亿美元)
营运资本变化:
  • 营运资本变动:-4.56亿美元
  • 现金及等价物:6个月内减少11.93亿美元
关键观察结论:
  • 经营现金流增长速度超过投资/融资现金流
  • 内容投资导致营运资本收缩
  • 流动性足以支撑12个月以上运营
数据来源:octagon-financials-agent、octagon-sec-agent、octagon-web-search-agent

4. Interpret Results

4. 解读结果

See references/interpreting-results.md for guidance on:
  • Understanding cash flow components
  • Evaluating cash flow quality
  • Analyzing working capital trends
  • Assessing liquidity position
解读指南请参阅references/interpreting-results.md,内容包括:
  • 理解现金流组成部分
  • 评估现金流质量
  • 分析营运资本趋势
  • 评估流动性状况

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.
完整现金流分析:
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.
营运资本深度分析:
Analyze working capital changes and cash conversion cycle for AMZN from the latest 10-K.
流动性评估:
Evaluate TSLA's liquidity position and cash runway from the latest quarterly filing.
资本支出分析:
Extract capital expenditure trends and investment priorities from GOOGL's cash flow statement.
融资活动分析:
Analyze debt repayments, share buybacks, and dividend payments from MSFT's latest 10-K cash flow.

Cash Flow Statement Components

现金流量表组成部分

Operating Activities

Operating Activities

ComponentDescription
Net IncomeStarting point
Depreciation/AmortizationNon-cash add-back
Stock CompensationNon-cash expense
Deferred TaxesTiming differences
Working Capital ChangesCurrent asset/liability changes
Other AdjustmentsNon-cash items
组成部分描述
Net Income起始点
Depreciation/Amortization非现金加回项
Stock Compensation非现金费用
Deferred Taxes时间性差异
Working Capital Changes流动资产/负债变动
Other Adjustments非现金项目

Investing Activities

Investing Activities

ComponentDescription
Capital ExpendituresProperty, equipment purchases
AcquisitionsBusiness combinations
Investment PurchasesSecurities bought
Investment SalesSecurities sold
Asset DispositionsProperty, equipment sales
组成部分描述
Capital Expenditures不动产、设备采购
Acquisitions业务合并
Investment Purchases证券买入
Investment Sales证券卖出
Asset Dispositions不动产、设备出售

Financing Activities

Financing Activities

ComponentDescription
Debt IssuanceBorrowings
Debt RepaymentPrincipal payments
Share IssuanceStock offerings
Share RepurchasesBuybacks
DividendsShareholder distributions
组成部分描述
Debt Issuance借款
Debt Repayment本金偿还
Share Issuance股票发行
Share Repurchases股票回购
Dividends股东分红

Key Cash Flow Metrics

关键现金流指标

Profitability vs. Cash

盈利能力与现金流对比

MetricCalculationWhat It Shows
Operating Cash FlowFrom statementCash from operations
Free Cash FlowOCF - CapExCash after investment
FCF MarginFCF / RevenueCash generation rate
Cash ConversionOCF / Net IncomeEarnings quality
指标计算公式反映内容
Operating Cash Flow来自报表经营活动产生的现金
Free Cash FlowOCF - CapEx扣除投资后的可用现金
FCF MarginFCF / 营收现金生成率
Cash ConversionOCF / Net Income盈利质量

Liquidity Metrics

流动性指标

MetricCalculationWhat It Shows
Cash PositionCash + equivalentsAvailable liquidity
Cash RunwayCash / Monthly BurnMonths of runway
Quick Ratio(Cash + Receivables) / Current LiabilitiesShort-term coverage
Current RatioCurrent Assets / Current LiabilitiesWorking capital
指标计算公式反映内容
Cash Position现金 + 等价物可用流动性
Cash Runway现金 / 月度消耗可支撑运营的月数
Quick Ratio(现金 + 应收账款) / 流动负债短期偿债能力
Current Ratio流动资产 / 流动负债营运资本状况

Investment Metrics

投资指标

MetricCalculationWhat It Shows
CapEx IntensityCapEx / RevenueInvestment level
CapEx / D&ACapEx / DepreciationMaintenance vs. growth
Acquisition SpendFrom investingM&A activity
Investment ReturnsSales / PurchasesPortfolio activity
指标计算公式反映内容
CapEx IntensityCapEx / 营收投资水平
CapEx / D&ACapEx / 折旧摊销维护性vs增长性投资
Acquisition Spend来自投资活动并购活动
Investment Returns卖出额 / 买入额投资组合活动

Working Capital Analysis

营运资本分析

Components

组成部分

ComponentIncrease MeansDecrease Means
Accounts ReceivableCash usedCash provided
InventoryCash usedCash provided
Prepaid ExpensesCash usedCash provided
Accounts PayableCash providedCash used
Accrued LiabilitiesCash providedCash used
Deferred RevenueCash providedCash used
组成部分增加意味着减少意味着
Accounts Receivable占用现金释放现金
Inventory占用现金释放现金
Prepaid Expenses占用现金释放现金
Accounts Payable释放现金占用现金
Accrued Liabilities释放现金占用现金
Deferred Revenue释放现金占用现金

Cash Conversion Cycle

现金转换周期

MetricCalculation
Days Sales Outstanding(AR / Revenue) × 365
Days Inventory Outstanding(Inventory / COGS) × 365
Days Payables Outstanding(AP / COGS) × 365
Cash Conversion CycleDSO + DIO - DPO
指标计算公式
Days Sales Outstanding(应收账款 / 营收) × 365
Days Inventory Outstanding(存货 / 销货成本) × 365
Days Payables Outstanding(应付账款 / 销货成本) × 365
Cash Conversion CycleDSO + DIO - DPO

Working Capital Trends

营运资本趋势

TrendInterpretation
Declining CCCImproved efficiency
Rising CCCCash tied up longer
Negative CCCCustomer-funded model
Stable CCCConsistent operations
趋势解读
现金转换周期下降运营效率提升
现金转换周期上升现金占用时间变长
现金转换周期为负客户资金支撑模式
现金转换周期稳定运营状况一致

Cash Flow Quality Assessment

现金流质量评估

Quality Indicators

质量指标

FactorHigh QualityLow Quality
OCF vs. Net IncomeOCF > NIOCF < NI
SustainabilityRecurring sourcesOne-time items
Working CapitalStable trendsErratic changes
Non-Cash ChargesReasonable D&AExcessive add-backs
因素高质量低质量
OCF vs. Net IncomeOCF > NIOCF < NI
可持续性经常性来源一次性项目
营运资本趋势稳定变动异常
非现金费用折旧摊销合理加回项过多

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
  1. 持续出现OCF < Net Income - 盈利质量存疑
  2. 负自由现金流 - 现金消耗
  3. 应收账款增加 - 回款问题
  4. 存货积压 - 需求疲软
  5. 应付账款减少 - 供应商压力
  6. 大额股权激励 - 稀释担忧

Trend Analysis

趋势分析

Period-over-Period

期间对比

MetricPrior PeriodCurrentChange
Operating CF
Investing CF
Financing CF
Free Cash Flow
Working Capital
指标上期本期变动
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
长期跟踪以下内容:
  • OCF增长轨迹
  • 自由现金流转化率
  • 营运资本效率
  • CapEx模式
  • 资本回报趋势

Liquidity Assessment

流动性评估

Cash Position Analysis

现金状况分析

FactorAssessment
Absolute LevelAdequate for operations
TrendGrowing or declining
vs. ObligationsCoverage of debt, commitments
vs. InvestmentAbility to fund growth
因素评估内容
绝对水平是否足以支撑运营
趋势增长或下降
与债务对比是否覆盖债务、承诺支出
与投资对比是否有能力支撑增长

Runway Calculation

运营周期计算

ScenarioCalculation
ConservativeCash / Average Monthly Burn
Including Revolver(Cash + Available Credit) / Burn
StressCash / Peak Monthly Burn
场景计算公式
保守型现金 / 平均月度消耗
含循环信贷(现金 + 可用信贷额度) / 消耗
压力测试现金 / 峰值月度消耗

Covenant Considerations

契约考量

FactorWhat to Check
Debt/EBITDALeverage limits
Interest CoveragePayment ability
Minimum CashRequired balances
CapEx LimitsInvestment constraints
因素核查内容
Debt/EBITDA杠杆限制
Interest Coverage偿债能力
Minimum Cash要求的最低余额
CapEx Limits投资约束

Financing Activity Analysis

融资活动分析

Capital Structure Changes

资本结构变动

ActivityImplication
Debt IssuanceLeverage increase
Debt RepaymentDeleveraging
Equity IssuanceDilution, capital raise
BuybacksReturn to shareholders
DividendsCash distribution
活动影响
Debt Issuance杠杆率上升
Debt Repayment去杠杆
Equity Issuance股权稀释、募资
Buybacks向股东返还现金
Dividends现金分配

Capital Allocation Assessment

资本配置评估

PriorityWhat It Signals
Heavy CapExGrowth investment
Heavy BuybacksMature, returning cash
Debt FocusDeleveraging priority
M&AExternal growth
BalancedDiversified approach
优先级信号含义
大额CapEx增长型投资
大额回购成熟阶段,返还现金
聚焦债务去杠杆优先
并购外部增长
均衡配置多元化策略

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.
  1. 对比OCF与盈利:差异意味着质量问题。
  2. 跟踪自由现金流趋势:比净利润更重要。
  3. 分析营运资本驱动因素:理解各组成部分的变动。
  4. 考虑季节性:季度模式会影响现金流。
  5. 阅读附注:资本承诺会在附注中披露。
  6. 查看管理层讨论: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
  • 投资分析:评估现金生成质量
  • 信用分析:评估偿债能力
  • 估值:基于自由现金流的模型
  • 流动性监控:跟踪现金状况
  • 营运资本效率:运营状况评估