Simple DCF Model

Overview This exercise is a simplified DCF modeling practice designed to teach the core mechanics of valuing a mature, capital-intensive company, such as an energy equipment manufacturer. Using a streamlined set of assumptions, you project free cash flows, apply a discount rate, and calculate enterprise and equity value in a realistic, asset-heavy business scenario. The emphasis is on understanding how key inputs — growth, margins, capital expenditures, working capital, and discount rates — drive valuation. This practice helps you build intuition for DCF logic, without getting lost in complex spreadsheet details. By completing this exercise, you’ll gain a clear grasp of the step-by-step process analysts use to estimate company value, a core skill in investment banking, private equity, and corporate finance. Learning Goals Understand the core logic of Discounted Cash Flow (DCF) valuation and how expected future cash flows determine intrinsic value. Learn how operating assumptions are translated into projected Free Cash Flow over a multi-year forecast period. Develop intuition for the role of the discount rate by applying WACC to reflect risk and the time value of money. Compare two commonly used approaches to estimating terminal value— the Perpetual Growth method and the Exit Multiple method—and understand when each is most appropriate. See how enterprise value is translated into equity value and an implied share price in practical valuation analysis. Key Concepts Unlevered Free Cash Flow (UFCF): Cash generated by the business before financing costs, available to all capital providers. Cost of Equity: The required return for equity investors, typically estimated using CAPM. WACC: The blended cost of debt and equity used as the discount rate in a DCF. Terminal Value (Perpetual Growth): Assumes the company grows at a constant rate forever. Terminal Value (Exit Multiple): Estimates value based on a valuation multiple applied in the terminal year. Enterprise Value (EV): The total value of the firm’s operations, independent of capital structure. Equity Value & Share Price: Deriving shareholders’ value after adjusting for cash, debt, and shares outstanding.

Practice Simple DCF Model with interactive Excel modeling exercises in our DCF Modeling module.

This hands-on modeling exercise helps you master Simple DCF Model through real-world Excel practice and financial modeling techniques.