Finance Travisjneuman Claude 2

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

## See Also

- [Fortune 50 Business Strategy](../fortune50-business-strategy/SKILL.md)
- [Fortune 50 Risk Management](../fortune50-risk-management/SKILL.md)
- [Fortune 50 Operations](../fortune50-operations/SKILL.md)