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.
I follow Prof. Damodaran of Stern NYU for valuation related queries.
link to file