please this question is to be solved on excel
Question #1 [5 marks] Recall last week's take-home assignment where a portfolio contained shares of Zoom (ZM on the Nasda), Slack (WORK), and Ferrari (RACE) stock. Suppose that your portfolio also contained a fourth asset; namely shares of Heineken Brewery (HEINY) stock 3. Go to Yahoo Finance and download the daily stock prices for HEINY from Dec. 31st, 2019 to Jan. 1st, 2021. Copy and paste (right-click and then "values" when pasting to retain formatting) the closing prices (column) for HEINY in 2020 (and Dec. Jist, 2019) to cells H20 to 1273 in the MA270 Taketome5.xlsx file that you completed last week b. Enter a formula in cell 21 for the daily return on the HEINY stock on Jan. 2nd, 2020 (Jan. Ist was a holiday) and use it complete cells 122 to 1273 c. Calculate the average daily return and standard deviation in daily returns in cells 12 and F3, respectively, for the HEINY stock in 2020. a. In cells F5, G6, HG, use the SUMPRODUCTO...) and SUME...) functions to approximate the covariance between the daily returns of ZM/HEINY, WORK/HEINY, and RACE/HEINY, respectively e. Enter formulae in cells C14 to F14 and F11 to F14 to complete the portfolio's 4 x 4 covariance matrix (Note: Assume asset 1 is ZM, asset 2 is WORK, asset 3 is RACE, and asset 4 is HEINY) Question #1 [5 marks] Recall last week's take-home assignment where a portfolio contained shares of Zoom (ZM on the Nasda), Slack (WORK), and Ferrari (RACE) stock. Suppose that your portfolio also contained a fourth asset; namely shares of Heineken Brewery (HEINY) stock 3. Go to Yahoo Finance and download the daily stock prices for HEINY from Dec. 31st, 2019 to Jan. 1st, 2021. Copy and paste (right-click and then "values" when pasting to retain formatting) the closing prices (column) for HEINY in 2020 (and Dec. Jist, 2019) to cells H20 to 1273 in the MA270 Taketome5.xlsx file that you completed last week b. Enter a formula in cell 21 for the daily return on the HEINY stock on Jan. 2nd, 2020 (Jan. Ist was a holiday) and use it complete cells 122 to 1273 c. Calculate the average daily return and standard deviation in daily returns in cells 12 and F3, respectively, for the HEINY stock in 2020. a. In cells F5, G6, HG, use the SUMPRODUCTO...) and SUME...) functions to approximate the covariance between the daily returns of ZM/HEINY, WORK/HEINY, and RACE/HEINY, respectively e. Enter formulae in cells C14 to F14 and F11 to F14 to complete the portfolio's 4 x 4 covariance matrix (Note: Assume asset 1 is ZM, asset 2 is WORK, asset 3 is RACE, and asset 4 is HEINY)
