Thursday, December 2, 2010

DCF

With summer recruiting coming up for first years in the next few months and with many of our second year finance courses requiring us to do some form of valuation (Corp Fin, Financial Management, Mergers and Acquisitions, Business Analysis and Valuation etc.), I thought it might be useful to post an "academic" quality discounted cash flow model as a reference.

There are some basic comments in the cells which explain some of the assumptions.



For a more advanced version of forecasting (including working capital schedule and depreciation schedule), check out my Chapters LBO model.

1 comment:

Anonymous said...

Nice model! Good overview for DCFs.

Here's another discounted cash flow tutorial that has a model similar to those you would do at an investment bank.

Good luck with the job hunting everybody!