please show excel formulas

Use the chart below to answer the following questions. = Stock A T= 0 Price Quantity 90 100 45 200 30 200 T=1 Price Quantity 95 100 50 200 30 200 T= 2 Price Quantity 98 100 200 10 400 B 50 C a. Create a value (VW) and price weighted index (PW) using the three stocks. Assume each stock will be in the index and calculate the return of each from t=1 to t= 2. (There should be 2 answers here. b. What would be the new divisor for the price weighted index at time period 0 if stock C had a 2 for 1 stock split What is the holding period return for each stock from time 0 to time 2. Assume Stock B has a $5 dividend and the other stocks do not. (Ignore the number of shares for this question only) c. 90 91 92 Mkt Cap pi 100 A 90 45 30 B p2 100 200 200 95 50 30 200 200 98 50 10 100 200 400 C Sum Part A/B Weights Mkt Weight Price Weight Stock Return B C Mkt Index Return Price Index Return Part Original Index 0 New Prices A B C Sum Solution