Discounted Cash Flow Model Template
  • Discounted Cash Flow Model Template
  • Discounted Cash Flow Model Template
  • Discounted Cash Flow Model Template
  • Discounted Cash Flow Model Template
  • Discounted Cash Flow Model Template
  • Discounted Cash Flow Model Template
Originally published: 09/11/2016 13:46
Publication number: ELQ-78928-1
View all versions & Certificate
certified

Discounted Cash Flow Model Template

A fully customizable excel model to match your needs, and use as a starting point or as a full DCF tool for valuation.

dcffinancefree cash flow projectionsinvestment analysisinvestment bankingvaluationwacc

Description
Don't waste hours creating your own discounted cash flow model.

Discounted cash flow (DCF) is used to estimate the attractiveness of an investment opportunity. DCF analysis uses future free cash flow projections and discounts them (most often using the weighted average cost of capital) to arrive at a present value, which is used to evaluate the potential for investment. If the value arrived at through DCF analysis is higher than the current cost of the investment, the opportunity may be a good one.

Instructions
1: Input the valuation date, discount rate, perpetual growth rate, and tax rate.
2: Forecast the company's key financials and calculate the corresponding free cash flows.
3: Discount the Projection Period and Terminal cash flows to the present using the discount rate.
4: The sum of future cash flows determines the aggregate value of the business today.

- Firmex Team

This business tool includes
1 Excel Model

Firmex offers you this business tool for free!

download for free

Add to bookmarks

Discuss

Reviews

  • Earnest Prashanth Sikhamani(last updated: 16/05/2018 02:53)
  • Dogan Pesen(last updated: 15/05/2018 15:14)
  • PV Kanthi Rekha(last updated: 12/05/2018 03:06)
  • Vivek Malviya(last updated: 11/05/2018 17:11)
  • Alex Cherh(last updated: 11/05/2018 15:29)
  • Mingwei Cao(last updated: 09/05/2018 14:33)
  • Aniello Priore(last updated: 08/05/2018 08:52)
  • Hector Rodriguez(last updated: 06/05/2018 17:00)
  • Salah K(last updated: 05/05/2018 14:36)
  • fatima hamad(last updated: 04/05/2018 22:25)
  • David Schibler(last updated: 03/05/2018 15:07)
  • Ray Ding(last updated: 02/05/2018 13:09)
  • al ss(last updated: 01/05/2018 16:54)
  • 雅韵 刘(last updated: 26/04/2018 07:56)
  • Meelan Gurung(last updated: 26/04/2018 03:24)
  • Sola(last updated: 25/04/2018 10:42)
  • Yixiang Hao(last updated: 25/04/2018 08:24)
  • Jesse Väisänen(last updated: 15/04/2018 07:13)
  • 宇祺 刘(last updated: 07/04/2018 05:39)
    很优秀便捷的模板
    作为一个初学者,有幸接触到这个模板让我对DCF有一个相对全面的认识。十分感谢作者
  • John Fletcher(last updated: 19/03/2018 14:17)
    Discounted Cash Flow Model
    I want to thank Firmex for introducing this template for the Eloquens audience. I have used this template to give me a quick overview on the assumptions that get to the heart and soul of DCF analysis. I highly recommend this spreadsheet template to be used in conjunction with Prof. Aswath Damodaran's Economic Value Added (EVA) & Discounted Cash Flow (DCF) template. These are very powerful tools that tell a very complete and compelling financial story when integrated together.
  • Natee Bicharoen(last updated: 15/03/2018 14:29)
    Nice Presentation
    Bar charts can explain everything by themselves
  • Kamilah Collison(last updated: 14/03/2018 11:23)
  • Mohammed Halaseh(last updated: 12/03/2018 12:53)
  • Ankur Kumar Jha(last updated: 16/02/2018 06:34)
  • Dwindra Arief Julianto(last updated: 05/02/2018 02:13)
  • Waskito Adinugroho(last updated: 13/12/2017 09:50)
  • Katwere James(last updated: 19/11/2017 08:29)
    Good DCF Template
    Really helpful excel model
  • Zhou Song(last updated: 13/10/2017 08:22)
  • Alfonso Cioffi(last updated: 12/10/2017 20:22)
  • Long Lê(last updated: 08/10/2017 05:18)
    Very well-organized template
    Just have a quick look at it. Simple and easy to follow

keyboard_arrow_leftkeyboard_arrow_right

Any questions on Discounted Cash Flow Model Template?

The user community and author are here to help. Go ahead!

please wait...