# Capital Structure Optimization Worksheet

## Overview
Capital Structure Optimization is the process of determining the ideal mix of debt and equity financing to maximize firm value while minimizing the cost of capital. This worksheet helps analyze your current capital structure and identify optimization opportunities.

## Current Capital Structure Analysis

### Current Financing Mix
**Equity Components:**
- Common Stock: $_________ (____%)
- Preferred Stock: $_________ (____%)
- Retained Earnings: $_________ (____%)
- Total Equity: $_________ (____%)

**Debt Components:**
- Short-term Debt: $_________ (____%)
- Long-term Debt: $_________ (____%)
- Bonds: $_________ (____%)
- Other Debt: $_________ (____%)
- Total Debt: $_________ (____%)

**Total Capital:** $_________

### Key Ratios
- Debt-to-Equity Ratio: _____
- Debt-to-Total Capital: _____
- Times Interest Earned: _____
- Debt Service Coverage Ratio: _____
- Return on Equity (ROE): _____
- Return on Assets (ROA): _____

## Cost of Capital Analysis

### Cost of Equity
**Using CAPM (Capital Asset Pricing Model):**
- Risk-free Rate: _____%
- Beta: _____
- Market Risk Premium: _____%
- Cost of Equity = Rf + β(Rm - Rf) = _____%

**Using Dividend Growth Model:**
- Current Dividend: $_____
- Growth Rate: _____%
- Current Stock Price: $_____
- Cost of Equity = (D1/P0) + g = _____%

### Cost of Debt
**Current Debt Costs:**
| Debt Type | Amount | Interest Rate | After-Tax Cost |
|-----------|--------|---------------|----------------|
| | $ | % | % |
| | $ | % | % |
| | $ | % | % |
| Weighted Average | | | % |

**Tax Shield Benefit:**
- Corporate Tax Rate: _____%
- Annual Interest Tax Shield: $_____

### Weighted Average Cost of Capital (WACC)
WACC = (E/V × Re) + (D/V × Rd × (1-Tc))
- Current WACC: _____%
- Industry Average WACC: _____%
- Target WACC: _____%

## Risk Assessment

### Business Risk Factors
**Operating Leverage:**
- Fixed Costs / Total Costs: _____%
- Degree of Operating Leverage: _____

**Revenue Stability:**
- Revenue Volatility (σ): _____%
- Customer Concentration: _____%
- Industry Cyclicality: High/Medium/Low

### Financial Risk Factors
**Liquidity Metrics:**
- Current Ratio: _____
- Quick Ratio: _____
- Cash Ratio: _____

**Credit Metrics:**
- Credit Rating: _____
- Interest Coverage: _____x
- Fixed Charge Coverage: _____x

## Optimization Analysis

### Scenario Analysis
| Scenario | D/E Ratio | WACC | EPS Impact | Credit Rating | Financial Flexibility |
|----------|-----------|------|------------|---------------|---------------------|
| Conservative | | % | $ | | High/Med/Low |
| Current | | % | $ | | High/Med/Low |
| Moderate | | % | $ | | High/Med/Low |
| Aggressive | | % | $ | | High/Med/Low |

### Trade-off Considerations

**Benefits of Debt:**
- [ ] Tax shield value: $_____
- [ ] Lower cost than equity
- [ ] No dilution of ownership
- [ ] Disciplinary effect on management

**Costs of Debt:**
- [ ] Financial distress costs
- [ ] Agency costs
- [ ] Loss of financial flexibility
- [ ] Covenant restrictions

### Industry Benchmarking
| Metric | Your Company | Industry Average | Best-in-Class |
|--------|--------------|------------------|---------------|
| D/E Ratio | | | |
| WACC | % | % | % |
| Interest Coverage | x | x | x |
| ROE | % | % | % |
| Credit Rating | | | |

## Strategic Considerations

### Growth Strategy Impact
**Capital Needs for Growth:**
- Organic Growth Requirements: $_____
- M&A Opportunities: $_____
- R&D Investment Needs: $_____
- Working Capital Growth: $_____

**Financing Strategy:**
_________________________________________________________________
_________________________________________________________________

### Market Conditions
**Current Market Environment:**
- Interest Rate Environment: Rising/Stable/Falling
- Equity Market Conditions: Bull/Neutral/Bear
- Credit Market Accessibility: Easy/Normal/Tight
- Industry-Specific Factors: _________________________

### Stakeholder Perspectives
**Equity Holders:**
- Return expectations: _____%
- Risk tolerance: High/Medium/Low
- Dilution sensitivity: High/Medium/Low

**Debt Holders:**
- Covenant requirements: _________________________
- Credit rating targets: _________________________
- Maturity preferences: _________________________

## Optimization Recommendations

### Target Capital Structure
**Recommended Mix:**
- Target Debt Ratio: _____%
- Target Equity Ratio: _____%
- Expected WACC: _____%
- Expected Credit Rating: _____

**Rationale:**
_________________________________________________________________
_________________________________________________________________
_________________________________________________________________

### Implementation Path
**Phase 1 (0-6 months):**
- [ ] _________________________________________________________________
- [ ] _________________________________________________________________
- [ ] _________________________________________________________________

**Phase 2 (6-12 months):**
- [ ] _________________________________________________________________
- [ ] _________________________________________________________________
- [ ] _________________________________________________________________

**Phase 3 (12+ months):**
- [ ] _________________________________________________________________
- [ ] _________________________________________________________________
- [ ] _________________________________________________________________

## Risk Mitigation

### Contingency Planning
**Stress Test Scenarios:**
- Revenue decline of 20%: Impact _________________________
- Interest rate increase of 200bps: Impact _________________________
- Loss of major customer: Impact _________________________

**Risk Mitigation Strategies:**
1. _________________________________________________________________
2. _________________________________________________________________
3. _________________________________________________________________

### Financial Flexibility Preservation
- Minimum cash balance: $_____
- Unused credit facilities: $_____
- Debt maturity ladder: _________________________
- Covenant headroom targets: _________________________

## Monitoring and Review

### Key Performance Indicators
- [ ] WACC vs Target: Review monthly
- [ ] Credit rating metrics: Review quarterly
- [ ] Market conditions: Review weekly
- [ ] Peer comparisons: Review quarterly

### Review Triggers
- [ ] WACC deviation > 50bps
- [ ] Credit rating watch
- [ ] Major acquisition opportunity
- [ ] Significant market disruption

## Example Application

**Company:** Mid-size Manufacturing Firm
**Current Structure:** 70% Equity, 30% Debt
**Current WACC:** 9.5%

**Optimization Analysis:**
- Increasing debt to 40% reduces WACC to 8.8%
- Maintains investment-grade credit rating
- Provides $50M additional debt capacity for growth
- Annual tax shield increase: $2M

**Implementation:** Issue $50M in 10-year bonds, use proceeds for expansion project with 15% IRR

---
*Date Completed:* _____________
*Completed By:* _____________
*Next Review Date:* _____________