DCF Valuation Model Template
Originally published: 08/05/2018 08:42
Last version published: 14/02/2019 06:57
Publication number: ELQ-51913-4
View all versions & Certificate

DCF Valuation Model Template

This template provides you with a foundation to build your own discounted cash flow model with different assumptions.

A simple and effective Discounted Cash Flow (DCF) template that allows you to build on your own discounted cash flow model with different assumptions. The model can be edited and adjusted according to your organization's needs.

A Discounted Cash Flow (DCF) model is a specific type of financial model used to value a business. DCF stands for Discounted Cash Flow, so a DCF model is simply a forecast of a company’s unlevered free cash flow discounted back to today’s value, which is called the Net Present Value (NPV).

Discounted Cash Flow (DCF) is a valuation method that is used to estimate the attractiveness of an investment opportunity. It analyzes future free cash flow projects and discounts them by using an annual rate, which then gives us the present value estimates. This present value estimate is then used to evaluate the potential for investment. If the value is higher than the current cost of the investment, the opportunity may be a desirable one.

The basic building block of a DCF model is the 3 statement financial model, which links the financials together. Once you have downloaded this tool, you will see the step-by-step methodology that accompanies the DCF template.

This Best Practice includes
1 DCF Model Excel Template

CFI offers you this Best Practice for free!

download for free

Add to bookmarks


4.7 / 5 (61 votes)

please wait...