Consider this information about 5 stocks from a date in the past....

1) Consider this information about 5 stocks from a date in the past . .. a) b) d) Price Mkt Cap (bill) GOOG Alphabet C $ 1,115.48 775.9 AAPL Apple 5 174.37 884.8 TGT Target $ 74.95 40.7 PG Proctor Gamble S 80.61 203.2 CVX Chevron 5 111.71 213.6 Calculate the weights of each stock in a price-weighted portfolio, a market value-weighted portfolio, and an equal-weighted portfolio. Round each to 3 decimals: xx.yyy% or .xxyyy Compare the weights which stock(s) islare the most di'erent across the 3 portfolios (indexes)? Calculate a price-weighted index including all 5 of these stocks. How much will each portfolio or index constructed using these securities move if AAPL rises by 2.5%? Ignore (d). Suppose GOOG does a 4:1 stock split. What changes have to be made if any to the price-weighted and market-value weighted indexes? After e) happens, suppose now a change to the portfolio is made, and Chevron is replaced by ExxonMobil, whose price on this day is $77.01 with 4.24 billion shares outstanding. Determine the adjustments that need to be made to the price-weighted index calculations to maintain its interpretability through time and to preserve its objective as measures of average performance