Show the formula and the answer. Use the excel sheet to answer

DJIA as of 10/21/2021 0 Symbol Company Name Last Price Market CC SB EPS Est Forward Dividend Next PE Patie Payment Date Erow Dale Dw/Share Forward OWN Forward DIY Trailing O Rate Trailing Ol Yel Prica/Book $5.67 $17.68 $9.42 $0.83 $6.72 $0.88 $7.04 $1.72 11-Aug-216-Aug-21 7-Sep-21 16-Aug-21 9-Nov-21 7-Oct-21 5-Mar-2013-Feb-20 19-Aug-21 22-Oct-21 0.59% 3.35% 0.96% 30.51 1443 0.56% 3.21% 0.95% $1.72 26.36 11,60 18.84 35.90 19.14 82.59 15.17 13.13 39.85 50.83 56.72 $1.72 $0.00 $4.20 $5.9T 5.55 -7.33 6.57 $4.44 2.1796 2.06% 511 $1.48 $5.35 2.63% 4.74% AAPL Apple Inc. $149.48 $2.471.000 AMGN Amgen Inc. $208.99 $118.675 AP American Express Company $177.47 $140.988 BA The Boeing Company $214.34 $125.630 CAT Caterpillar Inc $202.14 $110.686 CRM force.com, Inc. $280.81 $280.724 esco Cisco Systems, Inc. $55.69 $234.336 w Chevron Corporation $111.74 $216.095 DIS The Walt Disney Company 5171 34 5311,347 Dow Dow Inc $59.26 $44.194 os The Goldman Sachs Group, $407.59 $137397 HD The Home Depot, Inc. $36462 $384.805 HON Honeywell International Inc. $22.52 $155.008 IBM International Business Machi $128.33 $115.025 INTC Intel Corporation $56.00 $227192 INI Johnson & Johnson 5163.40 $430.384 MJPMorgan Chase & Co. $169.50 $500,023 KO The Coca-Cola Company $54 35 5234.500 MCD McDonald's Corporation $241.40 $162571 MMM Minn Mining $182.12 $105.382 MRK Merck & Co., Inc $81.17 $206.471 5.60 1.62 3.55 2.54 $10.56 $4.63 $3.67 $8.50 $4.30 58.15 $39.92 $15.15 50.15 $11.80 $4.41 $10:37 $11.89 $242 $9.90 $10.53 $6.79 10.21 24.07 24 54 10.88 12.70 15.76 14.26 22.46 20.30 17.30 11.95 26-Oct-21 4-Oct-21 9-Sep-21 18-Aug-21 15-Jan-2013-Dec-19 9-Sep-21 29-Nov-21 28-Sep-21 31-Aug-21 15-Sep-21 1-Sep-21 2-Dec-21 10-Nov-21 9-Sep-21 9-Aug 21 30-Nov-21 4-Nov-21 6-Sep-21 23-Aug-21 30-Oct-21 5-Oct-21 30-Sep-21 14-Sep-21 14-Dec-21 30-Nov-21 11-Sep-21 20 Aug 21 6-Oct-21 14-Sep-21 $0.00 $4.12 $0.00 $1.46 $5.21 $0.00 $2.80 $5.75 56.30 $3.60 $653 $1.35 $4.09 $3.70 $1.66 5512 $5.90 $2.56 $2.80 $8.00 $8.60 $3.92 $6.56 $1.39 3424 $4.00 $1.50 $5.52 $5.92 $2.60 4.73% 1.96N 1.8496 1.75% 4.626 251 2.599 $1.46 $5.21 $0.88 $2.80 $5.75 $6.45 $3.60 $6.53 5135 $4.14 $3.70 $1.66 $5.12 $5.90 $2.52 2.60% 400% 0.52% 4.68% 1.419 1.80% 1.66% 4.60 245 2.53% 2.17 3.04 2.14 3.231 3.11% 108.13 8.64 5.24 267 6.18 1.30 10.54 -31.04 7.29 6.17 2.34% 3.08 2.27% 325 3.21% 5 M N 0 3.11% 7 1 3 10 1 2 MC Morck & Co., Inc MST Microsoft Corporation NE NIKE, Inc. PG The Procter & Gamble Come TRV The Travelers Companies, ir UNH UnitedHealth Group Incorpo V Visa Inc VE Verizon Communications Inc W Walgreens Boots Aliano, in WMT Walmartine C D $81.17 $206.471 $310.76 $2,333.000 $162.10 $256.702 $139.33 $337.172 $160.19 $39.408 $44228 $417,033 $230.24 $505230 553.39 $221 041 $49.14 $42.530 $146.81 $400.380 $6.79 $10.11 $4.75 $6.37 $12.55 $21.85 $7:26 $533 $5.19 $8.50 G H 6-Oct-21 14-Sep-21 8-Dec-21 17-Nov-21 30-Sep-21 27-Aug-21 15-Aug-21 21-Oct-21 29-Sep-21 9-Dec-21 20-Sep-21 10-Sep-21 31-Aug-21 12-Aug-21 31-Oct-21 7-Oct-21 9-Sep-2119. Aug 21 2-Jan-22 9-Dec-21 $2.56 $2.14 51.10 $324 $3.46 30.74 34.14 21.87 12.76 20.43 31.71 10.02 9:47 2224 $2.60 $2.45 $1.10 $3.48 $3.52 $5.80 $128 $2.56 51.91 $2.20 3219 0.81 0.6956 2.46% 227) 1.33% 0.56% 4.78 3.95% 1.51% $2.52 $2 24 $1.10 $3.32 $35 $5.00 $123 $262 $1.38 $2.18 34 0 $5.00 0.73% 0.69% 2.37% 2.18% 1.24% OSS 4.70N 3.8995 1.49% 6.17 16.45 17.30 745 138 S77 14.13 2.87 129 500 $126 $2.51 $1.88 $2.18 Oltion you bought one share of each of the thony stock in the Dow Jones taustrials CA at the closing prices on October 21, 2001, w much would come? Question 2.39 stockare D chord unchanged and one stock was to report, what would be the change in the Dow Jones Intel Aurupe? Outton which stock has the highest waght in the Dow Jones anterian? Qui What is the weight of this stock in the DJ the stock to Oustion On What is caption for the DJA DJIA as of 10/21/2021 0 Symbol Company Name Last Price Market CC SB EPS Est Forward Dividend Next PE Patie Payment Date Erow Dale Dw/Share Forward OWN Forward DIY Trailing O Rate Trailing Ol Yel Prica/Book $5.67 $17.68 $9.42 $0.83 $6.72 $0.88 $7.04 $1.72 11-Aug-216-Aug-21 7-Sep-21 16-Aug-21 9-Nov-21 7-Oct-21 5-Mar-2013-Feb-20 19-Aug-21 22-Oct-21 0.59% 3.35% 0.96% 30.51 1443 0.56% 3.21% 0.95% $1.72 26.36 11,60 18.84 35.90 19.14 82.59 15.17 13.13 39.85 50.83 56.72 $1.72 $0.00 $4.20 $5.9T 5.55 -7.33 6.57 $4.44 2.1796 2.06% 511 $1.48 $5.35 2.63% 4.74% AAPL Apple Inc. $149.48 $2.471.000 AMGN Amgen Inc. $208.99 $118.675 AP American Express Company $177.47 $140.988 BA The Boeing Company $214.34 $125.630 CAT Caterpillar Inc $202.14 $110.686 CRM force.com, Inc. $280.81 $280.724 esco Cisco Systems, Inc. $55.69 $234.336 w Chevron Corporation $111.74 $216.095 DIS The Walt Disney Company 5171 34 5311,347 Dow Dow Inc $59.26 $44.194 os The Goldman Sachs Group, $407.59 $137397 HD The Home Depot, Inc. $36462 $384.805 HON Honeywell International Inc. $22.52 $155.008 IBM International Business Machi $128.33 $115.025 INTC Intel Corporation $56.00 $227192 INI Johnson & Johnson 5163.40 $430.384 MJPMorgan Chase & Co. $169.50 $500,023 KO The Coca-Cola Company $54 35 5234.500 MCD McDonald's Corporation $241.40 $162571 MMM Minn Mining $182.12 $105.382 MRK Merck & Co., Inc $81.17 $206.471 5.60 1.62 3.55 2.54 $10.56 $4.63 $3.67 $8.50 $4.30 58.15 $39.92 $15.15 50.15 $11.80 $4.41 $10:37 $11.89 $242 $9.90 $10.53 $6.79 10.21 24.07 24 54 10.88 12.70 15.76 14.26 22.46 20.30 17.30 11.95 26-Oct-21 4-Oct-21 9-Sep-21 18-Aug-21 15-Jan-2013-Dec-19 9-Sep-21 29-Nov-21 28-Sep-21 31-Aug-21 15-Sep-21 1-Sep-21 2-Dec-21 10-Nov-21 9-Sep-21 9-Aug 21 30-Nov-21 4-Nov-21 6-Sep-21 23-Aug-21 30-Oct-21 5-Oct-21 30-Sep-21 14-Sep-21 14-Dec-21 30-Nov-21 11-Sep-21 20 Aug 21 6-Oct-21 14-Sep-21 $0.00 $4.12 $0.00 $1.46 $5.21 $0.00 $2.80 $5.75 56.30 $3.60 $653 $1.35 $4.09 $3.70 $1.66 5512 $5.90 $2.56 $2.80 $8.00 $8.60 $3.92 $6.56 $1.39 3424 $4.00 $1.50 $5.52 $5.92 $2.60 4.73% 1.96N 1.8496 1.75% 4.626 251 2.599 $1.46 $5.21 $0.88 $2.80 $5.75 $6.45 $3.60 $6.53 5135 $4.14 $3.70 $1.66 $5.12 $5.90 $2.52 2.60% 400% 0.52% 4.68% 1.419 1.80% 1.66% 4.60 245 2.53% 2.17 3.04 2.14 3.231 3.11% 108.13 8.64 5.24 267 6.18 1.30 10.54 -31.04 7.29 6.17 2.34% 3.08 2.27% 325 3.21% 5 M N 0 3.11% 7 1 3 10 1 2 MC Morck & Co., Inc MST Microsoft Corporation NE NIKE, Inc. PG The Procter & Gamble Come TRV The Travelers Companies, ir UNH UnitedHealth Group Incorpo V Visa Inc VE Verizon Communications Inc W Walgreens Boots Aliano, in WMT Walmartine C D $81.17 $206.471 $310.76 $2,333.000 $162.10 $256.702 $139.33 $337.172 $160.19 $39.408 $44228 $417,033 $230.24 $505230 553.39 $221 041 $49.14 $42.530 $146.81 $400.380 $6.79 $10.11 $4.75 $6.37 $12.55 $21.85 $7:26 $533 $5.19 $8.50 G H 6-Oct-21 14-Sep-21 8-Dec-21 17-Nov-21 30-Sep-21 27-Aug-21 15-Aug-21 21-Oct-21 29-Sep-21 9-Dec-21 20-Sep-21 10-Sep-21 31-Aug-21 12-Aug-21 31-Oct-21 7-Oct-21 9-Sep-2119. Aug 21 2-Jan-22 9-Dec-21 $2.56 $2.14 51.10 $324 $3.46 30.74 34.14 21.87 12.76 20.43 31.71 10.02 9:47 2224 $2.60 $2.45 $1.10 $3.48 $3.52 $5.80 $128 $2.56 51.91 $2.20 3219 0.81 0.6956 2.46% 227) 1.33% 0.56% 4.78 3.95% 1.51% $2.52 $2 24 $1.10 $3.32 $35 $5.00 $123 $262 $1.38 $2.18 34 0 $5.00 0.73% 0.69% 2.37% 2.18% 1.24% OSS 4.70N 3.8995 1.49% 6.17 16.45 17.30 745 138 S77 14.13 2.87 129 500 $126 $2.51 $1.88 $2.18 Oltion you bought one share of each of the thony stock in the Dow Jones taustrials CA at the closing prices on October 21, 2001, w much would come? Question 2.39 stockare D chord unchanged and one stock was to report, what would be the change in the Dow Jones Intel Aurupe? Outton which stock has the highest waght in the Dow Jones anterian? Qui What is the weight of this stock in the DJ the stock to Oustion On What is caption for the DJA