Please show work to understand how answer came to, preferabe on excel. And only the 3 highlighted have to be answered as I figured out the first.

Problem1 Indexes (33 points) Consider the three stocks in the following table. Pt represents the price at the end of period t and t is the number of shares outstanding. Stock C splits 3:1 during period 2 PO Q0 P1 P2 92 69.00 150.00 63.00 150.00 S 72.oo S 36.o0 S 7.00 150.00 37.00 400.00 42.00 400.00 400.00 9.00 200.00 12.00 200.00 600.00 1.1 Calculate the price-weighted index of the three stocks for each period (4 points). What is the divisor for each period (4 points)? Does it change in the last period (2 points)? V or why not (2 points)? Calculate the price-weighted index returns for the periods ending in1 and2 1.3 Calculate the value-weighted index returns for the periods ending in 1 and 2 (7 points) 1.4 Caleulate the equal- weighted index returns for the periods ending in 1 and 2 (7 points)