DCF Model (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 tool set value 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 minimum 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 which 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 its 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, for 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.

 

Users who purchased DCF Model (Discounted Cash Flow Valuation Model), also purchased:
Hotel Valuation Financial Model
Hotel_VaHotel Valuation Financial Modelluation_Financial_Model
Add to wish list
Purchase Excluding 7.7% tax
Wind Energy Financial Model
Wind Energy Financial Model
Add to wish list
Purchase Excluding 7.7% tax
Solar Energy Financial Model
Solar Energy Financial Model
Add to wish list
Purchase Excluding 7.7% tax

Reviews

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

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