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 business tool includes
1 DCF Model Template in Excel
Richard M. Rockwood offers you this business tool for free!
download for free
Add to bookmarks
- No review yet!
People using this tool 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 flowexcelspreadsheetmodellingvaluation methods116 remove_red_eyefreeby 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 value226 remove_red_eye$15.00by ModellingGuy
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 flowscenario analysispublic equitiespublic valuation1,050 remove_red_eye$20.00by Colin Ferrian
Business Valuation Excel Model with Economic Value AddedBusiness and investment valuation model with economic value added (EVA) calculations.financevaluationdcfevaeconomic value addeddiscounted cash flow981 remove_red_eye
Discounted Cash Flow (DCF) ModelA step by step Discounted Cash Flow Analysis Tutorial (DCF model)analysisfinancevaluationdcfprivate equityinvestment bankingdiscounted cash flowvalue of a businessdcf model27,905 remove_red_eye
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 flownpvirrdcfreal estatefinancial analysisinvestingdiscounted cash flow11,731 remove_red_eye
The Discounted Free Cash Flow (DCF) ModelA full discounted cash flow excel model for a complete businessfinancevaluationpresent valueassetsdcfdiscounted cash flowcomplete business1,594 remove_red_eye
DCF (Discounted Cash Flow) Excel Monte Carlo Simulation ModelA simplified DCF (Discounted Cash Flow) Monte Carlo Simulation model in Excelvaluationdcfdiscounted cash flowsimulationmonte carlomonte carlo valuationsyleus and partners445 remove_red_eyefreeby Hans Ensing
Calculating Discounted Cash Flow in ExcelThis video takes you through a DCF Excel model to show you how to calculate Discounted Cash Flow.financevaluationstockassetsdcfwaccdiscounted cash flowliabilitiesdcf modelfcf570 remove_red_eyefreeby Finance Walk
Discounted Cash Flow (DCF) Model Template + InstructionsLearn how to build a simple DCF Model aligned with Investment Banking best practices.valuationdcfdiscounted cash flowtemplateexcelvideohow todcf modellessonquick lesson455 remove_red_eye
Any questions on Discounted Cash Flow (DCF) Model Excel Template?
The user community and author are here to help. Go ahead!