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
  • 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: 05/04/2018 12:30
Publication number: ELQ-10661-11
View all versions & Certificate

Discounted Cash Flow (DCF) Model

A step by step Discounted Cash Flow Analysis Tutorial (DCF model)

analysisdcfdcf modeldiscounted 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.

This 8-step DCF model template aims to help you calculate the value of a business. Every step is described and you are encouraged to ask questions if you need clarifications.

This DCF model template is all you need, it saves time (don't reinvent the wheel...), and it works!

You'll also find a few other models and tutorials we have put together on our Eloquens Channel here:

Should you have any questions on the model you're welcome to Private Message us via our Eloquens Channel or use the discussion feed below.

Feel free to leave a review and a rating if you have appreciated the model!

- The Business Valuation Team

PS: if you want to access a Premium Version of a DCF Excel Model (including Synergy Valuation) it's here (and built by us):


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

download for free

Add to bookmarks


Further information

This DCF model can be used by CFOs, Students, Teachers, Business controllers, M&A analysts, Private Equity analysts etc. The model is easy to use, has a hiqh flexibility and gets the job done.



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
  • Rohit
    I did not receive the online methodology document. Can only download the Excel file using the link sent over e-mail. Could you please help?
    arrow_drop_uparrow_drop_downReply reply
please wait...