Directions: Work on this astignmert endrvidully 1 1) Calculate value of DMA en Er3v2021, puating formula in cell D4S 2) Put meight calculations (fermulas) in celumns F and 6 (use cells in columes K and L ) in the price-meighed index. I thould see 30 culculationalformulan. 5) Use the Sspso0 sectors spreadatiee that accomparies this assignmerh and identify the sector for each of the 30 comparies. Pat them in celumn P. 6) Calculate the sector allocations using both the price weighting the actual sector allocations of the DUlid and the market-value meichting an they mo on 133 rro2t. Use the cella below teies bax 7) Emai your spreadaheet to me, frem yeur SL dohn's emsil addess, by 150pm en Fridey, September 30. \begin{tabular}{l||l|l|} \hline \multicolumn{1}{|l|}{ Price-Weighted } & MN-welghted \\ \hline Industrials & & \\ \hline Financials & & \\ \hline Healthcare & & \\ \hline Tech & & \\ \hline Energr & & \\ \hline Staples & & \\ \hline Discretionary & & \\ \hline Materials & & \\ \hline Comm Srcs & & \\ \hline Utilities & & \\ \hline Real Estate & & \\ \hline \end{tabular} Directions: Work on this astignmert endrvidully 1 1) Calculate value of DMA en Er3v2021, puating formula in cell D4S 2) Put meight calculations (fermulas) in celumns F and 6 (use cells in columes K and L ) in the price-meighed index. I thould see 30 culculationalformulan. 5) Use the Sspso0 sectors spreadatiee that accomparies this assignmerh and identify the sector for each of the 30 comparies. Pat them in celumn P. 6) Calculate the sector allocations using both the price weighting the actual sector allocations of the DUlid and the market-value meichting an they mo on 133 rro2t. Use the cella below teies bax 7) Emai your spreadaheet to me, frem yeur SL dohn's emsil addess, by 150pm en Fridey, September 30. \begin{tabular}{l||l|l|} \hline \multicolumn{1}{|l|}{ Price-Weighted } & MN-welghted \\ \hline Industrials & & \\ \hline Financials & & \\ \hline Healthcare & & \\ \hline Tech & & \\ \hline Energr & & \\ \hline Staples & & \\ \hline Discretionary & & \\ \hline Materials & & \\ \hline Comm Srcs & & \\ \hline Utilities & & \\ \hline Real Estate & & \\ \hline \end{tabular}