(a) Go to the Yahoo Finance website (http://finance.yahoo.com) and download the weekly adjusted closing share price over a five-year period beginning 1st Jan 2015 and ending 31st December 2019...

file attached


(a) Go to the Yahoo Finance website (http://finance.yahoo.com) and download the weekly adjusted closing share price over a five-year period beginning 1st Jan 2015 and ending 31st December 2019 inclusive for the following four stocks Bank of America, Apple , Nike ,Alibaba). You can download these data from the ‘Historical Prices’ section and then the ‘Download to Spreadsheet’ link for each stock. Save all these information in an Excel spreadsheet. Make sure you sort the data in ascending order by date (i.e. 1st Jan 2015 to 31st December 2019). Yahoo ranks them in descending order (last price to first price). Download also the weekly adjusted closing share index value for the S&P 500 index over the same five-year period. Due June 16, 2020   (b) Calculate the expected weekly returns for each stock and the index assuming continuous compounding (i.e. use log returns use the (ln(R2/R1) c)calculate the standard deviation of each stock and the index d) calculate the covariance and the correlation (the correlation and covariance matrix) e) calculate beta of each stock All above parts are due June 22, 2020 f) download the free cash flow for each company g) what is the risk free for 9 months’ treasury bill) h) calculate the cost of equity using the CAPM use the risk free in i) calculate the growth rate for 2019 using the formula g = ROE(2019)*payout ratio(2019) j)calculate the cost of equity using the DDM =k= D1/P+G k) use the cost of equity to calculate the value of the four companies free cash flow L) calculate the P/E ratio for the four stocks for 2019 using the price on June 25,2020. Due June 30, 2020