Originally published: 19/09/2016 14:53
Last version published: 05/04/2018 12:30
Publication number: ELQ-10661-11
View all versions & Certificate
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.netExperts in DCF and LBO modelling.
Business-Valuation.net 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.
Reviews
People using this tool also downloaded
All in One Private Equity Model
Used by Investment Professionals at Private Equity and IB Firms4,887 remove_red_eye2 chat_bubble$180.00by John SwanCalculating Discounted Cash Flow in Excel
This video takes you through a DCF Excel model to show you how to calculate Discounted Cash Flow.623 remove_red_eyeDiscussfreeby Finance WalkInformation Technology (IT) Industry Business Excel Model
This financial model focuses on valuation of a company in the Information Technology (IT) industry.106 remove_red_eyeDiscuss$49.00by Karan KaushalLBO model - Leveraged Buyout Analysis
A step by step LBO model tutorial. It is easy to use and we provide support if needed. Have fun modeling!12,059 remove_red_eye7 chat_bubbleBusiness Valuation Excel Model with Economic Value Added
Business and investment valuation model with economic value added (EVA) calculations.900 remove_red_eyeDiscussThe Discounted Free Cash Flow (DCF) Model
A full discounted cash flow excel model for a complete business1,312 remove_red_eyeDiscussSensitivity Analysis Using Excel
In this video you will learn how to carry out sensitivity analysis using Excel.669 remove_red_eyeDiscussfreeby Finance WalkDCF Valuation Model Template
This template provides you with a foundation to build your own discounted cash flow model with different assumptions.789 remove_red_eyeDiscussfreeby CFIDiscounted 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.11,169 remove_red_eyeDiscussfreeby FirmexDiscounted Cash Flow (DCF) Model (Academic Quality)
A simple DCF model serving as an academic exercise to understand how financial modeling works.1,382 remove_red_eyeDiscussfreeby Joshua Wong
More tools from Business-Valuation.net
Synergy Valuation Premium DCF Excel Model
A Premium Discounted Cash Flow DCF Model including synergy valuation1,927 remove_red_eyeDiscussLBO model - Leveraged Buyout Analysis
A step by step LBO model tutorial. It is easy to use and we provide support if needed. Have fun modeling!12,059 remove_red_eye7 chat_bubble
Discussion feed for Discounted Cash Flow (DCF) Model
The user community and author are here to help. Go ahead!
- Thanks for your question. I only use it to value private companies... Stock-listed companies tend to have a market value already (right or wrong). Good luck!
- Thanks! I was looking to value a private saas start-up companie. Do you have any idea of some modification I should bring to the model. Or maybe there's another model better to value this type of companies.
- You can perhaps check these pages on Eloquens.com -> There are quite a few SaaS Valuation Models in there. If you don't find what you're looking for, you're welcome to Private Message the Authors - perhaps they can help! Good luck!
https://www.eloquens.com/category/startups/software-as-a-service-saas/78
https://www.eloquens.com/category/startups/financial-models/87
https://www.eloquens.com/category/startups/startup-valuation-methods/711
- When you calculate implied exit multiple, why do you multiple the terminal value with (1+WACC)^period? shouldn't the terminal value in cell D63 already be the the value at the terminal year?
- Good question. It is calculated the way I was taught. I guess both methods will work. Good luck.
- is using size premium a market standard? I never learnt to account for the size premium when calculating cost of equity.
- Different schools are applied also here. It does not make sense to have a very low WACC on a start-up or a very small company, then the value will be too high. There are several ways to adjust WACC such as; size premium, country premium, company-specific premium etc.
- shouldn't the discount period 1 instead of 0.5 buz you are discounting by 1 year instead of discounting semi-annually?
- Mid-year method is applied. You do not receive all cash at the end of the period. Different schools, pick the method you prefer best.
- what does WACC stand for
- 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/
- In the tutorial which company's data has been used? I'd like to know so I can relate to the correct numbers while looking at other company's data.
- Thanks for your question. Sorry to disappoint you but a lot of the numbers in the model are made up to achieve a "normal" business for educational purpose. I am happy to answer other questions you might have in the modeling. Good luck.
- Hi, where can I find the accompanying step by step methodology for the sheet?
- 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!
- 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?
- 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!
- why to remove the model?Can u pls send it to my Email,tks!
- Dear Tao, I am not sure what you mean. The model is still published?
- Hi Tao,
If you want to have access to the model, simply click on the big blue button "Download for Free" on this page (see above). The Tool will then be added to your personal Eloquens library. Then, click on the title and you will be re-directed to a page from which you can download the Excel File! (Big Blue Button "Download").
Let us know if you face any additional issues in the process.
Best regards,
The Eloquens Support Team
Tool Useredit