Discounted Cash Flow (DCF) Model (Academic Quality)
Originally published: 06/10/2016 11:42
Last version published: 02/02/2017 10:57
Publication number: ELQ-78536-4
View all versions & Certificate
certified

Discounted Cash Flow (DCF) Model (Academic Quality)

A simple DCF model serving as an academic exercise to understand how financial modeling works.

Description
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 Best Practice includes
1 Excel Model, 1 Online Methodology

Joshua Wong offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss


4.3 / 5 (24 votes)

please wait...