# DCF Model Example Build a discounted cash flow model with forecast drivers, free cash flow, WACC, terminal value, and valuation outputs in a cleaner Excel-ready structure. - Canonical: https://finamodel.com/examples/dcf-model - Excel download: https://finamodel.com/templates/dcf.xlsx - Category: Capital Markets - Model type: Valuation - Difficulty: Advanced - Audiences: Investors & analysts, CFOs & FP&A, Investors, M&A advisors, Corporate finance, Equity research - Tags: valuation, fcf, wacc, investment, intrinsic-value ## Overview A DCF model values a company by discounting its unlevered free cash flows to present value. It answers the fundamental question: what is this business worth today based on its projected cash generation? This model covers a multi-year explicit forecast period (typically 5–10 years), terminal value calculated using both perpetuity growth and exit-multiple methods, and a complete bottom-up derivation of weighted average cost of capital (WACC) incorporating the company's target capital structure, cost of equity, and cost of debt. The transparency embedded in the WACC build - showing all components: risk-free rate, equity risk premium, beta, and debt costs - eliminates the black-box discount rate problem. The workbook includes historical financials linked to forward assumptions, driver-based free cash flow bridges from EBIT through working capital and capex, and a sensitivity matrix showing valuation across a range of key assumptions: revenue growth, margin trajectories, and discount rates. Terminal value is derived two ways - perpetuity growth and trading multiples - allowing you to stress-test the exit value assumption. The model produces a per-share valuation range with explicit upside and downside scenarios, giving you both a point estimate and a football field of plausible values. Enterprise value models like this are standard in M&A, PE underwriting, and equity research. This template works for any industry where you can forecast free cash flow with confidence. ## What's included - Segmented revenue forecast and margin build - Working capital schedule and free cash flow bridge - WACC build-up using CAPM inputs - Terminal value using perpetuity growth and exit multiple methods - Enterprise value to equity value bridge and sensitivity analysis - Multi-year unlevered free cash flow forecast with drivers - Terminal value calculation using perpetuity growth and exit multiple methods - Full WACC build-out: cost of equity, cost of debt, target capital structure - Sensitivity analysis across key assumptions (growth, margin, WACC) - Valuation summary and per-share estimates - Historical financials and assumption linkage ## How the DCF Model Values an Operating Business This enterprise DCF model frames valuation differently from a simple multiple. It projects unlevered free cash flow from multi-segment revenue and cost drivers, discounts those flows at WACC, adds a terminal value from two cross-checked methods, then bridges enterprise value to equity value. The page explains how the calculation flows and where sensitivities matter. ### Operating drivers that shape the cash flow forecast The forecast starts with five revenue segments, each carrying its own growth rate and gross margin. Stage-one growth applies through an explicit early period, then fades linearly toward a terminal growth rate across the remaining projected years. - This structure avoids a sudden growth kink and lets a mixed software and services portfolio behave differently by segment. Operating costs split into fixed-base lines that compound from a first-year amount and variable lines tied to revenue, with marketing treated as scenario-sensitive. - CapEx and depreciation are entered as revenue percentages, while working capital is derived from days sales outstanding, days inventory outstanding and days payables outstanding. A tax section rolls forward net operating losses, which matters for targets carrying tax shields into early forecast years. Together these drivers mean the model does not simply grow a single revenue line. It separates volume-like growth, margin mix, reinvestment and tax timing, so a change in segment mix or collection assumptions shows up in cash flow rather than hiding inside a blended average. ### How cash flow is discounted and how terminal value is handled Unlevered free cash flow is built from EBIT less cash taxes, plus depreciation and amortisation, less capital expenditure and less the change in net working capital. The discount rate comes from a WACC build using CAPM, with peer betas unlevered and re-levered through the Hamada relationship, an after-tax cost of debt, and target capital weights. - Discounting can follow either a mid-year or end-of-year convention, and the model supports a stub period for first-year timing. Terminal value is calculated two ways: a Gordon growth perpetuity using normalised free cash flow, and an exit multiple applied to final-year EBITDA. - Both use the same discount factor as the final explicit period to avoid a half-period mismatch. The model then takes the average enterprise value, but also displays the implied exit multiple and implied perpetuity growth so the two methods can be compared. The design pays particular attention to steady-state consistency. Normalised free cash flow uses terminal capital expenditure and a terminal working capital change, with terminal CapEx defaulting to terminal depreciation so a perpetuity is not overstated by an investment profile that never converges. ### From enterprise value to equity value and outputs After the average enterprise value is determined, the model bridges to equity by subtracting gross debt, preferred stock and minority interest, and adding cash and associates. Each of those items is labelled as of the valuation date, so the measurement date is explicit rather than assumed. - The resulting equity value supports an implied share price and underpins the sensitivity grids that vary WACC against terminal growth and against the exit multiple. A separate comparables cross-check places peer multiples alongside the discounted cash flow result, and a checks sheet runs ten institutional sanity tests. - Those tests cover terminal value as a share of enterprise value, whether the implied perpetuity growth or exit multiple falls outside a plausible band, the requirement that WACC exceeds terminal growth, also that discount factors decline monotonically, and that segment revenue ties to total revenue. A scenario toggle switches thirteen critical inputs between base, bull and bear sets, including segment growth, capital expenditure, marketing, terminal growth and exit multiple. The point is to test how sensitive the valuation is to a coherent set of assumptions rather than to move every input independently. ### Practical use and boundaries The model is documented for mature operating businesses, standalone acquisition baselines, leveraged buy-out or private-credit screening, and sale-process fairness work where sensitivities are the deliverable. It is intentionally an enterprise DCF: unlevered free cash flow discounted at WACC, then bridged to equity. - That makes it less suitable where capital structure or regulated returns are the central story, such as financial institutions, insurance, utilities or REITs, for which the design points to an alternative dividend discount approach. Pre-revenue companies without a meaningful NOPAT base are outside the documented scope. - It is also worth noting that the public download is a values-only preview. The underlying model captures these relationships, but the preview should be read as an illustration of structure and calculation flow rather than a live, automatically recalculating workbook. Default calibration is to a mid-cap mixed-portfolio operating business, and the model's own checks are designed to pass under base, bull and bear scenarios. Readers evaluating the template should focus on whether the driver set, terminal value treatment and bridge match the business being valued. ## Built for valuation decisions Use this model when you need to estimate intrinsic value, compare scenarios, or support an investment or strategic decision with a proper cash flow framework. ## Designed around real DCF logic A useful DCF is more than one discount formula. It needs operating forecasts, working capital, discounting assumptions, and a credible bridge from enterprise value to equity value. ## Better for review and iteration This gives you a stronger starting point for Excel-based valuation work, so you can test assumptions and explain the output without rebuilding the workbook from scratch. ## Built for valuation work This page targets users who need a practical DCF model template for investment, advisory, or internal valuation work. ## Faster than building from scratch Instead of wiring together a DCF file manually, start from a cleaner structure and adapt assumptions to your case. ## Useful for Excel-based workflows The output is designed for spreadsheet users who still need a proper workbook with auditable logic. ## Workbook structure ### Cover A front sheet that frames the workbook and keeps the valuation model organised. - Workbook overview and model framing - Clean starting point before assumptions and calculations - Easy orientation for reviewers and collaborators ### Assumptions This sheet holds the key drivers for revenue, margins, working capital, discount rate, and terminal value assumptions. - Revenue growth and margin assumptions - Discount rate and CAPM inputs - Terminal growth and exit multiple assumptions - Working capital and operating driver setup ### Income Statement The operating forecast builds revenue, margins, operating costs, and profit so the valuation is based on a coherent business case. - Segmented revenue build - Margin progression and operating costs - EBIT and tax logic - Operating performance that feeds the valuation ### Working Capital This schedule models receivables, inventory, and payables so free cash flow reflects real operating cash mechanics. - Receivables, inventory, and payables schedules - DSO, DIO, and DPO logic where relevant - Working capital investment over time - Cash flow effects of operational changes ### Free Cash Flow The free cash flow sheet bridges operating performance to unlevered cash flow available for valuation. - NOPAT to free cash flow bridge - Capex and working capital adjustments - Unlevered cash flow calculation - Clear transition from operating performance to valuation input ### DCF Valuation This sheet discounts projected cash flows, applies terminal value methods, and bridges enterprise value to implied equity value. - Discounted cash flow calculation - Perpetuity growth and exit multiple terminal values - Enterprise to equity value bridge - Sensitivity analysis for key valuation drivers ## Features - **Transparent WACC derivation:** Build cost of equity via CAPM, cost of debt from spreads, and target leverage to derive WACC used in discounting. - **Flexible terminal value logic:** Support perpetuity growth, terminal multiple, or custom terminal year methods; test sensitivities across each. - **Bridge from operations to FCF:** Link EBITDA, capex, NWC, and tax to generate unlevered FCF that flows into the valuation. ## Use cases - **Equity valuation for M&A or IPO:** Generate intrinsic value estimates as a benchmark for offer prices or public company comparables. - **Fairness opinion support:** Use as one of three valuation methods (comps, precedents, DCF) in fairness analyses. - **Strategic investment review:** Model acquisition or expansion targets with full FCF and WACC sensitivity to support board decision-making. ## Frequently asked questions ### What is a DCF model used for? A DCF model is used to estimate the intrinsic value of a business by forecasting future cash flows and discounting them back to present value. ### Does it include WACC and terminal value? Yes. A proper DCF model includes discount rate logic and terminal value methodology. ### What should a DCF model include? A solid DCF model should include operating forecasts, free cash flow, WACC, terminal value, and a bridge from enterprise value to equity value. ### Who uses DCF models? DCF models are commonly used by finance teams, investors, bankers, consultants, and operators doing valuation work. ### Can I use this in Excel? Yes. The template is meant to be Excel-ready so it can be reviewed, adapted, and shared easily. ## Related templates - [Leveraged Buyout Model](https://finamodel.com/templates/lbo-model) - [Dividend Discount Model](https://finamodel.com/templates/dividend-discount-model) - [Comparable Companies Analysis](https://finamodel.com/templates/comparable-company-analysis)