The solution must be in excel and word!

Question (1): The table below presents information about 5 stocks. Stock Price March t=0 $43 Quantity March t=0 Price April t=1 $28 Quantity April t=1 Price May t=2 $32 Quantity May t=2 Price June t=3 $32 Quantity June t=3 A 25 25 20 20 B $88 30 $111 30 ? ? ? ? $25 90 $27 90 $26 100 $26 100 D $98 300 $111 300 $110 300 $110 300 $31 10 $35 10 $35 10 E $29 10 Note: Numbers are in millions of $ A. Calculate the rate of return for a market value-weighted index for the first period (March till April). Among the 5 stocks, which stock's price change can affect the stock index the most? Why? B. Calculate the price of a price-weighted index for April C. In May, stock B splits 3-for-1. Calculate the price of a price-weighted index in May (Taking the stock split into account). D. What is the rate of return on a price-weighted index for the second period (April to May)? E. Calculate the rate of return for an equally weighted index for the last period (May to June)