Publication number: ELQ-63243-1
View all versions & Certificate
Calculating Discounted Cash Flow in Excel
This video takes you through a DCF Excel model to show you how to calculate Discounted Cash Flow.
DCF Valuation is a useful tool when the market lacks comparable companies. It involves a method in which some steps take into account the firm's inflation rate, capital structure, growth of the company, growth of the economy, working capital management, project risk factor, required future capital expenditure. etc.
The inputs required for DCF Models are:
-Discount rates: Cost of Equity and Cost of Debt
-Expected Cash Flows: Dividends, FCFE, and FCFF
-Expected Growth Rate
Step-by-Step DCF Method:
1. Measure/Forecast the Free Cash Flow
2. Estimate the Weighted Average Cost of Capital/cost of Equity
3. Use the Weighted Average Cost of Capital to discount Free Cash Flow
4. Estimate the Terminal or Residual Value
5. Use the Weighted Average Cost of Capital to discount Terminal Value
6. Estimate the Total Present Value of the Free Cash Flow
7. Add in the value of Non-Operating Assets
8. Take away the value of Liabilities assumed
9. Calculate the Common Stock value
Length: 8 minutes 54 seconds
This business tool includes
1 Video File
Add to bookmarks
Did Finance Walk's tool help you? You can make a small financial contribution to support the author.
- No review yet!
People using this tool also downloaded
Discounted Cash Flow (DCF) ModelA step by step Discounted Cash Flow Analysis Tutorial (DCF model)analysisfinancevaluationdcfprivate equityinvestment bankingdiscounted cash flowvalue of a businessdcf model13,656 remove_red_eye
The Discounted Free Cash Flow (DCF) ModelA full discounted cash flow excel model for a complete businessfinancevaluationpresent valueassetsdcfdiscounted cash flowcomplete business1,299 remove_red_eye
DCF Valuation Model TemplateThis template provides you with a foundation to build your own discounted cash flow model with different assumptions.financedcffinancial modeldiscounted cash flowdcf modeldiscounted cash flow model134 remove_red_eye
Discounted Cash Flow Model TemplateA fully customizable excel model to match your needs, and use as a starting point or as a full DCF tool for valuation.financevaluationdcfwaccinvestment bankinginvestment analysisfree cash flow projections7,516 remove_red_eyefreeby Firmex
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 model2,361 remove_red_eyefreeby John P. Burns
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 capital436 remove_red_eye
Business Valuation Excel Model with Economic Value AddedBusiness and investment valuation model with economic value added (EVA) calculations.financevaluationdcfevaeconomic value addeddiscounted cash flow112 remove_red_eye
Quick Lesson: Build a Discounted Cash Flow (DCF) Model, Part 1Learn how to build a simple DCF Model aligned with Investment Banking best practices.valuationdcfdiscounted cash flowtemplateexcelvideohow todcf modellessonquick lesson75 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,103 remove_red_eyefreeby Joshua Wong
How to Value a Company in 3 Easy StepsLearn how to value a company using a simple 3 step method.financevaluationaccountingassetsliabilitiesvaluation methodvaluatingcompany valuation3 step methodNew!freeby MBA Bullshit
Any questions on Calculating Discounted Cash Flow In Excel?
The user community and author are here to help. Go ahead!