
Originally published: 04/10/2016 15:55
Publication number: ELQ-99104-1
View all versions & Certificate
Publication number: ELQ-99104-1
View all versions & Certificate

The Discounted Free Cash Flow (DCF) Model
A full discounted cash flow excel model for a complete business
assetscomplete businessdcfdiscounted cash flowfinancepresent valuevaluation
Description
Instructions: Change any of the forecasting variables shown in red below and observe the effect on the model's outputs in the section below. To what variable is the business value conclusion most sensitive? To what variable is it least sensitive?
Valuation Model Outputs:
- Present Value of Company Operations
- Market Value of Company Assets
Includes printable output page and detailed DCF model.
Example: "Pie In The Sky Company"
- Joseph Andrews
This business tool includes
1 Excel Model
Reviews
Long Lê(last updated: 01/04/2018 10:28)
Kamilah Collison(last updated: 14/03/2018 11:23)
Mamadou Dr. Bass(last updated: 29/09/2017 09:38)
People using this tool also downloaded
keyboard_arrow_left
Calculating Discounted Cash Flow in Excel
This video takes you through a DCF Excel model to show you how to calculate Discounted Cash Flow.financevaluationstockassetsdcfwaccdiscounted cash flowliabilitiesdcf modelfcf88 remove_red_eyeDiscussfreeby Finance Walk
Discounted Cash Flow (DCF) Model
A step by step Discounted Cash Flow Analysis Tutorial (DCF model)analysisfinancevaluationdcfprivate equityinvestment bankingdiscounted cash flowvalue of a businessdcf model10,867 remove_red_eye5 chat_bubbleActivision Blizzard DCF (Discounted Cash Flow) Model
A simple DCF Model based on Operating and Working Capital Assumptions (example: Activision Blizzard)financevaluationdcfoperatingterminal valueshare pricediscounted cash flowworking capital408 remove_red_eyeDiscussDiscounted 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,065 remove_red_eyeDiscussfreeby Joshua Wong
Business Valuation Excel Model with Economic Value Added
Business and investment valuation model with economic value added (EVA) calculations.financevaluationdcfevaeconomic value addeddiscounted cash flow27 remove_red_eyeDiscussAll in One Private Equity Model
Used by Investment Professionals at Private Equity and IB Firmsfinancevaluationdcfevaprivate equityinvestment bankinglbofinancial statements3,160 remove_red_eye2 chat_bubble$180.00by John Swan
Economic Value Added (EVA) vs Cost of Capital Discounted Cash Flow (DCF) Valuation Excel Model
Excel Tool for reconciling EVA (Economic Value Added) and DCF (Discounted Cash Flow) valuation modelsfinancevaluationdcfevareconcile680 remove_red_eyeDiscussDiscounted Cash Flow (DCF) Analysis with IRR and NPV
Several spreadsheets that can be used for the analysis of a real estate investment from various perspectivesacquisitionfinancecash flownpvirrdcfreal estatefinancial analysisinvestingdiscounted cash flow6,352 remove_red_eye2 chat_bubbleDiscounted 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.financevaluationdcfwaccinvestment bankinginvestment analysisfree cash flow projections6,672 remove_red_eyeDiscussfreeby Firmex
FCFF (Free Cash Flow for the Firm) Excel Model with exposure to country risk
An Excel FCFF Model allowing the user to enter a measure of company exposure to country risk when making a valuationfinancevaluationfree cash flow for the firmfcffpresent valuecountry riskexposuremarket value473 remove_red_eyeDiscuss
Any questions on The Discounted Free Cash Flow (DCF) Model?
The user community and author are here to help. Go ahead!