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
- EASE OF USEWAS A LITTLE COMPLICATED FOR MY LEVEL OF EXPERTISE, BUT I'M GETTING ALONG NOW
People using this tool also downloaded
All in One Private Equity Model
Used by Investment Professionals at Private Equity and IB Firms4,703 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.485 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.61 remove_red_eyeDiscuss$49.00by Karan KaushalSensitivity Analysis Using Excel
In this video you will learn how to carry out sensitivity analysis using Excel.545 remove_red_eyeDiscussfreeby Finance WalkBusiness Valuation Excel Model with Economic Value Added
Business and investment valuation model with economic value added (EVA) calculations.850 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,374 remove_red_eye5 chat_bubbleDCF Valuation Model Template
This template provides you with a foundation to build your own discounted cash flow model with different assumptions.884 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,652 remove_red_eyeDiscussfreeby FirmexThe Discounted Free Cash Flow (DCF) Model
A full discounted cash flow excel model for a complete business1,542 remove_red_eyeDiscussDiscounted Cash Flow (DCF) Model (Academic Quality)
A simple DCF model serving as an academic exercise to understand how financial modeling works.1,504 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,330 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,374 remove_red_eye5 chat_bubble
Discussion feed for Discounted Cash Flow (DCF) Model
The user community and author are here to help. Go ahead!
- 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/
- 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
