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
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
Joseph Andrews offers you this business tool for free!
download for free
Add to bookmarks
- Osama Sulieman(last updated: 21/02/2019 19:03)
- UMA PANDEY(last updated: 14/02/2019 08:09)
- Danny Tan(last updated: 20/01/2019 13:37)
- Sriram S(last updated: 04/01/2019 11:11)
- Ron Jnr(last updated: 08/11/2018 22:29)
- George Frank(last updated: 25/10/2018 19:18)
- Teman Galau(last updated: 17/10/2018 09:29)
- Abdelrhman Alaa ,CMA Candidate(last updated: 12/10/2018 10:20)
- MOHAMMED NASEER(last updated: 08/10/2018 17:44)
- Sunny Yan(last updated: 22/09/2018 05:48)
- WILLY CAMPOS(last updated: 07/09/2018 17:30)
- Eiad Al Saba(last updated: 06/09/2018 07:06)
- Peleg Uzi(last updated: 19/08/2018 05:47)
- Kiley Hill(last updated: 14/08/2018 21:06)
- Edu Marupa Simanjuntak(last updated: 18/07/2018 10:24)
- Aheesh Singh(last updated: 06/06/2018 12:33)
- Guillem Torner(last updated: 15/05/2018 08:57)
- 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
Calculating Discounted Cash Flow in ExcelThis video takes you through a DCF Excel model to show you how to calculate Discounted Cash Flow.assetsdcfdcf modeldiscounted cash flowfcf740free by Finance Walk
Discounted Cash Flow (DCF) ModelA step by step Discounted Cash Flow Analysis Tutorial (DCF model)analysisdcfdcf modeldiscounted cash flowfinance29,942
Business Valuation Excel Model with Economic Value AddedBusiness and investment valuation model with economic value added (EVA) calculations.dcfdiscounted cash floweconomic value addedevafinance1,071
Discounted Cash Flow (DCF) Model (Academic Quality)A simple DCF model serving as an academic exercise to understand how financial modeling works.corporate financedcfdiscounted cash flowfinancemba1,500free by Joshua Wong
Activision Blizzard DCF (Discounted Cash Flow) ModelA simple DCF Model based on Operating and Working Capital Assumptions (example: Activision Blizzard)dcfdiscounted cash flowfinanceoperatingshare price529free by Erin Chan Parker
Quick valuation: Net present value (NPV) CalculatorA calculator for a quick net present value (NPV) calculation for valuing a businessdcfdiscounted cash flownet present valuenpvvaluation293$15.00 by ModellingGuy
All in One Private Equity ModelUsed by Investment Professionals at Private Equity and IB Firmsdcfevafinancefinancial statementsinvestment banking5,295$180.00 by John Swan
"La Doria" Excel Valuation ModelValuation Model of La Doria (public company)dcfdiscounted cash flowexcella doriapublic company70
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 riskdcfdiscounted cash flowequitymodelpublic equities1,337$20.00 by Colin Ferrian
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 modelsdcfevafinancereconcilevaluation1,386
Any questions on The Discounted Free Cash Flow (DCF) Model?
The user community and author are here to help. Go ahead!