Assistance needed with a finance question. Excel formulation required

Problem 12-4 Suppose all possible investment opportunities in the world are limited to the five stocks liste below. What does the market portfolio consist of? Stock A B C D E Price/Share ($) 10 20 8 50 45 Shares Outstanding (millions) 10 12 3 1 20 Market value (million) Share of Market portfolio Stock A Stock B Stock C Stock D Stock E Total Requirements 1. In cell D17, by using cell references, calculate the market value of stock A (1 pt.). 2. To calculate the market values of stocks B thru E copy cell D17 and paste it onto cell pt.). 3. You will calculate the total market value of all the stocks in the market portfolio by u SUM. In cell D22, by using the function SUM and cell references, calculate the total all the stocks in the market portfolio (1 pt.). 4. In cell E17, by using absolute and relative cell references, calculate the share (percen in the market portfolio (1 pt.). 5. To calculate the share (percentage) of stocks B thru E in the market portfolio, copy ce it onto cells E18:E21 (1 pt.). are limited to the five stocks listed in the table market value of stock A (1 pt.). py cell D17 and paste it onto cells D18:D21 (1 ocks in the market portfolio by using the function cell references, calculate the total market value of ences, calculate the share (percentage) of stock A E in the market portfolio, copy cell E17 and paste