Please show the equations and how I would attempt to do #3-5 ((:

1. Download and save the Excel 8 Template.xlsx file as LastNameFirstNameExcel8.xlsx (e.g. BestMarkExcel8.xlsx). As an analyst at the Jayhawk 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: Wal-Mart, Time Warner, AMD, and Intel. 2. Create a chart for each company using the appropriate stock chart sub-type. Place the Wal-Mart chart on the Wal-Mart worksheet, the Time Warner chart on the Time Warner worksheet, etc. Make sure that the charts are easy to read (i.e. you should make them bigger!). Use the following information to help you create the four charts: 0 Wal-Mart Chart Use the High-Low-Close Sub-Type. Chart Title = Wal-Mart (in bold). Display the Legend on the Right. Vertical Axis Minimum = 58; Vertical Axis Maximum = 70. Format the Close Markers to Size 8. . . Time Warner Chart Use the Open-High-Low-Close Sub-Type. Chart Title = Time Warner (in bold). Display the Legend on the Bottom. Vertical Axis Minimum = 16.5; Vertical Axis Maximum = 19.5. . . O AMD Chart Use the Volume-High-Low-Close Sub-Type. Chart Title = AMD (in bold). Display the Legend on the Bottom. Vertical Axis Minimum = 0; Vertical Axis Maximum = 30000000. Secondary Vertical Axis Minimum = 0; Secondary Vertical Axis Maximum = 25. Volume Columns: Fill = Solid Fill; Color = Light Blue (the exact shade of blue does not matter). . . . O Intel Chart Use the Volume-Open-High-Low-Close Sub-Type. Chart Title = Intel (in bold). Display the Legend on the Right. Vertical Axis Minimum = 0; Vertical Axis Maximum = 120000000. Secondary Vertical Axis Minimum = 25; Secondary Vertical Axis Maximum = 32. Volume Columns: Fill = Solid Fill; Color = Light Red (the exact shade of red does not matter). 3. On the Stock Comparison worksheet, create a line chart that compares all four stocks on the same chart. Use the following information to help you create the chart: . . Time Period in Chart = January 1, 2015 - December 31, 2015. Chart Title = Stock Price Comparison (in bold). Display the Legend on the Bottom. Vertical Axis Minimum = 0; Vertical Axis Maximum = 80. O 4. On the Portfolio worksheet, create a chart to display the relative contribution of each stock to the value of the portfolio. Before creating the chart, sort the data from largest to smallest by value. Your chart should look very similar to the one displayed below (the colors do not have to match). Portfolio Allocation CITY INC HOME WORKS INC AMER EXPRESSO CO SMITH&SMYTHE JQ RANDOLPH BOETERING CO WALT DOWNS CO GENERAL AIR CO INTL BUSCO Other INTELLIGENT CORP DU PAGE CO HEWLETT-GEORGE CARSONS INC HONEY-BART INTL ALBERT INC GENERAL MICRO AMER GROUP 5. Create a Combo Chart on the Intel Summary worksheet that shows the daily closing price and volume data. Include the data from January 1, 2015 - January 31, 2016. Add a linear trend line and a 30 day moving average trend line to the chart. Your chart should look very similar to the one displayed below (the colors do not have to match). Intel Summary 160,000,000 $40 140,000,000 $35 120,000,000 $30 100,000,000 $25 Volume 80,000,000 $20 Closing Price 60,000,000 $15 40,000,000 $10 20,000,000 $5 0 $o 1-Jan-15 one woman who come -Feb-15 1-Sep-15 1-Oct-15 1-Nov-1 1-Dec-15 Jan-18 1-Mar-15 1-Apr-15 1-May-15 1-Jun-15 1-Jul-15 Volume Close ......... Linear (Close) ........ 30 per. Mov. Avg. (Close) 6. Make the Wal-Mart tab the active worksheet, save and close your file, and use the Excel 8 link on Blackboard to submit your work. B D E G H 1 J K Open 64.31 63.71 63.55 Low 63.27 62.28 62.69 62.95 64.02 64.17 64.53 64.72 64.39 High 66.46 65.79 66.12 66.82 67.44 67.43 67.98 67.74 67.55 67.12 67.63 66.66 66.43 66.11 65.34 64.58 64.77 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 62.87 63.70 64.74 65.24 65.18 65.45 65.38 64.20 64.47 63.99 63.92 64.14 63.37 62.07 62.72 61.72 62.76 63.60 63.38 63.92 62.50 63.65 63.63 Close 65.28 64.72 64.84 65.25 66.64 66.18 66.98 66.84 66.49 65.00 65.28 65.32 65.75 64.59 63.15 63.87 62.90 63.96 64.37 65.10 65.02 64.72 65.00 65.28 65.69 63.09 62.91 63.20 62.71 60.76 61.46 60.96 61.02 61.80 62.47 62.70 62.87 61.90 62.46 62.84 Volume 9682956 9803808 10071432 10293156 11927736 7417440 9094464 6988356 9150192 15654384 11475540 9095544 7454808 11216448 15904404 7735176 14200164 10876248 9377640 9558648 7847496 8817876 7064280 10870740 6908760 64.65 65.34 66.01 66.01 66.52 65.88 66.01 66.48 Wal-Mart Time Warner AMD Intel Stock Comparison Portfolio A B D E F G H - J K 1 2 3 4 5 6 7 Close 18.33 17.76 17.75 17.79 18.28 18.19 18.31 18.26 18.23 18.35 18.63 18.73 8 9 10 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 High 18.66 18.34 18.06 18.16 18.52 18.55 18.55 18.63 18.64 18.63 19.11 18.94 19.10 19.03 19.22 19.17 18.95 18.40 18.32 11 12 13 Open 18.00 17.82 17.53 17.60 17.50 17.89 17.87 17.93 17.93 17.96 18.25 18.24 18.39 18.37 18.54 18.45 18.28 17.69 17.72 17.88 17.71 17.94 17.76 17.73 17.82 Low 17.60 17.14 17.14 17.16 17.33 17.63 17.65 17.67 17.71 17.76 17.90 17.93 18.09 17.98 18.14 18.22 17.61 17.38 17.40 17.45 17.49 17.57 17.38 17.55 17.51 Volume 22319280 16410816 14096052 19443456 15653628 9909000 11353608 13213692 16149348 12248604 14336568 10931004 12053556 10366920 13219956 10898064 21315420 15424020 11361492 12814416 10340892 11312028 14201136 21049416 11101428 14 15 16 17 18 19 20 21 22 18.82 18.61 18.81 18.79 18.28 18.10 18.06 17.99 18.19 18.13 18.16 18.32 18.20 18.40 23 24 25 18.50 18.70 18.43 18.70 18.45 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 Wal-Mart Time Warner AMD Intel Stock Comparison Portfolio A B D E F G H 1 J J 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 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 High 17.0212 16.4316 16.4753 16.9666 17.4142 17.3378 17.3159 17.5452 17.9055 18.4514 19.0956 19.1065 18.779 18.6479 18.8336 18.9755 19.2157 19.0192 18.779 17.7854 17.8182 18.0693 17.8182 18.1457 18.2767 Low 15.9376 15.3072 15.4648 15.4543 16.3789 16.1792 16.4104 16.1267 16.547 17.0828 17.8707 18.0913 17.7026 17.5555 17.7341 17.8602 18.0178 17.5976 16.61 16.547 16.8621 16.568 16.4209 16.652 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 7863696 17283132 8368704 8011332 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 Wal-Mart Time Warner AMD Intel Stock Comparison Portfolio A D E F G H - J K. 1 2 3 4 5 6 7 8 9 10 11 12 13 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 28.6973 27.8592 28.1139 27.8168 28.5382 29.4718 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 High 29.8826 28.9218 29.1511 29.3367 30.352 30.4066 30.5158 30.0682 29.9917 30.3302 30.7014 31.1818 31.0617 30.7123 30.7233 30.3193 30.4394 30.1446 29.9372 29.2821 29.1947 29.3803 28.9327 29.2057 30.1009 Low 27.7148 27.3471 27.4207 27.4837 28.2191 28.7024 28.8915 28.4713 28.3872 28.6604 29.0491 29.5429 29.4588 28.8705 28.5763 28.6078 28.8285 28.5028 27.9144 27.5888 27.6308 27.3471 27.137 27.158 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.8768 30.574 29.871 29.6007 29.8494 29.9251 29.6007 28.8328 28.6057 28.8544 28.1947 28.4218 28.6814 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 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 Wal-Mart Time Warner AMD Intel Stock Comparison Portfolio B D E F G H - J 1 Name Symbol AB Last 33.5 2 3 AP 4 ALBERT INC AMER EXPRESSO CO AMER GROUP BOETERING CO CARSONS INC AG BT 51.5 75.6 44.7 83.8 5 6 CR 7 CT CITY INC DU PAGE CO 8 DU GA GM HG 50.6 45.8 31.7 51.5 22.3 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 $ 639,718.37 37.6 HW HON IN IBC JQR 36 28.1 93.9 39.8 SS DWS 55.4 25.2 9 GENERAL AIR CO 10 GENERAL MICRO 11 HEWLETT-GEORGE 12 HOME WORKS INC 13 HONEY-BART INTL 14 INTELLIGENT CORP 15 INTL BUS CO 16 JQ RANDOLPH 17 SMITH& SMYTHE 18 WALT DOWNS CO 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 Wal-Mart Time Warner AMD Intel Stock Comparison Portfolio 1. Download and save the Excel 8 Template.xlsx file as LastNameFirstNameExcel8.xlsx (e.g. BestMarkExcel8.xlsx). As an analyst at the Jayhawk 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: Wal-Mart, Time Warner, AMD, and Intel. 2. Create a chart for each company using the appropriate stock chart sub-type. Place the Wal-Mart chart on the Wal-Mart worksheet, the Time Warner chart on the Time Warner worksheet, etc. Make sure that the charts are easy to read (i.e. you should make them bigger!). Use the following information to help you create the four charts: 0 Wal-Mart Chart Use the High-Low-Close Sub-Type. Chart Title = Wal-Mart (in bold). Display the Legend on the Right. Vertical Axis Minimum = 58; Vertical Axis Maximum = 70. Format the Close Markers to Size 8. . . Time Warner Chart Use the Open-High-Low-Close Sub-Type. Chart Title = Time Warner (in bold). Display the Legend on the Bottom. Vertical Axis Minimum = 16.5; Vertical Axis Maximum = 19.5. . . O AMD Chart Use the Volume-High-Low-Close Sub-Type. Chart Title = AMD (in bold). Display the Legend on the Bottom. Vertical Axis Minimum = 0; Vertical Axis Maximum = 30000000. Secondary Vertical Axis Minimum = 0; Secondary Vertical Axis Maximum = 25. Volume Columns: Fill = Solid Fill; Color = Light Blue (the exact shade of blue does not matter). . . . O Intel Chart Use the Volume-Open-High-Low-Close Sub-Type. Chart Title = Intel (in bold). Display the Legend on the Right. Vertical Axis Minimum = 0; Vertical Axis Maximum = 120000000. Secondary Vertical Axis Minimum = 25; Secondary Vertical Axis Maximum = 32. Volume Columns: Fill = Solid Fill; Color = Light Red (the exact shade of red does not matter). 3. On the Stock Comparison worksheet, create a line chart that compares all four stocks on the same chart. Use the following information to help you create the chart: . . Time Period in Chart = January 1, 2015 - December 31, 2015. Chart Title = Stock Price Comparison (in bold). Display the Legend on the Bottom. Vertical Axis Minimum = 0; Vertical Axis Maximum = 80. O 4. On the Portfolio worksheet, create a chart to display the relative contribution of each stock to the value of the portfolio. Before creating the chart, sort the data from largest to smallest by value. Your chart should look very similar to the one displayed below (the colors do not have to match). Portfolio Allocation CITY INC HOME WORKS INC AMER EXPRESSO CO SMITH&SMYTHE JQ RANDOLPH BOETERING CO WALT DOWNS CO GENERAL AIR CO INTL BUSCO Other INTELLIGENT CORP DU PAGE CO HEWLETT-GEORGE CARSONS INC HONEY-BART INTL ALBERT INC GENERAL MICRO AMER GROUP 5. Create a Combo Chart on the Intel Summary worksheet that shows the daily closing price and volume data. Include the data from January 1, 2015 - January 31, 2016. Add a linear trend line and a 30 day moving average trend line to the chart. Your chart should look very similar to the one displayed below (the colors do not have to match). Intel Summary 160,000,000 $40 140,000,000 $35 120,000,000 $30 100,000,000 $25 Volume 80,000,000 $20 Closing Price 60,000,000 $15 40,000,000 $10 20,000,000 $5 0 $o 1-Jan-15 one woman who come -Feb-15 1-Sep-15 1-Oct-15 1-Nov-1 1-Dec-15 Jan-18 1-Mar-15 1-Apr-15 1-May-15 1-Jun-15 1-Jul-15 Volume Close ......... Linear (Close) ........ 30 per. Mov. Avg. (Close) 6. Make the Wal-Mart tab the active worksheet, save and close your file, and use the Excel 8 link on Blackboard to submit your work. B D E G H 1 J K Open 64.31 63.71 63.55 Low 63.27 62.28 62.69 62.95 64.02 64.17 64.53 64.72 64.39 High 66.46 65.79 66.12 66.82 67.44 67.43 67.98 67.74 67.55 67.12 67.63 66.66 66.43 66.11 65.34 64.58 64.77 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 62.87 63.70 64.74 65.24 65.18 65.45 65.38 64.20 64.47 63.99 63.92 64.14 63.37 62.07 62.72 61.72 62.76 63.60 63.38 63.92 62.50 63.65 63.63 Close 65.28 64.72 64.84 65.25 66.64 66.18 66.98 66.84 66.49 65.00 65.28 65.32 65.75 64.59 63.15 63.87 62.90 63.96 64.37 65.10 65.02 64.72 65.00 65.28 65.69 63.09 62.91 63.20 62.71 60.76 61.46 60.96 61.02 61.80 62.47 62.70 62.87 61.90 62.46 62.84 Volume 9682956 9803808 10071432 10293156 11927736 7417440 9094464 6988356 9150192 15654384 11475540 9095544 7454808 11216448 15904404 7735176 14200164 10876248 9377640 9558648 7847496 8817876 7064280 10870740 6908760 64.65 65.34 66.01 66.01 66.52 65.88 66.01 66.48 Wal-Mart Time Warner AMD Intel Stock Comparison Portfolio A B D E F G H - J K 1 2 3 4 5 6 7 Close 18.33 17.76 17.75 17.79 18.28 18.19 18.31 18.26 18.23 18.35 18.63 18.73 8 9 10 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 High 18.66 18.34 18.06 18.16 18.52 18.55 18.55 18.63 18.64 18.63 19.11 18.94 19.10 19.03 19.22 19.17 18.95 18.40 18.32 11 12 13 Open 18.00 17.82 17.53 17.60 17.50 17.89 17.87 17.93 17.93 17.96 18.25 18.24 18.39 18.37 18.54 18.45 18.28 17.69 17.72 17.88 17.71 17.94 17.76 17.73 17.82 Low 17.60 17.14 17.14 17.16 17.33 17.63 17.65 17.67 17.71 17.76 17.90 17.93 18.09 17.98 18.14 18.22 17.61 17.38 17.40 17.45 17.49 17.57 17.38 17.55 17.51 Volume 22319280 16410816 14096052 19443456 15653628 9909000 11353608 13213692 16149348 12248604 14336568 10931004 12053556 10366920 13219956 10898064 21315420 15424020 11361492 12814416 10340892 11312028 14201136 21049416 11101428 14 15 16 17 18 19 20 21 22 18.82 18.61 18.81 18.79 18.28 18.10 18.06 17.99 18.19 18.13 18.16 18.32 18.20 18.40 23 24 25 18.50 18.70 18.43 18.70 18.45 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 Wal-Mart Time Warner AMD Intel Stock Comparison Portfolio A B D E F G H 1 J J 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 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 High 17.0212 16.4316 16.4753 16.9666 17.4142 17.3378 17.3159 17.5452 17.9055 18.4514 19.0956 19.1065 18.779 18.6479 18.8336 18.9755 19.2157 19.0192 18.779 17.7854 17.8182 18.0693 17.8182 18.1457 18.2767 Low 15.9376 15.3072 15.4648 15.4543 16.3789 16.1792 16.4104 16.1267 16.547 17.0828 17.8707 18.0913 17.7026 17.5555 17.7341 17.8602 18.0178 17.5976 16.61 16.547 16.8621 16.568 16.4209 16.652 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 7863696 17283132 8368704 8011332 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 Wal-Mart Time Warner AMD Intel Stock Comparison Portfolio A D E F G H - J K. 1 2 3 4 5 6 7 8 9 10 11 12 13 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 28.6973 27.8592 28.1139 27.8168 28.5382 29.4718 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 High 29.8826 28.9218 29.1511 29.3367 30.352 30.4066 30.5158 30.0682 29.9917 30.3302 30.7014 31.1818 31.0617 30.7123 30.7233 30.3193 30.4394 30.1446 29.9372 29.2821 29.1947 29.3803 28.9327 29.2057 30.1009 Low 27.7148 27.3471 27.4207 27.4837 28.2191 28.7024 28.8915 28.4713 28.3872 28.6604 29.0491 29.5429 29.4588 28.8705 28.5763 28.6078 28.8285 28.5028 27.9144 27.5888 27.6308 27.3471 27.137 27.158 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.8768 30.574 29.871 29.6007 29.8494 29.9251 29.6007 28.8328 28.6057 28.8544 28.1947 28.4218 28.6814 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 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 Wal-Mart Time Warner AMD Intel Stock Comparison Portfolio B D E F G H - J 1 Name Symbol AB Last 33.5 2 3 AP 4 ALBERT INC AMER EXPRESSO CO AMER GROUP BOETERING CO CARSONS INC AG BT 51.5 75.6 44.7 83.8 5 6 CR 7 CT CITY INC DU PAGE CO 8 DU GA GM HG 50.6 45.8 31.7 51.5 22.3 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 $ 639,718.37 37.6 HW HON IN IBC JQR 36 28.1 93.9 39.8 SS DWS 55.4 25.2 9 GENERAL AIR CO 10 GENERAL MICRO 11 HEWLETT-GEORGE 12 HOME WORKS INC 13 HONEY-BART INTL 14 INTELLIGENT CORP 15 INTL BUS CO 16 JQ RANDOLPH 17 SMITH& SMYTHE 18 WALT DOWNS CO 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 Wal-Mart Time Warner AMD Intel Stock Comparison Portfolio