Valuation · 2026-07-07

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

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

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 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

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 no sign-up. Enter your assumptions and download a valuation you can defend in a data room.

→ Build your financial model free