Free Download DCF Model Template (Discounted Cash Flow Valuation Model)

This simple DCF model in Excel allows you to value a company via the Discounted Free Cash Flow (DCF) valuation method. The discounted cash flow valuation model uses a three statement model to derive free cash flows to firm and discounts them to their present value.

Discounted Cash Flow DCF Valuation
, ,
, , , , , , , ,

The DCF Model template allows you to quickly perform a Discounted Cash Flow Valuation from the convenience of your own Excel file.

The Discounted Cash Flow Valuation Model

A DCF valuation is a forward-looking valuation method based on an expected cash flow stream going forward. The DCF valuation method focuses on cash and not on accounting profits, therefore, it includes any effects which impact the cash position of a company before considering the type of financing (debt or equity). As such, a DCF valuation is one of the theoretically most solid valuation methods which can be used to value a company or an asset. Other valuation methods often used by practitioners, such as e.g. comparable market multiples or replacement cost considerations, at the end of the day fall short to correctly consider the company’s specific future prospects. This advantage makes the DCF valuation method very powerful and – when done correctly – will lead to the identification of many good arguments to be considered. Most DCF valuations use the unlevered cash flow available to the company, the Free Cash Flow to Firm.

However, the main challenge with the DCF valuation is that it requires a set of forward-looking assumptions, which normally are quite subjective and more often are subject to manipulation. Therefore, very solid analysis and objectively rational argumentation need to be made in order to make the result of a DCF valuation believable.

We have put together a simple DCF model free of charge to give you a toolset value for a company via this valuation method.

Add to wish list

How the DCF Model Works

The DCF model comes as an Excel template and requires a Free Cash Flow stream of a minimum of 5 years. This is normally done by forecasting the financial statements of a company over the next years. We have, therefore, included a three statement model in this Excel file, which allows you to build the Income Statement, Balance Sheet, and Cash Flow Statement of the company. Afterward, it’s possible to calculate the Free Cash Flow to Firm over the next years by adding up the following:

  • EBIT (Earnings before Interest and Taxes)
  • Adjusted Taxes (the applicable income tax rate applied to EBIT
  • Add back Depreciation and Amortization as these are non-cash expenses
  • Change in Net Working Capital needs to count for any changes of the working capital required to run a company
  • CAPEX is one of the major cash flows and needs to be deducted

The DCF model will then require a discount rate to discount the future cash flows back to their present value. The discount rate should reflect the company’s risk (or the risk of an asset).

  • The weighted average cost of capital (debt and equity costs weighted). See the WACC model on how to calculate the WACC.

The discounted cash flow valuation model will then discount the Free Cash Flows to Firm to their present value which will be equal to the Enterprise Value. In order to obtain the Equity value, net debt will be deducted.

  • Deduct a company’s financial debt
  • Add the company’s cash

The equity value will be the end result of your discounted cash flow valuation model.

You can use this DCF model as a starting point to build your own DCF valuation model. You can simply start to replace the line items with more detailed calculations that reflect the value of your company. The discounted cash flow valuation model will work as long as the figures are correctly flowing into the Free Cash Flow to the Firm.

The DCF model provides a template to value a company via the Discounted Cash Flow (DCF) valuation method.

Filetype: .xlsx

Add to wish list

We always strive to help as much as we can to provide you all with better financial model templates. Of course, we would be really grateful if you give us any feedback, comments, suggestions, and reviews of our templates, for this will guide us and our Vendors, in deciding which financial model templates to create in the future. Also, for those who are looking for financial model templates that you can’t find in our inventory, please feel free to comment your request here: Missing Financial Model Templates, so that one of our Vendors will pick up that project for you.



  • DFC Model

    Really well laid out easy to use template/model. Was very helpful.

    1 of 2 people found this review helpful.

    Help other customers find the most helpful reviews

    Did you find this review helpful? Yes No

  • Deduct a company’s financial debt

    if company’s financial debt tenor spread for 15 years , how can we deduct the same from the DCF while valuation?

    Thank you for your feedback.

  • Finance Manager

    Excellent Template. It covers all the aspects of the company on which the valuation is carried out for. I really appreciate the efforts spent in making this template. It is easy to understand and easy to comprehend the results based on the information that is used in the DCF calculation.

    I would appreciate It if another option was also included in addition to Multiples of EBITDA, the Growth to perpetuity percentage for the terminal valuation.

    1 of 2 people found this review helpful.

    Help other customers find the most helpful reviews

    Did you find this review helpful? Yes No

  • DCF Template

    Excellent templates..

    1 of 2 people found this review helpful.

    Help other customers find the most helpful reviews

    Did you find this review helpful? Yes No

  • Write a Review

    500 character(s) remaining