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

A Discounted Cash Flow 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 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 (typically a firm's Weighted Average Cost of Captial), 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.


[caption id="attachment_319" align="alignnone" width="1000"]DCF Model Excel File Example Screenshot from the model.[/caption]


DCF Excel Model Building Tips

After downloading the template you may wish to make some changes to the Excel file. Here are some tips and best practices for building a robust model.

  1. Format all assumptions and hardcoded numbers with a blue font
  2. Ensure all formulas are formatted as a black font
  3. Break down complex formulas into simpler steps
  4. Use headings and title to keep your model organized
  5. Audit the formulas and functions
  6. Create charts and graphs to display the output of your results
  7. To learn more, check out CFI's Free Excel Crash Course


Thank you for downloading this free DCF Model Excel template, we hope you find it useful!


This business tool includes
1 DCF Model Excel Template

Reviews Add a review
Marinos Kyriacou

Very Helpful DCF template

Gonzalo Farrell

Great exactly what I needed for my course!

Daniel Bega

Thanks for good works. keep doing it right

John Lawson
Lisa Mitchell

Useful DCF template, nice formatting thanks

More From Corporate Finance Institute®

Browse our top rated business templates. See All
REIT Financial Model Template
This REIT financial model template acts as a guideline for modeling a real estate investment trust (REIT). This model will…
Energy Industry Comps Template Energy Industry Comps Template
This energy industry comps template provides a guideline and example of what a comparables universe would look like for a…
Financial Institution Dividend Discount Model
The financial institution dividend discount model uses future dividends to find the implied share price. This model is based on…
Loan Payment Calculator
The loan payment calculator allows users to determine the principal and interest payment each month until the full balance of…
DDM - Excel Dividend Discount Model Template
The dividend discount model template allows investors to value a company base on future dividend payments. This is based on…
Non-directional trading strategy template Non-directional Trading Strategies Template
The non-directional trading strategies template allow users to determine the profit when buying options. This template focuses on non-directional strategies…
See All