mcpField
F
finance

finance

github.com/travisjneuman其他106376 次安装1 天前更新
代码仓库

关于 finance

面向财务团队和分析师的金融分析技能,涵盖财务报表分析、估值、公司财务、风险管理和规划框架。

主要功能

  1. 01财务比率与现金流分析
  2. 02DCF 与可比公司估值
  3. 03LBO 与并购建模框架
  4. 04资本配置与风险分析
  5. 05预测与预算框架

适用场景

  1. 01分析企业财务状况
  2. 02构建估值模型
  3. 03评估收购或 LBO
  4. 04编制预测与预算

安装

复制下面的命令,在终端中运行。

$npx skills add https://github.com/travisjneuman/.claude --skill finance

安装后在 Claude Code 中输入/finance确认已加载。

包含的文件

除 SKILL.md 外,安装时一起下载的参考资料和脚本。

references/
corporate-finance-expert.md
financial-modeling-master.md
ma-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%(因情况而异)
ROICNOPAT / 投入资本> WACC
ROE净利润 / 权益15-20%+
流动性流动比率流动资产 / 流动负债1.5-2.0x
速动比率(CA - Inventory) / CL1.0x+
现金比率现金 / 流动负债0.2-0.5x
杠杆债务/权益总债务 / 总权益< 1.0x
债务/EBITDA总债务 / EBITDA2-3x(IG),4-6x(HY)
利息保障倍数EBIT / 利息费用> 3x
效率资产周转率收入 / 总资产因行业而异
存货天数存货 / (COGS/365)因行业而异
DSOAR / (收入/365)30-45 天
DPOAP / (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 模型模板
年份12345终值
收入
增长率
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
投资门槛收益率
投资类型典型门槛风险溢价
维护性 CapExWACC无
增长性 CapExWACC + 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