• 
• 
• 
• 
• 
• 
• 
• 

Send to a friend

• linkedin
• twitter
• facebook
• google+
• code

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)

by Business-Valuation.net
Experts in DCF and LBO modelling.

226 reviews18,520 views|7 comments|Bookmark

analysisdcfdcf modeldiscounted cash flowfinanceinvestment bankingprivate equityvaluationvalue of a business

Description
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: https://www.eloquens.com/channel/business-valuation-net

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): https://www.eloquens.com/tool/xQrUMb/finance/discounted-cash-flow-dcf/synergy-valuation-premium-dcf-excel-model

Enjoy!

This business tool includes
1 Excel Model, 1 Online Methodology

Business-Valuation.net offers you this business tool for free!

download for free

Add to bookmarks

Discuss

Further information

Reviews

• Batsukh Bat-Ochir(last updated: 18/07/2018 06:48)
  
• Tram Phan(last updated: 18/07/2018 03:59)
  
• Shirley Xingwan YANG(last updated: 18/07/2018 01:32)
  
• wahyu pranata(last updated: 17/07/2018 08:07)
  
• Sittipume Khanthavit(last updated: 17/07/2018 03:58)
  
• 佳娜 陈(last updated: 16/07/2018 06:55)
  
• Jingwen Xue(last updated: 16/07/2018 05:44)
  
• Aemon(last updated: 16/07/2018 03:36)
  
• Rane Pearson(last updated: 14/07/2018 06:45)
  
• Daniel K. Tonga(last updated: 12/07/2018 04:51)
  
• Debjit Adak(last updated: 11/07/2018 09:52)
  
• Tingxuan An(last updated: 11/07/2018 06:55)
  
• Wan Haifeng(last updated: 10/07/2018 21:41)
  
• Jun Zhang(last updated: 10/07/2018 08:42)
  
• 远 致(last updated: 09/07/2018 07:39)
  
• Petko Ganchev, PhD St(last updated: 09/07/2018 07:31)
  
• jhon doe(last updated: 09/07/2018 05:06)
  
• Rourou Lee(last updated: 09/07/2018 02:28)
  
• Pramodh Kumar(last updated: 07/07/2018 08:33)
  
• Arjun Vyas(last updated: 07/07/2018 03:36)
  
• Ella(last updated: 06/07/2018 08:34)
  

  Good Model Template

  Good Model Template. I think it is convenient and useful to me to learn valuation of a company.
• Le Min(last updated: 06/07/2018 03:42)
  
• Daochi Zhou(last updated: 05/07/2018 08:23)
  
• zelin(last updated: 05/07/2018 04:37)
  
• Simona Pirrera(last updated: 01/07/2018 08:47)
  
• 莫那鲁涛(last updated: 30/06/2018 07:37)
  
• Darrel Luebke, CPA, CMA(last updated: 29/06/2018 13:32)
  
• SANDEEP RUSTOGI(last updated: 29/06/2018 09:46)
  

  DCF Valuation

  Good Illustration for concept clearing
• Rustom Sui(last updated: 28/06/2018 16:05)
  
• Pavan Surabhi(last updated: 26/06/2018 14:14)
  

People using this tool also downloaded

Post Comment

• 

  John Hay 1 year ago
  Tool Useredit

  what does WACC stand for

  1arrow_drop_uparrow_drop_downReply reply

  • 

    Business-Valuation.net 1 year ago
    Tool Authorstar

    WACC stands for Weighted Average Cost of Capital, it is a company's required return on an investment, mixture of both required return on and equity and debt. Read more here: http://www.business-valuation.net/definition/wacc/

    2arrow_drop_uparrow_drop_downReply reply
• 

  Anish Rathi 6 months ago
  Tool Useredit

  Hi, where can I find the accompanying step by step methodology for the sheet?

  arrow_drop_uparrow_drop_downReply reply

  • 

    Business-Valuation.net 6 months ago
    Tool Authorstar

    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

    • 

      Anish Rathi 6 months ago
      Tool Useredit

      Thanks!

      1arrow_drop_uparrow_drop_downReply reply
• 

  Rohit 2 weeks ago
  Eloquens Member

  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

  • 

    Business-Valuation.net 2 weeks ago
    Tool Authorstar

    Dear Rohit. On the page where you download the excel, there should be a tutorial you can follow. If you cannot find it there, the tutorial is also available here: https://www.business-valuation.net/methods/discounted-cash-flow-analysis/
    
    Good luck!

    arrow_drop_uparrow_drop_downReply reply