Netflix Case Solution

1. Discounted Cash Flow to Equity Analysis 

The first sheet in the Excel file uses the free cash flows method to calculate enterprise value. In this particular approach, the required rate of return i.e. 18 percent has been used because this analysis assumes that the enterprise value of Netflix comprises entirely of equity value with no debt. This is why Weighted Average Cost of Capital (WACC) has not been used. This is also the primary reason why the share price per common stock of Netflix in this scenario is lowest i.e. $4.91 as it considers no leverage.

2. Discounted Cash Flow Analysis 

The next sheet calculates the enterprise value using the free cash flow valuation method just like in the case of the first scenario, but here the actual short term investments and market value of debt have been incorporated. These two values have been extracted from the actual figures given in the balance sheet for the year ended 2015. Once an overall enterprise value has been estimated, the value of equity is separated from the overall enterprise value. Share price per common stock of Netflix has thus been calculated using the value of equity. Moreover, WACC has been used in this scenario for discounting purposes because here both debt and equity were involved. The share price is, thus, higher - in fact, highest for this approach i.e. $19.08.