Back to Details

free-cash-flow

Compare original and translation side by side

🇺🇸

Original

English
🇨🇳

Translation

Chinese

Free Cash Flow Diagram

自由现金流图表

Metadata

元数据

  • Name: free-cash-flow
  • Description: Cash flow modeling for investment and valuation analysis
  • Triggers: free cash flow, FCF, cash flow, NPV, break-even, investment analysis
  • 名称: free-cash-flow
  • 描述: 用于投资与估值分析的现金流建模
  • 触发词: free cash flow, FCF, cash flow, NPV, break-even, investment analysis

Instructions

说明

You are a financial analyst modeling free cash flow for $ARGUMENTS.
Your task is to project cash flows over time and assess investment attractiveness.
你是一名为$ARGUMENTS建模自由现金流的金融分析师。
你的任务是预测随时间变化的现金流，并评估投资吸引力。

Framework

框架

Free Cash Flow Components

自由现金流构成

Revenue
- Operating Expenses (OpEx)
─────────────────────────
= Operating Income (EBIT)
- Taxes
─────────────────────────
= NOPAT (Net Operating Profit After Tax)
+ Depreciation & Amortization
- Capital Expenditures (CapEx)
- Change in Working Capital
─────────────────────────
= Free Cash Flow (FCF)
Revenue
- Operating Expenses (OpEx)
─────────────────────────
= Operating Income (EBIT)
- Taxes
─────────────────────────
= NOPAT (Net Operating Profit After Tax)
+ Depreciation & Amortization
- Capital Expenditures (CapEx)
- Change in Working Capital
─────────────────────────
= Free Cash Flow (FCF)

The FCF Diagram Structure

FCF图表结构

        Year 0    Year 1    Year 2    Year 3    Year 4    Year 5
          │         │         │         │         │         │
    ┌─────┴─────┬───┴─────┬───┴─────┬───┴─────┬───┴─────┬───┴─────┐
    │  Initial  │         │         │         │         │         │
    │  Invest   │ Returns │ Returns │ Returns │ Returns │ Returns │
    │   ($100)  │  +$20   │  +$35   │  +$50   │  +$65   │  +$80   │
    └───────────┴─────────┴─────────┴─────────┴─────────┴─────────┘
         │         │         │         │         │         │
         └─────────┴─────────┴─────────┴─────────┴─────────┘
                           │
                    Cumulative Cash Flow
                    -$100 → -$80 → -$45 → +$5 → +$70 → +$150
                           │
                    Break-even: Year 3
        Year 0    Year 1    Year 2    Year 3    Year 4    Year 5
          │         │         │         │         │         │
    ┌─────┴─────┬───┴─────┬───┴─────┬───┴─────┬───┴─────┬───┴─────┐
    │  Initial  │         │         │         │         │         │
    │  Invest   │ Returns │ Returns │ Returns │ Returns │ Returns │
    │   ($100)  │  +$20   │  +$35   │  +$50   │  +$65   │  +$80   │
    └───────────┴─────────┴─────────┴─────────┴─────────┴─────────┘
         │         │         │         │         │         │
         └─────────┴─────────┴─────────┴─────────┴─────────┘
                           │
                    Cumulative Cash Flow
                    -$100 → -$80 → -$45 → +$5 → +$70 → +$150
                           │
                    Break-even: Year 3

Key Metrics

关键指标

MetricFormulaInterpretation
NPVΣ(FCF/(1+r)^t) - Initial InvestmentValue created (>0 = good)
IRRRate where NPV = 0Return percentage
PaybackYears to recover investmentTime to break-even
ROI(Total FCF - Investment) / InvestmentReturn percentage
指标公式解读
NPVΣ(FCF/(1+r)^t) - Initial Investment创造的价值（>0为优质）
IRR使NPV=0的折现率回报率百分比
Payback收回投资所需年限回本时间
ROI(总FCF - 投资金额) / 投资金额回报率百分比

Output Process

输出流程

  1. Define time horizon - Typically 5-10 years
  2. Estimate revenue - By year, with assumptions
  3. Model costs - OpEx, CapEx, working capital
  4. Calculate FCF - For each year
  5. Discount to present - Apply discount rate
  6. Calculate metrics - NPV, IRR, payback
  7. Sensitivity test - Key assumptions
  8. Interpret results - Investment decision
  1. 确定时间范围 - 通常为5-10年
  2. 预估收入 - 按年度估算，并附上假设条件
  3. 建模成本 - OpEx、CapEx、营运资金
  4. 计算FCF - 逐年计算
  5. 折现至现值 - 应用折现率
  6. 计算指标 - NPV、IRR、回收期
  7. 敏感性测试 - 关键假设条件测试
  8. 解读结果 - 给出投资决策

Output Format

输出格式

undefined
undefined

Free Cash Flow Analysis: [Project/Business]

自由现金流分析: [项目/企业]

Executive Summary

执行摘要

MetricValueAssessment
NPV$X M✅ Positive / ❌ Negative
IRRX%✅ > WACC / ❌ < WACC
Payback PeriodX years✅ < Target / ❌ > Target
Maximum Exposure$X MCapital at risk
Break-even YearYear XWhen cash turns positive
Recommendation: [Invest / Do not invest / More analysis needed]
指标数值评估
NPV$X M✅ 为正 / ❌ 为负
IRRX%✅ 高于WACC / ❌ 低于WACC
回收期X年✅ 短于目标 / ❌ 长于目标
最大风险敞口$X M面临风险的资本
回本年份第X年现金流转正的时间
建议: [投资 / 不投资 / 需要更多分析]

Assumptions

假设条件

AssumptionValueSource
Revenue CAGRX%[Basis]
Operating MarginX%[Basis]
Tax RateX%[Basis]
Discount Rate (WACC)X%[Basis]
Working Capital %X%[Basis]
CapEx % of RevenueX%[Basis]
Terminal GrowthX%[Basis]
假设数值来源
收入复合年增长率 (CAGR)X%[依据]
营业利润率X%[依据]
税率X%[依据]
折现率 (WACC)X%[依据]
营运资金占比X%[依据]
资本支出占收入比X%[依据]
终期增长率X%[依据]

Cash Flow Projections

现金流预测

Line ItemYear 0Year 1Year 2Year 3Year 4Year 5
Revenue-$100$120$145$175$210
- OpEx-($70)($82)($97)($115)($136)
= EBIT-$30$38$48$60$74
- Taxes (25%)-($7.5)($9.5)($12)($15)($18.5)
= NOPAT-$22.5$28.5$36$45$55.5
+ D&A-$10$12$14$16$18
- CapEx($50)($10)($12)($14)($16)($18)
- Δ Working Cap-($5)($6)($7)($8)($9)
= Free Cash Flow($50)$17.5$22.5$29$37$46.5
项目第0年第1年第2年第3年第4年第5年
收入-$100$120$145$175$210
- 营业支出 (OpEx)-($70)($82)($97)($115)($136)
= 息税前利润 (EBIT)-$30$38$48$60$74
- 税费 (25%)-($7.5)($9.5)($12)($15)($18.5)
= 税后净营业利润 (NOPAT)-$22.5$28.5$36$45$55.5
+ 折旧与摊销 (D&A)-$10$12$14$16$18
- 资本支出 (CapEx)($50)($10)($12)($14)($16)($18)
- 营运资金变化 (Δ Working Cap)-($5)($6)($7)($8)($9)
= 自由现金流 (FCF)($50)$17.5$22.5$29$37$46.5

Cumulative Cash Flow

累计现金流

YearFCFCumulativeStatus
0($50)($50)🔴 Investment
1$17.5($32.5)🟡 Recovery
2$22.5($10)🟡 Near break-even
3$29$19🟢 Break-even achieved
4$37$56🟢 Profitable
5$46.5$102.5🟢 Strong returns
Break-even Point: Between Year 2 and Year 3 Maximum Exposure: $50M (Year 0)
年份FCF累计值状态
0($50)($50)🔴 投资阶段
1$17.5($32.5)🟡 回收阶段
2$22.5($10)🟡 接近回本
3$29$19🟢 已回本
4$37$56🟢 盈利
5$46.5$102.5🟢 高回报
回本点: 第2年至第3年之间 最大风险敞口: $50M (第0年)

Valuation

估值

Discounted Cash Flows (WACC = 10%)
YearFCFDiscount FactorPresent Value
0($50)1.000($50.0)
1$17.50.909$15.9
2$22.50.826$18.6
3$290.751$21.8
4$370.683$25.3
5$46.50.621$28.9
Terminal Value$465*0.621$288.9
NPV$349.4
*Terminal Value = Year 5 FCF × (1 + g) / (WACC - g) = $46.5 × 1.02 / (0.10 - 0.02)
折现现金流 (WACC = 10%)
年份FCF折现因子现值
0($50)1.000($50.0)
1$17.50.909$15.9
2$22.50.826$18.6
3$290.751$21.8
4$370.683$25.3
5$46.50.621$28.9
终值$465*0.621$288.9
NPV$349.4
*终值 = 第5年FCF × (1 + g) / (WACC - g) = $46.5 × 1.02 / (0.10 - 0.02)

Sensitivity Analysis

敏感性分析

NPV Sensitivity to Key Assumptions
Assumption-20%Base Case+20%
Revenue$249M$349M$449M
Operating Margin$274M$349M$424M
Discount Rate$412M$349M$298M
Terminal Growth$299M$349M$399M
Most Sensitive To: Revenue growth
关键假设对NPV的敏感性
假设-20%基准情况+20%
收入$249M$349M$449M
营业利润率$274M$349M$424M
折现率$412M$349M$298M
终期增长率$299M$349M$399M
最敏感因素: 收入增长

Risk Assessment

风险评估

RiskProbabilityImpactMitigation
Revenue shortfallMediumHighConservative base case
Cost overrunsLowMediumContingency budget
Delay in launchMediumMediumPhased approach
CompetitionHighHighDifferentiation strategy
风险概率影响缓解措施
收入未达预期中等高采用保守的基准情况
成本超支低中等设置应急预算
上线延迟中等中等采用分阶段推进方案
竞争加剧高高实施差异化策略

Visual: Cash Flow Diagram

可视化：现金流图表

    ($50)  ─────────────────────────────────────────────────────
      │    │         │         │         │         │         │
      ▼    ▼         ▼         ▼         ▼         ▼         ▼
    ┌────┬─────────┬─────────┬─────────┬─────────┬─────────┬─────┐
    │    │ ░░░░░░░ │ ░░░░░░░ │ ▓▓▓▓▓▓▓ │ ▓▓▓▓▓▓▓ │ ▓▓▓▓▓▓▓ │     │
    │Inv │ Returns │ Returns │ Returns │ Returns │ Returns │ TV  │
    └────┴─────────┴─────────┴─────────┴─────────┴─────────┴─────┘
      Y0    Y1        Y2        Y3        Y4        Y5
                      │
                 Break-even
                (Year 2-3)
Legend:
  • ▓▓▓ Returns (cash inflows)
  • ░░░ Early returns (lower)
  • Inv = Initial investment
    ($50)  ─────────────────────────────────────────────────────
      │    │         │         │         │         │         │
      ▼    ▼         ▼         ▼         ▼         ▼         ▼
    ┌────┬─────────┬─────────┬─────────┬─────────┬─────────┬─────┐
    │    │ ░░░░░░░ │ ░░░░░░░ │ ▓▓▓▓▓▓▓ │ ▓▓▓▓▓▓▓ │ ▓▓▓▓▓▓▓ │     │
    │Inv │ Returns │ Returns │ Returns │ Returns │ Returns │ TV  │
    └────┴─────────┴─────────┴─────────┴─────────┴─────────┴─────┘
      Y0    Y1        Y2        Y3        Y4        Y5
                      │
                 回本点
                (第2-3年)
图例:
  • ▓▓▓ 回报（现金流入）
  • ░░░ 早期回报（较低）
  • Inv = 初始投资

Decision Criteria

决策标准

CriterionTargetActualPass?
NPV > 0> $0$349M✅
IRR > WACC> 10%45%✅
Payback < 4 years< 4 yr2.5 yr✅
Max exposure < $100M< $100M$50M✅
All criteria met: ✅ Recommend investment
undefined
标准目标实际值是否通过？
NPV > 0> $0$349M✅
IRR > WACC> 10%45%✅
回收期 < 4年< 4年2.5年✅
最大风险敞口 < $100M< $100M$50M✅
所有标准均满足: ✅ 建议投资
undefined

Tips

提示

  • Be conservative on revenue, realistic on costs
  • Terminal value often dominates - scrutinize carefully
  • Use sensitivity analysis to identify key assumptions
  • Show both undiscounted and discounted cash flows
  • Payback ignores time value of money - use as secondary metric
  • Consider multiple scenarios (base, optimistic, pessimistic)
  • The diagram should tell the story at a glance
  • 对收入预估要保守，对成本预估要贴合实际
  • 终值通常占估值的主要部分，需仔细审核
  • 利用敏感性测试识别关键假设条件
  • 同时展示未折现和折现后的现金流
  • 回收期未考虑货币的时间价值，仅用作次要指标
  • 考虑多种场景（基准、乐观、悲观）
  • 图表应能直观展示核心信息

References

参考资料

  • Brealey, Myers, Allen. Principles of Corporate Finance. Multiple editions.
  • Copeland, Koller, Murrin. Valuation. 1994.
  • Damodaran, Aswath. Investment Valuation. 2012.
  • Brealey, Myers, Allen. Principles of Corporate Finance. 多版次。
  • Copeland, Koller, Murrin. Valuation. 1994.
  • Damodaran, Aswath. Investment Valuation. 2012.