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
- 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 flow570add_shopping_cartfreeby Andrew Han
Quick valuation: Net present value (NPV) CalculatorA calculator for a quick net present value (NPV) calculation for valuing a businessvaluationnpvdcfdiscounted cash flownet present value613add_shopping_cart$15.00by ModellingGuy
"La Doria" Excel Valuation ModelValuation Model of La Doria (public company)valuationdcfdiscounted cash flowexcelpublic company696add_shopping_cart$5.00by Pérez
Income Statement - Excel Model TemplateThis is an Income Statement template to help present your business’ profit and loss over time.businessincome statementvaluationdebtdcf241add_shopping_cartfreeby Wall Street Oasis
Discounted Cash Flow DCF Valuation Model Template (Mining Company)Financial model that performs a DCF & Relative valuation on Mining Company.valuationdcfwaccratiosdiscounted cash flow1,079add_shopping_cart$49.00by Fin-Wiser Advisory
Valuation- DCF Approach Complete GuideJP Morgan comprehensive guideline on business valuation by Discounted Cash Flow Method, full of illustrations and tipspresentationvaluationmergersdcfwacc158add_shopping_cart$9.00by Rositsa Chopeva
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 flow2,484add_shopping_cart$20.00by Colin Ferrian
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 flownpvirr15,840add_shopping_cartfreeby Norm Miller PhD
Discounted Cash Flow (DCF) ModelA step by step Discounted Cash Flow Analysis Tutorial (DCF model)analysisfinancevaluationdcfprivate equity48,111add_shopping_cart$9.00by Patrik Johansson
Business Valuation Excel Model with Economic Value AddedBusiness and investment valuation model with economic value added (EVA) calculations.financevaluationdcfevaeconomic value added2,283add_shopping_cart
Any questions on Discounted Cash Flow (DCF) Model Excel Template?
The user community and author are here to help. Go ahead!