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

DCF Model Template

Year	1	2	3	4	5	Terminal
Revenue
Growth %
EBITDA
Margin %
D&A
EBIT
Tax
NOPAT
+ D&A
- CapEx
- NWC Change
UFCF
Discount Factor
PV of UFCF

Comparable Company Analysis

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)

Precedent Transaction Analysis

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

Sum-of-the-Parts (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

Leveraged Buyout (LBO) Analysis

LBO Model Structure

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 Returns Framework

IRR Target	Hold Period	Required MOIC
20%	3 years	1.7x
20%	5 years	2.5x
25%	3 years	2.0x
25%	5 years	3.0x

Value Creation Sources

                        % 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

M&A Financial Analysis

Accretion/Dilution Analysis

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

Synergy Analysis

Synergy Type	Typical Range	Realization Timeline
Cost Synergies	5-15% of target costs	1-3 years
Revenue Synergies	2-5% of combined revenue	2-5 years

Deal Structure Considerations

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

Capital Allocation Framework

Capital Allocation Hierarchy

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

Treasury & Risk Management

Working Capital Management

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

Hedging Strategies

Risk Type	Hedging Instruments	Strategy
FX Risk	Forwards, Options, Swaps	Natural hedging, rolling hedge
Interest Rate	Swaps, Caps, Floors	Fixed/floating mix
Commodity	Futures, Options	Cost certainty for inputs
Credit	CDS, Insurance	Counterparty protection

Capital Structure Optimization

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%

Investor Relations

Earnings Call Preparation

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

Guidance Framework

Guidance Type	Frequency	Specificity
Revenue	Quarterly	Range
EPS	Quarterly	Range
Cash Flow	Annual	Target
CapEx	Annual	Range
Long-term Targets	Investor Day	Directional

Financial Planning & Analysis

Rolling Forecast Model

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

Budget Process Timeline

Phase	Timing	Activities
Strategic Planning	Q2	Long-range plan update
Guidance Setting	Q3	Preliminary targets
Detailed Budgeting	Q3-Q4	Bottom-up plans
Review & Approval	Q4	Executive/Board approval
Communication	Q4	Cascaded targets

finance

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

Financial Statement Analysis

DuPont Analysis (5-Factor)

Key Financial Ratios

Cash Flow Analysis

Valuation Methodologies

Discounted Cash Flow (DCF)

DCF Model Template

Comparable Company Analysis

Precedent Transaction Analysis

Sum-of-the-Parts (SOTP)

Leveraged Buyout (LBO) Analysis

LBO Model Structure

LBO Returns Framework

Value Creation Sources

M&A Financial Analysis

Accretion/Dilution Analysis

Synergy Analysis

Deal Structure Considerations

Capital Allocation Framework

Capital Allocation Hierarchy

Investment Hurdle Rates

ROIC vs WACC Framework

Treasury & Risk Management

Working Capital Management

Hedging Strategies

Capital Structure Optimization

Investor Relations

Earnings Call Preparation

Guidance Framework

Financial Planning & Analysis

Rolling Forecast Model

Budget Process Timeline

See Also

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.