Financial analysis expertise for financial modeling (DCF, LBO, M&A), valuation, financial statement analysis, capital allocation, treasury management, and corporate finance decisions. Use when building financial models, analyzing statements, or making investment decisions.
📖 中文导读:Financial analysis expertise for financial modeling (DCF, LBO, M&A), valuation, financial statement analysis, capital allocation, treasury management, and corporate finance decisions. Use when building financial models, analyzing statements, or making investment decisions. 以下正文为该技能的原始 SKILL.md 内容(英文),上方安装命令可直接使用。
name: finance
description: Financial analysis expertise for financial modeling (DCF, LBO, M&A), valuation, financial statement analysis, capital allocation, treasury management, and corporate finance decisions. Use when building financial models, analyzing statements, or making investment decisions.
Financial Analysis Expert
Comprehensive financial frameworks for modeling, valuation, and corporate finance decisions.
Financial Statement Analysis
DuPont Analysis (5-Factor)
Decompose ROE into operational drivers:
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
Key Financial Ratios
Category
Ratio
Formula
Benchmark
Profitability
Gross Margin
Gross Profit / Revenue
Industry specific
Operating Margin
EBIT / Revenue
15-25% (varies)
Net Margin
Net Income / Revenue
10-20% (varies)
ROIC
NOPAT / Invested Capital
> WACC
ROE
Net Income / Equity
15-20%+
Liquidity
Current Ratio
Current Assets / Current Liabilities
1.5-2.0x
Quick Ratio
(CA - Inventory) / CL
1.0x+
Cash Ratio
Cash / Current Liabilities
0.2-0.5x
Leverage
Debt/Equity
Total Debt / Total Equity
< 1.0x
Debt/EBITDA
Total Debt / EBITDA
2-3x (IG), 4-6x (HY)
Interest Coverage
EBIT / Interest Expense
> 3x
Efficiency
Asset Turnover
Revenue / Total Assets
Industry specific
Inventory Days
Inventory / (COGS/365)
Industry specific
DSO
AR / (Revenue/365)
30-45 days
DPO
AP / (COGS/365)
30-60 days
Cash Flow Analysis
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
Valuation Methodologies
Discounted 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
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
Investment Hurdle Rates
Investment Type
Typical Hurdle
Risk Premium
Maintenance CapEx
WACC
None
Growth CapEx
WACC + 2-3%
Low
Domestic M&A
WACC + 3-5%
Medium
International M&A
WACC + 5-8%
High
Venture/Innovation
25-30% IRR
Very High
ROIC vs WACC Framework
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
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