How to Build a DCF Model in Excel (Step-by-Step Guide)

Key takeaway

Build a discounted cash flow (DCF) model in Excel step by step — unlevered free cash flow, WACC, terminal value, enterprise and equity value.

A DCF model in Excel values a business as the present value of the cash it will generate in the future. You project unlevered free cash flow for an explicit forecast period, discount each year back at the weighted average cost of capital (WACC), add a discounted terminal value for everything beyond the forecast, and subtract net debt to reach equity value. Done well, a DCF is the most defensible way to value a company; done carelessly, small assumption errors compound. Here is the structure, in order.

Step 1 — Project unlevered free cash flow

Start from the operating model: revenue, costs, tax and the investment needed to sustain the business. Unlevered free cash flow (UFCF) is NOPAT (operating profit after tax) plus depreciation and amortisation, minus capital expenditure, minus the increase in working capital. UFCF is used because it is the cash available to all capital providers, independent of how the business is financed.

Step 2 — Choose a discount rate (WACC)

The same cash flows, discounted at different WACCs — why the rate deserves a defensible build-up.

The discount rate reflects the risk of those cash flows. WACC blends the cost of equity and the after-tax cost of debt by their weights in the capital structure. You can enter WACC directly or build the cost of equity from CAPM: risk-free rate plus beta times the equity risk premium. Because the discount rate drives the whole valuation, it deserves a defensible, source-backed build-up.

Step 3 — Discount the cash flows

Discount each period's UFCF by 1 ÷ (1 + WACC) raised to the period number, then sum the present values. This is the value of the explicit forecast. Getting the period convention right matters — mid-year vs year-end, and fractional periods for quarterly or monthly models — because errors here quietly bias the answer.

Step 4 — Add a terminal value

Most of a DCF's value usually sits beyond the forecast, captured in the terminal value. The Gordon-Growth method uses TV = final-year FCF × (1 + g) ÷ (WACC − g), where g must be safely below WACC. Discount the terminal value back to today and add it to the sum of discounted cash flows to get enterprise value. Always cross-check it against an EV/EBITDA exit multiple.

Step 5 — Bridge to equity value and IRR

Subtract net debt (debt minus cash) from enterprise value to reach equity value, then compute the equity IRR including the exit. A credible model also runs sensitivity tables on WACC and terminal growth, because a single point estimate hides how much the answer moves with the assumptions.

Common DCF mistakes to avoid

Three errors ruin more DCFs than any others: setting terminal growth at or above WACC (which breaks the perpetuity formula and produces a nonsensical value), forgetting to discount the terminal value back to today, and using inconsistent period conventions between the forecast and the discounting. A fourth — omitting the increase in working capital from free cash flow — quietly overstates value for any growing business. A model that runs these checks automatically stops you from silently shipping a wrong number into a valuation.

Generate a DCF automatically

A quick sanity check on your DCF

Before trusting a DCF, pressure-test three things. First, what share of enterprise value is the terminal value? Above roughly 75% means the explicit forecast is doing too little work — extend it. Second, does the implied exit EV/EBITDA multiple look sane versus comparable companies? Third, is WACC comfortably above terminal growth? If any check fails, revisit the assumptions before trusting the output.

Cross-check with a multiple

A DCF and a comparable-companies valuation should land in a similar range. A large gap is not necessarily wrong, but it flags an assumption — growth, margin or discount rate — that deserves a second look.

The EasyFinancialModels DCF Valuation Model writes every one of these formulas for you — UFCF build, WACC or CAPM, discounting, Gordon-Growth terminal value, EV/EBITDA cross-check, enterprise and equity value, IRR and four sensitivity tables — as a linked, editable Excel workbook. It is free for a 3-year model, annual to monthly, with just your email. Enter your assumptions and download a valuation you can defend in a data room.

Frequently asked questions

What are the steps to build a DCF in Excel?

Project unlevered free cash flow, calculate WACC, discount each year's FCF to present value, add a discounted terminal value for enterprise value, then subtract net debt for equity value.

What is the biggest mistake in a DCF?

Over-relying on the terminal value, which often exceeds half of enterprise value. Keep terminal growth below WACC and long-run GDP, and cross-check against an exit multiple.

How many forecast years should a DCF have?

Five to ten explicit years is standard — long enough to reach steady state, short enough to forecast credibly. Longer-life assets justify extended horizons.

→ Build your dcf & valuation model free with the DCF Valuation tool

More DCF & Valuation guides

Hurdle Rate Explained: How to Set the Minimum Return (and Use It with NPV & IRR) · DCF Valuation Explained for Founders and Analysts · How to Calculate WACC and Cost of Equity (CAPM Formula) · How to Calculate Terminal Value in a DCF (Gordon Growth & Exit Multiple) · Enterprise Value vs Equity Value: The Difference Explained

About the author

Every model is built and reviewed by the project's Financial Advisor — a Fellow Chartered Accountant (FCA) of the Institute of Chartered Accountants of Pakistan (ICAP), Chartered Global Management Accountant (CGMA) and Associate Chartered Management Accountant (ACMA) with around two decades of corporate finance, audit and accounting experience, designing investor-grade financial models across industries. Full credentials and background are available on LinkedIn. More about the author →

← All guides · WACC calculator · DCF calculator · IRR calculator · Inside the 16-sheet model