Please I need the step-by-step process or the instructions. I can not do anything with just a picture.

WEEKN 4 - EXERCISES CHAPTER #3 Exercise Ch3-2: Level 2- Analyzing Stock Performance for Universal Investments. As an analyst at the Universal Investments financial company, you regularly monitor the performance of your clients' investments. You are preparing for a meeting with one of your investors to discuss how their stocks have performed over the last year and changes they should make to their portfolio. Your client has asked for information on four companies: Intel, AMD, Time Wamer, and Wal-Mart. You will find daily stock price and volume information contained in the Invest.xlsx workbook. Complete the following: 1. Open the workbook named Invest-1.xlsx attached with the data of the assignment, and then save the file as 3-2-Investment-Performance-YourName.xlsx 2. Create a chart for each company using the appropriate stock chart sub-type. Be certain to use each chart sub-type only once. 3. Place each chart on a new sheet in the workbook. 4. On the Stock Comparison worksheet use the appropriate chart to compare the change in stock price for each company over the last year. 5. Using the information on the Portfolio worksheet, prepare the appropriate chart to display the relative contribution of each stock to the value of the portfolio 6. Create an appropriate Combo chart on the Intel Summary worksheet that shows the daily closing price and volume data. Add a linear and a 30 day moving average trend line to the chart. 7. Add your name and date at the end of the exercise 8. Save and close the 3-2-Investment-Performance-YourName.xlsx workbook A B D E 1 2 Name 3 ALBERT INC 4 AMER EXPRESSO CO 5 AMER GROUP 6 BOETERING CO 7 CARSONS INC 8 CITY INC 9 DU PAGE CO 10 GENERAL AIR CO 11 GENERAL MICRO 12 HEWLETT-GEORGE 13 HOME WORKS INC 14 HONEY-BART INTL 15 INTELLIGENT CORP 16 INTL BUS CO 17 JQ RANDOLPH 18 SMITH&SMYTHE 19 WALT DOWNS CO Portfolio - 22SB Symbol Last AB 33.46 AP 51.46 AG 75.58 BT 44.66 CR 83.75 CT 50.55 DU 45.81 GA 31.73 GM 51.46 HG 22.33 HW 37.56 HON 35.96 IN 28.09 IBC 93.86 JQR 39.8 SS 55.36 DWS 25.16 Shares Value 55 $ 1,840.30 600 $ 30,876.00 1200 $ 90,696.00 527 $ 23,535.82 950 $ 79,562.50 800 $ 40,440.00 100 $ 4,581.00 675 $ 21,417.75 2000 $ 102,920.00 200 $ 4,466.00 1100 $ 41,316.00 100 $ 3,596.00 500 $ 14,045.00 800 $ 75,088.00 750 $ 29,850.00 1000 $ 55,360.00 800 $ 20,128.00 20 Total $639,718.37 A F 000 W N 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 Date 3-Mar-16 4-Mar-16 5-Mar-16 6-Mar-16 7-Mar-16 10-Mar-16 11-Mar-16 12-Mar-16) 13-Mar-16 14-Mar-16 17-Mar-16 18-Mar-16 19-Mar-16 20-Mar-16 21-Mar-16 24-Mar-16 25-Mar-16 26-Mar-16 27-Mar-16 28-Mar-16 31-Mar-16) 1-Apr-16 2-Apr-16 3-Apr-16 4-Apr-16 B C D E Wal-Mart Stock Price History - 225B Open High Loy Close 64.31 66.46 63.27 65.28 63.71 65.79 62.28 64.72 63.55 66.12 62.69 64.84 63.70 66.82 62.95 65.25 64.74 67.44 64.02 66.64 65.24 67.43 64.17 66.18 65.18 67.98 64.53 66.98 65.45 67.74 64.72 66.84 65.38 67.55 64.39 66.49 64.20 67.12 62.87 65.00 64.47 67.63 63.09 65.28 63.99 66.66 62.91 65.32 63.92 66.43 63.20 65.75 64.14 66.11 62.71 64.59 63.37 65.34 60.76 63.15 62.07 64.58 61.46 63.87 62.72 64.77 60.96 62.90 61.72 64.65 61.02 63.96 62.76 65.34 61.80 64.37 63.60 66.01 62.47 65.10 63.38 66.01 62.70 65.02 63.92 66.52 62.87 64.72 62.50 65.88 61.90 65.00 63.65 66.01 62.46 65.28 63.63 66.48 62.84 65.69 Volume 9682956 9803808 10071432 10293156 11927736 7417440 9094464 6988356) 9150192 15654384 11475540 9095544 7454808 112164481 15904404 7735176 14200164 10876248 9377640 9558648 7847496 8817876 7064280 10870740 6908760 19 20 21 22 23 24 25 26 27 A F 2 - 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 Date 3-Mar-16 4-Mar-16 5-Mar-16 6-Mar-16 7-Mar-16 10-Mar-16 11-Mar-16 12-Mar-16 13-Mar-16 14-Mar-16 17-Mar-16 18-Mar-16 19-Mar-16 20-Mar-16 21-Mar-16 24-Mar-16 25-Mar-16 26-Mar-16 27-Mar-16 28-Mar-16 31-Mar-16 1-Apr-16 2-Apr-16 3-Apr-16 4-Apr-16 B B D E E Time Warner - 22SB Open High Loy Close 18.00 18.66 17.60 18.33 17.82 18.34 17.14 17.76 17.53 18.06 17.14 17.75 17.60 18.16 17.16 17.79 17.50 18.52 17.33 18.28 17.89 18.55 17.63 18.19 17.87 18.55 17.65 18.31 17.93 18.63 17.67 18.26 17.93 18.64 17.71 18.23 17.96 18.63 17.76 18.35 18.25 19.11 17.90 18.63 18.24 18.94 17.93 18.73 18.39 19.10 18.09 18.82 18.37 19.03 17.98 18.61 18.54 19.22 18.14 18.81 18.45 19.17 18.22 18.79 18.28 18.95 17.61 18.28 17.69 18.40 17.38 18.10 17.72 18.32 17.40 18.06 17.88 18.40 17.45 17.99 17.71 18.50 17.49 18.19 17.94 18.70 17.57 18.13 17.76 18.43 17.38 18.16 17.73 18.70 17.55 18.32 17.82 18.45 17.51 18.20 Volume 22319280 16410816 14096052 19443456 15653628 9909000 11353608 13213692 16149348 12248604 14336568 10931004 12053556 10366920 13219956 10898064 21315420 15424020 11361492 128144161 10340892 11312028 14201136 21049416 11101428 A B D E E F 1 1 3 4 N 00 000 U AWN 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 Date 3-Mar-16 4-Mar-16 5-Mar-16 6-Mar-16 7-Mar-16 10-Mar-16 11-Mar-16 12-Mar-16 13-Mar-16 14-Mar-16 17-Mar-16 18-Mar-16 19-Mar-16 20-Mar-16 21-Mar-16 24-Mar-16 25-Mar-16 26-Mar-16 27-Mar-16 28-Mar-16 31-Mar-16 1-Apr-16 2-Apr-16 3-Apr-16 4-Apr-16 Open 16.1999 15.9665 15.9878 15.765 16.6031) 16.7092 16.6243 16.55) 17.0062 17.2715 18.1838 18.3005 18.2475 18.0353 18.2899 18.1626 18.5658 17.7701 18.1626 17.2078 17.0805 17.4518 16.9107 17.1123 17.6109 AMD - 22SB High Loy 17.0212 15.9376 16.4316 15.3072 16.4753 15.4648 16.9666 15.4543 17.4142 16.3789 17.3378 16.1792 17.3159 16.4104 17.5452 16.1267 17.9055 16.547) 18.4514 17.0828 19.0956 17.8707 19.1065 18.0913 18.779 17.7026 18.64791 17.5555 18.8336 17.7341 18.9755 17.86021 19.2157 18.01781 19.0192 17.5976 18.779 16.61 17.7854 16.547 17.8182) 16.8621 18.06931 16.568) 17.8182 16.4209 18.1457 16.652 18.2767 17.0197 Close 16.4929 15.9954 16.0711 16.8065 17.1634 16.7741 17.012 17.3364 17.5527 18.1584 18.8722 18.8505 18.4937 18.2774 18.3855 18.7857| 18.5585 18.5153 17.5419 17.3581 17.6176) 17.0769 17.6068 17.8015 17.6933 Volume 8785476 10484748 12602628 15589368 13414032 15149808 8524008 11666376 13204188 14679900 15567984 11783988 13075884 11125620 7544340 6943644 18005544 13781880 26910684 10870092 11549304 78636961 17283132 8368704 8011332 A B D E F G G 1 2 3 4 5 6 Date 3-Mar-16 4-Mar-16 5-Mar-16 6-Mar-16 7-Mar-16 10-Mar-16 7 8 11-Mar-16 12-Mar-16 13-Mar-16 14-Mar-16 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 17-Mar-16 18-Mar-16 19-Mar-16 20-Mar-16 21-Mar-16 24-Mar-16 25-Mar-16 26-Mar-16 27-Mar-16 28-Mar-16 31-Mar-16 1-Apr-16 2-Apr-16 3-Apr-16 4-Apr-16 Open 28.6973 27.8592 28.1139 27.8168 28.5382 29.47181 29.3339 29.1005 29.0899 29.0368 29.7052 30.0235 29.9704 29.7901 29.7901 29.3869 29.5673 28.8671 29.0793 28.3897 28.0184 28.3154 27.7213 27.5516 28.4321 Intel - 22SB High Loy 29.8826 27.7148 28.9218 27.3471 29. 1511 27.4207 29.3367 27.4837 30.352 28.2191 30.4066 28.7024 30.5158 28.8915 30.0682 28.4713 29.9917 28.3872 30.3302 28.6604 30.7014 29.0491 31. 1818 29.5429 31.0617 29.4588 30.7123 28.8705 30.7233 28.5763 30.3193 28.6078 30.4394 28.8285 30.1446 28.5028 29.9372 27.9144 29.2821 27.5888 29.1947 27.6308 29.3803 27.3471 28.9327 27.137 29.2057 27.158 30.10091 27.9985 Close 28.6489 28.3677 28.292 28.6922 30.0549 29.6115 29.9467 29.6655 29.4168 29.6115 30.4118 30.87681 30.574 29.871 29.6007 29.8494 29.9251 29.6007 28.8328 28.6057 28.8544 28.1947 28.4218 28.68141 29.7737 Volume 90433472 78846912 75835328 75061512 91534968 70895844 71549460 67166496 62434044 59456052 84965976 51337476) 75759840 78494832 77534928 55098252 89818096 85548640 97739024 69017616 55644516 54659232 66916800 70378740 70421292 WEEKN 4 - EXERCISES CHAPTER #3 Exercise Ch3-2: Level 2- Analyzing Stock Performance for Universal Investments. As an analyst at the Universal Investments financial company, you regularly monitor the performance of your clients' investments. You are preparing for a meeting with one of your investors to discuss how their stocks have performed over the last year and changes they should make to their portfolio. Your client has asked for information on four companies: Intel, AMD, Time Wamer, and Wal-Mart. You will find daily stock price and volume information contained in the Invest.xlsx workbook. Complete the following: 1. Open the workbook named Invest-1.xlsx attached with the data of the assignment, and then save the file as 3-2-Investment-Performance-YourName.xlsx 2. Create a chart for each company using the appropriate stock chart sub-type. Be certain to use each chart sub-type only once. 3. Place each chart on a new sheet in the workbook. 4. On the Stock Comparison worksheet use the appropriate chart to compare the change in stock price for each company over the last year. 5. Using the information on the Portfolio worksheet, prepare the appropriate chart to display the relative contribution of each stock to the value of the portfolio 6. Create an appropriate Combo chart on the Intel Summary worksheet that shows the daily closing price and volume data. Add a linear and a 30 day moving average trend line to the chart. 7. Add your name and date at the end of the exercise 8. Save and close the 3-2-Investment-Performance-YourName.xlsx workbook A B D E 1 2 Name 3 ALBERT INC 4 AMER EXPRESSO CO 5 AMER GROUP 6 BOETERING CO 7 CARSONS INC 8 CITY INC 9 DU PAGE CO 10 GENERAL AIR CO 11 GENERAL MICRO 12 HEWLETT-GEORGE 13 HOME WORKS INC 14 HONEY-BART INTL 15 INTELLIGENT CORP 16 INTL BUS CO 17 JQ RANDOLPH 18 SMITH&SMYTHE 19 WALT DOWNS CO Portfolio - 22SB Symbol Last AB 33.46 AP 51.46 AG 75.58 BT 44.66 CR 83.75 CT 50.55 DU 45.81 GA 31.73 GM 51.46 HG 22.33 HW 37.56 HON 35.96 IN 28.09 IBC 93.86 JQR 39.8 SS 55.36 DWS 25.16 Shares Value 55 $ 1,840.30 600 $ 30,876.00 1200 $ 90,696.00 527 $ 23,535.82 950 $ 79,562.50 800 $ 40,440.00 100 $ 4,581.00 675 $ 21,417.75 2000 $ 102,920.00 200 $ 4,466.00 1100 $ 41,316.00 100 $ 3,596.00 500 $ 14,045.00 800 $ 75,088.00 750 $ 29,850.00 1000 $ 55,360.00 800 $ 20,128.00 20 Total $639,718.37 A F 000 W N 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 Date 3-Mar-16 4-Mar-16 5-Mar-16 6-Mar-16 7-Mar-16 10-Mar-16 11-Mar-16 12-Mar-16) 13-Mar-16 14-Mar-16 17-Mar-16 18-Mar-16 19-Mar-16 20-Mar-16 21-Mar-16 24-Mar-16 25-Mar-16 26-Mar-16 27-Mar-16 28-Mar-16 31-Mar-16) 1-Apr-16 2-Apr-16 3-Apr-16 4-Apr-16 B C D E Wal-Mart Stock Price History - 225B Open High Loy Close 64.31 66.46 63.27 65.28 63.71 65.79 62.28 64.72 63.55 66.12 62.69 64.84 63.70 66.82 62.95 65.25 64.74 67.44 64.02 66.64 65.24 67.43 64.17 66.18 65.18 67.98 64.53 66.98 65.45 67.74 64.72 66.84 65.38 67.55 64.39 66.49 64.20 67.12 62.87 65.00 64.47 67.63 63.09 65.28 63.99 66.66 62.91 65.32 63.92 66.43 63.20 65.75 64.14 66.11 62.71 64.59 63.37 65.34 60.76 63.15 62.07 64.58 61.46 63.87 62.72 64.77 60.96 62.90 61.72 64.65 61.02 63.96 62.76 65.34 61.80 64.37 63.60 66.01 62.47 65.10 63.38 66.01 62.70 65.02 63.92 66.52 62.87 64.72 62.50 65.88 61.90 65.00 63.65 66.01 62.46 65.28 63.63 66.48 62.84 65.69 Volume 9682956 9803808 10071432 10293156 11927736 7417440 9094464 6988356) 9150192 15654384 11475540 9095544 7454808 112164481 15904404 7735176 14200164 10876248 9377640 9558648 7847496 8817876 7064280 10870740 6908760 19 20 21 22 23 24 25 26 27 A F 2 - 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 Date 3-Mar-16 4-Mar-16 5-Mar-16 6-Mar-16 7-Mar-16 10-Mar-16 11-Mar-16 12-Mar-16 13-Mar-16 14-Mar-16 17-Mar-16 18-Mar-16 19-Mar-16 20-Mar-16 21-Mar-16 24-Mar-16 25-Mar-16 26-Mar-16 27-Mar-16 28-Mar-16 31-Mar-16 1-Apr-16 2-Apr-16 3-Apr-16 4-Apr-16 B B D E E Time Warner - 22SB Open High Loy Close 18.00 18.66 17.60 18.33 17.82 18.34 17.14 17.76 17.53 18.06 17.14 17.75 17.60 18.16 17.16 17.79 17.50 18.52 17.33 18.28 17.89 18.55 17.63 18.19 17.87 18.55 17.65 18.31 17.93 18.63 17.67 18.26 17.93 18.64 17.71 18.23 17.96 18.63 17.76 18.35 18.25 19.11 17.90 18.63 18.24 18.94 17.93 18.73 18.39 19.10 18.09 18.82 18.37 19.03 17.98 18.61 18.54 19.22 18.14 18.81 18.45 19.17 18.22 18.79 18.28 18.95 17.61 18.28 17.69 18.40 17.38 18.10 17.72 18.32 17.40 18.06 17.88 18.40 17.45 17.99 17.71 18.50 17.49 18.19 17.94 18.70 17.57 18.13 17.76 18.43 17.38 18.16 17.73 18.70 17.55 18.32 17.82 18.45 17.51 18.20 Volume 22319280 16410816 14096052 19443456 15653628 9909000 11353608 13213692 16149348 12248604 14336568 10931004 12053556 10366920 13219956 10898064 21315420 15424020 11361492 128144161 10340892 11312028 14201136 21049416 11101428 A B D E E F 1 1 3 4 N 00 000 U AWN 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 Date 3-Mar-16 4-Mar-16 5-Mar-16 6-Mar-16 7-Mar-16 10-Mar-16 11-Mar-16 12-Mar-16 13-Mar-16 14-Mar-16 17-Mar-16 18-Mar-16 19-Mar-16 20-Mar-16 21-Mar-16 24-Mar-16 25-Mar-16 26-Mar-16 27-Mar-16 28-Mar-16 31-Mar-16 1-Apr-16 2-Apr-16 3-Apr-16 4-Apr-16 Open 16.1999 15.9665 15.9878 15.765 16.6031) 16.7092 16.6243 16.55) 17.0062 17.2715 18.1838 18.3005 18.2475 18.0353 18.2899 18.1626 18.5658 17.7701 18.1626 17.2078 17.0805 17.4518 16.9107 17.1123 17.6109 AMD - 22SB High Loy 17.0212 15.9376 16.4316 15.3072 16.4753 15.4648 16.9666 15.4543 17.4142 16.3789 17.3378 16.1792 17.3159 16.4104 17.5452 16.1267 17.9055 16.547) 18.4514 17.0828 19.0956 17.8707 19.1065 18.0913 18.779 17.7026 18.64791 17.5555 18.8336 17.7341 18.9755 17.86021 19.2157 18.01781 19.0192 17.5976 18.779 16.61 17.7854 16.547 17.8182) 16.8621 18.06931 16.568) 17.8182 16.4209 18.1457 16.652 18.2767 17.0197 Close 16.4929 15.9954 16.0711 16.8065 17.1634 16.7741 17.012 17.3364 17.5527 18.1584 18.8722 18.8505 18.4937 18.2774 18.3855 18.7857| 18.5585 18.5153 17.5419 17.3581 17.6176) 17.0769 17.6068 17.8015 17.6933 Volume 8785476 10484748 12602628 15589368 13414032 15149808 8524008 11666376 13204188 14679900 15567984 11783988 13075884 11125620 7544340 6943644 18005544 13781880 26910684 10870092 11549304 78636961 17283132 8368704 8011332 A B D E F G G 1 2 3 4 5 6 Date 3-Mar-16 4-Mar-16 5-Mar-16 6-Mar-16 7-Mar-16 10-Mar-16 7 8 11-Mar-16 12-Mar-16 13-Mar-16 14-Mar-16 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 17-Mar-16 18-Mar-16 19-Mar-16 20-Mar-16 21-Mar-16 24-Mar-16 25-Mar-16 26-Mar-16 27-Mar-16 28-Mar-16 31-Mar-16 1-Apr-16 2-Apr-16 3-Apr-16 4-Apr-16 Open 28.6973 27.8592 28.1139 27.8168 28.5382 29.47181 29.3339 29.1005 29.0899 29.0368 29.7052 30.0235 29.9704 29.7901 29.7901 29.3869 29.5673 28.8671 29.0793 28.3897 28.0184 28.3154 27.7213 27.5516 28.4321 Intel - 22SB High Loy 29.8826 27.7148 28.9218 27.3471 29. 1511 27.4207 29.3367 27.4837 30.352 28.2191 30.4066 28.7024 30.5158 28.8915 30.0682 28.4713 29.9917 28.3872 30.3302 28.6604 30.7014 29.0491 31. 1818 29.5429 31.0617 29.4588 30.7123 28.8705 30.7233 28.5763 30.3193 28.6078 30.4394 28.8285 30.1446 28.5028 29.9372 27.9144 29.2821 27.5888 29.1947 27.6308 29.3803 27.3471 28.9327 27.137 29.2057 27.158 30.10091 27.9985 Close 28.6489 28.3677 28.292 28.6922 30.0549 29.6115 29.9467 29.6655 29.4168 29.6115 30.4118 30.87681 30.574 29.871 29.6007 29.8494 29.9251 29.6007 28.8328 28.6057 28.8544 28.1947 28.4218 28.68141 29.7737 Volume 90433472 78846912 75835328 75061512 91534968 70895844 71549460 67166496 62434044 59456052 84965976 51337476) 75759840 78494832 77534928 55098252 89818096 85548640 97739024 69017616 55644516 54659232 66916800 70378740 70421292