关于 finance
面向财务团队和分析师的金融分析技能,涵盖财务报表分析、估值、公司财务、风险管理和规划框架。
主要功能
- 01财务比率与现金流分析
- 02DCF 与可比公司估值
- 03LBO 与并购建模框架
- 04资本配置与风险分析
- 05预测与预算框架
适用场景
- 01分析企业财务状况
- 02构建估值模型
- 03评估收购或 LBO
- 04编制预测与预算
安装
复制下面的命令,在终端中运行。
$
npx skills add https:/ / github.com/ travisjneuman/ .claude --skill finance安装后在 Claude Code 中输入/finance确认已加载。
包含的文件
除 SKILL.md 外,安装时一起下载的参考资料和脚本。
references/corporate-finance-expert.mdfinancial-modeling-master.mdma-due-diligence-specialist.md详细介绍
金融分析专家
用于建模、估值和企业融资决策的综合金融框架。
财务报表分析
杜邦分析(5 因素)
将 ROE 分解为各项运营驱动因素:
ROE = Net Profit Margin x Asset Turnover x Equity Multiplier
Extended (5-Factor):
ROE = (EBIT/Sales) x (Sales/Assets) x (Assets/Equity) x (EBT/EBIT) x (NI/EBT)
= Operating Margin x Asset Turnover x Leverage x Interest Burden x Tax Burden
关键财务比率
| 类别 | 比率 | 公式 | 基准 |
|---|---|---|---|
| 盈利能力 | 毛利率 | 毛利 / 收入 | 因行业而异 |
| 营业利润率 | EBIT / 收入 | 15-25%(因情况而异) | |
| 净利率 | 净利润 / 收入 | 10-20%(因情况而异) | |
| ROIC | NOPAT / 投入资本 | > WACC | |
| ROE | 净利润 / 权益 | 15-20%+ | |
| 流动性 | 流动比率 | 流动资产 / 流动负债 | 1.5-2.0x |
| 速动比率 | (CA - Inventory) / CL | 1.0x+ | |
| 现金比率 | 现金 / 流动负债 | 0.2-0.5x | |
| 杠杆 | 债务/权益 | 总债务 / 总权益 | < 1.0x |
| 债务/EBITDA | 总债务 / EBITDA | 2-3x(IG),4-6x(HY) | |
| 利息保障倍数 | EBIT / 利息费用 | > 3x | |
| 效率 | 资产周转率 | 收入 / 总资产 | 因行业而异 |
| 存货天数 | 存货 / (COGS/365) | 因行业而异 | |
| DSO | AR / (收入/365) | 30-45 天 | |
| DPO | AP / (COGS/365) | 30-60 天 |
现金流分析
FREE CASH FLOW (FCF):
Operating Cash Flow
- Capital Expenditures
= Free Cash Flow
UNLEVERED FREE CASH FLOW (for valuation):
EBIT
x (1 - Tax Rate)
= NOPAT
+ Depreciation & Amortization
- Change in Working Capital
- Capital Expenditures
= Unlevered Free Cash Flow
LEVERED FREE CASH FLOW:
Unlevered FCF
- Interest Expense x (1 - Tax Rate)
- Mandatory Debt Repayments
+ Net Borrowing
= Levered Free Cash Flow
估值方法
贴现现金流(DCF)
ENTERPRISE VALUE:
T UFCFt Terminal Value
EV = Σ ─────────── + ─────────────────────
t=1 (1+WACC)^t (1+WACC)^T
TERMINAL VALUE (Perpetuity Growth):
UFCF(T+1)
Terminal Value = ───────────
WACC - g
TERMINAL VALUE (Exit Multiple):
Terminal Value = EBITDA(T) x Exit Multiple
EQUITY VALUE:
Equity Value = Enterprise Value - Net Debt + Cash
DCF 模型模板
| 年份 | 1 | 2 | 3 | 4 | 5 | 终值 |
|---|---|---|---|---|---|---|
| 收入 | ||||||
| 增长率 | ||||||
| EBITDA | ||||||
| 利润率 % | ||||||
| D&A | ||||||
| EBIT | ||||||
| 税项 | ||||||
| NOPAT | ||||||
| + D&A | ||||||
| - CapEx | ||||||
| - NWC 变动 | ||||||
| UFCF | ||||||
| 贴现因子 | ||||||
| UFCF 现值 |
可比公司分析
TRADING MULTIPLES:
- EV/Revenue
- EV/EBITDA
- EV/EBIT
- P/E
- P/B
SELECTION CRITERIA:
1. Industry/sector alignment
2. Size (revenue, market cap)
3. Growth profile
4. Profitability profile
5. Geographic exposure
6. Capital structure
ADJUSTMENTS:
- Control premium (20-30% for acquisition)
- Liquidity discount (10-30% for private)
- Size discount (10-20% for smaller)
先例交易分析
TRANSACTION MULTIPLES:
- EV/LTM Revenue
- EV/LTM EBITDA
- EV/NTM EBITDA
- Transaction Premium to unaffected price
ADJUSTMENTS:
- Market conditions at time of deal
- Strategic vs. financial buyer
- Competitive auction vs. negotiated
- Synergy assumptions baked in
分部加总法(SOTP)
METHODOLOGY:
1. Identify distinct business segments
2. Value each segment independently
3. Apply segment-specific multiples/DCF
4. Sum segment values
5. Subtract corporate costs (capitalized)
6. Adjust for holding company discount (10-20%)
CONGLOMERATE DISCOUNT FACTORS:
- Complexity premium demanded by investors
- Capital allocation inefficiencies
- Management distraction
- Lack of pure-play comparables
杠杆收购(LBO)分析
LBO 模型结构
SOURCES & USES:
Sources:
- Senior Debt (Term Loan A/B)
- Subordinated Debt (Mezz, High Yield)
- Equity Contribution
Uses:
- Purchase Price
- Refinance Existing Debt
- Transaction Fees
- Cash to Balance Sheet
KEY METRICS:
- Entry Multiple: EV / LTM EBITDA
- Exit Multiple: Assumed sale multiple
- Equity IRR: Target 20-25%+
- Cash-on-Cash: 2.0-3.0x in 5 years
- MOIC: Multiple of Invested Capital
LBO 回报框架
| IRR 目标 | 持有期 | 所需 MOIC |
|---|---|---|
| 20% | 3 年 | 1.7x |
| 20% | 5 年 | 2.5x |
| 25% | 3 年 | 2.0x |
| 25% | 5 年 | 3.0x |
价值创造来源
% of Total Returns (typical)
EBITDA Growth 40-50%
- Revenue growth
- Margin improvement
Multiple Expansion 20-30%
- Market timing
- Operational improvement
- Strategic repositioning
Debt Paydown 20-30%
- Cash flow generation
- Working capital improvement
并购财务分析
增厚/摊薄分析
STANDALONE EPS (Acquirer):
Net Income / Shares Outstanding = EPS
PRO FORMA EPS:
(Combined Net Income - Synergies + Interest Cost) / New Shares = PF EPS
ACCRETION/(DILUTION):
(PF EPS - Standalone EPS) / Standalone EPS = %
BREAKEVEN SYNERGIES:
Synergies needed to make deal EPS neutral
协同效应分析
| 协同效应类型 | 典型范围 | 实现时间 |
|---|---|---|
| 成本协同效应 | 目标公司成本的 5-15% | 1-3 年 |
| 收入协同效应 | 合并后收入的 2-5% | 2-5 年 |
交易结构考量
CONSIDERATION:
- Cash: Immediate value, tax implications
- Stock: Alignment, dilution, tax deferral
- Mixed: Balance of above
FINANCING:
- Debt capacity analysis
- Credit rating implications
- Optimal capital structure
- Bridge financing needs
资本配置框架
资本配置层级
1. MAINTAIN CORE BUSINESS
- Maintenance CapEx
- Working capital
- Required debt service
2. INVEST IN GROWTH
- Growth CapEx (> WACC hurdle)
- M&A (strategic fit + returns)
- R&D / Innovation
3. RETURN TO SHAREHOLDERS
- Dividends (sustainable payout)
- Share repurchases (below intrinsic value)
4. BUILD FLEXIBILITY
- Cash reserves
- Debt capacity
- Strategic optionality
投资门槛收益率
| 投资类型 | 典型门槛 | 风险溢价 |
|---|---|---|
| 维护性 CapEx | WACC | 无 |
| 增长性 CapEx | WACC + 2-3% | 低 |
| 国内并购 | WACC + 3-5% | 中 |
| 国际并购 | WACC + 5-8% | 高 |
| 创业投资/创新 | 25-30% IRR | 非常高 |
ROIC 与 WACC 框架
VALUE CREATION:
ROIC > WACC → Value creating
ROIC = WACC → Value neutral
ROIC < WACC → Value destroying
ECONOMIC PROFIT:
Economic Profit = (ROIC - WACC) x Invested Capital
SPREAD ANALYSIS:
Track ROIC-WACC spread over time
Target: Positive and expanding spread
财资与风险管理
营运资本管理
CASH CONVERSION CYCLE:
CCC = DSO + DIO - DPO
DSO (Days Sales Outstanding) = AR / (Revenue/365)
DIO (Days Inventory Outstanding) = Inventory / (COGS/365)
DPO (Days Payable Outstanding) = AP / (COGS/365)
OPTIMIZATION LEVERS:
- Accelerate collections (DSO reduction)
- Improve inventory turns (DIO reduction)
- Extend payment terms (DPO increase)
- Supply chain financing
对冲策略
| 风险类型 | 对冲工具 | 策略 |
|---|---|---|
| 外汇风险 | 远期合约、期权、互换 | 自然对冲、滚动对冲 |
| 利率风险 | 互换、上限、下限 | 固定利率/浮动利率组合 |
| 大宗商品风险 | 期货、期权 | 确保投入品成本稳定 |
| 信用风险 | CDS、保险 | 交易对手保护 |
资本结构优化
OPTIMAL CAPITAL STRUCTURE:
Balance:
- Tax shield benefits of debt
- Bankruptcy/distress costs
- Financial flexibility
- Credit rating implications
CREDIT METRICS TARGETS:
Investment Grade:
- Debt/EBITDA: 2-3x
- Interest Coverage: > 5x
- FFO/Debt: > 30%
High Yield:
- Debt/EBITDA: 4-6x
- Interest Coverage: > 2x
- FFO/Debt: 15-25%
投资者关系
财报电话会议准备
KEY COMPONENTS:
1. Prepared remarks (10-15 min)
- Financial highlights
- Operational performance
- Strategic updates
- Guidance
2. Q&A preparation
- Anticipated questions
- Approved responses
- Escalation protocols
3. Supplemental materials
- Earnings release
- Investor presentation
- Financial supplement
业绩指引框架
| 指引类型 | 频率 | 具体程度 |
|---|---|---|
| 收入 | 每季度 | 范围 |
| EPS | 每季度 | 范围 |
| 现金流 | 每年 | 目标 |
| CapEx | 每年 | 范围 |
| 长期目标 | 投资者日 | 方向性 |
财务规划与分析
滚动预测模型
FREQUENCY: Monthly or Quarterly
HORIZON: 12-18 months rolling
COMPONENTS:
- Revenue by segment/product
- Gross margin drivers
- Operating expense detail
- Working capital assumptions
- CapEx plan
- Cash flow projection
VARIANCE ANALYSIS:
- Budget vs. Actual
- Prior forecast vs. Current
- Volume vs. Price vs. Mix
预算流程时间表
| 阶段 | 时间 | 活动 |
|---|---|---|
| 战略规划 | Q2 | 更新长期规划 |
| 指引制定 | Q3 | 初步目标 |
| 详细预算编制 | Q3-Q4 | 自下而上的计划 |
| 审核与批准 | Q4 | 高管/董事会批准 |
| 沟通 | Q4 | 逐级下达目标 |
另请参阅
评论
支持 Markdown