DCF Valuation Model Template

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

by CFI
Corporate Finance Institute® (CFI) - Official provider of the Financial Modeling & Valuation Analyst (FMVA)™Follow 225

47 reviews1,551 views|Start the discussion!|Bookmark download for free

Description
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