I am struggling how to find the information needed for this and how to work it out on excel.

$1.$ Choose a publicly traded company and estimate its required rate of return based on CAPM.

$--->$ I have chosen Netflix $($NFLX$)$

$2.$ Use the same company and estimate its required rate of return based on the Discounted Cash Flow method. $($You need to go to Yahoo Finance and get D$1$ and g$)$

$3.$ What is the systematic risk of your chosen company? $($From various websites$)$

$4.$ Is the systematic risk of your chosen stock higher or lower than the systematic risk of the market?

$5.$ If the stock market goes up by $12\%$ next year, what would you expect the return of your chosen company to be next year?

The picture below is my current set up on excel.