Skip to main content
/2 min read

DCF Model Overview and Steps

DCF Model Build

1

Project Free Cash Flows

5-10 years of unlevered FCF based on operating assumptions.

2

Calculate Terminal Value

Gordon growth or exit multiple beyond projection period.

3

Discount at WACC

Each year's FCF discounted to present value at the cost of capital.

4

Sum to Get Enterprise Value

Adjust for net debt to get equity value.

Master Financial Modeling at Noble Desktop

Noble Desktop's Financial Analyst Training Program covers financial modeling, valuation, accounting, and Excel for finance.

Discover the process of Discounted Cash Flow (DCF) modeling, a valuation method used to estimate a company's value based on its expected future cash flows, through a step-by-step guide and key considerations.

DCF Model overview and steps

Discounted cash flow (DCF) is a valuation method used to estimate the value of the company based on its expected future cash flows. DCF analysis attempts to figure out the value of the company today, based on projections of how much money it will generate in the future. 

Step 1. Derive historical information from financial statements.

The first step in any financial model is to derive necessary information from financial statements. We need to create historical data in the spreadsheet with the model. Then we need to calculate the necessary totals. And after—we calculate Free Cash Flows, which is the gross free cash flow generated by a company. 

Step 2. Calculate Historical Value Drivers

Next, we need to create a list of historical value drivers to use in our model and calculate them based on the historical line items above.

Step 3. Make Assumptions for the Projected Value Drivers

We can use historical data for that and also any helpful information in the MD&A and footnotes sections of the 10-K. Also, you can do additional research for the industry to make sure your assumptions make sense.

Step 4. Calculate Projected Line Items for the Model.

Calculating based on historical data and projected value drivers we did input and calculated in the previous step.

Step 5. Calculate Equity Value per Share

The final step and final goal of DCF modeling is to find equity value per share. Screenshot of an Excel workbook titled 'Discounted Cash Flow Analysis for Company, ' displaying historical and projected financial data in a table. Several numbered annotations (1–5) highlight key sections, including line items for revenue, expenses, valuation metrics, WACC, and other inputs used in the DCF model.

In the Upcoming Videos, We’ll Build This Simple DCF Model Step by Step.

Some of the points that you need to remember:

  1. There are limitations in terms of using DCF. Primarily that it relies on estimations of future cash flows. That could prove to be inaccurate.
  2. At the same time, DCF is a simple and effective way to value the company.
Video Transcript4 sections

1Full Video Transcript

Discounted cash flow is a valuation method used to estimate the value of the company based on its expected future cash flows. DCF analysis attempts to figure out the value of the company based on projections of how much money it will generate in the future. Let's discuss the logic of building a DCF financial model.

2Gathering Historical Financial Data

The very first step would be to derive historical information from financial statements. We need to create historical data in the spreadsheet with a model and then calculate the necessary totals. After that, we need to calculate free cash flows, which is the gross free cash flow generated by the company.

In the second step, we need to create a list of historical value drivers to use in our model and calculate them based on historical line items above.