Last version published: 02/02/2017 10:57
Publication number: ELQ-78536-4
View all versions & Certificate
Discounted Cash Flow (DCF) Model (Academic Quality)
A simple DCF model serving as an academic exercise to understand how financial modeling works.
This is an "Academic" quality discounted cash flow model, which can be used as a reference for valuation MBA courses (Corp Fin, Financial Management, Mergers and Acquisitions, Business Analysis and Valuation etc.)
Within the cells, you may find some essential comments that will further explain some assumptions.
If you'd like a more advanced version for forecasting (including both the working capital and depreciation schedule), you can check the Chapter LBO model on the Eloquens catalog on: https://www.eloquens.com/method/Q8lSy1/chapters-model-with-lbo-module
Keep in mind: the model is made strictly for academic purposes; particularly to understand how financial modelling works. The assumptions made are general and are strictly not appropriate for realistic business practice.
Joshua Wong has no liability for the material provided. The content does not have warranties, be it explicit or implied.
- Joshua Wong, amgstr.blogspot.com, 2010
This business tool includes
1 Excel Model, 1 Online Methodology
Joshua Wong offers you this business tool for free!
download for free
Add to bookmarks
- Kamilah Collison(last updated: 14/03/2018 11:23)
- Jan Huis in 't Veld(last updated: 29/09/2017 20:38)
- Mohammed Halaseh(last updated: 29/12/2016 09:40)
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,653 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
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
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 modelfcf138 remove_red_eyefreeby Finance Walk
Discounted Cash Flow Formula: TutorialVideo tutorial on how to build a discounted cash flow from scratch in Excel.financecorporate financedcfdiscounted cash flowexcelhow todiscounted cash flow analysis17 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
All in One Private Equity ModelUsed by Investment Professionals at Private Equity and IB Firmsfinancevaluationdcfevaprivate equityinvestment bankinglbofinancial statements3,428 remove_red_eye$180.00by John Swan
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 modelsfinancevaluationdcfevareconcile775 remove_red_eye
Chapters Model with Leveraged Buyout LBO AnalysisA full financial model to understand the mechanics of an organisation using Valuation, LBO, & Financial Reportsvaluationleveraged buyoutaccountingcorporate financecase studycompany analysismergers and acquisitionshedge fundslbo modellbo analyis509 remove_red_eyefreeby Joshua Wong
Any questions on Discounted Cash Flow (DCF) Model (Academic Quality)?
The user community and author are here to help. Go ahead!