Skill Tracer
Skills › Financial Services › initiating-coverage › task3-valuation.md

task3-valuation.md

698 lines · plugins/vertical-plugins/equity-research/skills/initiating-coverage/references/task3-valuation.md at 6056506

Open on GitHub
1# Task 3: Valuation Analysis - Detailed Workflow
2
3This document provides step-by-step instructions for executing Task 3 (Valuation Analysis) of the initiating-coverage skill.
4

Task 3: Valuation Analysis - Detailed Workflow

This document provides step-by-step instructions for executing Task 3 (Valuation Analysis) of the initiating-coverage skill.

Raw lines 1 to 4
5## Task Overview
6
7**Purpose**: Perform comprehensive valuation using DCF, comparables, and precedent transactions.
8
9**Prerequisites**: ⚠️ Verify before starting
10- **Required**: Financial model from Task 2
11 - Projected income statements
12 - Projected cash flows
13 - Revenue and EBITDA forecasts
14 - DCF inputs (unlevered FCF)
16**⚠️ CRITICAL: DO NOT START THIS TASK UNLESS TASK 2 IS COMPLETE**
18This task requires the financial model from Task 2. Starting without it will result in incomplete work.
20**IF TASK 2 IS NOT COMPLETE**: Stop immediately and inform the user that Task 2 (Financial Modeling) must be completed first. Do not attempt to proceed or create placeholder valuations.
22**Output**: Valuation Analysis (4-6 pages + Excel tabs)
23- DCF analysis with sensitivity tables
24- Comparable companies analysis
25- Precedent transactions (if applicable)
26- Valuation football field
27- Price target and recommendation
29---

Task Overview

Purpose: Perform comprehensive valuation using DCF, comparables, and precedent transactions.

Prerequisites: ⚠️ Verify before starting

  • Required: Financial model from Task 2
  • Projected income statements
  • Projected cash flows
  • Revenue and EBITDA forecasts
  • DCF inputs (unlevered FCF)

⚠️ CRITICAL: DO NOT START THIS TASK UNLESS TASK 2 IS COMPLETE

This task requires the financial model from Task 2. Starting without it will result in incomplete work.

IF TASK 2 IS NOT COMPLETE: Stop immediately and inform the user that Task 2 (Financial Modeling) must be completed first. Do not attempt to proceed or create placeholder valuations.

Output: Valuation Analysis (4-6 pages + Excel tabs)

  • DCF analysis with sensitivity tables
  • Comparable companies analysis
  • Precedent transactions (if applicable)
  • Valuation football field
  • Price target and recommendation
Raw lines 5 to 30
31## Input Verification
33**BEFORE STARTING - CHECK:**
34- [ ] Task 2 complete? (Financial model exists)
35- [ ] Model file path/location known?
36- [ ] Can access projected financials from model?
38**Required from model:**
39- [ ] Projected FCF (5 years)
40- [ ] Revenue projections
41- [ ] EBITDA projections
42- [ ] Terminal year metrics
43- [ ] Balance sheet data (debt, cash, shares)
45**IF VERIFICATION FAILS**: Stop and complete Task 2 (Financial Modeling) before proceeding.
47---

Input Verification

BEFORE STARTING - CHECK:

  • [ ] Task 2 complete? (Financial model exists)
  • [ ] Model file path/location known?
  • [ ] Can access projected financials from model?

Required from model:

  • [ ] Projected FCF (5 years)
  • [ ] Revenue projections
  • [ ] EBITDA projections
  • [ ] Terminal year metrics
  • [ ] Balance sheet data (debt, cash, shares)

IF VERIFICATION FAILS: Stop and complete Task 2 (Financial Modeling) before proceeding.

Raw lines 31 to 48
49## Detailed Methodology Reference
51For deep dive on valuation methodologies, formulas, and theory, see:
52**[valuation-methodologies.md](valuation-methodologies.md)**
54This workflow document focuses on execution steps. Reference the methodology file for:
55- DCF theory and formulas
56- WACC calculation details
57- Terminal value methods
58- Comparable companies theory
59- Precedent transactions theory
61---

Detailed Methodology Reference

For deep dive on valuation methodologies, formulas, and theory, see: valuation-methodologies.md

This workflow document focuses on execution steps. Reference the methodology file for:

  • DCF theory and formulas
  • WACC calculation details
  • Terminal value methods
  • Comparable companies theory
  • Precedent transactions theory
Raw lines 49 to 62
63## Step-by-Step Valuation Workflow

Step-by-Step Valuation Workflow

Raw lines 63 to 64
65### Step 1: Extract Data from Financial Model
67**From Task 2's financial model, extract:**
691. **Projected Financials (5 years)**
70 - Revenue by year (2025E-2029E)
71 - EBITDA by year
72 - EBIT by year
73 - Tax rate
74 - D&A by year
75 - CapEx by year
76 - Change in NWC by year
782. **Unlevered Free Cash Flow**
79 ```
80 Extract from DCF Inputs tab in financial model:
82 2025E 2026E 2027E 2028E 2029E
83 EBIT $XXX $XXX $XXX $XXX $XXX
84 × (1 - Tax Rate)
85 = NOPAT $XXX $XXX $XXX $XXX $XXX
86 + D&A $XXX $XXX $XXX $XXX $XXX
87 - CapEx ($XX) ($XX) ($XX) ($XX) ($XX)
88 - Chg in NWC ($XX) ($XX) ($XX) ($XX) ($XX)
89 = Unlevered FCF $XXX $XXX $XXX $XXX $XXX
90 ```
923. **Balance Sheet Data (current)**
93 - Total debt
94 - Cash & equivalents
95 - Net debt (Debt - Cash)
96 - Diluted shares outstanding
984. **Scenario Data**
99 - Bull case revenue CAGR and terminal margin
100 - Base case revenue CAGR and terminal margin
101 - Bear case revenue CAGR and terminal margin

Step 1: Extract Data from Financial Model

From Task 2's financial model, extract:

  1. Projected Financials (5 years)
  2. Revenue by year (2025E-2029E)
  3. EBITDA by year
  4. EBIT by year
  5. Tax rate
  6. D&A by year
  7. CapEx by year
  8. Change in NWC by year
  1. Unlevered Free Cash Flow ``` Extract from DCF Inputs tab in financial model:

2025E 2026E 2027E 2028E 2029E EBIT $XXX $XXX $XXX $XXX $XXX × (1 - Tax Rate) = NOPAT $XXX $XXX $XXX $XXX $XXX

  • D&A $XXX $XXX $XXX $XXX $XXX
  • CapEx ($XX) ($XX) ($XX) ($XX) ($XX)
  • Chg in NWC ($XX) ($XX) ($XX) ($XX) ($XX) = Unlevered FCF $XXX $XXX $XXX $XXX $XXX ```
  1. Balance Sheet Data (current)
  2. Total debt
  3. Cash & equivalents
  4. Net debt (Debt - Cash)
  5. Diluted shares outstanding
  1. Scenario Data
  2. Bull case revenue CAGR and terminal margin
  3. Base case revenue CAGR and terminal margin
  4. Bear case revenue CAGR and terminal margin
Raw lines 65 to 102
103### Step 2: Build DCF Analysis
105#### A. Calculate WACC
107**1. Determine Risk-Free Rate**
108 - Use 10-year Treasury yield (check current rate)
109 - Example: 4.0-4.5% as of late 2024
111**2. Determine Cost of Equity (CAPM)**
112 ```
113 Cost of Equity = Risk-Free Rate + Beta × Equity Risk Premium
115 Inputs:
116 - Risk-Free Rate: [Current 10-year Treasury, e.g., 4.2%]
117 - Beta: [Company beta from Bloomberg/FactSet or peer average]
118 - Equity Risk Premium: 5-6% (historical average)
120 Example:
121 Cost of Equity = 4.2% + 1.3 × 5.5% = 11.35%
122 ```
124**3. Determine Cost of Debt**
125 ```
126 Cost of Debt = Current borrowing rate or implied yield on bonds
128 For private companies:
129 Cost of Debt = Risk-Free Rate + Credit Spread (based on rating)
131 Example:
132 Cost of Debt (pre-tax) = 6.5%
133 Cost of Debt (after-tax) = 6.5% × (1 - 25% tax rate) = 4.875%
134 ```
136**4. Determine Capital Structure**
137 ```
138 Use market values (not book values):
140 Market Value of Equity (E) = Share Price × Shares Outstanding
141 Market Value of Debt (D) = Total Debt (use book value if bonds not traded)
142 Total Value (V) = E + D
144 Weight of Equity = E / V
145 Weight of Debt = D / V
147 Example:
148 E = $5,000M (90.9%)
149 D = $500M (9.1%)
150 V = $5,500M (100%)
151 ```
153**5. Calculate WACC**
154 ```
155 WACC = (E/V × Cost of Equity) + (D/V × Cost of Debt × (1 - Tax Rate))
157 Example:
158 WACC = (90.9% × 11.35%) + (9.1% × 6.5% × (1 - 25%))
159 WACC = 10.32% + 0.44% = 10.76%
161 Round to: 10.8% for base case
162 ```
164#### B. Calculate Terminal Value
166**Method 1: Perpetuity Growth (Preferred)**
167```
168Terminal Value = FCF(2029) × (1 + g) / (WACC - g)
170Where:
171- FCF(2029) = Final year unlevered FCF from model
172- g = Perpetual growth rate (typically 2.0-3.0%)
173 - Should not exceed long-term GDP growth
174 - Use 2.5% as base case
176Example:
177FCF(2029) = $500M
178g = 2.5%
179WACC = 10.8%
181Terminal Value = $500M × (1.025) / (0.108 - 0.025)
182Terminal Value = $512.5M / 0.083 = $6,175M
183```
185**Method 2: Exit Multiple (Alternative)**
186```
187Terminal Value = EBITDA(2029) × Exit Multiple
189Where:
190- Exit Multiple = Current peer trading median (e.g., 12-15x EBITDA)
192Example:
193EBITDA(2029) = $800M
194Exit Multiple = 13x
196Terminal Value = $800M × 13x = $10,400M
197```
199**Choose one method or average both.**
201#### C. Discount Cash Flows to Present Value
203```
204PV of Projected FCF = Σ [FCFt / (1 + WACC)^t] for t = 1 to 5
206Example:
207Year FCF Discount PV of FCF
208 ($M) Factor ($M)
2092025 $250 1/(1.108)^1 = 0.9026 $226
2102026 $320 1/(1.108)^2 = 0.8147 $261
2112027 $390 1/(1.108)^3 = 0.7353 $287
2122028 $450 1/(1.108)^4 = 0.6636 $299
2132029 $500 1/(1.108)^5 = 0.5988 $299
214 Total PV: $1,372M
216PV of Terminal Value = Terminal Value / (1 + WACC)^5
217PV of Terminal Value = $6,175M / (1.108)^5 = $6,175M × 0.5988 = $3,697M
219Enterprise Value = $1,372M + $3,697M = $5,069M
220```
222#### D. Calculate Equity Value and Price Per Share
224```
225Enterprise Value $5,069M
226- Net Debt (Debt - Cash) ($450M)
227+ Non-operating Assets $0M
228- Minority Interest $0M
229- Preferred Stock $0M
230= Equity Value $4,619M
232Diluted Shares Outstanding 100M
234Price Per Share = $4,619M / 100M = $46.19
236Current Stock Price: $42.00
237Implied Upside: 10.0%
238```
240#### E. DCF Sensitivity Analysis **CRITICAL**
242**Table 1: WACC vs. Terminal Growth Rate**
244Create 2-way sensitivity table:
245```
246Price Per Share ($) Terminal Growth Rate
247WACC 1.5% 2.0% 2.5% 3.0% 3.5%
2489.0% $52 $55 $59 $63 $68
2499.5% $48 $51 $54 $58 $62
25010.0% $45 $48 $51 $54 $57
25110.5% $42 $45 $47 $50 $53
25211.0% $40 $42 $44 $47 $50
25311.5% $38 $40 $42 $44 $47
25412.0% $36 $38 $40 $42 $44
256Base Case: WACC = 10.8%, g = 2.5% → $46
257Format as heatmap: Green (high values) → Yellow → Red (low values)
258```
260**Table 2: Revenue CAGR vs. Terminal EBITDA Margin**
261```
262Price Per Share ($) Terminal EBITDA Margin (2029E)
263Revenue CAGR 28% 30% 32% 34% 36%
26415% $38 $42 $46 $50 $54
26520% $42 $46 $51 $56 $61
26625% $46 $51 $56 $62 $68
26730% $51 $56 $62 $68 $75
26835% $56 $62 $68 $75 $83
270Base Case: Rev CAGR = 25%, EBITDA Margin = 32% → $56
271```

Step 2: Build DCF Analysis

A. Calculate WACC

1. Determine Risk-Free Rate

  • Use 10-year Treasury yield (check current rate)
  • Example: 4.0-4.5% as of late 2024

2. Determine Cost of Equity (CAPM) ``` Cost of Equity = Risk-Free Rate + Beta × Equity Risk Premium

Inputs:

  • Risk-Free Rate: [Current 10-year Treasury, e.g., 4.2%]
  • Beta: [Company beta from Bloomberg/FactSet or peer average]
  • Equity Risk Premium: 5-6% (historical average)

Example: Cost of Equity = 4.2% + 1.3 × 5.5% = 11.35% ```

3. Determine Cost of Debt ``` Cost of Debt = Current borrowing rate or implied yield on bonds

For private companies: Cost of Debt = Risk-Free Rate + Credit Spread (based on rating)

Example: Cost of Debt (pre-tax) = 6.5% Cost of Debt (after-tax) = 6.5% × (1 - 25% tax rate) = 4.875% ```

4. Determine Capital Structure ``` Use market values (not book values):

Market Value of Equity (E) = Share Price × Shares Outstanding Market Value of Debt (D) = Total Debt (use book value if bonds not traded) Total Value (V) = E + D

Weight of Equity = E / V Weight of Debt = D / V

Example: E = $5,000M (90.9%) D = $500M (9.1%) V = $5,500M (100%) ```

5. Calculate WACC ``` WACC = (E/V × Cost of Equity) + (D/V × Cost of Debt × (1 - Tax Rate))

Example: WACC = (90.9% × 11.35%) + (9.1% × 6.5% × (1 - 25%)) WACC = 10.32% + 0.44% = 10.76%

Round to: 10.8% for base case ```

B. Calculate Terminal Value

Method 1: Perpetuity Growth (Preferred)

Terminal Value = FCF(2029) × (1 + g) / (WACC - g)

Where:
- FCF(2029) = Final year unlevered FCF from model
- g = Perpetual growth rate (typically 2.0-3.0%)
  - Should not exceed long-term GDP growth
  - Use 2.5% as base case

Example:
FCF(2029) = $500M
g = 2.5%
WACC = 10.8%

Terminal Value = $500M × (1.025) / (0.108 - 0.025)
Terminal Value = $512.5M / 0.083 = $6,175M

Method 2: Exit Multiple (Alternative)

Terminal Value = EBITDA(2029) × Exit Multiple

Where:
- Exit Multiple = Current peer trading median (e.g., 12-15x EBITDA)

Example:
EBITDA(2029) = $800M
Exit Multiple = 13x

Terminal Value = $800M × 13x = $10,400M

Choose one method or average both.

C. Discount Cash Flows to Present Value

PV of Projected FCF = Σ [FCFt / (1 + WACC)^t] for t = 1 to 5

Example:
Year    FCF      Discount    PV of FCF
        ($M)     Factor      ($M)
2025    $250     1/(1.108)^1 = 0.9026    $226
2026    $320     1/(1.108)^2 = 0.8147    $261
2027    $390     1/(1.108)^3 = 0.7353    $287
2028    $450     1/(1.108)^4 = 0.6636    $299
2029    $500     1/(1.108)^5 = 0.5988    $299
                              Total PV:  $1,372M

PV of Terminal Value = Terminal Value / (1 + WACC)^5
PV of Terminal Value = $6,175M / (1.108)^5 = $6,175M × 0.5988 = $3,697M

Enterprise Value = $1,372M + $3,697M = $5,069M

D. Calculate Equity Value and Price Per Share

Enterprise Value                 $5,069M
- Net Debt (Debt - Cash)         ($450M)
+ Non-operating Assets           $0M
- Minority Interest              $0M
- Preferred Stock                $0M
= Equity Value                   $4,619M

Diluted Shares Outstanding       100M

Price Per Share = $4,619M / 100M = $46.19

Current Stock Price: $42.00
Implied Upside: 10.0%

E. DCF Sensitivity Analysis CRITICAL

Table 1: WACC vs. Terminal Growth Rate

Create 2-way sensitivity table:

Price Per Share ($)     Terminal Growth Rate
WACC        1.5%    2.0%    2.5%    3.0%    3.5%
9.0%        $52     $55     $59     $63     $68
9.5%        $48     $51     $54     $58     $62
10.0%       $45     $48     $51     $54     $57
10.5%       $42     $45     $47     $50     $53
11.0%       $40     $42     $44     $47     $50
11.5%       $38     $40     $42     $44     $47
12.0%       $36     $38     $40     $42     $44

Base Case: WACC = 10.8%, g = 2.5% → $46
Format as heatmap: Green (high values) → Yellow → Red (low values)

Table 2: Revenue CAGR vs. Terminal EBITDA Margin

Price Per Share ($)     Terminal EBITDA Margin (2029E)
Revenue CAGR    28%     30%     32%     34%     36%
15%             $38     $42     $46     $50     $54
20%             $42     $46     $51     $56     $61
25%             $46     $51     $56     $62     $68
30%             $51     $56     $62     $68     $75
35%             $56     $62     $68     $75     $83

Base Case: Rev CAGR = 25%, EBITDA Margin = 32% → $56
Raw lines 103 to 272
273### Step 3: Comparable Companies Analysis
275#### A. Select Comparable Companies
277**Selection Criteria:**
278- Same industry/sector (primary requirement)
279- Similar business model
280- Comparable size (market cap, revenue)
281- Similar growth profile
282- Similar geographies
284**Identify 5-10 peer companies:**
2851. [Peer 1] - Direct competitor
2862. [Peer 2] - Direct competitor
2873. [Peer 3] - Adjacent player
2884. [Peer 4] - Similar business model
2895. [Peer 5] - Regional competitor
2906. [Add 3-5 more]
292**Document rationale for each peer selected.**
294#### B. Gather Peer Financial Data
296**For each comparable, gather:**
297- Current stock price
298- Shares outstanding (diluted)
299- Market capitalization
300- Total debt and cash (for EV calculation)
301- Enterprise value
302- LTM (Last Twelve Months) financials:
303 - Revenue
304 - EBITDA
305 - EBIT
306 - Net Income
307- NTM (Next Twelve Months) consensus estimates
308- Revenue growth rate
309- EBITDA margin
311**Data sources:**
312- FactSet, CapitalIQ, Bloomberg (preferred)
313- Company 10-Ks/10-Qs for actuals
314- Consensus estimates from Yahoo Finance, Seeking Alpha (if pro tools unavailable)
316#### C. Calculate Valuation Multiples
318**For each peer, calculate:**
319```
320EV/Revenue (LTM) = Enterprise Value / LTM Revenue
321EV/Revenue (NTM) = Enterprise Value / NTM Revenue (est.)
322EV/EBITDA (LTM) = Enterprise Value / LTM EBITDA
323EV/EBITDA (NTM) = Enterprise Value / NTM EBITDA (est.)
324P/E (NTM) = Market Cap / NTM Net Income (est.)
325```
327#### D. Create Comparable Companies Table (MANDATORY FORMAT)
329```
330COMPARABLE COMPANIES ANALYSIS
332Company Ticker Mkt Cap EV/Rev EV/Rev EV/EBITDA EV/EBITDA P/E Rev EBITDA
333 ($B) LTM NTM LTM NTM NTM Growth Margin
334Peer A PRA 45.2 3.5x 3.2x 15.2x 13.8x 25x 18% 23%
335Peer B PRB 32.8 3.2x 2.9x 14.1x 12.5x 22x 15% 23%
336Peer C PRC 28.5 2.8x 2.6x 12.8x 11.2x 20x 12% 22%
337Peer D PRD 52.1 4.1x 3.7x 17.5x 15.2x 29x 22% 23%
338Peer E PRE 38.9 3.6x 3.3x 15.8x 14.1x 25x 17% 23%
339Peer F PRF 41.2 3.7x 3.4x 16.1x 13.9x 26x 19% 23%
340Peer G PRG 35.5 3.3x 3.0x 14.5x 12.8x 23x 16% 22%
342[Target] TRGT 38.0 3.4x 3.1x 14.8x 13.0x 24x 17% 23%
344STATISTICAL SUMMARY
345Maximum 52.1 4.1x 3.7x 17.5x 15.2x 29x 22% 23%
34675th Percentile 45.2 3.7x 3.4x 16.1x 14.1x 26x 19% 23%
347Median 38.9 3.5x 3.2x 15.2x 13.8x 25x 17% 23%
34825th Percentile 32.8 3.2x 2.9x 14.1x 12.5x 22x 15% 22%
349Minimum 28.5 2.8x 2.6x 12.8x 11.2x 20x 12% 22%
351Note: Market data as of [Date]. LTM = Last Twelve Months. NTM = Next Twelve Months.
352Source: FactSet, company filings, [Analyst] estimates.
353```
355**CRITICAL**: The statistical summary (max/75th/median/25th/min) is MANDATORY.
357#### E. Apply Multiples to Target Company
359**Choose primary multiple (typically EV/EBITDA for mature companies):**
361```
362Target Company NTM EBITDA = $550M (from financial model)
364Apply Median Peer Multiple:
365Peer Median EV/EBITDA (NTM) = 13.8x
366Implied EV = $550M × 13.8x = $7,590M
368Apply 25th Percentile (Conservative):
36925th Percentile EV/EBITDA (NTM) = 12.5x
370Implied EV = $550M × 12.5x = $6,875M
372Apply 75th Percentile (Optimistic):
37375th Percentile EV/EBITDA (NTM) = 14.1x
374Implied EV = $550M × 14.1x = $7,755M
376Valuation Range (Comps): $6,875M - $7,755M
377Midpoint: $7,315M
379Convert to Equity Value:
380Implied EV (Median) $7,590M
381- Net Debt ($450M)
382= Implied Equity Value $7,140M
384Shares Outstanding 100M
385Implied Price/Share $71.40
386```
388**Justify Premium/Discount:**
389- Target is growing 17% vs. peer median 17% → In-line
390- Target EBITDA margin 23% vs. peer median 23% → In-line
391- Target market position → [Justify premium/discount]
392- **Conclusion**: Apply median multiple (no adjustment)

Step 3: Comparable Companies Analysis

A. Select Comparable Companies

Selection Criteria:

  • Same industry/sector (primary requirement)
  • Similar business model
  • Comparable size (market cap, revenue)
  • Similar growth profile
  • Similar geographies

Identify 5-10 peer companies:

  1. [Peer 1] - Direct competitor
  2. [Peer 2] - Direct competitor
  3. [Peer 3] - Adjacent player
  4. [Peer 4] - Similar business model
  5. [Peer 5] - Regional competitor
  6. [Add 3-5 more]

Document rationale for each peer selected.

B. Gather Peer Financial Data

For each comparable, gather:

  • Current stock price
  • Shares outstanding (diluted)
  • Market capitalization
  • Total debt and cash (for EV calculation)
  • Enterprise value
  • LTM (Last Twelve Months) financials:
  • Revenue
  • EBITDA
  • EBIT
  • Net Income
  • NTM (Next Twelve Months) consensus estimates
  • Revenue growth rate
  • EBITDA margin

Data sources:

  • FactSet, CapitalIQ, Bloomberg (preferred)
  • Company 10-Ks/10-Qs for actuals
  • Consensus estimates from Yahoo Finance, Seeking Alpha (if pro tools unavailable)

C. Calculate Valuation Multiples

For each peer, calculate:

EV/Revenue (LTM) = Enterprise Value / LTM Revenue
EV/Revenue (NTM) = Enterprise Value / NTM Revenue (est.)
EV/EBITDA (LTM) = Enterprise Value / LTM EBITDA
EV/EBITDA (NTM) = Enterprise Value / NTM EBITDA (est.)
P/E (NTM) = Market Cap / NTM Net Income (est.)

D. Create Comparable Companies Table (MANDATORY FORMAT)

COMPARABLE COMPANIES ANALYSIS

Company      Ticker  Mkt Cap  EV/Rev  EV/Rev  EV/EBITDA  EV/EBITDA  P/E   Rev     EBITDA
                     ($B)     LTM     NTM     LTM        NTM        NTM   Growth  Margin
Peer A       PRA     45.2     3.5x    3.2x    15.2x      13.8x      25x   18%     23%
Peer B       PRB     32.8     3.2x    2.9x    14.1x      12.5x      22x   15%     23%
Peer C       PRC     28.5     2.8x    2.6x    12.8x      11.2x      20x   12%     22%
Peer D       PRD     52.1     4.1x    3.7x    17.5x      15.2x      29x   22%     23%
Peer E       PRE     38.9     3.6x    3.3x    15.8x      14.1x      25x   17%     23%
Peer F       PRF     41.2     3.7x    3.4x    16.1x      13.9x      26x   19%     23%
Peer G       PRG     35.5     3.3x    3.0x    14.5x      12.8x      23x   16%     22%

[Target]     TRGT    38.0     3.4x    3.1x    14.8x      13.0x      24x   17%     23%

STATISTICAL SUMMARY
Maximum              52.1     4.1x    3.7x    17.5x      15.2x      29x   22%     23%
75th Percentile      45.2     3.7x    3.4x    16.1x      14.1x      26x   19%     23%
Median               38.9     3.5x    3.2x    15.2x      13.8x      25x   17%     23%
25th Percentile      32.8     3.2x    2.9x    14.1x      12.5x      22x   15%     22%
Minimum              28.5     2.8x    2.6x    12.8x      11.2x      20x   12%     22%

Note: Market data as of [Date]. LTM = Last Twelve Months. NTM = Next Twelve Months.
Source: FactSet, company filings, [Analyst] estimates.

CRITICAL: The statistical summary (max/75th/median/25th/min) is MANDATORY.

E. Apply Multiples to Target Company

Choose primary multiple (typically EV/EBITDA for mature companies):

Target Company NTM EBITDA = $550M (from financial model)

Apply Median Peer Multiple:
Peer Median EV/EBITDA (NTM) = 13.8x
Implied EV = $550M × 13.8x = $7,590M

Apply 25th Percentile (Conservative):
25th Percentile EV/EBITDA (NTM) = 12.5x
Implied EV = $550M × 12.5x = $6,875M

Apply 75th Percentile (Optimistic):
75th Percentile EV/EBITDA (NTM) = 14.1x
Implied EV = $550M × 14.1x = $7,755M

Valuation Range (Comps): $6,875M - $7,755M
Midpoint: $7,315M

Convert to Equity Value:
Implied EV (Median)        $7,590M
- Net Debt                 ($450M)
= Implied Equity Value     $7,140M

Shares Outstanding         100M
Implied Price/Share        $71.40

Justify Premium/Discount:

  • Target is growing 17% vs. peer median 17% → In-line
  • Target EBITDA margin 23% vs. peer median 23% → In-line
  • Target market position → [Justify premium/discount]
  • Conclusion: Apply median multiple (no adjustment)
Raw lines 273 to 393
394### Step 4: Precedent Transactions (Optional)
396**Note**: Only if M&A is relevant for this sector/company.
398#### A. Identify Relevant Transactions
400**Search for 5-10 M&A deals:**
401- Same industry, last 3-5 years
402- Similar size (0.5x to 2x target's size)
403- Announced and closed deals
405**Example:**
406```
407PRECEDENT TRANSACTIONS ANALYSIS
409Date Target Acquirer Deal EV/Rev EV/EBITDA Premium Rationale
410 Value($B) LTM LTM
411Q1 2024 Comp A Strategic $5.2B 4.2x 16.5x 35% Consolidation
412Q3 2023 Comp B PE Firm $3.8B 3.8x 14.2x 28% Platform
413Q4 2023 Comp C Strategic $4.5B 4.0x 15.8x 32% Geographic
414Q2 2023 Comp D Strategic $6.1B 4.5x 17.2x 38% Strategic fit
415Q1 2023 Comp E PE Firm $3.2B 3.5x 13.5x 25% Carve-out
417Median 4.0x 15.8x 32%
419Source: CapitalIQ, company filings, press releases.
420```
422#### B. Apply to Target Company
424```
425Target Company LTM EBITDA = $500M
426Precedent Median EV/EBITDA (LTM) = 15.8x
428Implied EV (Precedent) = $500M × 15.8x = $7,900M
430Note: Precedent multiples typically 10-20% higher than trading comps
431due to control premium and synergies.
432```

Step 4: Precedent Transactions (Optional)

Note: Only if M&A is relevant for this sector/company.

A. Identify Relevant Transactions

Search for 5-10 M&A deals:

  • Same industry, last 3-5 years
  • Similar size (0.5x to 2x target's size)
  • Announced and closed deals

Example:

PRECEDENT TRANSACTIONS ANALYSIS

Date     Target        Acquirer      Deal     EV/Rev  EV/EBITDA  Premium  Rationale
                                    Value($B)  LTM     LTM
Q1 2024  Comp A       Strategic      $5.2B    4.2x    16.5x      35%      Consolidation
Q3 2023  Comp B       PE Firm        $3.8B    3.8x    14.2x      28%      Platform
Q4 2023  Comp C       Strategic      $4.5B    4.0x    15.8x      32%      Geographic
Q2 2023  Comp D       Strategic      $6.1B    4.5x    17.2x      38%      Strategic fit
Q1 2023  Comp E       PE Firm        $3.2B    3.5x    13.5x      25%      Carve-out

Median                                        4.0x    15.8x      32%

Source: CapitalIQ, company filings, press releases.

B. Apply to Target Company

Target Company LTM EBITDA = $500M
Precedent Median EV/EBITDA (LTM) = 15.8x

Implied EV (Precedent) = $500M × 15.8x = $7,900M

Note: Precedent multiples typically 10-20% higher than trading comps
due to control premium and synergies.
Raw lines 394 to 433
434### Step 5: Valuation Reconciliation
436#### A. Create Valuation Summary Table
438```
439VALUATION SUMMARY
441Method Low Base High Weight Weighted Value
442DCF Analysis $42 $46 $51 50% $23.00
443Trading Comps (NTM) $64 $71 $78 40% $28.40
444Precedent Trans. $70 $79 $88 10% $7.90
445 -------
446Weighted Average Target 100% $59.30
448Rounded Price Target: $59.00
450Current Price (as of [Date]): $42.00
451Upside to Target: 40% ($59.00 / $42.00 - 1)
452```
454#### B. Determine Weighting Rationale
456**Typical Weighting:**
457- DCF: 40-60% (higher when forecasts reliable)
458- Trading Comps: 25-40% (reflects market sentiment)
459- Precedent Trans: 10-25% (lower unless M&A likely)
461**For this example:**
462- DCF 50%: High confidence in projections
463- Comps 40%: Robust peer set
464- Precedent 10%: M&A unlikely near-term
466#### C. Create Valuation Football Field Chart
468```
469VALUATION FOOTBALL FIELD
471Method Low ◄────────── Range ──────────► High
473DCF Analysis $42 ▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓ $51
475Trading Comps (NTM) $64 ▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓ $78
477Precedent Trans. $70 ▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓ $88
478 ↑
479 Current: $42
480─────────────────────────────────────────────────────────
481Valuation Range $42 $88
482Price Target: $59 (weighted average)
484Color code:
485- DCF: Blue
486- Trading Comps: Green
487- Precedent Trans: Orange
488- Vertical line at current price: Red dashed
489- Vertical line at target: Black solid
490```
492#### D. Scenario-Based Valuations
494```
495VALUATION BY SCENARIO
497Scenario Probability Revenue EBITDA DCF Comps Weighted
498 CAGR Margin Value Multiple Avg
499Bear Case 20% 18% 28% $38 11.5x $42
500Base Case 60% 25% 32% $46 13.8x $59
501Bull Case 20% 32% 36% $58 16.0x $82
503Expected Value (probability-weighted): $59
504```

Step 5: Valuation Reconciliation

A. Create Valuation Summary Table

VALUATION SUMMARY

Method                  Low     Base    High    Weight  Weighted Value
DCF Analysis            $42     $46     $51     50%     $23.00
Trading Comps (NTM)     $64     $71     $78     40%     $28.40
Precedent Trans.        $70     $79     $88     10%     $7.90
                                                        -------
Weighted Average Target                         100%    $59.30

Rounded Price Target: $59.00

Current Price (as of [Date]):    $42.00
Upside to Target:                40% ($59.00 / $42.00 - 1)

B. Determine Weighting Rationale

Typical Weighting:

  • DCF: 40-60% (higher when forecasts reliable)
  • Trading Comps: 25-40% (reflects market sentiment)
  • Precedent Trans: 10-25% (lower unless M&A likely)

For this example:

  • DCF 50%: High confidence in projections
  • Comps 40%: Robust peer set
  • Precedent 10%: M&A unlikely near-term

C. Create Valuation Football Field Chart

VALUATION FOOTBALL FIELD

Method                  Low ◄────────── Range ──────────► High

DCF Analysis            $42 ▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓ $51

Trading Comps (NTM)     $64 ▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓ $78

Precedent Trans.        $70 ▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓ $88
                                          ↑
                                    Current: $42
─────────────────────────────────────────────────────────
Valuation Range         $42                          $88
Price Target: $59 (weighted average)

Color code:
- DCF: Blue
- Trading Comps: Green
- Precedent Trans: Orange
- Vertical line at current price: Red dashed
- Vertical line at target: Black solid

D. Scenario-Based Valuations

VALUATION BY SCENARIO

Scenario    Probability  Revenue  EBITDA    DCF      Comps    Weighted
                        CAGR     Margin    Value    Multiple  Avg
Bear Case   20%         18%      28%       $38      11.5x     $42
Base Case   60%         25%      32%       $46      13.8x     $59
Bull Case   20%         32%      36%       $58      16.0x     $82

Expected Value (probability-weighted): $59
Raw lines 434 to 505
506### Step 6: Final Price Target & Recommendation
508```
509═══════════════════════════════════════════════════════════
510INVESTMENT RECOMMENDATION
511═══════════════════════════════════════════════════════════
513Current Price: $42.00 (as of [Date])
514Price Target: $59.00 (12-month)
515Upside/(Downside): +40.5%
517Rating: BUY / OUTPERFORM
519Valuation Methodology: Based on weighted average of DCF (50%),
520 trading comparables (40%), and precedent
521 transactions (10%).
523Time Horizon: 12 months
525───────────────────────────────────────────────────────────
526KEY INVESTMENT CATALYSTS
527───────────────────────────────────────────────────────────
5291. New Product Launch (Q2 2025)
530 - Expected to drive 15-20% revenue acceleration
531 - Already seeing strong pre-orders
5332. Margin Expansion (FY2025-2026)
534 - Operating leverage from scale
535 - Path to 35% EBITDA margin (from current 28%)
5373. Market Share Gains (Ongoing)
538 - Taking share from legacy competitors
539 - Net Promoter Score improvement
5414. International Expansion (H2 2025)
542 - Entry into European markets
543 - Potential $200M incremental revenue opportunity
5455. Potential M&A Target (12-18 months)
546 - Strategic fit for larger players
547 - Precedent transactions suggest 30-40% premium
549───────────────────────────────────────────────────────────
550KEY RISKS TO PRICE TARGET
551───────────────────────────────────────────────────────────
553Downside Risks:
5541. Competitive Pressure (High probability, -15% impact)
555 - New entrant launched competing product
556 - Could pressure pricing and market share
5582. Execution Risk (Medium probability, -10% impact)
559 - New product launch delays or underperformance
560 - Management turnover
5623. Macro Slowdown (Medium probability, -20% impact)
563 - Economic recession would impact customer spending
564 - Operating leverage would reverse
5664. Regulatory Risk (Low probability, -25% impact)
567 - Potential new regulations in key market
568 - Would increase compliance costs
570Upside Risks:
5711. M&A Bid (Low probability, +35% impact)
572 - Strategic acquirer pays control premium
5742. Beat-and-Raise (Medium probability, +10% impact)
575 - Consistent outperformance vs. estimates
577═══════════════════════════════════════════════════════════
578```
580---

Step 6: Final Price Target & Recommendation

═══════════════════════════════════════════════════════════
INVESTMENT RECOMMENDATION
═══════════════════════════════════════════════════════════

Current Price:          $42.00 (as of [Date])
Price Target:           $59.00 (12-month)
Upside/(Downside):      +40.5%

Rating:                 BUY / OUTPERFORM

Valuation Methodology:  Based on weighted average of DCF (50%),
                       trading comparables (40%), and precedent
                       transactions (10%).

Time Horizon:          12 months

───────────────────────────────────────────────────────────
KEY INVESTMENT CATALYSTS
───────────────────────────────────────────────────────────

1. New Product Launch (Q2 2025)
   - Expected to drive 15-20% revenue acceleration
   - Already seeing strong pre-orders

2. Margin Expansion (FY2025-2026)
   - Operating leverage from scale
   - Path to 35% EBITDA margin (from current 28%)

3. Market Share Gains (Ongoing)
   - Taking share from legacy competitors
   - Net Promoter Score improvement

4. International Expansion (H2 2025)
   - Entry into European markets
   - Potential $200M incremental revenue opportunity

5. Potential M&A Target (12-18 months)
   - Strategic fit for larger players
   - Precedent transactions suggest 30-40% premium

───────────────────────────────────────────────────────────
KEY RISKS TO PRICE TARGET
───────────────────────────────────────────────────────────

Downside Risks:
1. Competitive Pressure (High probability, -15% impact)
   - New entrant launched competing product
   - Could pressure pricing and market share

2. Execution Risk (Medium probability, -10% impact)
   - New product launch delays or underperformance
   - Management turnover

3. Macro Slowdown (Medium probability, -20% impact)
   - Economic recession would impact customer spending
   - Operating leverage would reverse

4. Regulatory Risk (Low probability, -25% impact)
   - Potential new regulations in key market
   - Would increase compliance costs

Upside Risks:
1. M&A Bid (Low probability, +35% impact)
   - Strategic acquirer pays control premium

2. Beat-and-Raise (Medium probability, +10% impact)
   - Consistent outperformance vs. estimates

═══════════════════════════════════════════════════════════
Raw lines 506 to 581
582## Quality Standards

Quality Standards

Raw lines 582 to 583
584### DCF Quality Checks
585- [ ] WACC properly calculated with documented components
586- [ ] Terminal value reasonable (< 70% of total enterprise value)
587- [ ] Sensitivity analysis covers realistic ranges (±200-300bps for WACC, ±100bps for terminal growth)
588- [ ] Unlevered FCF properly calculated from EBIT
589- [ ] Enterprise to equity value bridge correct
590- [ ] Share count is diluted shares, not basic

DCF Quality Checks

  • [ ] WACC properly calculated with documented components
  • [ ] Terminal value reasonable (< 70% of total enterprise value)
  • [ ] Sensitivity analysis covers realistic ranges (±200-300bps for WACC, ±100bps for terminal growth)
  • [ ] Unlevered FCF properly calculated from EBIT
  • [ ] Enterprise to equity value bridge correct
  • [ ] Share count is diluted shares, not basic
Raw lines 584 to 591
592### Comparables Quality Checks
593- [ ] 5-10 comparable companies selected
594- [ ] Peer selection defensible (document why each peer was chosen)
595- [ ] Statistical summary included (max/75th/median/25th/min) - MANDATORY
596- [ ] Multiple selection appropriate (EV/EBITDA for mature, EV/Revenue for high-growth)
597- [ ] Premium/discount justified with specific factors
598- [ ] Data sourced properly with dates noted

Comparables Quality Checks

  • [ ] 5-10 comparable companies selected
  • [ ] Peer selection defensible (document why each peer was chosen)
  • [ ] Statistical summary included (max/75th/median/25th/min) - MANDATORY
  • [ ] Multiple selection appropriate (EV/EBITDA for mature, EV/Revenue for high-growth)
  • [ ] Premium/discount justified with specific factors
  • [ ] Data sourced properly with dates noted
Raw lines 592 to 599
600### Overall Valuation Quality Checks
601- [ ] At least 2 valuation methods used (DCF + Comps minimum)
602- [ ] Weighting explained and appropriate
603- [ ] Valuation range provided (low/base/high), not just point estimate
604- [ ] Scenarios analyzed (Bull/Base/Bear)
605- [ ] Sanity checks performed (see below)
606- [ ] All assumptions documented with rationale
608---

Overall Valuation Quality Checks

  • [ ] At least 2 valuation methods used (DCF + Comps minimum)
  • [ ] Weighting explained and appropriate
  • [ ] Valuation range provided (low/base/high), not just point estimate
  • [ ] Scenarios analyzed (Bull/Base/Bear)
  • [ ] Sanity checks performed (see below)
  • [ ] All assumptions documented with rationale
Raw lines 600 to 609
610## Sanity Checks
612**Always perform these validation checks:**
6141. **Historical Multiple Check**
615 - Is implied multiple in line with company's historical trading range?
616 - If not, explain why
6182. **Peer Comparison**
619 - Is premium/discount vs. peers justified by fundamentals?
620 - Check: growth, margins, market position
6223. **Implied Growth Check**
623 - What growth is market pricing in at current price?
624 - Is that reasonable given company trajectory?
6264. **Market Cap Reasonableness**
627 - Does total market cap make sense given company size and peers?
628 - Would company be too large/small relative to industry?
6305. **Terminal Value Check**
631 - Is terminal value < 60-70% of total enterprise value?
632 - If > 70%, projections may not be long enough
6346. **WACC Reasonableness**
635 - Is WACC 8-14% range for typical companies?
636 - Tech/high-growth: 10-14%
637 - Mature/stable: 7-10%
6397. **Implied Returns Check**
640 - What IRR from current price to target over 12 months?
641 - Is that consistent with recommendation rating?
643---

Sanity Checks

Always perform these validation checks:

  1. Historical Multiple Check
  2. Is implied multiple in line with company's historical trading range?
  3. If not, explain why
  1. Peer Comparison
  2. Is premium/discount vs. peers justified by fundamentals?
  3. Check: growth, margins, market position
  1. Implied Growth Check
  2. What growth is market pricing in at current price?
  3. Is that reasonable given company trajectory?
  1. Market Cap Reasonableness
  2. Does total market cap make sense given company size and peers?
  3. Would company be too large/small relative to industry?
  1. Terminal Value Check
  2. Is terminal value < 60-70% of total enterprise value?
  3. If > 70%, projections may not be long enough
  1. WACC Reasonableness
  2. Is WACC 8-14% range for typical companies?
  3. Tech/high-growth: 10-14%
  4. Mature/stable: 7-10%
  1. Implied Returns Check
  2. What IRR from current price to target over 12 months?
  3. Is that consistent with recommendation rating?
Raw lines 610 to 644
645## Output Files
647Create the following deliverables:

Output Files

Create the following deliverables:

Raw lines 645 to 648
649### 1. Valuation Analysis Document
650**File**: `[Company]_Valuation_Analysis_[Date].md` (written analysis)
652**Contents** (4-6 pages):
653- Executive summary with price target
654- DCF analysis (1 page) with sensitivity table
655- Comparable companies analysis (1 page) with statistical summary
656- Precedent transactions (0.5 page) if applicable
657- Valuation summary and football field (0.5 page)
658- Investment recommendation (1 page)
659- Key catalysts and risks (1 page)

1. Valuation Analysis Document

File: [Company]_Valuation_Analysis_[Date].md (written analysis)

Contents (4-6 pages):

  • Executive summary with price target
  • DCF analysis (1 page) with sensitivity table
  • Comparable companies analysis (1 page) with statistical summary
  • Precedent transactions (0.5 page) if applicable
  • Valuation summary and football field (0.5 page)
  • Investment recommendation (1 page)
  • Key catalysts and risks (1 page)
Raw lines 649 to 660
661### 2. Excel Valuation Tabs
662**Add to Task 2's financial model file:** `[Company]_Financial_Model_[Date].xlsx`
664**IMPORTANT**: Do NOT create a separate Excel file. Add these tabs to the existing financial model from Task 2. This keeps all quantitative data in one place.
666**Tabs to add:**
667- DCF tab with full calculations
668- Sensitivity analysis tab
669- Comps tab with peer data
670- Precedent transactions tab (if applicable)
671- Valuation summary tab
673---

2. Excel Valuation Tabs

Add to Task 2's financial model file: [Company]_Financial_Model_[Date].xlsx

IMPORTANT: Do NOT create a separate Excel file. Add these tabs to the existing financial model from Task 2. This keeps all quantitative data in one place.

Tabs to add:

  • DCF tab with full calculations
  • Sensitivity analysis tab
  • Comps tab with peer data
  • Precedent transactions tab (if applicable)
  • Valuation summary tab
Raw lines 661 to 674
675## Success Criteria
677A successful valuation analysis should:
6781. Use at least 2 methods (DCF + Comps minimum)
6792. Include comprehensive DCF sensitivity analysis (2-way tables)
6803. Include statistical summary in comps (max/75th/median/25th/min)
6814. Provide valuation range (low/base/high), not point estimate
6825. Document all key assumptions with clear rationale
6836. Perform sanity checks
6847. Arrive at defensible price target
6858. Provide clear buy/hold/sell recommendation
6869. Identify 3-5 key catalysts
68710. Identify 3-5 key risks
68811. Be auditable and transparent
690---

Success Criteria

A successful valuation analysis should:

  1. Use at least 2 methods (DCF + Comps minimum)
  2. Include comprehensive DCF sensitivity analysis (2-way tables)
  3. Include statistical summary in comps (max/75th/median/25th/min)
  4. Provide valuation range (low/base/high), not point estimate
  5. Document all key assumptions with clear rationale
  6. Perform sanity checks
  7. Arrive at defensible price target
  8. Provide clear buy/hold/sell recommendation
  9. Identify 3-5 key catalysts
  10. Identify 3-5 key risks
  11. Be auditable and transparent
Raw lines 675 to 691
692## Next Steps
694After completing Task 3, the valuation analysis will be used for:
695- **Task 4 (Charts)**: Create DCF sensitivity heatmaps, valuation football field, scenario comparison charts
696- **Task 5 (Report Assembly)**: Integrate valuation analysis into final report
698The price target and recommendation are the foundation of the final investment recommendation in the equity research report.

Next Steps

After completing Task 3, the valuation analysis will be used for:

  • Task 4 (Charts): Create DCF sensitivity heatmaps, valuation football field, scenario comparison charts
  • Task 5 (Report Assembly): Integrate valuation analysis into final report

The price target and recommendation are the foundation of the final investment recommendation in the equity research report.

Raw lines 692 to 698