Discounted Cash Flow (DCF) Model — The Deep Valuation Engine

You already did the forensic work in Advanced Financial Statement Analysis. Now we convert that forensic evidence into a court verdict: an intrinsic value.

Why DCF after Comparative Company Analysis?

You just used comparables and multiples to triangulate value. Good. Comps give market context and a sanity check. The DCF model answers the different question: what is the firm worth based on its expected future cash flows? Think of comps as the market’s gossip; DCF is the company’s autobiography (with spreadsheets and a strong personality).

Use DCF to:

• Translate your normalized income statement and balance sheet adjustments into cash flows (you did those adjustments already).
• Capture company-specific lifecycle dynamics (reinvestment needs, margins, competitive moat).
• Cross-check multiples-based valuations and explain deviations.

Core ingredients — what you need from your prior analysis

From Advanced Financial Statement Analysis you should already have:

• Normalized revenue growth and margins (after removing one-offs)
• Adjusted capex and depreciation estimates
• Working capital drivers (DSO, DPO, DIO or ΔNWC dynamics)
• Off-balance-sheet liabilities and non-operating assets (pensions, minority interests, excess cash)

These feed directly into Free Cash Flows and terminal-value assumptions.

Step-by-step DCF (practical walkthrough)

1. Choose the cash flow type

   • Free Cash Flow to Firm (FCFF) — discount at WACC → gives enterprise value (EV).
   • Free Cash Flow to Equity (FCFE) — discount at cost of equity → gives equity value directly.

   For most advanced valuations, use FCFF and WACC because capital structure changes are easier to model at the EV stage.

2. Project operating performance (5–10 years typical for US large caps)

   • Revenue by drivers (volumes, price, market share).
   • EBIT or NOPAT = Operating income × (1 − tax rate).
   • Add back non-cash charges, subtract capex and ΔNWC: FCFF = NOPAT + Depreciation − CapEx − ΔNWC.

3. Calculate WACC (discount rate)

   WACC = wE × rE + wD × rD × (1 − t)

   • rE = risk-free rate + beta × market risk premium (use your levered/unlevered beta workflow from comps)
   • rD = market yield on debt or company-specific borrowing rate
   • Weights = market value of equity and debt (not book)

4. Compute Terminal Value

   Two common methods:

   • Gordon Growth (Perpetuity): TV = FCFF_{n+1} / (WACC − g)
     • Choose g conservatively (long-run GDP + inflation or lower). For US large caps, g typically ≤ 3–3.5%.
   • Exit Multiple: TV = terminal metric (EBITDA) × selected multiple (from comps)
     • Useful when industry multiples are stable and you want market-anchored terminal value.

   Important: avoid overreliance on terminal value — it often dominates valuation.

5. Discount cash flows & sum to enterprise value

   • EV = Σ (FCFF_t / (1+WACC)^t) + TV / (1+WACC)^n
   • Equity value = EV − Net Debt − Minority Interests + Non-operating Assets

6. Sensitivity and scenario analysis

   • Build a sensitivity table for WACC vs terminal growth / exit multiple.
   • Create bull / base / bear cases with different revenue/margin trajectories.

Quick example (numbers simplified)

Suppose FCFF years 1–5: 100, 120, 140, 160, 180; WACC = 9%; perpetual g = 2.5%.

Terminal FCFF_{6} = 180 × 1.025 = 184.5

TV = 184.5 / (0.09 − 0.025) = 2,838.46

Discount PV of FCFFs + TV to get EV. (I encourage doing this in Excel and running a sensitivity table.)

Pitfalls & advanced gotchas (these trip up even senior analysts)

• Terminal value dominance: If >50% of value is terminal, your forecast years are too short or too uncertain. Expand explicit forecast or tighten assumptions.
• Growth > WACC: Never make terminal growth (g) exceed WACC — that's a mathematical and economic red flag.
• Using book weights in WACC: Use market values. If a company has heavy debt with low market price, weights shift.
• Double-counting/non-operating items: Subtract net debt and add back excess cash/non-core assets once — don’t bury them in FCFF.
• Ignoring cyclical normalization: For cyclical firms, normalize margins and sales cycles (use median/mean cycles from prior cycles).
• Beta mismatch: Use a beta consistent with the cash flow type (levered beta for equity discount; unlever and relever when changing capital structure).

Reconcile DCF with Comparative Analysis

• Use comps to pick an exit multiple and to sanity-check WACC (implied multiples vs DCF implied multiples).
• If DCF gives a much higher value than comps, check inputs: overly optimistic margins, underestimated capex, or an aggressive terminal growth.
• Use implied multiples: compute implied EV/EBITDA from your DCF at terminal year — it should sit reasonably close to the peer median for the industry.

Practical tips & model hygiene

• Keep working capital drivers explicit (DSO/DIO/DPO) — it's easier to sanity check seasonality.
• Build modular sheets: Assumptions → Income Statement → Working Capital → FCFF → DCF → Sensitivity.
• Document tax assumptions and unusual items (NOLs, tax credits) and where they are applied.
• Run a Monte Carlo or at least a three-scenario analysis if you’re presenting to clients or a board.

Final checklist before you claim a valuation as "the" number

• Are the forecasts supported by industry and company evidence?
• Did you use market weights and a defensible market risk premium and risk-free rate?
• Does implied terminal multiple align with comps?
• Is terminal value a reasonable share of total value?
• Have you disclosed main sensitivities and most critical assumptions?

Key takeaways

• DCF = intrinsic, fundamentals-driven valuation. It complements comps and helps explain why multiples diverge.
• Garbage in = garbage out. Your Advanced Financial Statement Analysis is the best defense; use it to build defensible cash flows.
• Terminal assumptions matter — a lot. Be conservative and justify your g or exit multiple using macro and peer evidence.

This is the moment where all your accounting edits, normalization work, and competitor sleuthing finally click: you aren’t guessing a price — you’re projecting a company’s economic engine.

Quick resources

• Excel: build scenario tables and two-way sensitivity for WACC vs g.
• Python/snack script: use numpy.financial.npv or pandas to automate scenario runs.

# very small snippet to discount a cashflow series
import numpy as np
fcff = np.array([100,120,140,160,180])
wacc = 0.09
pv = sum(fcff / (1+wacc)**(np.arange(1,6)))

Good models are auditable and humble: they show what would change the verdict. Bring the numbers, bring the narrative, and never be shy about showing the sensitivity table.