Discounted Cash Flow (DCF) Model
The project involves developing a Discounted Cash Flow (DCF) model to calculate the intrinsic value of a company's stock. The model forecasts unlevered free cash flows over a defined period, discounts them to their present value using the Weighted Average Cost of Capital (WACC), and incorporates terminal value to estimate the enterprise value.
​
To see the additional calculations used in the model, such as the fixed asset roll forward schedule or the net working capital table, please download the entire file from the button below.
Forecasting Income Statament items to calculate unlevered free cash flows for the next five years.
Calculating the discount rate using the Weighted Average Cost of Capital (WACC) method:
Final sheet where equity value and implied share price is calculated.
A sensitivity table is also included for different growth and discount rates.
