Overview

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

Share
Reviews Add a review
Avatar
Elinor
Avatar
Gonzalo Farrell

Great exactly what I needed for my course!

Avatar
Jarinder
Avatar
Daniel Bega

Thanks for good works. keep doing it right

Avatar
John Lawson
Avatar
Lisa Mitchell

Useful DCF template, nice formatting thanks

More From Corporate Finance Institute®

Browse our top rated business templates. See All
Financial Institution Dividend Discount Model
333
0
The financial institution dividend discount model uses future dividends to find the implied share price. This model is based on…
Loan Payment Calculator
246
0
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
306
24
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
296
0
The non-directional trading strategies template allow users to determine the profit when buying options. This template focuses on non-directional strategies…
restructuring financial model template preview 1 Restructuring Financial Model Template
527
0
This restructuring financial model template is used to demonstrate the financial interactions behind the restructuring process. Adjust this model to…
TMT Financial Model Template Preview TMT Financial Model Template
699
0
This TMT financial model template is used to value technology, media, and telecom firms. This model provides a template to…