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 flowfinancembamergers and acquisitionsvaluation

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 business tool includes
1 Excel Model, 1 Online Methodology

Joshua Wong offers you this business tool for free!

Download for free

Ask a question

Reviews


Any questions on Discounted Cash Flow (DCF) Model (Academic Quality)?

The user community and author are here to help. Go ahead!

please wait...