# DCF Valuation Model Template

**Purpose:** Build a Discounted Cash Flow (DCF) model to determine the intrinsic value of a business based on projected future cash flows discounted to present value.

**Time to Complete:** 4-6 hours (with financial data available)

**Difficulty Level:** Advanced

**Team Size:** Solo or 2-3 person financial team

---

## Introduction

The DCF valuation model is a fundamental financial tool that estimates a company's value based on its ability to generate future cash flows. Unlike market-based valuations that rely on comparable companies or transactions, DCF attempts to calculate intrinsic value independent of market sentiment.

### When to Use DCF

- **Investment decisions**: Evaluating whether a stock is overvalued or undervalued
- **M&A transactions**: Determining fair acquisition price
- **Strategic planning**: Understanding value creation drivers
- **Capital allocation**: Prioritizing projects based on value creation
- **Fundraising**: Justifying valuation to investors

### Key Assumptions

DCF models are only as good as their assumptions. The most critical inputs are:
1. Revenue growth rate (near-term and terminal)
2. Operating margins and cost structure
3. Capital expenditure and working capital needs
4. Discount rate (WACC - Weighted Average Cost of Capital)
5. Terminal value assumptions (perpetual growth or exit multiple)

**Warning:** Small changes in assumptions can dramatically impact valuation. Always perform sensitivity analysis.

---

## DCF Model Structure Overview

A complete DCF model contains five core components:

```
1. Revenue Projections → 2. Operating Model → 3. Free Cash Flow
                                                      ↓
                                          4. Terminal Value ← 5. Discount Rate (WACC)
                                                      ↓
                                              Enterprise Value
                                                      ↓
                                          - Net Debt + Cash = Equity Value
```

### Model Timeline

- **Years 1-5**: Detailed annual projections with explicit assumptions
- **Years 6-10**: Simplified projections with declining growth to steady state
- **Terminal Year**: Perpetual cash flow representing business as ongoing concern

---

## Step-by-Step Instructions

### Step 1: Revenue Forecasting

Build revenue projections based on business drivers, not arbitrary growth rates.

**For Years 1-5 (Detailed Forecast):**

| Revenue Driver | Year 0 (Base) | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
|----------------|---------------|--------|--------|--------|--------|--------|
| **Customer Base** | [10,000] | [12,500] | [15,625] | [19,531] | [24,414] | [30,517] |
| Growth Rate (%) | - | 25% | 25% | 25% | 25% | 25% |
| **Avg Revenue/Customer** | [$1,200] | [$1,260] | [$1,323] | [$1,389] | [$1,459] | [$1,532] |
| Price Growth (%) | - | 5% | 5% | 5% | 5% | 5% |
| **Total Revenue** | $12.0M | $15.8M | $20.7M | $27.1M | $35.6M | $46.8M |
| **YoY Growth (%)** | - | 31.3% | 31.3% | 31.3% | 31.3% | 31.3% |

**For Years 6-10 (Simplified Forecast):**

| Year | Revenue | Growth Rate | Notes |
|------|---------|-------------|-------|
| 6 | [$58.5M] | 25% → 20% | Growth begins decelerating |
| 7 | [$70.2M] | 20% | Mature market competition |
| 8 | [$80.7M] | 15% | Market saturation effects |
| 9 | [$88.8M] | 10% | Approaching steady state |
| 10 | [$93.2M] | 5% | Terminal growth rate |

**Instructions:**
1. Identify 2-3 key revenue drivers (customers, units, subscribers, etc.)
2. Project each driver independently based on market size, competition, sales capacity
3. Multiply drivers to calculate revenue (avoid circular assumptions)
4. Validate growth rates against market benchmarks
5. Decelerate growth over time (gravity always wins)

---

### Step 2: Operating Margin Assumptions

Project costs and operating margins based on business model economics.

| Cost Category | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 10 |
|---------------|--------|--------|--------|--------|--------|---------|
| **Revenue** | $15.8M | $20.7M | $27.1M | $35.6M | $46.8M | $93.2M |
| **COGS** | 20% | 18% | 17% | 16% | 15% | 15% |
| Gross Profit | 80% | 82% | 83% | 84% | 85% | 85% |
| **R&D** | 18% | 16% | 15% | 14% | 13% | 10% |
| **Sales & Marketing** | 35% | 32% | 30% | 28% | 26% | 20% |
| **G&A** | 12% | 11% | 10% | 9% | 8% | 8% |
| **EBITDA Margin** | 15% | 23% | 28% | 33% | 38% | 47% |
| **EBITDA ($)** | $2.4M | $4.8M | $7.6M | $11.7M | $17.8M | $43.8M |

**Key Assumptions:**
- **Gross Margin**: Improves with scale (automation, vendor discounts)
- **R&D**: Decreases as % of revenue as product matures
- **Sales & Marketing**: Decreases as brand builds, CAC improves
- **G&A**: Fixed costs leverage over growing revenue

**Benchmark Guidance:**
- **SaaS**: Gross margin 75-85%, EBITDA margin 20-40% at scale
- **E-commerce**: Gross margin 30-50%, EBITDA margin 5-15% at scale
- **Manufacturing**: Gross margin 25-40%, EBITDA margin 10-20% at scale

---

### Step 3: Working Capital and Capital Expenditures

Calculate cash requirements beyond operating expenses.

**Working Capital Calculation:**

| Line Item | % of Revenue | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
|-----------|--------------|--------|--------|--------|--------|--------|
| **Accounts Receivable** | 8% (45 days) | $1.3M | $1.7M | $2.2M | $2.8M | $3.7M |
| **Inventory** | 5% | $0.8M | $1.0M | $1.4M | $1.8M | $2.3M |
| **Accounts Payable** | (6%) | ($0.9M) | ($1.2M) | ($1.6M) | ($2.1M) | ($2.8M) |
| **Net Working Capital** | 7% | $1.1M | $1.4M | $1.9M | $2.5M | $3.3M |
| **Change in NWC** | - | ($1.1M) | ($0.3M) | ($0.5M) | ($0.6M) | ($0.8M) |

**Capital Expenditures:**

| Type | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 10 |
|------|--------|--------|--------|--------|--------|---------|
| **Maintenance Capex** | 2% rev | 2% rev | 2% rev | 2% rev | 2% rev | 2% rev |
| **Growth Capex** | $1.0M | $1.5M | $2.0M | $1.5M | $1.0M | $0.5M |
| **Total Capex** | ($1.3M) | ($1.9M) | ($2.5M) | ($2.2M) | ($1.9M) | ($2.4M) |

**Instructions:**
1. Calculate working capital as % of revenue (industry-specific)
2. Change in working capital is a cash outflow (uses cash as business grows)
3. Separate maintenance capex (sustaining) from growth capex (expanding)
4. Growth capex should decline as business matures

---

### Step 4: Free Cash Flow Calculation Worksheet

Calculate unlevered free cash flow (cash available to all capital providers).

| Line Item | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
|-----------|--------|--------|--------|--------|--------|
| **Revenue** | $15.8M | $20.7M | $27.1M | $35.6M | $46.8M |
| EBITDA | $2.4M | $4.8M | $7.6M | $11.7M | $17.8M |
| - D&A | ($0.5M) | ($0.7M) | ($0.9M) | ($1.2M) | ($1.5M) |
| **EBIT** | $1.9M | $4.1M | $6.7M | $10.5M | $16.3M |
| - Taxes (25%) | ($0.5M) | ($1.0M) | ($1.7M) | ($2.6M) | ($4.1M) |
| **NOPAT** | $1.4M | $3.1M | $5.0M | $7.9M | $12.2M |
| + D&A | $0.5M | $0.7M | $0.9M | $1.2M | $1.5M |
| - Capex | ($1.3M) | ($1.9M) | ($2.5M) | ($2.2M) | ($1.9M) |
| - Δ NWC | ($1.1M) | ($0.3M) | ($0.5M) | ($0.6M) | ($0.8M) |
| **Free Cash Flow** | ($0.5M) | $1.6M | $2.9M | $6.3M | $11.0M |

**Formula:** FCF = NOPAT + D&A - Capex - Δ Working Capital

**Notes:**
- Negative FCF in early years is common for high-growth businesses
- FCF should turn positive as growth moderates and margins expand
- Use tax rate appropriate to business (statutory rate, not effective rate)

---

### Step 5: Terminal Value Calculation

Terminal value typically represents 50-80% of total enterprise value.

**Method 1: Perpetuity Growth Method**

```
Terminal Value = Final Year FCF × (1 + g) / (WACC - g)

Where:
- Final Year FCF = $18.5M (Year 10)
- g = Perpetual growth rate (2-3%, typically GDP growth)
- WACC = 10% (calculated in Step 6)

Terminal Value = $18.5M × 1.03 / (0.10 - 0.03)
Terminal Value = $19.1M / 0.07
Terminal Value = $272.1M
```

**Method 2: Exit Multiple Method**

```
Terminal Value = Final Year EBITDA × Exit Multiple

Where:
- Final Year EBITDA = $43.8M (Year 10)
- Exit Multiple = 10x (based on comparable companies)

Terminal Value = $43.8M × 10
Terminal Value = $438.0M
```

**Method 3: Comparable Companies Method**

| Metric | Company A | Company B | Company C | Median | Your Co (Year 10) |
|--------|-----------|-----------|-----------|--------|-------------------|
| **EV/Revenue** | 6.0x | 8.5x | 7.2x | 7.2x | $93.2M × 7.2 = $671M |
| **EV/EBITDA** | 12.0x | 15.5x | 13.8x | 13.8x | $43.8M × 13.8 = $604M |
| **EV/FCF** | 18.0x | 22.0x | 20.5x | 20.5x | $18.5M × 20.5 = $379M |

**Recommended Approach:**
1. Calculate terminal value using all three methods
2. Cross-check for reasonableness
3. Use average or triangulate based on confidence in assumptions
4. Conservative: Use perpetuity growth method (lowest value)
5. Aggressive: Use exit multiple method (highest value)

**Example Blended Terminal Value:**
- Weight perpetuity growth: 50% × $272M = $136M
- Weight exit multiple: 30% × $438M = $131M
- Weight comparables: 20% × $604M = $121M
- **Blended Terminal Value: $388M**

---

### Step 6: Discount Rate (WACC) Calculation

WACC represents the weighted average cost of capital from debt and equity.

**WACC Formula:**
```
WACC = (E/V × Re) + (D/V × Rd × (1-Tc))

Where:
E = Market value of equity
D = Market value of debt
V = E + D (total value)
Re = Cost of equity
Rd = Cost of debt
Tc = Corporate tax rate
```

**Cost of Equity (CAPM Method):**
```
Re = Rf + β × (Rm - Rf)

Where:
Rf = Risk-free rate (10-year Treasury) = 4.5%
β = Beta (stock volatility vs. market) = 1.3
Rm = Expected market return = 10%

Re = 4.5% + 1.3 × (10% - 4.5%)
Re = 4.5% + 7.15%
Re = 11.65%
```

**Cost of Debt:**
```
Rd = Interest rate on debt = 6.0%
After-tax Rd = 6.0% × (1 - 0.25) = 4.5%
```

**WACC Calculation Example:**

| Component | Market Value | % of Total | Cost | Weighted Cost |
|-----------|--------------|------------|------|---------------|
| **Equity** | $100M | 80% | 11.65% | 9.32% |
| **Debt** | $25M | 20% | 4.5% (after-tax) | 0.90% |
| **Total** | $125M | 100% | - | **10.22%** |

**WACC Guidance by Industry:**
- **High-growth tech/SaaS**: 10-15%
- **Stable software**: 8-12%
- **E-commerce**: 9-13%
- **Manufacturing**: 7-10%
- **Utilities**: 5-8%

**Instructions:**
1. For private companies, use comparable public company betas
2. Adjust beta for leverage differences
3. Add size premium (2-4%) for small companies
4. Add country risk premium for international businesses
5. Round to nearest 0.5% for simplicity

---

### Step 7: NPV Calculation and Enterprise Value

Discount all cash flows to present value.

**Present Value of Projected Cash Flows:**

| Year | Free Cash Flow | Discount Factor (10%) | Present Value |
|------|----------------|-----------------------|---------------|
| 1 | ($0.5M) | 1 / (1.10)^1 = 0.909 | ($0.5M) |
| 2 | $1.6M | 1 / (1.10)^2 = 0.826 | $1.3M |
| 3 | $2.9M | 1 / (1.10)^3 = 0.751 | $2.2M |
| 4 | $6.3M | 1 / (1.10)^4 = 0.683 | $4.3M |
| 5 | $11.0M | 1 / (1.10)^5 = 0.621 | $6.8M |
| 6 | $13.5M | 1 / (1.10)^6 = 0.564 | $7.6M |
| 7 | $15.8M | 1 / (1.10)^7 = 0.513 | $8.1M |
| 8 | $17.5M | 1 / (1.10)^8 = 0.467 | $8.2M |
| 9 | $18.2M | 1 / (1.10)^9 = 0.424 | $7.7M |
| 10 | $18.5M | 1 / (1.10)^10 = 0.386 | $7.1M |
| **Total PV of Projected FCF** | | | **$52.8M** |

**Present Value of Terminal Value:**

```
Terminal Value (Year 10) = $388.0M
Discount Factor = 1 / (1.10)^10 = 0.386
PV of Terminal Value = $388.0M × 0.386 = $149.8M
```

**Enterprise Value Calculation:**

| Component | Value |
|-----------|-------|
| PV of Projected Cash Flows (Years 1-10) | $52.8M |
| PV of Terminal Value | $149.8M |
| **Enterprise Value** | **$202.6M** |
| - Net Debt | ($10.0M) |
| + Cash | $5.0M |
| **Equity Value** | **$197.6M** |
| Shares Outstanding | 10M |
| **Value per Share** | **$19.76** |

**Sanity Checks:**
- Terminal value % of enterprise value: $149.8M / $202.6M = **74%** (reasonable: 50-80%)
- Implied exit multiple: $202.6M / $46.8M (Year 5 revenue) = **4.3x** (compare to industry)
- Implied FCF yield: $18.5M / $202.6M = **9.1%** (should be < WACC of 10%)

---

## Example DCF Models

### Example 1: SaaS Company

**Business Characteristics:**
- Recurring subscription revenue (annual contracts)
- High gross margins (85%)
- Negative cash flow early (customer acquisition costs)
- Low capex (cloud-based)
- Minimal working capital

| Metric | Year 1 | Year 3 | Year 5 | Year 10 |
|--------|--------|--------|--------|---------|
| Revenue | $10M | $25M | $55M | $150M |
| Growth Rate | 50% | 40% | 30% | 10% |
| Gross Margin | 82% | 85% | 87% | 88% |
| EBITDA Margin | 5% | 25% | 40% | 50% |
| Free Cash Flow | ($2M) | $4M | $18M | $60M |
| WACC | 12% | 12% | 12% | 12% |

**Key Drivers:**
- ARR (Annual Recurring Revenue) growth
- Net revenue retention (110%+)
- Customer acquisition cost payback period (<18 months)
- Rule of 40: Growth % + FCF Margin % > 40%

**Valuation:** $450M enterprise value (3x Year 5 revenue, 8x Year 5 FCF)

---

### Example 2: E-Commerce Company

**Business Characteristics:**
- Transaction-based revenue
- Moderate gross margins (40%)
- High working capital needs (inventory)
- Moderate capex (warehouses, logistics)
- Seasonal cash flow patterns

| Metric | Year 1 | Year 3 | Year 5 | Year 10 |
|--------|--------|--------|--------|---------|
| Revenue | $50M | $85M | $125M | $200M |
| Growth Rate | 35% | 20% | 12% | 5% |
| Gross Margin | 38% | 42% | 44% | 46% |
| EBITDA Margin | 8% | 12% | 15% | 18% |
| Free Cash Flow | $1M | $5M | $10M | $22M |
| WACC | 11% | 11% | 11% | 11% |

**Key Drivers:**
- GMV (Gross Merchandise Value) growth
- Take rate (% of GMV captured as revenue)
- Fulfillment cost efficiency
- Inventory turns (6-8x per year)

**Valuation:** $185M enterprise value (1.5x Year 5 revenue, 18x Year 5 FCF)

---

### Example 3: B2B Software (License Model)

**Business Characteristics:**
- Upfront perpetual licenses + maintenance revenue
- High gross margins (80%+)
- Lumpy revenue (large deals)
- High sales costs
- Customer concentration risk

| Metric | Year 1 | Year 3 | Year 5 | Year 10 |
|--------|--------|--------|--------|---------|
| Revenue | $20M | $32M | $48M | $75M |
| Growth Rate | 25% | 20% | 15% | 8% |
| Gross Margin | 78% | 82% | 84% | 85% |
| EBITDA Margin | 18% | 28% | 35% | 42% |
| Free Cash Flow | $2M | $7M | $14M | $26M |
| WACC | 10% | 10% | 10% | 10% |

**Key Drivers:**
- New license bookings
- Maintenance renewal rate (90%+)
- Deal size and sales cycle
- Enterprise vs. SMB customer mix

**Valuation:** $275M enterprise value (5.7x Year 5 revenue, 20x Year 5 FCF)

---

## Sensitivity Analysis

Small assumption changes can dramatically impact valuation. Always test key variables.

### Two-Way Sensitivity Table: Revenue Growth vs. EBITDA Margin

**Base Case:** Revenue CAGR = 25%, EBITDA Margin = 35%, Valuation = $202.6M

| Revenue Growth → <br> EBITDA Margin ↓ | 15% | 20% | 25% | 30% | 35% |
|---------------------------------------|-----|-----|-----|-----|-----|
| **25%** | $98M | $135M | $168M | $198M | $225M |
| **30%** | $115M | $156M | $193M | $228M | $260M |
| **35%** | $132M | $178M | $219M | $258M | $295M |
| **40%** | $150M | $201M | $246M | $290M | $332M |
| **45%** | $169M | $225M | $275M | $324M | $371M |

**Interpretation:**
- 10% change in revenue growth: ±$50M valuation swing (±25%)
- 10% change in margin: ±$70M valuation swing (±35%)
- **Margin matters more than growth** for this business model

---

### Two-Way Sensitivity Table: Discount Rate vs. Terminal Growth Rate

**Base Case:** WACC = 10%, Terminal Growth = 3%, Valuation = $202.6M

| WACC → <br> Terminal Growth ↓ | 8% | 9% | 10% | 11% | 12% |
|-------------------------------|----|----|-----|-----|-----|
| **1.5%** | $268M | $235M | $210M | $189M | $172M |
| **2.0%** | $282M | $246M | $218M | $196M | $178M |
| **2.5%** | $298M | $258M | $227M | $203M | $184M |
| **3.0%** | $315M | $271M | $237M | $211M | $190M |
| **3.5%** | $334M | $285M | $247M | $219M | $197M |

**Interpretation:**
- 1% change in WACC: ±$35M valuation swing (±17%)
- 1% change in terminal growth: ±$27M valuation swing (±13%)
- **WACC and terminal assumptions are highly sensitive**

---

### Key Value Drivers (Tornado Chart Concept)

Rank assumptions by impact on valuation:

| Assumption | Low Case | Base Case | High Case | Valuation Range |
|------------|----------|-----------|-----------|-----------------|
| **Terminal EBITDA Multiple** | 8x | 10x | 12x | $165M - $240M |
| **Year 5 EBITDA Margin** | 30% | 38% | 45% | $178M - $227M |
| **WACC** | 12% | 10% | 8% | $172M - $268M |
| **Revenue CAGR (Yrs 1-5)** | 20% | 28% | 35% | $185M - $220M |
| **Terminal Growth Rate** | 2% | 3% | 4% | $195M - $222M |

**Priority Focus:**
1. **Terminal value assumptions** (multiple and growth rate) - Highest impact
2. **Operating margin trajectory** - Second highest impact
3. **Discount rate** - Requires careful benchmarking
4. **Revenue growth** - Important but less sensitive than margins

**Action:** Spend 80% of due diligence time on top 3 value drivers.

---

## Common Mistakes and How to Avoid

### Mistake 1: Overly Optimistic Growth Assumptions

**Problem:** Projecting 50% annual growth for 10 years (32x growth) without market constraints.

**Reality Check:**
- Analyze total addressable market (TAM)
- Calculate implied market share by Year 10
- Review historical growth rates of comparable companies
- Apply "gravity" - growth always decelerates

**Fix:** Use bottoms-up revenue model (customers × price) and cap at reasonable market share.

---

### Mistake 2: Ignoring Working Capital Impact

**Problem:** Assuming all EBITDA converts to cash without working capital investment.

**Impact Example:**
- Revenue grows from $50M to $100M (100% growth)
- Working capital = 10% of revenue
- Working capital increase = $5M cash outflow
- FCF reduced by $5M compared to EBITDA

**Fix:** Explicitly model accounts receivable, inventory, and payables as % of revenue.

---

### Mistake 3: Terminal Value Assumptions

**Problem:** Terminal value represents 50-80% of valuation but receives minimal scrutiny.

**Common Errors:**
- Using perpetual growth rate > GDP growth (2-3%)
- Using exit multiples from peak markets
- Ignoring competitive dynamics in mature phase

**Fix:**
- Cap terminal growth at 2-3% (long-term GDP growth)
- Use trough multiple, not peak multiple, for exit
- Cross-check terminal value reasonableness (should be ~5-15x terminal FCF)

**Terminal Value Sanity Check:**

| Terminal Value Method | Implied Multiple | Reasonableness |
|-----------------------|------------------|----------------|
| Perpetuity Growth (3%) | $272M / $18.5M FCF = 14.7x | High but defensible for quality business |
| Exit Multiple (10x EBITDA) | $438M / $18.5M FCF = 23.7x | Too high - implies aggressive exit |
| Blended Approach | $388M / $18.5M FCF = 21.0x | Moderately aggressive |

**Recommendation:** Use conservative perpetuity method or stress-test with lower multiples.

---

### Mistake 4: Discount Rate Selection

**Problem:** Using cost of equity (12-15%) instead of WACC (9-11%) inflates discount rate.

**Impact:**
- Using 15% instead of 10% discount rate
- Reduces valuation by ~30-40%

**Fix:**
- Use WACC (blended cost of debt and equity)
- Add size premium for small companies (2-4%)
- Benchmark against comparable companies
- Don't inflate discount rate to account for risk - model risk explicitly

---

### Mistake 5: Revenue Growth Without Investment

**Problem:** Projecting 30% revenue growth without increasing capex or working capital.

**Reality:** Growth requires investment:
- **Sales & marketing**: Customer acquisition
- **Capex**: Infrastructure, capacity expansion
- **Working capital**: Inventory, receivables
- **R&D**: Product development

**Fix:** For every 1% of revenue growth, model appropriate investment levels:
- High-growth SaaS: 40-50% of incremental revenue → S&M + R&D
- E-commerce: 15-25% of incremental revenue → working capital + capex
- Manufacturing: 25-35% of incremental revenue → capex + working capital

---

## DCF Model Checklist

Before finalizing your DCF model, verify:

**Revenue Assumptions:**
- [ ] Bottoms-up revenue model (drivers × assumptions)
- [ ] Market size analysis supports growth projections
- [ ] Growth rates decelerate over time
- [ ] Year 10 revenue implies reasonable market share (<30%)

**Operating Model:**
- [ ] Gross margin assumptions benchmarked to industry
- [ ] Operating leverage modeled (margins expand with scale)
- [ ] Cost structure validated against comparable companies
- [ ] EBITDA margin progression is realistic

**Cash Flow Assumptions:**
- [ ] Working capital modeled as % of revenue
- [ ] Capex separated into maintenance and growth
- [ ] Growth capex declines as business matures
- [ ] Free cash flow turns positive within 5 years

**Terminal Value:**
- [ ] Perpetual growth rate ≤ 3% (GDP growth)
- [ ] Exit multiple benchmarked to comparable companies
- [ ] Terminal value represents 50-80% of enterprise value
- [ ] Terminal FCF yield < WACC (otherwise model is broken)

**Discount Rate:**
- [ ] WACC calculated using market value weights
- [ ] Cost of equity uses CAPM or build-up method
- [ ] Beta adjusted for leverage and industry
- [ ] Size premium added for small companies

**Valuation Output:**
- [ ] Sensitivity analysis performed on key assumptions
- [ ] Valuation compared to market multiples (EV/Revenue, EV/EBITDA)
- [ ] Implied multiples are reasonable
- [ ] Downside scenario modeled (stress test)

---

## Notes and Customization

[INSERT COMPANY-SPECIFIC ASSUMPTIONS HERE]

**Industry:** [e.g., SaaS, E-commerce, Manufacturing]

**Key Value Drivers:**
1. [e.g., ARR growth rate]
2. [e.g., Customer acquisition cost]
3. [e.g., Gross margin expansion]

**Comparable Companies:**
1. [Company A] - EV/Revenue: [X]x, EV/EBITDA: [Y]x
2. [Company B] - EV/Revenue: [X]x, EV/EBITDA: [Y]x
3. [Company C] - EV/Revenue: [X]x, EV/EBITDA: [Y]x

**Risk Factors:**
- [e.g., Customer concentration - top 3 customers = 45% of revenue]
- [e.g., Technology disruption risk]
- [e.g., Competitive intensity increasing]

**Valuation Summary:**

| Scenario | Enterprise Value | Equity Value | Per Share | Implied Multiple |
|----------|------------------|--------------|-----------|------------------|
| **Bull Case** | [____] | [____] | [____] | [____] |
| **Base Case** | $202.6M | $197.6M | $19.76 | 4.3x Rev |
| **Bear Case** | [____] | [____] | [____] | [____] |

---

## Additional Resources

**Recommended Reading:**
- "Valuation" by McKinsey & Company
- "Investment Valuation" by Aswath Damodaran
- "Valuation Techniques" by CFA Institute

**Online Tools:**
- Damodaran Online (http://pages.stern.nyu.edu/~adamodar/) - Beta, WACC, and multiple databases
- FRED Economic Data - Risk-free rate and economic data
- Yahoo Finance - Comparable company data

**Excel Best Practices:**
- Color-code assumptions (blue), calculations (black), outputs (green)
- Use named ranges for key assumptions
- Link summary sheet to detailed worksheets
- Version control and assumption change tracking

---

*This template provides a comprehensive framework for DCF valuation. Adapt assumptions and structure based on your specific business model, industry, and use case. Remember: DCF is only as good as your assumptions - be conservative and test sensitivities.*