sec-cash-flow-review
Compare original and translation side by side
🇺🇸
Original
English🇨🇳
Translation
ChineseSEC 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 tool with a natural language prompt:
octagon-agentExtract 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-agentExtract 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
| 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 |
| 组成部分 | 描述 |
|---|---|
| Net Income | 起始点 |
| Depreciation/Amortization | 非现金加回项 |
| Stock Compensation | 非现金费用 |
| Deferred Taxes | 时间性差异 |
| Working Capital Changes | 流动资产/负债变动 |
| Other Adjustments | 非现金项目 |
Investing Activities
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 |
| 组成部分 | 描述 |
|---|---|
| Capital Expenditures | 不动产、设备采购 |
| Acquisitions | 业务合并 |
| Investment Purchases | 证券买入 |
| Investment Sales | 证券卖出 |
| Asset Dispositions | 不动产、设备出售 |
Financing Activities
Financing Activities
| Component | Description |
|---|---|
| Debt Issuance | Borrowings |
| Debt Repayment | Principal payments |
| Share Issuance | Stock offerings |
| Share Repurchases | Buybacks |
| Dividends | Shareholder distributions |
| 组成部分 | 描述 |
|---|---|
| Debt Issuance | 借款 |
| Debt Repayment | 本金偿还 |
| Share Issuance | 股票发行 |
| Share Repurchases | 股票回购 |
| Dividends | 股东分红 |
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 |
| 指标 | 计算公式 | 反映内容 |
|---|---|---|
| Operating Cash Flow | 来自报表 | 经营活动产生的现金 |
| Free Cash Flow | OCF - CapEx | 扣除投资后的可用现金 |
| FCF Margin | FCF / 营收 | 现金生成率 |
| Cash Conversion | OCF / Net Income | 盈利质量 |
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 |
| 指标 | 计算公式 | 反映内容 |
|---|---|---|
| Cash Position | 现金 + 等价物 | 可用流动性 |
| Cash Runway | 现金 / 月度消耗 | 可支撑运营的月数 |
| Quick Ratio | (现金 + 应收账款) / 流动负债 | 短期偿债能力 |
| Current Ratio | 流动资产 / 流动负债 | 营运资本状况 |
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 |
| 指标 | 计算公式 | 反映内容 |
|---|---|---|
| CapEx Intensity | CapEx / 营收 | 投资水平 |
| CapEx / D&A | CapEx / 折旧摊销 | 维护性vs增长性投资 |
| Acquisition Spend | 来自投资活动 | 并购活动 |
| Investment Returns | 卖出额 / 买入额 | 投资组合活动 |
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 |
| 组成部分 | 增加意味着 | 减少意味着 |
|---|---|---|
| Accounts Receivable | 占用现金 | 释放现金 |
| Inventory | 占用现金 | 释放现金 |
| Prepaid Expenses | 占用现金 | 释放现金 |
| Accounts Payable | 释放现金 | 占用现金 |
| Accrued Liabilities | 释放现金 | 占用现金 |
| Deferred Revenue | 释放现金 | 占用现金 |
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 |
| 指标 | 计算公式 |
|---|---|
| Days Sales Outstanding | (应收账款 / 营收) × 365 |
| Days Inventory Outstanding | (存货 / 销货成本) × 365 |
| Days Payables Outstanding | (应付账款 / 销货成本) × 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 |
| 因素 | 高质量 | 低质量 |
|---|---|---|
| OCF vs. Net Income | OCF > NI | OCF < NI |
| 可持续性 | 经常性来源 | 一次性项目 |
| 营运资本 | 趋势稳定 | 变动异常 |
| 非现金费用 | 折旧摊销合理 | 加回项过多 |
Red Flags
预警信号
- OCF < Net Income persistently - Earnings quality concern
- Negative FCF - Cash consumption
- Rising receivables - Collection issues
- Inventory buildup - Demand weakness
- Declining payables - Supplier pressure
- Heavy stock compensation - Dilution concern
- 持续出现OCF < Net Income - 盈利质量存疑
- 负自由现金流 - 现金消耗
- 应收账款增加 - 回款问题
- 存货积压 - 需求疲软
- 应付账款减少 - 供应商压力
- 大额股权激励 - 稀释担忧
Trend Analysis
趋势分析
Period-over-Period
期间对比
| Metric | Prior Period | Current | Change |
|---|---|---|---|
| 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
现金状况分析
| 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 |
| 因素 | 核查内容 |
|---|---|
| Debt/EBITDA | 杠杆限制 |
| Interest Coverage | 偿债能力 |
| Minimum Cash | 要求的最低余额 |
| CapEx Limits | 投资约束 |
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 |
| 活动 | 影响 |
|---|---|
| Debt Issuance | 杠杆率上升 |
| Debt Repayment | 去杠杆 |
| Equity Issuance | 股权稀释、募资 |
| Buybacks | 向股东返还现金 |
| Dividends | 现金分配 |
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 |
| 优先级 | 信号含义 |
|---|---|
| 大额CapEx | 增长型投资 |
| 大额回购 | 成熟阶段,返还现金 |
| 聚焦债务 | 去杠杆优先 |
| 并购 | 外部增长 |
| 均衡配置 | 多元化策略 |
Analysis Tips
分析技巧
-
Compare OCF to earnings: Divergence signals quality issues.
-
Track FCF trends: More important than net income.
-
Analyze working capital drivers: Understand component changes.
-
Consider seasonality: Quarterly patterns affect cash flow.
-
Read footnotes: Capital commitments disclosed there.
-
Check management discussion: Cash flow commentary in MD&A.
- 对比OCF与盈利:差异意味着质量问题。
- 跟踪自由现金流趋势:比净利润更重要。
- 分析营运资本驱动因素:理解各组成部分的变动。
- 考虑季节性:季度模式会影响现金流。
- 阅读附注:资本承诺会在附注中披露。
- 查看管理层讨论: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
- 投资分析:评估现金生成质量
- 信用分析:评估偿债能力
- 估值:基于自由现金流的模型
- 流动性监控:跟踪现金状况
- 营运资本效率:运营状况评估