DCF guide
A DCF is useful when it clarifies what the business must deliver. It is dangerous when the terminal value is doing all the thinking.
Overview
The DCF is not the point. Assumption quality is the point. The model is just a forcing function for judgment.
Read this first
Write these prompts down
Interactive lab
This is where the guide becomes practical. Adjust assumptions, compare scenarios, and write what would force you to raise or cut your valuation confidence.
Interactive learning lab
Move the dials and watch the output update instantly. This is where concept turns into judgment for Discounted cash flow without spreadsheet theater.
Live reference
MSFT
Microsoft
Loading...
Quick presets
Fair value
$71.97
Upside vs spot
-28.0%
Terminal dependence
74%
Scenario value map
Interpretation
Most of the output is being driven by terminal value. Tighten your terminal assumptions before sizing conviction.
Full framework
A good DCF captures the economic path of value creation. Complexity only helps if it sharpens assumptions.
For some businesses it is retention, for others pricing power, utilization, or capital intensity. The model should orbit that variable.
Why it matters
If the primary driver is vague, model detail becomes noise.
When it matters
Before forecasting revenue and margins.
Investor take
Name the primary driver in one line and challenge it first in your downside case.
Growth consumes capital. Capex, working capital, and strategic spend are part of the valuation equation, not afterthoughts.
Why it matters
Ignoring reinvestment overstates intrinsic value by design.
When it matters
Whenever a story emphasizes long runway or expansion.
Investor take
If reinvestment assumptions look too clean, they probably are.
You should be able to explain every major assumption in plain language to a skeptical investor.
Why it matters
If you cannot narrate it, you likely cannot underwrite it.
When it matters
At every step where margins, growth, or returns inflect.
Investor take
Make each inflection answer: what changed, why now, and why durable?
Terminal value is where optimism hides. It should be treated as uncertainty, not certainty.
Calculate how much total equity value comes from the terminal period and treat that as duration risk.
Why it matters
This exposes whether your valuation is near-term execution or long-duration faith.
When it matters
Before trusting any fair-value output.
Investor take
If terminal contribution is extreme, widen your discount to confidence.
High growth, high margins, and low reinvestment cannot all be gifted together without extraordinary economics.
Why it matters
Terminal assumptions should reflect moat quality, not hope.
When it matters
When a business is framed as a long compounding machine.
Investor take
Document what evidence would justify premium terminal assumptions.
Rate changes should reveal range risk. They should not be the hidden dial that makes the model agree with your position.
Why it matters
A fragile case should be seen clearly, not smoothed away.
When it matters
During sensitivity analysis and investment committee prep.
Investor take
If a 50-100 bps shift destroys value, position sizing should reflect that fragility.
A DCF is valuable only if it changes what you do with capital.
Define entry, add, hold, and reduce zones tied to your fair-value range and confidence level.
Why it matters
Action thresholds prevent emotional decision-making in volatile tape.
When it matters
Before initiating or resizing a position.
Investor take
Write the action bands now, not after price moves.
Assumption changes should be evidence-driven: margin trajectory, capital returns, competitive shifts, or demand signals.
Why it matters
Without evidence discipline, revisions become narrative drift.
When it matters
After earnings and major catalysts.
Investor take
Log every assumption change with the evidence that caused it.
A real downside case should include weaker unit economics and multiple compression, not just lower top-line growth.
Why it matters
Most damage comes from both earnings disappointment and confidence reset.
When it matters
Whenever valuation looks comfortable.
Investor take
If downside feels implausible, you probably made it too polite.
Evidence
DCF mechanics
A DCF is a sequence, not a spreadsheet aesthetic. Each line exists to answer how much economic profit survives after the business pays for growth.
Formula guide
| Step | Simple formula | Question it answers | Where analysts usually cheat |
|---|---|---|---|
| Revenue forecast | Base x growth | How large can the demand pool realistically get? | Headline growth is extrapolated without asking what sustains it. |
| Operating profit | Revenue x operating margin | How much of the revenue becomes real operating earnings? | Margins step up on schedule with no operating reason. |
| NOPAT | EBIT - cash taxes | What does the business earn after an honest tax burden? | Temporary tax help is treated like a permanent economic feature. |
| Reinvestment | Capex + working capital + strategic spend | What must be spent to support the forecast? | Growth is modeled as if incremental capital needs are optional. |
| Present value | FCFF / (1 + r)^t | How much are those future dollars worth today? | Discount rate becomes the hidden dial that makes the answer feel comfortable. |
| Terminal value | FCFF_(t+1) / (r - g) | What is the business worth once it settles into maturity? | The terminal period does all the work and pretends to be insight. |
Watch-out
Apply and continue