DCF Valuation

In the financial modeling series we have covered term loan schedule, depreciation schedule, tax schedule and an integrated financial model.This is probably the last link in the financial modeling series.

Here we have valued the company using the most widely used valuation technique called Discounted Cash flow (DCF) valuation method. We arrive at Free cash flow of firm (FCFF), discount it by Weighted average cost of capital (WACC) to present value to find the Enterprise value (EV) and then subtract net debt to get the Equity Value of the company.

val1

I follow Prof. Damodaran of Stern NYU for valuation related queries.

link to file

https://drive.google.com/file/d/0B2FLZ9YjqpJTeVloRUNjSWc1SnM/view?usp=sharing

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s