Publication number: ELQ-78928-1
View all versions & Certificate
Discounted 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.
Don't waste hours creating your own discounted cash flow model.
Discounted cash flow (DCF) is used to estimate the attractiveness of an investment opportunity. DCF analysis uses future free cash flow projections and discounts them (most often using the weighted average cost of capital) to arrive at a present value, which is used to evaluate the potential for investment. If the value arrived at through DCF analysis is higher than the current cost of the investment, the opportunity may be a good one.
1: Input the valuation date, discount rate, perpetual growth rate, and tax rate.
2: Forecast the company's key financials and calculate the corresponding free cash flows.
3: Discount the Projection Period and Terminal cash flows to the present using the discount rate.
4: The sum of future cash flows determines the aggregate value of the business today.
- Firmex Team
This business tool includes
1 Excel Model
Firmex offers you this business tool for free!
download for free
Add to bookmarks
- John Fletcher(last updated: 19/03/2018 14:17)Discounted Cash Flow Model
- Natee Bicharoen(last updated: 15/03/2018 14:29)Nice Presentation
- Kamilah Collison(last updated: 14/03/2018 11:23)
- Mohammed Halaseh(last updated: 12/03/2018 12:53)
- Ankur Kumar Jha(last updated: 16/02/2018 06:34)
- Dwindra Arief Julianto(last updated: 05/02/2018 02:13)
- Waskito Adinugroho(last updated: 13/12/2017 09:50)
- Katwere James(last updated: 19/11/2017 08:29)Good DCF Template
- Zhou Song(last updated: 13/10/2017 08:22)
- Alfonso Cioffi(last updated: 12/10/2017 20:22)
- Long Lê(last updated: 08/10/2017 05:18)Very well-organized template
- Mamadou Dr. Bass(last updated: 29/09/2017 09:38)
People using this tool also downloaded
All in One Private Equity ModelUsed by Investment Professionals at Private Equity and IB Firmsfinancevaluationdcfevaprivate equityinvestment bankinglbofinancial statements2,818 remove_red_eye$180.00by John Swan
Discounted Cash Flow (DCF) ModelA step by step Discounted Cash Flow Analysis Tutorial (DCF model)analysisfinancevaluationdcfprivate equityinvestment bankingdiscounted cash flowvalue of a businessdcf model6,677 remove_red_eye
Leveraged Buyout LBO Model TemplateA full Leveraged Buyout LBO model template for a project to understand its different components and work with your own.financevaluationleveraged buyoutdcfwacclbotemplatelbo analysislbo model1,812 remove_red_eyefreeby John P. Burns
Economic Value Added (EVA) vs Cost of Capital Discounted Cash Flow (DCF) Valuation Excel ModelExcel Tool for reconciling EVA (Economic Value Added) and DCF (Discounted Cash Flow) valuation modelsfinancevaluationdcfevareconcile559 remove_red_eye
LBO model - Leveraged Buyout AnalysisA step by step LBO model tutorial. It is easy to use and we provide support if needed. Have fun modeling!financevaluationleveraged buyoutprivate equityinvestment bankinglbom&amergers & acquisition5,168 remove_red_eye
Abercrombie & Fitch Valuation ModelA full PDF of an Excel Valuation Model created for fundamental analysis of Abercrombie & Fitch ($ANF) in 2006financevaluationfcfffcfefree cash flow to equitywaccfree cash flow to the firmscenariocontingency636 remove_red_eyefreeby Lindsay Meyer
The Discounted Free Cash Flow (DCF) ModelA full discounted cash flow excel model for a complete businessfinancevaluationpresent valueassetsdcfdiscounted cash flowcomplete business1,190 remove_red_eye
Discounted Cash Flow (DCF) Model (Academic Quality)A simple DCF model serving as an academic exercise to understand how financial modeling works.financevaluationcorporate financedcfdiscounted cash flowmbamergers and acquisitions1,006 remove_red_eyefreeby Joshua Wong
Activision Blizzard DCF (Discounted Cash Flow) ModelA simple DCF Model based on Operating and Working Capital Assumptions (example: Activision Blizzard)financevaluationdcfoperatingterminal valueshare pricediscounted cash flowworking capital381 remove_red_eye
Any questions on Discounted Cash Flow Model Template?
The user community and author are here to help. Go ahead!