FM+CW8+HW8+Portfolio+Statistics.xlsm - DOW-JONES 30 INDUSTRIALS RETURN DATA for Dec 93 April 99 1 Dec-93 Jan-94 Feb-94 Mar-94 Apr-94 May-94 Jun-94

FM+CW8+HW8+Portfolio+Statistics.xlsm - DOW-JONES 30...

This preview shows page 1 - 5 out of 34 pages.

DOW-JONES 30 INDUSTRIALS, RETURN DATA for Dec. 93 - April 99 1 2 3 4 5 6 7 8 Index AA DIS JNJ PG ALD EK JPM S Dec-93 3754.1 15.7954 13.7441 20.5433 25.8483 18.1703 38.7584 56.8164 23.1166 Jan-94 3978.4 18.1096 15.2573 19.3988 27.1296 18.0841 38.4493 58.7615 23.991 Feb-94 3832 17.2228 15.4995 18.4815 26.2177 17.631 37.8293 55.7927 20.1182 Mar-94 3636 16.3931 13.562 17.3876 24.3938 16.8519 39.0389 51.9298 19.0158 Apr-94 3681.7 15.5634 13.7482 19.0572 26.0828 15.9285 36.5096 50.8953 20.7245 May-94 3758.4 16.2599 14.0312 20.5245 25.8535 16.2939 41.5923 54.7228 22.5034 Jun-94 3625 16.8354 13.4651 19.8867 24.4777 16.0619 42.7014 51.8464 21.3366 Jul-94 3764.5 18.0153 13.732 21.8 25.7313 17.7435 42.9232 52.6826 21.0032 Aug-94 3913.4 19.4385 13.3674 23.3911 28.0968 17.4192 44.5038 55.0868 21.2385 Sep-94 3843.2 19.6121 12.5573 24.1495 27.5198 15.9045 46.2929 51.3587 21.5187 Oct-94 3908.1 19.8209 12.8253 25.4911 29.1826 16.1375 43.0502 52.4155 22.1912 Nov-94 3739.2 18.9781 14.1241 25.0445 29.0086 15.2823 41.0561 49.6679 21.3663 Dec-94 3834.4 20.1406 14.9358 25.6897 28.7765 15.9264 43.0864 48.0786 20.8011 Jan-95 3843.9 18.3827 16.5456 27.2733 30.3982 16.7461 44.2143 53.9679 20.0097 Feb-95 4011.1 18.2366 17.3587 26.7622 31.04 17.8333 46.3827 55.2529 22.4588 Mar-95 4157.7 19.4056 17.3993 28.0591 30.9233 18.4807 48.429 52.9051 24.3399 Apr-95 4321.3 20.9838 18.039 30.6527 32.7841 18.6573 52.2942 56.9164 24.7389 May-95 4465.1 21.8532 18.0797 31.3388 33.7225 19.1005 55.2699 61.4697 25.9474 Jun-95 4556.1 23.5568 18.0797 31.9904 33.7225 21.0519 55.4988 61.4473 27.3252 Jul-95 4708.5 26.7878 19.129 34.0047 32.502 22.1163 52.7524 64.1856 30.3641 Aug-95 4610.6 26.9548 18.3541 32.8557 32.7379 21.0826 53.2332 63.857 30.3351 Sep-95 4789.1 24.9494 18.7211 35.2961 36.3362 20.9639 54.6159 68.452 34.5516 Oct-95 4755.5 24.0647 18.8331 38.8078 38.4158 20.1918 57.7269 68.2309 31.8577 Nov-95 5074.5 27.726 19.6501 41.4161 41.0243 22.6059 63.2775 69.4473 37.1143 Dec-95 5117.1 25.06 19.2708 40.8783 39.3644 22.6655 62.1185 71.7194 36.7609 Jan-96 5395.3 26.4098 21.0301 45.8984 40.019 23.7988 68.0291 72.6131 39.1173 Feb-96 5485.6 27.0641 21.4393 44.8547 39.0662 26.6518 66.6572 73.1717 42.983 Mar-96 5587.1 29.8002 20.9074 44.2551 40.3763 28.3288 66.191 74.8961 46.1801 Apr-96 5569.1 29.6812 20.3288 44.375 40.4467 27.7898 71.3185 75.9112 47.3642 May-96 5643.2 29.4305 19.9189 46.9028 42.0622 26.3332 69.7105 78.3927 48.413 Jun-96 5654.6 27.4008 20.6157 47.6855 43.3785 27.4755 72.8738 77.0895 46.2719 Jul-96 5528.9 27.8072 18.2735 45.9997 42.9491 28.2571 69.9448 77.4312 39.0159 Aug-96 5616.2 29.7848 18.7252 47.615 42.7686 29.8078 68.323 79.7085 42.0817 Sep-96 5882.2 28.2866 20.7784 49.5486 46.9191 31.799 73.9773 81.6862 42.799 Oct-96 6029.4 28.2627 21.6782 47.615 47.8624 31.6179 75.0375 79.3884 46.266 Nov-96 6521.7 30.6732 24.3109 51.6752 52.5762 35.4694 76.8253 86.6264 47.8049 Dec-96 6448.3 30.7334 22.9534 48.2787 52.0323 32.443 75.9967 90.551 44.2015 Jan-97 6813.1 33.2644 24.0202 56.0421 56.1255 34.0773 82.1521 95.5365 46.1233 Feb-97 6877.7 34.4627 24.4734 55.9742 58.3098 35.1086 85.4084 97.3916 52.3483 Mar-97 6583.5 32.8908 24.0202 51.4719 55.7007 34.6226 72.3235 91.8891 48.3679 Apr-97 7009 33.9192 26.9937 59.503 61.2664 35.1086 79.1039 95.2794 46.3174 May-97 7331 35.7396 27.0349 58.6167 67.1738 37.422 79.2844 100.774 47.6131 Jun-97 7672.8 36.5891 26.4984 62.8908 68.8182 40.957 73.4247 98.4039 52.0957 Jul-97 8222.6 42.9603 26.7293 60.6927 74.3627 44.9796 64.0972 109.246 61.1822 Aug-97 7622.4 40.0402 25.4063 55.5878 65.075 40.3795 62.9529 101.35 55.2243 Sep-97 7945.3 39.9185 26.6673 56.5684 67.5191 41.5717 62.5316 107.98 55.4067 Oct-97 7442.1 35.5372 27.2878 56.262 66.7107 35.2137 57.6567 104.892 40.7492 Nov-97 7823.1 32.8507 31.4493 61.9439 74.7429 36.4466 58.8035 108.515 44.8024
Image of page 1

Subscribe to view the full document.

Dec-97 7908.3 34.3772 32.795 64.8351 78.2992 38.1033 58.7429 108.102 44.2523 Jan-98 7906.5 37.3081 35.4513 65.8808 77.1297 38.226 63.2895 96.9092 44.9858 Feb-98 8545.7 36.018 37.1305 74.4217 83.5264 41.9341 64.0829 114.447 52.0514 Mar-98 8799.8 33.7783 35.4098 72.5087 83.0343 41.3799 63.3506 129.559 56.4095 Apr-98 9063.4 38.0428 41.3787 70.5958 81.1268 43.1656 70.4912 126.605 58.2509 May-98 8900 34.165 37.6207 68.4261 82.7925 42.2658 70.1363 119.792 60.9295 Jun-98 8952 32.4722 34.9009 73.3181 89.8872 43.8724 71.7946 113.822 60.1902 Jul-98 8883.3 34.1342 34.3669 76.5381 78.6044 43.0073 82.4194 122.634 50.025 Aug-98 7539.1 29.5993 27.3813 68.5905 75.7573 34.057 77.1713 90.9121 44.9177 Sep-98 7842.6 35.099 25.323 77.7856 70.4345 35.1116 75.9366 83.1117 43.7421 Oct-98 8592.1 39.1774 26.9375 81.0163 88.1321 38.6476 76.554 92.5646 44.4846 Nov-98 9116.55 36.8237 32.1875 81.0076 87.0763 43.8271 72.1615 104.964 47.1769 Dec-98 9181.43 36.9786 30 83.6248 90.7407 44.1383 71.5405 104.206 42.2666 Jan-99 9358.83 41.4421 33 84.8711 90.6047 38.8467 64.9577 104.64 39.9046 Feb-99 9306.58 40.3666 35.1875 85.375 89.2338 41.375 66.1875 110.529 40.625 Mar-99 9786.16 41.0518 31.125 93.5 97.6462 49.1875 63.875 123.375 45.1875 Apr-99 10878.4 62.0449 31.75 97.5 93.8125 58.75 74.75 138 46
Image of page 2
9 10 11 12 13 14 15 16 17 18 AXP GE KO T BA GM MCD UK C GT 24.3631 23.3923 20.9735 20.9341 21.625 45.0597 13.7669 20.0961 12.8788 40.952 25.9542 24.0336 19.211 22.6287 21.625 50.2944 14.6726 22.9028 13.9554 43.3017 23.2693 23.5039 20.0335 20.9341 23.375 47.9845 14.6684 21.6049 12.299 40.631 22.076 22.4581 19.1848 20.5637 22.25 44.3805 13.7611 20.3606 11.6779 36.3659 23.7819 21.3913 19.716 20.5637 22.5 46.7489 14.5172 23.8672 11.5122 35.019 25.2682 22.3458 19.0077 21.9179 23.1875 44.4373 15.0011 24.4934 10.891 34.9786 23.5532 21.1025 19.2745 21.9486 23.125 41.5437 13.9999 24.1516 10.684 32.4963 24.4529 22.7998 21.0537 22.0496 22.3125 42.4738 13.1514 25.7465 10.9739 32.1578 25.9523 22.5169 21.8247 22.0496 22.75 41.7106 13.7276 31.5076 12.2576 31.7785 28.0285 21.9434 23.1681 21.9313 21.625 38.9091 12.8165 31.1639 10.891 30.3031 28.7025 22.2854 24.0019 22.3374 21.9375 32.7874 14.0313 30.2473 11.5122 31.892 27.5405 20.9745 24.4514 19.9514 22.4375 31.8097 13.817 26.3993 10.8496 30.9319 27.6359 23.4447 24.6307 20.5399 23.5 35.1472 14.243 27.091 10.7254 30.7037 29.5096 23.6745 25.109 20.3866 22.25 32.4355 15.8865 23.5173 12.2162 32.8723 31.5003 25.1686 26.3046 21.1019 23.0625 35.7471 16.2202 26.5746 12.8788 33.8581 32.6713 25.0111 27.0696 21.2865 26.875 36.9002 16.647 28.4313 12.7959 33.7433 32.7656 25.9374 27.9099 20.8752 27.5 37.8437 17.0739 29.8239 13.707 34.8911 33.4728 26.8638 29.5905 20.8752 29.4375 40.5359 18.5111 27.2011 13.9554 38.9218 33.237 26.3037 30.723 21.9376 31.3125 39.5859 19.122 31.2871 14.4938 37.9979 36.5355 27.5285 31.6266 21.8341 33.5 41.1693 18.8776 32.4545 15.6947 40.0768 38.3148 27.4702 30.964 23.4381 32 40.0453 17.8725 33.3309 15.9018 37.1778 42.1107 29.9358 33.3667 27.3558 34.125 39.8329 18.7294 37.3212 17.5996 36.5969 38.7554 29.701 34.757 26.6277 32.75 37.1774 20.0759 35.5608 16.73 35.3189 40.5441 31.5206 36.7381 27.4078 36.4375 41.4904 21.8847 37.3939 19.7115 39.6298 39.4709 34.0269 36.0106 27.078 39.1875 45.2331 22.1299 35.3885 20.7468 42.4355 44.1223 36.2717 36.5562 27.9667 38.75 45.0192 24.6432 39.7531 21.7821 44.7735 44.0024 35.6809 39.163 26.6076 40.5625 44.1771 24.5535 42.6474 22.1548 44.5349 47.3595 37.0249 40.2569 25.6972 43.3125 45.9011 23.5714 47.0306 21.8649 47.9425 46.7295 36.7277 39.6488 25.7498 41.0625 46.7631 23.51 43.1213 20.3741 49.0001 44.0799 39.3427 44.7569 26.2227 42.625 47.8778 23.6691 41.0433 20.6226 47.7035 42.9959 41.2444 47.803 26.2043 43.5625 45.4894 22.9928 37.8312 22.6724 45.342 42.3635 39.3134 45.7299 22.0834 44.25 42.3409 22.8084 39.9726 20.9953 41.7996 42.3635 39.7316 48.7785 22.1891 45.25 43.4287 22.8445 41.3415 21.5543 43.3386 44.7843 43.7155 49.7509 22.2208 47.25 42.0066 23.3371 43.6117 24.4117 43.8135 45.7277 46.4777 49.3842 20.8044 47.6875 46.9292 21.9208 40.7441 26.9584 43.5761 50.8356 49.9605 50.1173 23.3306 49.6875 50.7992 23.066 44.272 29.8158 46.3434 55.187 47.739 51.5878 25.9819 53.25 49.1463 22.3876 39.2329 30.0643 49.0906 60.6812 49.972 56.7343 24.8377 53.5625 52.0114 22.4493 43.5522 34.7023 52.0766 64.0999 49.6702 59.7977 25.1531 50.875 51.4604 21.373 45.5385 35.5305 50.6647 58.4835 48.1623 54.7748 22.4413 49.3125 49.2375 23.3497 42.6471 31.8035 50.1845 64.4607 53.8641 62.5121 21.3272 49.3125 51.4604 26.4382 48.0684 36.7728 50.5447 68.1372 58.5954 67.3018 23.3963 52.6875 51.4537 24.8726 45.2292 36.4415 56.3523 73.0392 63.0841 66.9477 22.5228 53.0625 49.9964 23.9136 45.5316 41.7835 61.1187 82.3565 68.3252 68.0552 23.647 58.6875 55.4893 26.605 53.5737 47.6639 62.4461 76.4564 60.9568 56.4255 25.0521 54.5 56.7362 23.4582 49.8163 42.0734 59.7486 80.5127 66.5744 60.2022 28.6348 54.4375 60.5224 23.6132 47.2679 45.262 66.6566 76.9136 63.2121 55.8845 31.6277 48 58.0359 22.2187 44.3554 46.3801 60.7181 77.7764 72.2599 61.8176 36.1575 53.125 55.5262 24.0869 43.0558 50.5626 59.1319
Image of page 3

Subscribe to view the full document.

88.2357 72.0761 65.9594 39.8849 48.9375 58.6689 23.7144 41.8971 53.5442 61.9941 82.7364 76.1281 64.043 40.7388 47.625 55.9528 23.404 42.7509 49.2582 61.0198 89.039 76.3737 67.8757 39.6817 54.25 67.1049 27.1407 45.526 55.2834 67.7762 90.7691 84.996 76.7505 42.9822 52.125 65.9489 29.8454 49.1411 59.6316 74.1378 101.244 84.0098 75.2019 39.305 50.0625 65.5839 30.7781 47.548 60.8118 68.5102 101.677 82.2224 77.6797 39.7953 47.75 70.4579 32.6882 49.164 60.8739 70.65 112.927 89.6187 84.8982 37.5561 44.5625 65.4952 34.3693 52.5483 60.2527 63.3393 109.576 88.493 79.9334 39.8571 38.8125 70.8867 33.2797 47.2565 66.8371 59.8989 77.4356 79.1552 64.6666 32.9541 30.9375 57.3827 28.1201 39.5737 44.1025 48.4309 77.0633 79.0076 57.3608 38.6328 34.3125 54.1742 29.7724 42.6654 37.2697 50.9018 87.7343 86.8898 67.2527 41.3185 37.5625 62.3806 33.4511 38.0897 46.7114 53.2492 99.6542 89.7447 69.8842 41.1119 40.625 69.5008 34.9912 44.5074 49.9414 56.4017 102.082 101.638 66.8295 50.2994 32.625 71.1793 38.3624 42.2696 49.3824 50.1279 102.687 104.503 65.1463 60.2596 34.6875 89.2694 39.3612 39.348 55.9046 48.6992 108.302 99.957 63.7125 54.5325 35.625 82.5625 42.4514 44 58.5845 46.0625 117.75 110.625 61.375 53.2083 34 87 45.3125 45.1875 63.6951 49.8125 135.375 107.625 68.0625 53.125
Image of page 4
Image of page 5

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Ask Expert Tutors You can ask 0 bonus questions You can ask 0 questions (0 expire soon) You can ask 0 questions (will expire )
Answers in as fast as 15 minutes