Information system assignment
zxy0120
is_deliverable.xlsxSheet1
| Date (Month) | Adjusted Closing Price for TESLA | Adjusted Closing Price for GM | Adjusted Closing for NASDAQ |
| 1/3/11 | 24.1 | 32.593037 | 2700.080078 |
| 2/1/11 | 23.889999 | 29.949148 | 2782.27002 |
| 3/1/11 | 27.75 | 27.716139 | 2781.070068 |
| 4/1/11 | 27.6 | 28.662935 | 2873.540039 |
| 5/2/11 | 30.139999 | 28.412836 | 2835.300049 |
| 6/1/11 | 29.129999 | 27.117691 | 2773.52002 |
| 7/1/11 | 28.17 | 24.723904 | 2756.379883 |
| 8/1/11 | 24.74 | 21.463707 | 2579.459961 |
| 9/1/11 | 24.389999 | 18.024868 | 2415.399902 |
| 10/3/11 | 29.370001 | 23.089338 | 2684.409912 |
| 11/1/11 | 32.740002 | 19.016327 | 2620.340088 |
| 12/1/11 | 28.559999 | 18.105257 | 2605.149902 |
| 1/3/12 | 29.07 | 21.454775 | 2813.840088 |
| 2/1/12 | 33.41 | 23.241184 | 2966.889893 |
| 3/1/12 | 37.240002 | 22.910696 | 3091.570068 |
| 4/2/12 | 33.130001 | 20.543705 | 3046.360107 |
| 5/1/12 | 29.5 | 19.829142 | 2827.340088 |
| 6/1/12 | 31.290001 | 17.613993 | 2935.050049 |
| 7/2/12 | 27.42 | 17.605061 | 2939.52002 |
| 8/1/12 | 28.52 | 19.069918 | 3066.959961 |
| 9/4/12 | 29.280001 | 20.320404 | 3116.22998 |
| 10/1/12 | 28.129999 | 22.776716 | 2977.22998 |
| 11/1/12 | 33.82 | 23.116133 | 3010.23999 |
| 12/3/12 | 33.869999 | 25.751087 | 3019.51001 |
| 1/2/13 | 37.509998 | 25.090117 | 3142.129883 |
| 2/1/13 | 34.830002 | 24.250504 | 3160.189941 |
| 3/1/13 | 37.889999 | 24.848951 | 3267.52002 |
| 4/1/13 | 53.990002 | 27.546429 | 3328.790039 |
| 5/1/13 | 97.760002 | 30.270702 | 3455.909912 |
| 6/3/13 | 107.360001 | 29.752645 | 3403.25 |
| 7/1/13 | 134.279999 | 32.039246 | 3626.370117 |
| 8/1/13 | 169 | 30.440413 | 3589.870117 |
| 9/3/13 | 193.369995 | 32.128571 | 3771.47998 |
| 10/1/13 | 159.940002 | 33.00391 | 3919.709961 |
| 11/1/13 | 127.279999 | 34.593811 | 4059.889893 |
| 12/2/13 | 150.429993 | 36.505268 | 4176.589844 |
| 1/2/14 | 181.410004 | 32.226822 | 4103.879883 |
| 2/3/14 | 244.809998 | 32.334007 | 4308.120117 |
| 3/3/14 | 208.449997 | 31.017056 | 4198.990234 |
| 4/1/14 | 207.889999 | 31.071125 | 4114.560059 |
| 5/1/14 | 207.770004 | 31.161242 | 4242.620117 |
| 6/2/14 | 240.059998 | 32.984013 | 4408.180176 |
| 7/1/14 | 223.300003 | 30.730558 | 4369.77002 |
| 8/1/14 | 269.700012 | 31.621035 | 4580.27002 |
| 9/2/14 | 242.679993 | 29.276283 | 4493.390137 |
| 10/1/14 | 241.699997 | 28.781319 | 4630.740234 |
| 11/3/14 | 244.520004 | 30.642021 | 4791.629883 |
| 12/1/14 | 222.410004 | 32.284039 | 4736.049805 |
| 1/2/15 | 203.600006 | 30.166294 | 4635.240234 |
| 2/2/15 | 203.339996 | 34.50351 | 4963.529785 |
| 3/2/15 | 188.770004 | 34.96394 | 4900.879883 |
| 4/1/15 | 226.050003 | 32.688953 | 4941.419922 |
| 5/1/15 | 250.800003 | 33.537411 | 5070.029785 |
| 6/1/15 | 268.26001 | 31.397797 | 4986.870117 |
| 7/1/15 | 266.149994 | 29.683304 | 5128.279785 |
| 8/3/15 | 249.059998 | 27.733307 | 4776.509766 |
| 9/1/15 | 248.399994 | 28.627621 | 4620.160156 |
| 10/1/15 | 206.929993 | 33.290813 | 5053.75 |
| 11/2/15 | 230.259995 | 34.520985 | 5108.669922 |
| 12/1/15 | 240.009995 | 32.774151 | 5007.410156 |
Sheet2
Company Stock's Performance
Tesla 40546 40575 40603 40634 40665 40695 40725 40756 40787 40819 40848 40878 40911 40940 40969 41001 41030 41061 41092 41122 41156 41183 41214 41246 41276 41306 41334 41365 41395 41428 41456 41487 41520 41548 41579 41610 41641 41673 41701 41730 41760 41792 41821 41852 41884 41913 41946 41974 42006 42037 42065 42095 42125 42156 42186 42219 42248 42278 42310 42339 24.1 23.889999 27.75 27.6 30.139999 29.129999000000002 28.17 24.74 24.389999 29.370000999999998 32.740001999999997 28.559999000000001 29.07 33.409999999999997 37.240001999999997 33.130001 29.5 31.290001 27.42 28.52 29.280000999999999 28.129999000000002 33.82 33.869999 37.509998000000003 34.830002 37.889999000000003 53.990001999999997 97.760002 107.360001 134.279999 169 193.36999499999999 159.94000199999999 127.279999 150.429993 181.41000399999999 244.80999800000001 208.449997 207.88999899999999 207.770004 240.05999800000001 223.300003 269.70001200000002 242.679993 241.699997 244.520004 222.41000399999999 203.60000600000001 203.33999600000001 188.770004 226.050003 250.800003 268.26001000000002 266.14999399999999 249.05999800000001 248.39999399999999 206.929993 230.259995 240.009995 General Motors 40546 40575 40603 40634 40665 40695 40725 40756 40787 40819 40848 40878 40911 40940 40969 41001 41030 41061 41092 41122 41156 41183 41214 41246 41276 41306 41334 41365 41395 41428 41456 41487 41520 41548 41579 41610 41641 41673 41701 41730 41760 41792 41821 41852 41884 41913 41946 41974 42006 42037 42065 42095 42125 42156 42186 42219 42248 42278 42310 42339 32.593037000000002 29.949148000000001 27.716138999999998 28.662935000000001 28.412835999999999 27.117691000000001 24.723904000000001 21.463706999999999 18.024868000000001 23.089338000000001 19.016327 18.105257000000002 21.454775000000001 23.241184000000001 22.910696000000002 20.543704999999999 19.829142000000001 17.613993000000001 17.605060999999999 19.069918000000001 20.320404 22.776716 23.116133000000001 25.751086999999998 25.090116999999999 24.250503999999999 24.848951 27.546429 30.270702 29.752645000000001 32.039245999999999 30.440412999999999 32.128571000000001 33.003909999999998 34.593811000000002 36.505268000000001 32.226821999999999 32.334007 31.017056 31.071124999999999 31.161242000000001 32.984012999999997 30.730557999999998 31.621034999999999 29.276282999999999 28.781319 30.642021 32.284039 30.166294000000001 34.503509999999999 34.963940000000001 32.688952999999998 33.537410999999999 31.397797000000001 29.683304 27.733307 28.627621000000001 33.290813 34.520985000000003 32.774151000000003
Date
Adjusted Closign Price
According to the line chart above, we can see that Tesla outperformed General Motors in stock performance. Both companies had simlar low adjusted closing prices (below $50), from the beginning of 2011 to the end of 2012. In 2013, we can see that Tesla started to have increasing adjusted closing prices, whereas General Motors still had stock prices below $50. Tesla has shown to have a greater stock performance throughout all the years where the highest closing stock price was apprxomiately $269 in August of 2014. Despite having inconsistent, fluctuating closing stock prices, Tesla has shown significant,comparable performance from 2013 to 2015.
Sheet1 (2)
| Date (Month) | Adjusted Closing Price for TESLA | Adjusted Closing Price for GM | Adjusted Closing for NASDAQ | Date (Month) | Tesla | NASDAQ | |
| 1/3/11 | 24.1 | 32.593037 | 2700.080078 | 1/3/11 | 100 | 100 | |
| 2/1/11 | 23.889999 | 29.949148 | 2782.27002 | 2/1/11 | 99.128626556 | 103.0439816459 | |
| 3/1/11 | 27.75 | 27.716139 | 2781.070068 | 3/1/11 | 116.1573928906 | 99.9568714758 | |
| 4/1/11 | 27.6 | 28.662935 | 2873.540039 | 4/1/11 | 99.4594594595 | 103.3249781105 | |
| 5/2/11 | 30.139999 | 28.412836 | 2835.300049 | 5/2/11 | 109.2028949275 | 98.6692376135 | |
| 6/1/11 | 29.129999 | 27.117691 | 2773.52002 | 6/1/11 | 96.6489713553 | 97.8210408799 | |
| 7/1/11 | 28.17 | 24.723904 | 2756.379883 | 7/1/11 | 96.7044317441 | 99.382007814 | |
| 8/1/11 | 24.74 | 21.463707 | 2579.459961 | 8/1/11 | 87.8239261626 | 93.5814390792 | |
| 9/1/11 | 24.389999 | 18.024868 | 2415.399902 | 9/1/11 | 98.5852829426 | 93.6397516736 | |
| 10/3/11 | 29.370001 | 23.089338 | 2684.409912 | 10/3/11 | 120.4182132193 | 111.1372866157 | |
| 11/1/11 | 32.740002 | 19.016327 | 2620.340088 | 11/1/11 | 111.4742965109 | 97.6132622774 | |
| 12/1/11 | 28.559999 | 18.105257 | 2605.149902 | 12/1/11 | 87.2327344391 | 99.4202971565 | |
| 1/3/12 | 29.07 | 21.454775 | 2813.840088 | 1/3/12 | 101.7857178496 | 108.0106786116 | |
| 2/1/12 | 33.41 | 23.241184 | 2966.889893 | 2/1/12 | 114.9294805642 | 105.4391792075 | |
| 3/1/12 | 37.240002 | 22.910696 | 3091.570068 | 3/1/12 | 111.4636396289 | 104.2023863202 | |
| 4/2/12 | 33.130001 | 20.543705 | 3046.360107 | 4/2/12 | 88.9634780363 | 98.5376375109 | |
| 5/1/12 | 29.5 | 19.829142 | 2827.340088 | 5/1/12 | 89.0431606084 | 92.8104356902 | |
| 6/1/12 | 31.290001 | 17.613993 | 2935.050049 | 6/1/12 | 106.0678 | 103.8095863125 | |
| 7/2/12 | 27.42 | 17.605061 | 2939.52002 | 7/2/12 | 87.6318284554 | 100.1522962445 | |
| 8/1/12 | 28.52 | 19.069918 | 3066.959961 | 8/1/12 | 104.0116703136 | 104.3353996616 | |
| 9/4/12 | 29.280001 | 20.320404 | 3116.22998 | 9/4/12 | 102.6648001403 | 101.6064774117 | |
| 10/1/12 | 28.129999 | 22.776716 | 2977.22998 | 10/1/12 | 96.0723976751 | 95.5394819737 | |
| 11/1/12 | 33.82 | 23.116133 | 3010.23999 | 11/1/12 | 120.2275193824 | 101.1087490796 | |
| 12/3/12 | 33.869999 | 25.751087 | 3019.51001 | 12/3/12 | 100.1478385571 | 100.3079495333 | |
| 1/2/13 | 37.509998 | 25.090117 | 3142.129883 | 1/2/13 | 110.7469710879 | 104.0609195728 | |
| 2/1/13 | 34.830002 | 24.250504 | 3160.189941 | 2/1/13 | 92.8552488859 | 100.5747712116 | |
| 3/1/13 | 37.889999 | 24.848951 | 3267.52002 | 3/1/13 | 108.785520598 | 103.3963173418 | |
| 4/1/13 | 53.990002 | 27.546429 | 3328.790039 | 4/1/13 | 142.491431578 | 101.875122987 | |
| 5/1/13 | 97.760002 | 30.270702 | 3455.909912 | 5/1/13 | 181.0705656207 | 103.8188011713 | |
| 6/3/13 | 107.360001 | 29.752645 | 3403.25 | 6/3/13 | 109.819966043 | 98.4762359743 | |
| 7/1/13 | 134.279999 | 32.039246 | 3626.370117 | 7/1/13 | 125.0745135518 | 106.5560895321 | |
| 8/1/13 | 169 | 30.440413 | 3589.870117 | 8/1/13 | 125.8564203594 | 98.9934838744 | |
| 9/3/13 | 193.369995 | 32.128571 | 3771.47998 | 9/3/13 | 114.4201153846 | 105.0589535855 | |
| 10/1/13 | 159.940002 | 33.00391 | 3919.709961 | 10/1/13 | 82.7119026403 | 103.9302868313 | |
| 11/1/13 | 127.279999 | 34.593811 | 4059.889893 | 11/1/13 | 79.5798408206 | 103.576283281 | |
| 12/2/13 | 150.429993 | 36.505268 | 4176.589844 | 12/2/13 | 118.1882418148 | 102.8744609848 | |
| 1/2/14 | 181.410004 | 32.226822 | 4103.879883 | 1/2/14 | 120.5943046212 | 98.2591069816 | |
| 2/3/14 | 244.809998 | 32.334007 | 4308.120117 | 2/3/14 | 134.9484552131 | 104.9767595501 | |
| 3/3/14 | 208.449997 | 31.017056 | 4198.990234 | 3/3/14 | 85.1476650067 | 97.4668792876 | |
| 4/1/14 | 207.889999 | 31.071125 | 4114.560059 | 4/1/14 | 99.7313513993 | 97.9892743185 | |
| 5/1/14 | 207.770004 | 31.161242 | 4242.620117 | 5/1/14 | 99.9422795706 | 103.1123633186 | |
| 6/2/14 | 240.059998 | 32.984013 | 4408.180176 | 6/2/14 | 115.5412202812 | 103.9023069338 | |
| 7/1/14 | 223.300003 | 30.730558 | 4369.77002 | 7/1/14 | 93.0184140883 | 99.1286618408 | |
| 8/1/14 | 269.700012 | 31.621035 | 4580.27002 | 8/1/14 | 120.7792245305 | 104.8171871526 | |
| 9/2/14 | 242.679993 | 29.276283 | 4493.390137 | 9/2/14 | 89.9814542834 | 98.1031711532 | |
| 10/1/14 | 241.699997 | 28.781319 | 4630.740234 | 10/1/14 | 99.5961776709 | 103.0567142583 | |
| 11/3/14 | 244.520004 | 30.642021 | 4791.629883 | 11/3/14 | 101.1667385333 | 103.4743829468 | |
| 12/1/14 | 222.410004 | 32.284039 | 4736.049805 | 12/1/14 | 90.9577950113 | 98.840059033 | |
| 1/2/15 | 203.600006 | 30.166294 | 4635.240234 | 1/2/15 | 91.5426475151 | 97.8714419157 | |
| 2/2/15 | 203.339996 | 34.50351 | 4963.529785 | 2/2/15 | 99.8722937169 | 107.0824711218 | |
| 3/2/15 | 188.770004 | 34.96394 | 4900.879883 | 3/2/15 | 92.834664952 | 98.7377953853 | |
| 4/1/15 | 226.050003 | 32.688953 | 4941.419922 | 4/1/15 | 119.7488998305 | 100.8271991962 | |
| 5/1/15 | 250.800003 | 33.537411 | 5070.029785 | 5/1/15 | 110.9489049642 | 102.6026904216 | |
| 6/1/15 | 268.26001 | 31.397797 | 4986.870117 | 6/1/15 | 106.9617251958 | 98.3597794978 | |
| 7/1/15 | 266.149994 | 29.683304 | 5128.279785 | 7/1/15 | 99.2134437034 | 102.8356396835 | |
| 8/3/15 | 249.059998 | 27.733307 | 4776.509766 | 8/3/15 | 93.5788103005 | 93.1405844894 | |
| 9/1/15 | 248.399994 | 28.627621 | 4620.160156 | 9/1/15 | 99.7350020054 | 96.726697575 | |
| 10/1/15 | 206.929993 | 33.290813 | 5053.75 | 10/1/15 | 83.3051521732 | 109.384736229 | |
| 11/2/15 | 230.259995 | 34.520985 | 5108.669922 | 11/2/15 | 111.274345329 | 101.0867162404 | |
| 12/1/15 | 240.009995 | 32.774151 | 5007.410156 | 12/1/15 | 104.2343438772 | 98.0178839591 |
Company Performance vs NASDAQ
Tesla 40546 40575 40603 40634 40665 40695 40725 40756 40787 40819 40848 40878 40911 40940 40969 41001 41030 41061 41092 41122 41156 41183 41214 41246 41276 41306 41334 41365 41395 41428 41456 41487 41520 41548 41579 41610 41641 41673 41701 41730 41760 41792 41821 41852 41884 41913 41946 41974 42006 42037 42065 42095 42125 42156 42186 42219 42248 42278 42310 42339 100 99.128626556016584 116.15739289064012 99.459459459459467 109.20289492753624 96.648971355307609 96.704431744058766 87.8239261625843 98.585282942603087 120.41821321927893 111.47429651091943 87.232734439051058 101.78571784963997 114.92948056415548 111.46363962885364 88.963478036333086 89.043160608416528 106.06780000000001 87.631828455358644 104.01167031363967 102.66480014025245 96.072397675123042 120.22751938242158 100.14783855706682 110.74697108789404 92.855248885910356 108.78552059801778 142.49143157802669 181.07056562064955 109.81996604296305 125.07451355183949 125.85642035937161 114.42011538461539 82.711902640324325 79.57984082055971 118.1882418148039 120.59430462115357 134.94845521308739 85.147665006720842 99.73135139934783 99.942279570649291 115.54122028124907 93.018414088298044 120.77922453050751 89.981454283361316 99.596177670896836 101.16673853330664 90.957795011323483 91.542647515082109 99.872293716926521 92.834664951994966 119.74889983050485 110.94890496418175 106.96172519583264 99.213443703368227 93.578810300480413 99.735002005420398 83.305152173232344 111.27434532895384 104.2343438772332 NASDAQ 40546 40575 40603 40634 40665 40695 40725 40756 40787 40819 40848 40878 40911 40940 40969 41001 41030 41061 41092 41122 41156 41183 41214 41246 41276 41306 41334 41365 41395 41428 41456 41487 41520 41548 41579 41610 41641 41673 41701 41730 41760 41792 41821 41852 41884 41913 41946 41974 42006 42037 42065 42095 42125 42156 42186 42219 42248 42278 42310 42339 100 103.04398164593991 99.956871475759939 103.3249781105479 98.669237613501025 97.821040879895946 99.382007814026878 93.581439079164824 93.639751673586844 111.13728661565541 97.613262277359667 99.420297156481169 108.01067861161411 105.43917920754279 104.20238632023948 98.537637510857152 92.810435690228132 103.80958631249032 100.15229624454011 104.33539966160869 101.60647741172126 95.53948197366357 101.10874907957228 100.30794953328621 104.06091957284156 100.57477121164568 103.39631734179993 101.87512298700467 103.81880117131655 98.4762359742900 63 106.55608953206495 98.993483874442589 105.05895358553441 103.93028683132503 103.57628328102717 102.87446098479695 98.259106981633494 104.97675955005531 97.466879287572098 97.989274318469413 103.1123633186466 103.90230693378857 99.128661840794962 104.81718715256324 98.103171153215115 103.05671425832837 103.47438294678481 98.840059032998568 97.871441915716943 107.0824711218193 98.737795385265329 100.82719919622238 102.60269042158122 98.359779497824007 102.83563968345477 93.140584489385475 96.726697575017567 109.38473622904428 101.08671624041554 98.017883959111657
Date
Adjusted Closing
The values shown above are indexed to show better comparison between the two data sets. According to the graph above, we can see that Tesla has been performing erratically compared to NASDAQ throughout the years. It has shown the major growths and declines, whereas the NASDAQ remained relatively stagnant, with minor growth and declines in price. Tesla has shown to outperform and show significant growth compared to the stock index in the first quarter of 2013. However, Tesla has shown to underperform and show significant decline in its fourth quarter in 2014 in comparison to the index.
