Publication number: ELQ-52155-1
View all versions & Certificate
Discounted Cash Flow (DCF) Model Excel Template
This is a valuation tool known as the DCF model. This is an Excel template.
One method an investor could use to determine the value of a company involves conducting a discounted cash flow analysis.
An example of a series of assumptions an investor could use to calculate a companies intrinsic value under the Three-Stage DCF, for example, are:
1: an initial cash flow of $10,000
2: a discount rate of 15% (the user should insert his required return here)
3: cash flows grow at a 14% rate for the first 5 years, a 10% rate for the next 5 years, and a 5% rate for the final 5 year period
4: the investor uses a terminal growth rate of 3%
5: the company has 10,000 shares outstanding and pays no dividends.
Boxes that are highlighted in black are where users can plug in their own assumptions
As the name implies, a companies future cash flows are discounted back to the present to derive what a valuation for the company in question. The DCF Model is certainly not a perfect valuation tool (as it is very difficult to predict what a company will grow its cash flows at), but it can provide one estimate of value that, when combined with all the other components of a users research on a company, can help give an idea of what a company is worth. The user should also keep in mind that the Intrinsic Value that is produced is only as good as the numbers put into the model. If you assume unrealistic growth rates (or terminal value) you will get an unrealistic intrinsic value result. The investor should think of the Intrinsic Value figure given in this light: you need to pay the price given, or lower, in order to achieve a given return (i.e. the discount rate) on your investment if your assumptions are correct.
This Best Practice includes
1 DCF Model Template in Excel
Richard M. Rockwood offers you this Best Practice for free!
download for free
Add to bookmarks
- Rate this Downloadable Best Practice
Write a review
- Aqeel Ahmad(last updated: 25/03/2021 01:32)
- Vasile Popovici the Excel guru(last updated: 08/10/2020 15:11)
- Wael Attallah, MBA(last updated: 21/09/2020 17:53)
- Samantha (wenhua) Lee(last updated: 11/08/2020 06:33)
- LU LU(last updated: 30/07/2020 01:49)
- Almira HN(last updated: 10/06/2020 08:43)
- Tharwat Attallah(last updated: 09/06/2020 14:15)
- WEI YANG(last updated: 04/06/2020 04:42)
- wal(last updated: 04/02/2020 12:48)
- Agung Santoso(last updated: 08/10/2019 08:47)
People using this Best Practice also downloaded
Discount Cash Flow Template in ExcelThis is a discounted cash flow (DCF) template with income statement, balance sheet, FCF calculation & FV calculation.valuationcash flowdcfinvestordiscounted cash flow683add_shopping_cartfreeby Andrew Han
Discounted Cash Flow DCF Valuation Model Template (Mining Company)Financial model that performs a DCF & Relative valuation on Mining Company.valuationdcfwaccratiosdiscounted cash flow1,822add_shopping_cart$49.00by Fin-Wiser Advisory
Quick valuation: Net present value (NPV) CalculatorA calculator for a quick net present value (NPV) calculation for valuing a businessvaluationnpvdcfdiscounted cash flownet present value749add_shopping_cart$15.00by ModellingGuy
Valuation- DCF Approach Complete GuideJP Morgan comprehensive guideline on business valuation by Discounted Cash Flow Method, full of illustrations and tipspresentationvaluationmergersdcfwacc294add_shopping_cart$9.00by Rositsa Chopeva
"La Doria" Excel Valuation ModelValuation Model of La Doria (public company)valuationdcfdiscounted cash flowexcelpublic company1,002add_shopping_cart$5.00by Pérez
Discounted Cash Flow (DCF) Valuation Excel Model (Engineering and Construction)Detailed Financial model for DCF valuation on Engineering and Construction Companyvaluationfcffcash flowfcfedcf384add_shopping_cart$75.00by Fin-Wiser Advisory
Agricultural Silo budget forecast and ValuationA comprehensive and very flexible Agricultural Silo forecast model that also allows to generate a 5 year business planbusinessvaluationreal estatediscounted cash flowfinancial modelling137add_shopping_cart$20.00by Finance Cell
DCF Model with Bear and Bull Scenarios in ExcelA DCF model built for public equity valuations, with a bull and bear scenario analysis to evaluate upside/downside riskmodelvaluationequitydcfdiscounted cash flow3,228add_shopping_cart$20.00by Colin Ferrian
Income Statement - Excel Model TemplateThis is an Income Statement template to help present your business’ profit and loss over time.businessincome statementvaluationdebtdcf428add_shopping_cartfreeby Wall Street Oasis
Discounted Cash Flow (DCF) Analysis with IRR and NPVSeveral spreadsheets that can be used for the analysis of a real estate investment from various perspectivesacquisitionfinancecash flownpvirr16,331add_shopping_cartfreeby Norm Miller PhD
Any questions on Discounted Cash Flow (DCF) Model Excel Template?
The user community and author are here to help. Go ahead!