Financial Management Data Processing Project

UBHC
FM_ASGN_Data.xlsx
Home>Business & Finance homework help>Management homework help>Financial Management Data Processing Project

Sheet1

Date 1M Treasury Rate S&P500 APPLE PFIZER COCA-COLA WALMART BOEING P&G AT&T NIKE GENERAL MOTORS BANK OF AMERICA
1/31/16 0.14 1940.24 22.473866 23.497143 36.131569 58.721012 107.736595 69.451813 26.249481 58.491337 24.715639 12.75172
2/29/16 0.22 1932.22998 22.323797 22.865208 36.308357 58.70332 105.987793 68.856514 27.275852 58.095161 24.548864 11.290775
3/31/16 0.23 2059.73999 25.300169 23.071732 39.052738 60.605835 114.897522 70.588875 28.914612 57.981976 26.208254 12.192595
4/30/16 0.18 2065.30005 21.760138 25.461414 38.008331 59.610382 122.011871 68.710724 28.656252 55.738865 26.849333 13.180448
5/31/16 0.16 2096.94995 23.18079 27.010426 37.838657 63.09586 114.182487 70.069038 29.258209 52.220917 26.410284 13.388659
6/30/16 0.27 2098.86011 22.327021 27.652849 38.457996 65.569283 118.508415 73.207611 32.292389 52.202003 23.894218 12.012675
7/31/16 0.20 2173.6001 24.337851 28.972271 37.299572 65.524376 121.966843 74.003075 32.352177 52.639034 26.968822 13.161576
8/31/16 0.19 2170.94995 24.779259 27.330851 37.12859 64.15049 118.12516 76.081764 30.893173 54.668716 27.293745 14.660305
9/30/16 0.26 2168.27002 26.545429 26.821577 36.179649 65.204453 121.211037 78.207993 30.689127 49.935944 27.16548 14.281386
10/31/16 0.20 2126.1499 26.660484 25.111074 36.544189 63.305809 131.046677 75.637367 27.80234 47.725746 27.343615 15.057054
11/30/16 0.20 2198.81006 25.951357 25.451591 34.777306 63.676479 138.526886 72.410286 29.548306 47.621132 29.878952 19.273027
12/31/16 0.38 2238.83008 27.335484 25.977364 36.03611 62.492111 144.337631 73.832848 32.531433 48.343967 30.147202 20.242151
1/31/17 0.44 2278.87012 28.640661 25.377516 36.131714 60.772194 151.513748 76.923828 32.248421 50.494244 32.022434 20.736752
2/28/17 0.40 2363.63989 32.331974 27.28903 36.470692 64.587532 167.098999 80.604729 32.336926 54.560513 32.223614 22.605261
3/31/17 0.40 2362.71997 34.053204 27.639759 36.887897 65.634697 165.385056 79.524918 32.151203 53.195545 30.929071 21.60689
4/30/17 0.74 2384.19995 34.050831 27.405453 37.836048 68.960861 172.837936 77.29451 30.665529 53.054893 30.609301 21.443069
5/31/17 0.68 2411.80005 36.210274 26.37937 39.870338 72.097954 175.456284 78.564178 30.170485 50.737747 29.981922 20.588655
6/30/17 0.86 2423.40991 34.279442 27.40152 39.326683 69.884048 186.335297 77.725853 29.544064 56.492306 30.865555 22.361502
7/31/17 0.84 2470.30005 35.400517 27.050743 40.525558 73.863983 228.464523 80.99897 30.538513 56.732891 32.148197 22.232462
8/31/17 1.00 2471.6499 39.035057 27.670723 40.269184 72.091026 225.826126 82.93779 29.714594 50.737747 32.648556 22.020456
9/30/17 0.95 2519.36011 36.827488 29.407255 39.791782 72.609543 240.964951 81.778275 31.071024 49.986603 36.079601 23.476458
10/31/17 0.96 2575.26001 40.392677 28.880068 40.972775 81.130486 244.538559 77.607552 26.692371 53.013752 38.794048 25.375698
11/30/17 0.99 2584.84009 41.064133 29.868546 40.785641 90.348389 262.377899 81.49453 29.220287 58.248611 38.893333 26.098337
12/31/17 1.14 2673.61011 40.583443 30.108227 41.218853 91.760826 281.04715 83.206108 31.228283 60.302067 36.99786 27.465597
1/31/18 1.28 2823.81006 40.151787 30.789852 42.755119 99.577271 337.712097 78.18911 30.079708 65.986725 38.627808 29.773008
2/28/18 1.43 2713.83008 42.71537 30.183033 38.82909 84.0802 345.183502 71.649422 29.542206 64.835678 35.840702 29.866045
3/31/18 1.50 2640.87012 40.399765 29.774715 39.017757 83.108704 314.009766 72.342918 29.013214 64.264999 33.09914 27.902889
4/30/18 1.63 2648.05005 39.792973 30.714348 39.162792 83.124962 319.449463 66.010193 26.6124 66.351257 33.803837 27.942219
5/31/18 1.65 2705.27002 44.996445 30.143858 38.972454 77.562004 337.262634 67.385384 26.677513 69.659584 39.287521 27.12039
6/30/18 1.76 2718.37012 44.744537 30.734619 39.751904 80.991501 322.91983 71.888802 26.504177 77.30468 36.251255 26.434141
7/31/18 1.77 2816.29004 45.996632 33.826714 42.638855 84.37677 342.929688 74.485863 26.388613 74.825699 35.184685 28.956591
8/31/18 1.94 2901.52002 55.022411 35.173679 40.755177 90.646164 329.926666 77.085533 26.773485 79.972328 33.458393 29.003477
9/30/18 1.95 2913.97998 54.756927 37.651814 42.236511 89.318001 359.712952 77.345734 28.148205 82.627045 31.249489 27.625036
10/31/18 2.12 2711.73999 53.088074 36.788902 44.15427 95.376511 343.231323 82.410423 25.7173 73.186195 34.329227 25.911776
11/30/18 2.20 2760.16992 43.317505 39.497234 46.478184 92.875122 335.396851 88.604332 26.576284 73.264229 35.605202 26.759796
12/31/18 2.31 2506.8501 38.39592 37.580757 44.010803 88.595161 313.372223 86.17617 24.279356 72.523048 31.383244 23.216949
1/31/19 2.44 2704.1001 40.513611 36.547607 44.735794 91.641495 374.705688 90.441856 25.572439 80.094231 36.994022 26.975672
2/28/19 2.42 2784.48999 42.146912 37.64843 42.142555 94.663368 427.507721 93.12262 26.912998 83.860291 37.430138 27.553654
3/31/19 2.44 2834.3999 46.434544 36.884171 43.555359 93.267181 372.486572 98.319733 27.12055 82.373421 35.17371 26.27533
4/30/19 2.43 2945.83008 49.055115 35.268803 45.998295 98.87426 368.843903 100.615921 26.774626 86.135521 37.29414 29.122856
5/31/19 2.43 2752.06006 42.797031 36.059124 46.063927 97.528252 333.608948 97.928993 26.869064 75.651749 31.922632 25.332502
6/30/19 2.35 2941.76001 48.56918 37.956062 47.742214 106.793579 357.526581 104.342773 29.443504 82.559532 36.891991 27.618141
7/31/19 2.18 2980.37988 52.279598 34.030777 49.730709 106.687256 335.10321 112.326668 29.917973 84.605087 39.03896 29.375967
8/31/19 2.01 2926.45996 51.224396 31.148146 52.007946 110.437454 357.605164 115.151611 31.44944 83.100426 35.89378 26.340708
9/30/19 2.10 2976.73999 55.170628 31.775618 51.440994 115.274223 376.025269 119.126312 33.750618 92.603004 36.271202 27.930149
10/31/19 1.91 3037.56006 61.277161 33.933498 51.807579 113.894974 335.939117 119.250816 34.330368 88.294289 36.322464 30.138229
11/30/19 1.59 3140.97998 65.831795 34.066151 50.827202 115.672455 361.902222 117.65107 33.800255 92.179031 35.18861 32.114029
12/31/19 1.62 3230.78003 72.552094 34.984711 53.076775 115.429626 323.833313 120.388504 35.337456 100.150017 35.775085 33.945271
1/31/20 1.48 3225.52002 76.470634 33.252441 56.001514 111.703255 316.387573 120.118607 34.017273 95.197395 32.987583 31.81452
2/29/20 1.56 2954.21997 67.539055 30.146311 51.293171 105.059036 273.482849 109.788452 32.27338 88.356628 30.132414 27.618452
3/31/20 1.45 2584.59009 62.976532 29.442715 42.432648 110.854446 149.139999 106.656624 26.711216 82.019585 20.52956 20.573322
4/30/20 0.05 2912.42993 72.761436 34.602402 44.391228 119.116165 141.020004 114.287422 27.920778 86.420921 22.290001 23.454805
5/31/20 0.10 3044.31006 78.739868 34.449062 45.15543 121.575905 145.850006 113.146255 28.7756 97.721664 25.879999 23.523075
6/30/20 0.13 3100.29004 90.5896 29.790798 43.220745 117.897949 183.300003 116.708923 28.188156 97.438736 25.299999 23.162231
7/31/20 0.13 3271.12 105.548805 35.056572 46.112293 127.366791 158 127.982544 27.582058 97.001472 24.889999 24.433485
8/31/20 0.09 3500.31 128.176331 34.764442 48.347626 136.668304 171.820007 135.872055 28.279295 111.192451 29.629999 25.278049
9/30/20 0.08 3363 115.242294 33.761711 48.191441 138.277802 165.259995 136.520325 27.046047 125.033722 29.59 23.657663
10/30/20 0.08 3269.96 108.326363 32.639389 47.292465 137.131332 144.389999 134.663925 25.632559 119.595741 34.529999 23.436794
11/30/20 0.08 3621.63 118.466408 37.145927 50.775928 151.007523 210.710007 137.159836 27.775223 134.156784 43.84 27.84726
12/31/20 0.08 3756.07 132.267349 36.058567 54.387314 142.468323 214.059998 137.426514 27.784883 140.89949 41.639999 29.973383