Discounted Cash Flow (DCF) Model
  • Discounted Cash Flow (DCF) Model
  • Discounted Cash Flow (DCF) Model
  • Discounted Cash Flow (DCF) Model
  • Discounted Cash Flow (DCF) Model
Originally published: 19/09/2016 14:53
Last version published: 04/04/2017 12:35
Publication number: ELQ-10661-5
View all versions & Certificate

Discounted Cash Flow (DCF) Model

A step by step discounted cash flow analysis tutorial (DCF model)

analysisdcfdiscounted cash flowfinanceinvestment bankingprivate equityvaluationvalue of a business

DCF analysis is a valuation method which uses future cash flow predictions to estimate investment return potential by discounting these projections to a present value approximation and using this to assess the attractiveness of the investment.

The aim of this simple tutorial is to provide a good understanding of the DCF model and how it works. To further improve and develop your understanding and get a more in-depth view, this modelling package ( is considered to be one of the best available financial modelling tutorials out there.

This 10-step model template aims to help you calculate the value of a business. To guide you, the step-by-step description is also included in the model so everything you need is all in one file!

This business tool includes
1 Excel Model, 1 Online Methodology offers you this business tool for free!

download for free



Discussion feed for Discounted Cash Flow (DCF) Model

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

  • John Hay
    what does WACC stand for
    1arrow_drop_uparrow_drop_downReply reply
  • Anish Rathi
    Hi, where can I find the accompanying step by step methodology for the sheet?
    arrow_drop_uparrow_drop_downReply reply
      Hi Anish,

      Sure! It's really easy.
      1/ Download the DCF Model from this page
      2/ Go to your Library Page on Eloquens
      3/ Click on the Tool Title Link
      4/ You will be on the /details page and from there you will be able to download the file + follow the step by step methodology written just below.

      Hope this helps (feel free to give a rating/review if you have appreciated the model).

      Good luck!
      2arrow_drop_uparrow_drop_downReply reply
please wait...