How to Build a DCF Model Step by Step

# How to Build a DCF Model Step by Step

*Educational content only. Not personalized financial or investment advice.*

A discounted cash flow (DCF) model translates a set of business assumptions — revenue growth, margins, reinvestment needs — into a single estimate of what a company might be worth today. Investors use it because it forces discipline: instead of anchoring on a stock’s current price, you build the value from the ground up, cash flow by cash flow.

This article is a hands-on tutorial. Rather than just explaining what DCF is, it walks through constructing a complete model step by step — historical financials, forecast assumptions, free cash flow, WACC, terminal value, and intrinsic value per share — the same way you’d build it in Excel or Google Sheets. By the end, you’ll have seen every calculation that turns a set of assumptions into a per-share value estimate, and you’ll be able to replicate the same structure for a real company.

**The example in this article uses a fictional company, ABC Industries Ltd., and entirely hypothetical numbers.** The figures are for illustration only and are not a real valuation of any actual business.

If you haven’t already, it’s worth reading the [complete DCF valuation guide](https://blog.investorguidefinder.com/dcf-valuation/) first — this article assumes familiarity with the core concepts (present value, WACC, terminal value) and focuses purely on construction.

—

## What Is a DCF Model?

**A DCF model estimates the present value of a company’s expected future cash flows.**

The model follows one continuous chain of logic:

**Forecast Cash Flows → Discount Rate → Present Value → Enterprise Value → Equity Value → Intrinsic Value Per Share**

It’s worth distinguishing a few related terms before building anything:

– **DCF valuation** — the broader concept and methodology of valuing a business by discounting its future cash flows.
– **DCF model** — the actual spreadsheet or calculation structure that implements that methodology.
– **Intrinsic value** — the output of the model: an estimate of what the business is worth based on its own fundamentals.
– **Market price** — what the stock currently trades for, which may or may not be close to the model’s output.

The model itself is just a structured set of formulas. The judgment goes into the assumptions that feed it.

## What You Need Before Building a DCF Model

### Financial Information

Before opening a spreadsheet, gather:

– Revenue
– Cost of revenue
– Gross profit
– Operating expenses
– EBIT
– Taxes
– Depreciation and amortization
– Capital expenditures
– Accounts receivable
– Inventory
– Accounts payable
– Cash
– Debt
– Diluted shares outstanding

### Business Information

Alongside the numbers, gather a qualitative picture:

– Business model and how revenue is generated
– Industry structure and competitive dynamics
– Competitive position and economic moat
– Historical growth trends
– Market share and its trajectory
– Pricing power
– Capital intensity
– Management’s stated strategy and capital allocation priorities

Financial modeling should start with understanding the business — the numbers only make sense in the context of what’s actually driving them. A model built without that understanding is just an exercise in typing formulas.

## DCF Model Structure

Every DCF model follows the same backbone, regardless of how simple or elaborate it becomes:

**Historical Financials → Forecast Assumptions → Revenue Forecast → Operating Forecast → Free Cash Flow → WACC → Terminal Value → Present Value → Enterprise Value → Equity Value → Intrinsic Value Per Share**

Each stage feeds the next. Historical financials establish a baseline; forecast assumptions translate that baseline into future years; free cash flow converts the forecast into distributable cash; WACC and terminal value convert that cash flow stream into a present-day number; and the final steps convert that number into a per-share estimate.

—

## Step 1 — Create the Historical Financials Section

Every model starts with several years of historical data. For this tutorial, consider a fictional company, **ABC Industries Ltd.** *(all financial figures in this tutorial are fictional and provided for educational purposes only)*, with the following 5-year historical summary, in $ millions:

| Metric | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
|—|—:|—:|—:|—:|—:|
| Revenue | 100.0 | 108.0 | 116.0 | 125.0 | 135.0 |
| EBIT | 15.0 | 16.7 | 18.6 | 20.6 | 23.0 |
| EBIT Margin | 15.0% | 15.5% | 16.0% | 16.5% | 17.0% |
| D&A | 4.0 | 4.3 | 4.6 | 5.0 | 5.4 |
| CapEx | 5.0 | 5.4 | 5.8 | 6.3 | 6.8 |
| Net Working Capital | 8.0 | 8.6 | 9.3 | 10.0 | 10.8 |
| Free Cash Flow | 10.3 | 10.8 | 12.1 | 13.5 | 15.1 |

This historical block is the foundation everything else builds on. Notice the trends: revenue growing at roughly 7–8% a year, EBIT margin expanding gradually as the business gains scale, and free cash flow growing faster than revenue as margins improve.

## Step 2 — Calculate Historical Growth Rates

With the historical table in place, calculate year-over-year growth:

**Revenue Growth = (Current Revenue / Previous Revenue) − 1**

For ABC Industries, revenue growth runs approximately 8.0%, 7.4%, 7.8%, and 8.0% across the four year-over-year periods — a fairly stable historical growth band. EBIT margin has expanded from 15.0% to 17.0% over five years, roughly +0.5 percentage points per year. Free cash flow has grown from $10.3M to $15.1M, faster than revenue, reflecting the combination of margin expansion and a relatively stable reinvestment rate.

These historical patterns inform — but should not be mechanically extrapolated into — the forecast. An 8% growth rate sustained for five historical years does not guarantee an 8% growth rate for the next ten.

## Step 3 — Build the Forecast Assumptions

With a 5-year forecast period, build an assumptions table before forecasting a single dollar of revenue:

| Assumption | FY1 | FY2 | FY3 | FY4 | FY5 |
|—|—:|—:|—:|—:|—:|
| Revenue Growth | 7.5% | 7.0% | 6.0% | 5.5% | 5.0% |
| EBIT Margin | 17.3% | 17.5% | 17.7% | 17.8% | 17.8% |
| Tax Rate | 25% | 25% | 25% | 25% | 25% |
| D&A % of Revenue | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% |
| CapEx % of Revenue | 5.0% | 5.0% | 5.0% | 5.0% | 5.0% |
| NWC % of Revenue | 8.0% | 8.0% | 8.0% | 8.0% | 8.0% |

Two deliberate choices here are worth noting. First, revenue growth decelerates from 7.5% to 5.0% across the forecast — a more conservative assumption than simply repeating the historical average indefinitely. Second, EBIT margin continues expanding but flattens out by Year 4, reflecting the idea that margin gains from scale and operating leverage eventually plateau. Every assumption in this table should be justified by something concrete — a market-size constraint, a competitive dynamic, a documented cost initiative — not just picked to hit a target value.

## Step 4 — Forecast Revenue

Revenue is forecast forward using:

**Revenue = Previous-Year Revenue × (1 + Growth Rate)**

Starting from the Year 5 historical base of $135.0M:

| | FY1 | FY2 | FY3 | FY4 | FY5 |
|—|—:|—:|—:|—:|—:|
| Revenue ($M) | 145.1 | 155.3 | 164.6 | 173.6 | 182.3 |

Beyond simple growth-rate extrapolation, revenue can also be built up from historical growth trends, industry or end-market growth, total addressable market size, market share assumptions, customer growth, price increases, volume growth, or geographic expansion. Whichever method is used, forecasts generally should become more conservative the further out they extend — near-term revenue is more knowable than revenue five years from now.

## Step 5 — Forecast EBIT

EBIT is calculated as:

**EBIT = Revenue × EBIT Margin**

| | FY1 | FY2 | FY3 | FY4 | FY5 |
|—|—:|—:|—:|—:|—:|
| Revenue ($M) | 145.1 | 155.3 | 164.6 | 173.6 | 182.3 |
| EBIT Margin | 17.3% | 17.5% | 17.7% | 17.8% | 17.8% |
| EBIT ($M) | 25.1 | 27.2 | 29.1 | 30.9 | 32.5 |

Margin assumptions should be grounded in real drivers: operating leverage as fixed costs are spread over more revenue, pricing power, competitive intensity, cost structure, and economies of scale. Assuming margins expand indefinitely without a plausible mechanism is one of the fastest ways to make a DCF unrealistic — real-world margins tend to plateau or compress as competitors respond.

## Step 6 — Calculate Taxes

From EBIT, calculate net operating profit after tax:

**NOPAT = EBIT × (1 − Tax Rate)**

| | FY1 | FY2 | FY3 | FY4 | FY5 |
|—|—:|—:|—:|—:|—:|
| EBIT ($M) | 25.1 | 27.2 | 29.1 | 30.9 | 32.5 |
| NOPAT ($M) | 18.8 | 20.4 | 21.9 | 23.2 | 24.3 |

FCFF uses taxes on *operating* profit (EBIT), not reported net income, because net income already reflects interest expense — and interest is a financing decision, not an operating one. Mixing the two would double-count the effect of debt.

## Step 7 — Calculate Depreciation and Amortization

Depreciation and amortization are non-cash expenses that reduced EBIT on the income statement but didn’t actually consume cash, so they’re added back:

**D&A = Revenue × D&A %**

| | FY1 | FY2 | FY3 | FY4 | FY5 |
|—|—:|—:|—:|—:|—:|
| D&A ($M) | 5.8 | 6.2 | 6.6 | 6.9 | 7.3 |

Forecasting D&A as a percentage of revenue is a simplification that works reasonably well for a stable, moderately capital-intensive business; more capital-intensive businesses may instead tie D&A to the CapEx and asset schedule directly.

## Step 8 — Forecast Capital Expenditures

Capital expenditure is the cash the business must reinvest to maintain and grow its asset base:

**CapEx = Revenue × CapEx %**

| | FY1 | FY2 | FY3 | FY4 | FY5 |
|—|—:|—:|—:|—:|—:|
| CapEx ($M) | 7.3 | 7.8 | 8.2 | 8.7 | 9.1 |

CapEx is often split conceptually into maintenance CapEx (keeping existing assets running) and growth CapEx (funding expansion). Capital intensity varies enormously by industry — an asset-light software company and a capital-intensive manufacturer will have very different CapEx-to-revenue ratios — so this assumption should reflect the specific business, not a generic benchmark.

## Step 9 — Forecast Net Working Capital

Working capital represents the cash tied up in day-to-day operations: accounts receivable and inventory (operating current assets) net of accounts payable (operating current liabilities).

**Change in NWC = Current NWC − Previous NWC**

| | FY0 (base) | FY1 | FY2 | FY3 | FY4 | FY5 |
|—|—:|—:|—:|—:|—:|—:|
| NWC ($M) | 10.8 | 11.6 | 12.4 | 13.2 | 13.9 | 14.6 |
| Change in NWC ($M) | — | 0.8 | 0.8 | 0.8 | 0.7 | 0.7 |

As revenue grows, working capital typically grows with it — more receivables, more inventory — which consumes cash even though the company is growing profitably. This is a common blind spot in simplified valuation approaches that stop at net income.

## Step 10 — Calculate Free Cash Flow to the Firm

Everything from Steps 4–9 now comes together:

**FCFF = EBIT × (1 − Tax Rate) + D&A − CapEx − Change in NWC**

| Metric ($M) | FY1 | FY2 | FY3 | FY4 | FY5 |
|—|—:|—:|—:|—:|—:|
| Revenue | 145.1 | 155.3 | 164.6 | 173.6 | 182.3 |
| EBIT | 25.1 | 27.2 | 29.1 | 30.9 | 32.5 |
| Taxes (25%) | 6.3 | 6.8 | 7.3 | 7.7 | 8.1 |
| NOPAT | 18.8 | 20.4 | 21.9 | 23.2 | 24.3 |
| D&A | 5.8 | 6.2 | 6.6 | 6.9 | 7.3 |
| CapEx | 7.3 | 7.8 | 8.2 | 8.7 | 9.1 |
| Change in NWC | 0.8 | 0.8 | 0.8 | 0.7 | 0.7 |
| **FCFF** | **16.6** | **18.0** | **19.5** | **20.7** | **21.8** |

This row — FCFF — is the single most important output of the entire forecast section. Every subsequent step discounts and sums these five numbers.

—

## Step 11 — Calculate WACC

FCFF is discounted using the Weighted Average Cost of Capital, since it represents cash flow available to both debt and equity holders:

**WACC = (E/V × Re) + (D/V × Rd × (1 − T))**

Where E is the market value of equity, D is the market value of debt, V is total capital (E + D), Re is cost of equity, Rd is cost of debt, and T is the tax rate.

## Step 12 — Calculate Cost of Equity

Cost of equity is commonly estimated with CAPM:

**Cost of Equity = Risk-Free Rate + Beta × Equity Risk Premium**

For ABC Industries, using hypothetical assumptions of a 4.0% risk-free rate, a beta of 1.1, and a 5.5% equity risk premium:

Cost of Equity = 4.0% + (1.1 × 5.5%) = **10.1%**

CAPM is widely used but has real limitations — beta is estimated from historical price volatility and may not fully capture a company’s actual risk, and both the risk-free rate and equity risk premium are themselves estimates. Treat the output as a reasoned estimate, not a precise figure.

## Step 13 — Calculate Cost of Debt

Cost of debt reflects what the company actually pays (or would pay) to borrow, adjusted for the tax shield interest provides:

For ABC Industries, assume a pre-tax cost of debt of 5.5%, based on its credit profile and current borrowing rates, and a 25% tax rate:

After-Tax Cost of Debt = 5.5% × (1 − 25%) = **4.1%**

## Step 14 — Calculate WACC for ABC Industries

Assuming a capital structure of 80% equity and 20% debt:

| Component | Value |
|—|—:|
| Equity Weight | 80% |
| Debt Weight | 20% |
| Cost of Equity | 10.1% |
| Pre-Tax Cost of Debt | 5.5% |
| After-Tax Cost of Debt | 4.1% |
| Tax Rate | 25% |
| **WACC** | **8.9%** |

WACC = (0.80 × 10.1%) + (0.20 × 4.1%) = 8.1% + 0.8% = **8.9%**

This 8.9% is the rate that will discount every future FCFF and the terminal value back to the present.

## Step 15 — Calculate the Discount Factor

Each year’s discount factor is:

**Discount Factor = 1 / (1 + WACC)^t**

| Year | FCFF ($M) | WACC | Discount Factor | Present Value ($M) |
|—:|—:|—:|—:|—:|
| 1 | 16.6 | 8.9% | 0.918 | 15.2 |
| 2 | 18.0 | 8.9% | 0.843 | 15.2 |
| 3 | 19.5 | 8.9% | 0.774 | 15.1 |
| 4 | 20.7 | 8.9% | 0.711 | 14.7 |
| 5 | 21.8 | 8.9% | 0.653 | 14.3 |
| **Total** | | | | **74.4** |

Each year’s FCFF is multiplied by its discount factor to arrive at present value; the five present values sum to **$74.4M** — the value today of five years of forecast cash flow, before terminal value is added.

## Step 16 — Calculate Terminal Value

Since the business will keep generating cash flow beyond Year 5, terminal value captures everything after the explicit forecast, using the perpetual growth method:

**Terminal Value = FCFF₍ₙ₊₁₎ / (WACC − g)**

Using a conservative perpetual growth rate of 2.5%:

FCFF Year 6 = FCFF Year 5 × (1 + g) = 21.8 × 1.025 = **22.4**

Terminal Value = 22.4 / (8.9% − 2.5%) = 22.4 / 6.4% = **$349.5M**

**The perpetual growth rate must remain below the discount rate**, or this formula produces a nonsensical result. A 2.5% terminal growth rate — roughly in line with long-run inflation and GDP growth — is a deliberately conservative choice for a mature-stage assumption.

## Step 17 — Discount the Terminal Value

The terminal value is a Year-5 figure and must itself be discounted back to today using the Year-5 discount factor:

**PV of Terminal Value = Terminal Value × Final-Year Discount Factor**

PV of Terminal Value = $349.5M × 0.653 = **$228.2M**

Notice that this single number is roughly three times larger than the sum of all five years of discounted forecast FCFF — a reminder of just how much weight terminal value carries in most DCF models, and why its assumptions deserve careful scrutiny.

## Step 18 — Calculate Enterprise Value

**Enterprise Value = PV of Forecast FCFF + PV of Terminal Value**

Enterprise Value = $74.4M + $228.2M = **$302.6M**

## Step 19 — Convert Enterprise Value to Equity Value

**Equity Value = Enterprise Value + Cash − Debt**

Assume ABC Industries holds $40.0M in cash and $120.0M in debt:

Equity Value = $302.6M + $40.0M − $120.0M = **$222.6M**

Enterprise value represents the whole operating business available to all capital providers; equity value isolates what belongs specifically to shareholders. The two are not interchangeable, and enterprise value should never be read directly as market capitalization.

## Step 20 — Calculate Intrinsic Value Per Share

**Intrinsic Value Per Share = Equity Value / Diluted Shares Outstanding**

Assuming 50 million diluted shares outstanding (accounting for stock-based compensation and other dilutive securities, net of any buybacks):

Intrinsic Value Per Share = $222.6M / 50M = **$4.45**

—

## Complete DCF Model Example

Pulling every step together into one consolidated summary for ABC Industries Ltd.:

| DCF Component | Result |
|—|—:|
| Sum of PV of Forecast FCFF | $74.4M |
| Terminal Value | $349.5M |
| PV of Terminal Value | $228.2M |
| Enterprise Value | $302.6M |
| Cash | $40.0M |
| Debt | $120.0M |
| Equity Value | $222.6M |
| Diluted Shares Outstanding | 50.0M |
| **Estimated Intrinsic Value Per Share** | **$4.45** |

*All figures above are fictional and constructed solely to illustrate the mechanics of the model.*

## DCF Sensitivity Analysis

A single-point estimate like $4.45 per share should never be treated as precise. Varying WACC and terminal growth shows how sensitive the output is to assumptions that are themselves uncertain:

| WACC ↓ / Growth → | 2.0% | 2.5% | 3.0% |
|—|—:|—:|—:|
| 8.0% | $4.98 | $5.46 | $6.04 |
| 9.0% | $4.02 | $4.36 | $4.75 |
| 10.0% | $3.30 | $3.55 | $3.83 |

Across a fairly narrow, defensible range of WACC (8–10%) and terminal growth (2–3%) assumptions, the estimated intrinsic value per share swings from roughly $3.30 to $6.04 — nearly double. This is normal and expected; it’s precisely why a DCF output is best understood as a range grounded in explicit assumptions rather than a single “correct” number.

## Build Bear, Base, and Bull Cases

Beyond mechanically varying WACC and growth, it helps to build full alternative scenarios with internally consistent assumptions:

**Bear Case:** Revenue growth slows faster (from 5% down to 3%), EBIT margin stays flat near 15% rather than expanding, and a higher WACC (10%) reflects greater perceived risk. This combination points toward a materially lower intrinsic value, in the neighborhood of the lower end of the sensitivity table.

**Base Case:** The assumptions used throughout this tutorial — moderate deceleration in growth, gradual margin expansion, WACC near 8.9% — producing the **$4.45** central estimate.

**Bull Case:** Stronger sustained revenue growth, continued margin expansion beyond 17.8%, and a lower WACC (8%) reflecting a more durable competitive position, pointing toward the upper end of the sensitivity range and beyond.

These scenarios are not predictions of what will happen. They’re a tool for understanding which assumptions matter most and how much the valuation depends on them.

## How to Build a DCF Model in Excel

A practical spreadsheet layout keeps historical and forecast data visually separated:

– **Columns B–F** — historical years
– **Columns G–K** — forecast years

Suggested row order:

1. Revenue
2. Revenue Growth %
3. EBIT
4. EBIT Margin %
5. Taxes
6. NOPAT
7. D&A
8. CapEx
9. NWC
10. Change in NWC
11. FCFF
12. Discount Factor
13. Present Value of FCFF
14. Terminal Value
15. Present Value of Terminal Value

Keep assumptions (growth rates, margins, WACC inputs) in a clearly labeled block separate from the calculations that consume them — this makes the model far easier to audit, sensitize, and update later. This tutorial does not provide a downloadable template; the structure above is meant to be rebuilt directly in your own spreadsheet.

## Recommended DCF Spreadsheet Structure

For anything beyond a quick back-of-envelope model, splitting the workbook into dedicated tabs pays off:

– **Tab 1 — Assumptions:** all growth, margin, WACC, and terminal-value inputs in one place
– **Tab 2 — Historical Financials:** the raw historical data pulled from filings
– **Tab 3 — Forecast:** the year-by-year revenue-through-FCFF build
– **Tab 4 — DCF Valuation:** discounting, terminal value, enterprise value, and equity value
– **Tab 5 — Sensitivity Analysis:** the WACC/growth data table
– **Tab 6 — Scenario Analysis:** bear/base/bull case comparison
– **Tab 7 — Summary:** the final output and key assumptions, for quick reference

## DCF Model Best Practices

– Keep assumptions separate from calculations
– Use formulas throughout — avoid hardcoded numbers buried inside calculations
– Clearly label historical data versus forecast data
– Document the reasoning behind each assumption
– Avoid circular references (common when interest expense depends on debt, which depends on cash flow, which depends on interest expense)
– Check units consistently ($ millions vs. $ thousands, percentages vs. decimals)
– Double-check signs — CapEx and change in NWC should reduce FCFF, not add to it
– Confirm debt and cash figures are current and complete
– Use diluted, not basic, shares outstanding
– Always test sensitivity rather than relying on a single output
– Revisit and update the model as new financial results and information arrive

## Common DCF Modeling Mistakes

1. Forecasting unrealistic revenue growth
2. Using overly optimistic margin assumptions
3. Ignoring working capital effects
4. Ignoring capital expenditure
5. Using inconsistent or outdated financial statements
6. Mixing FCFF with cost of equity as the discount rate
7. Mixing FCFE with WACC as the discount rate
8. Using an unsupported or arbitrary WACC
9. Assuming excessive terminal growth
10. Forgetting to adjust for net debt
11. Ignoring share dilution
12. Double-counting cash in the valuation
13. Using incorrect discount periods (e.g., misaligning year 1 vs. year 0)
14. Hardcoding values instead of linking formulas
15. Treating the model’s output as a precise, certain number
16. Back-solving assumptions to reach a predetermined target price
17. Skipping sensitivity and scenario analysis entirely

## FCFF vs FCFE in a DCF Model

Mixing these frameworks — for example, discounting FCFF with cost of equity, or FCFE with WACC — produces valuations that are internally inconsistent and typically wrong. Pick one framework and stay consistent with it throughout the model.

## DCF vs P/E vs EV/EBITDA

Many investors build a DCF and then cross-check it against relative valuation multiples, since each method has different blind spots.

## Reverse DCF

A reverse DCF flips the process. Instead of asking:

> “What is the company worth?”

it asks:

> “What assumptions are embedded in today’s stock price?”

By holding the market price constant and solving backward through the same model structure, an investor can back out the implied revenue growth, margin trajectory, or long-term growth rate the market is already pricing in — a direct way of examining market expectations rather than only comparing an independent estimate to price.

## When Should You Not Use a DCF?

A DCF model becomes considerably less reliable for:

– Highly unpredictable or volatile businesses
– Very early-stage companies without an established cash-flow history
– Businesses in severe financial distress
– Extremely cyclical companies where “normal” earnings are hard to define
– Businesses undergoing a rapidly changing business model
– Companies with fundamentally unstable cash flows

In these cases, relative valuation, asset-based approaches, or qualitative judgment may be more informative than forcing a multi-year cash-flow forecast onto a business that can’t reasonably support one.

## How to Improve a DCF Model Over Time

A DCF model shouldn’t be built once and forgotten. As new information arrives, revisit:

– Historical results as new quarters and years are reported
– Forecast assumptions, particularly growth and margin trajectories
– Industry data and competitive dynamics
– Capital expenditure and working capital patterns
– The discount rate, as interest rates and risk perceptions shift
– Terminal-period assumptions

One of the most valuable habits in financial modeling is comparing **previous forecasts against actual results** — where did the model overshoot or undershoot, and why? That feedback loop is what improves modeling judgment over time, far more than refining formulas in isolation.

## DCF Model Quality-Control Checklist

**Financial Data**
– Historical data verified against source filings
– Revenue correctly calculated and consistent across periods
– EBIT correctly calculated
– Taxes checked against the effective rate
– CapEx checked against cash flow statement
– Working capital checked against balance sheet

**Forecast**
– Growth assumptions justified by a specific driver
– Margin assumptions justified and not indefinitely expanding
– D&A assumptions reasonable relative to CapEx
– CapEx assumptions reasonable for the industry
– Working capital assumptions reasonable relative to revenue

**Valuation**
– WACC calculated with clearly stated inputs
– Terminal growth rate reasonable and below WACC
– Discount factors correctly aligned to each period
– Enterprise value calculation correct
– Cash and debt correctly adjusted
– Diluted shares used, not basic shares

**Risk**
– Bear case built
– Base case built
– Bull case built
– Sensitivity analysis completed
– Key risks to the thesis documented

—

## Frequently Asked Questions

**1. What is a DCF model?**
A DCF model is a spreadsheet-based calculation that forecasts a company’s future free cash flow, discounts it back to present value, and derives an estimate of intrinsic value.

**2. How do you build a DCF model?**
Start with historical financials, build forecast assumptions for revenue and margins, calculate free cash flow, determine a discount rate (WACC), estimate terminal value, discount everything back to present value, and convert enterprise value into equity value and then value per share.

**3. What are the steps in a DCF valuation?**
Forecast revenue and margins, calculate FCFF, calculate WACC, calculate terminal value, discount all cash flows to present value, sum them into enterprise value, adjust for net debt to get equity value, and divide by diluted shares.

**4. What is the DCF formula?**
Enterprise Value = Present Value of Forecast FCFF + Present Value of Terminal Value, where each cash flow is discounted using 1 / (1 + WACC)^t.

**5. What is FCFF?**
Free cash flow to the firm — the cash available to all capital providers, calculated as EBIT × (1 − Tax Rate) + D&A − CapEx − Change in Net Working Capital.

**6. What is WACC in a DCF model?**
The Weighted Average Cost of Capital — the blended required return on a company’s debt and equity, used as the discount rate for FCFF.

**7. How do you calculate terminal value?**
Most commonly with the perpetual growth method: Terminal Value = FCFF₍ₙ₊₁₎ / (WACC − Growth Rate), where growth must be lower than WACC.

**8. How many years should a DCF forecast cover?**
There’s no universal answer — 5 years is common for mature businesses, while less predictable or earlier-stage companies sometimes warrant longer explicit forecast windows before assuming steady-state growth.

**9. What discount rate should be used in a DCF?**
WACC for an FCFF-based (enterprise value) model, or cost of equity for an FCFE-based (equity value) model — the two should never be mixed.

**10. How do you calculate intrinsic value per share?**
Divide equity value (enterprise value plus cash minus debt) by diluted shares outstanding.

**11. What is the difference between FCFF and FCFE?**
FCFF is cash flow available to all capital providers and is discounted at WACC to produce enterprise value; FCFE is cash flow available specifically to equity holders and is discounted at cost of equity to produce equity value directly.

**12. Why is terminal value important?**
Terminal value typically represents the majority of a DCF’s total value — in this tutorial’s example, roughly three-quarters of enterprise value — so its assumptions deserve close scrutiny.

**13. How accurate is a DCF model?**
A DCF is only as accurate as its assumptions; small changes in growth, margin, or discount-rate inputs can shift the output meaningfully, which is why sensitivity and scenario analysis are essential rather than optional.

**14. What are the most common DCF mistakes?**
Overly optimistic growth or margin assumptions, ignoring CapEx or working capital, mixing FCFF/FCFE frameworks incorrectly, using an unjustified WACC, and treating a single output as a certain answer.

**15. What is a reverse DCF?**
A reverse DCF starts from the current market price and solves backward through the model to reveal what growth, margin, or cash-flow assumptions are already priced in.

**16. Can DCF be used for any company?**
DCF works best for businesses with reasonably predictable cash flows; it becomes far less reliable for early-stage, financially distressed, or highly cyclical companies.

**17. Is DCF better than P/E valuation?**
Neither is universally better — DCF is grounded in company-specific cash flows but highly assumption-sensitive, while P/E is simpler but shaped by accounting choices and capital structure; many investors use both together.

—

## Final Takeaway

Historical Financials → Forecast Assumptions → Revenue Forecast → EBIT Forecast → NOPAT → D&A → CapEx → Change in NWC → FCFF → WACC → Discount Factors → Terminal Value → Enterprise Value → Equity Value → Intrinsic Value Per Share → Sensitivity Analysis → Investment Thesis

**A DCF model is not a machine that produces a perfectly accurate stock price. It is a structured framework for translating business assumptions into an estimated valuation** — and the ABC Industries example above shows exactly how each of those assumptions flows through to the final number, including how much that number moves when the assumptions change.

For the broader concepts behind each of these steps, see the companion guide: [DCF Valuation: Complete Advanced Guide](https://blog.investorguidefinder.com/dcf-valuation/). To connect the resulting estimate to an investment decision, see [Intrinsic Value vs Market Price](https://blog.investorguidefinder.com/intrinsic-value-vs-market-price/) and [How to Find Undervalued Stocks](https://blog.investorguidefinder.com/how-to-find-undervalued-stocks/).

—

*Disclaimer: This article is for educational and informational purposes only and does not constitute personalized financial or investment advice. All figures used are entirely fictional and are not a valuation of any real company. Always conduct independent research or consult a qualified financial advisor before making investment decisions.*

How to Build a DCF Model Step by Step

Comments

Leave a Reply Cancel reply