/////////////////////

////////////////////////////

i want to know the calculations and formulas

Instructions 1. Please use the excel FINANCE 251 A1S12021Data.xls file to do the calculations. 2. This excel file can be found through the link given in the assignment. 3. You can also download the data from Yahoo.com as specified but data may vary depending on what date you download. To avoid such issues we are providing you with the data set. 4. The data is provided in separate sheets for Auckland International Airports Limited (AIA.NZ), Briscoes Group Limited (BGP.NZ) and the S&P/NZX 50 Index (^N250) 5. Start Date is 1 July 2010 and the End Date is 1 August 2020. 6. The data is monthly. In any blank column (J onwards) calculate the return for each period of one month using the data from column H Adjusted Close (this includes an adjustment for accrued dividends so you don't need to calculate the Cash Flow part of the usual formula) For instance on the row for 1 August 2010 (i.e. for the month 1 July 2010 to 1 August 2010) the return calculated as: PriceAugust- PriceJuly PriceJuly Date Open High Low Close Adj Close Volume 2010-07-01 2972.09 3047.31 2929.09 3034.62 3034.62 517329800 2010-08-01 3034.62 3069.33 2987.46 3036.10 3036.10 644828200 2010-09-01 3036.10 3252.68 3034.00 3178.09 3178.09 767437700 2010-10-01 3178.09 3309.62 3178.09 3304.89 3304.89 633354000 2010-11-01 3304.89 3344.11 3246.64 3264.50 3264.50 783159300 2010-12-01 3264.50 3338.87 3253.29 3309.03 3309.03 756935500 2011-01-01 3309.03 3377.01 3309.03 3338.74 3338.74 408749600 2011-02-01 3338.74 3413.43 3333.11 3370.52 3370.52 763824800 2011-03-01 3370.52 3444.14 3304.76 3439.85 3439.85 909177000 2011-04-01 3439.85 3519.94 3426.39 3519.33 3519.33 578633600 2011-05-01 3519.33 3584.46 3484.97 3547.64 3547.64 1054188600 2011-06-01 3547.64 3554.50 3414.92 3448.35 3448.35 794012400 2011-07-01 3448.35 3491.58 3369.63 3395.63 3395.63 863799400 2011-08-01 3395.63 3507.84 3055.09 3323.07 3323.07 855707800 2011-09-01 3323.07 3343.95 3247.08 3343.35 3343.35 729560400 2011-10-01 3343.35 3397.27 3257.89 3332.56 3332.56 631748000 2011-11-01 3332.56 3365.17 3211.60 3270.21 3270.21 703188200 2011-12-01 3270.21 3303.99 3198.27 3274.71 3274.71 601153400 2012-01-01 3274.71 3307.95 3209.49 3296.20 3296.20 480122000 2012-02-01 3296.20 3353.77 3279.02 3322.53 3322.53 718206800 2012-03-01 3322.53 3549.62 3318.68 3509.55 3509.55 1016087200 2012-04-01 3509.55 3562.32 3452.64 3555.87 3555.87 557634400 2012-05-01 3555.87 3616.12 3460.02 3488.29 3488.29 875327600 2012-06-01 3488.29 3495.63 3376.20 3399.83 3399.83 744419400 2012-07-01 3399.83 3545.72 3399.83 3545.01 3545.01 770878600 2012-08-01 3545.01 3692.22 3526.18 3666.68 3666.68 1008576600 2012-09-01 3666.68 3843.08 3662.30 3834.15 3834.15 766982200 2012-10-01 3830.03 4004.26 3830.03 3957.88 3957.88 517570000 2012-11-01 3957.88 4052.03 3900.99 4050.09 4050.09 304638900 2012-12-01 4023.36 4089.28 3974.73 4066.51 4066.51 192945000 2013-01-01 4082.37 4207.16 4072.35 4199.82 4199.82 125501800 2013-02-01 4252.65 4253.73 4166.37 4214.60 4214.60 307827000 2013-03-01 4320.01 4423.24 4241.11 4422.75 4422.75 1236954200 2013-04-01 4430.17 4616.01 4391.55 4614.37 4614.37 734659400 2013-05-01 4614.37 4680.11 4466.69 4511.35 4511.35 1064676800 4316.99 4440.17 4440.17 4511.35 4440.17 4518.32 4608.46 4407.83 4537.98 4537.98 4540.97 4736.39 4590.85 4783.97 4494.61 4530.52 2013-06-01 2013-07-01 2013-08-01 2013-09-01 2013-10-01 2013-11-01 2013-12-01 2014-01-01 4537.98 4540.97 4782.68 4540.97 4782.68 4909.73 4909.73 4983.60 4794.95 4909.73 4794.95 4737.01 4876.41 4799.90 4951.17 2014-02-01 2014-03-01 4990.04 5160.39 4737.01 4874.58 4990.04 5139.98 5232.68 4978.23 5232.68 5232.91 5178.44 5129.00 5223.21 5177.91 5136.56 5114.36 5212.00 5256.09 5396.20 5429.09 5577.20 5741.89 5884.57 5816.91 5196.44 5196.60 5248.15 5289.48 5405.31 5537.99 5599.03 5141.48 5167.99 5223.30 5255.04 5820.00 5878.47 5927.10 719784200 717650400 949183600 847818500 895557200 1464603700 894659900 640540800 752586200 992838700 801659300 910159700 827390700 798375200 721732800 827570600 845591000 980400700 805633500 581708000 813148900 1008754900 714697700 812986800 966490300 900951600 1532862700 926746200 1164370800 1002010100 953601600 4708.75 4909.73 4786.04 4794.95 4672.24 4737.01 4736.38 4874.58 4780.05 4990.04 4969.59 5139.98 5016.38 5232.68 5094.36 5178.44 5091.02 5141.48 5080.70 5167.99 5038.23 5223.30 5142.34 5255.04 5097.08 5387.83 5387.83 5424.45 5401.44 5568.28 5541.62 5744.00 5717.05 5878.47 5811.50 5833.99 5734.28 5791.34 5704.76 5844.95 5684.05 5726.96 5686.99 5920.96 5461.73 5656.24 5542.03 5593.36 5573.71 5986.37 5945.14 6100.15 6012.86 6324.26 6035.88 6170.22 5910.03 6230.87 6233.53 6752.42 6695.20 6820.58 6783.92 7039.42 2014-04-01 2014-05-01 2014-06-01 2014-07-01 2014-08-01 2014-09-01 2014-10-01 2014-11-01 2014-12-01 2015-01-01 2015-02-01 2015-03-01 2015-04-01 2015-05-01 2015-06-01 2015-07-01 2015-08-01 2015-09-01 2015-10-01 2015-11-01 2015-12-01 2016-01-01 2016-02-01 2016-03-01 2016-04-01 2016-05-01 5387.83 5424.45 5568.28 5744.00 5878.47 5833.99 5791.34 5884.72 5844.95 5898.59 5844.95 5778.82 5850.18 5726.96 5920.95 5937.57 5963.05 5726.96 5920.96 5656.24 5593.36 5986.37 5656.24 5725.89 5593.36 6014.48 5986.37 6100.15 6324.26 6107.47 6324.26 6170.22 6233.53 6753.32 6819.67 6127.23 6333.33 6324.26 6254.72 6758.01 6917.57 7046.83 6170.22 6230.87 6752.42 6820.58 7039.42 534614300 817777500 986542200 922883100 938581500 6587.42 6897.53 6897.53 977416900 724856900 848945700 801154200 682417900 859040700 730225100 502450500 643494300 949770800 706381200 740188000 778998000 700165600 789859400 730212900 752025200 986135600 2016-06-01 7043.88 7049.02 2016-07-01 6909.04 7357.72 2016-08-01 7348.13 7481.68 2016-09-01 7405.56 7585.29 2016-10-01 7352.22 7372.49 2016-11-01 6960.68 6960.68 2016-12-01 6901.29 6973.45 2017-01-01 6881.22 7135.73 2017-02-01 7050.75 7187.44 2017-03-01 7168.73 7212.33 2017-04-01 7188.94 7386.89 2017-05-01 7378.75 7501.50 2017-06-01 7424.52 7688.63 2017-07-01 7611.44 7732.75 2017-08-01 7693.99 7890.58 2017-09-01 7817.45 7955.76 2017-10-01 7931.60 8167.60 2017-11-01 8146.34 8190.21 2017-12-01 8188.91 8423.39 2018-01-01 8398.08 8468.05 2018-02-01 8442.01 8442.01 2018-03-01 8380.10 8634.71 2018-04-01 8271.78 8492.59 2018-05-01 8443.58 8765.66 2018-06-01 8664.40 9049.60 2018-07-01 8943.13 9084.04 2018-08-01 8922.09 9369.78 2018-09-01 9313.20 9381.23 2018-10-01 9352.69 9352.69 2018-11-01 8752.31 8959.34 2018-12-01 8828.63 8917.22 2019-01-01 8811.27 9153.59 2019-02-01 8985.34 9367.38 2019-03-01 9326.02 9844.95 2019-04-01 9844.95 10083.81 2019-05-01 10013.83 10265.46 6897.52 7348.13 7348.13 7277.40 7398.83 7398.83 7183.38 7361.09 7361.09 6892.27 6960.68 6960.68 6642.03 6896.95 6896.95 6748.62 6881.22 6881.22 6881.22 7050.75 7050.75 7030.26 7167.46 7167.46 7019.87 7196.78 7196.78 7182.46 7378.75 7378.75 7349.37 7418.90 7418.90 7400.31 7611.44 7611.44 7583.95 7693.99 7693.99 7687.06 7817.10 7817.10 7719.19 7930.40 7930.40 7905.54 8146.34 8146.34 7959.69 8186.82 8186.82 8130.86 8398.08 8398.08 8211.37 8442.01 8442.01 8031.08 8373.82 8373.82 8278.61 8319.07 8319.07 8250.83 8443.58 8443.58 8419.96 8658.79 8658.79 8588.34 8943.13 8943.13 8857.52 8922.09 8922.09 8832.68 9313.20 9313.20 9043.24 9351.06 9351.06 8490.76 8752.31 8752.31 8652.37 8823.54 8823.54 8657.06 8811.27 8811.27 8664.50 8985.34 8985.34 8972.16 9325.03 9325.03 9302.67 9844.95 9844.95 9705.70 10013.83 10013.83 9938.51 10117.99 10117.99 561139300 514644000 611871400 736044500 467637500 835861100 603563300 474596100 541538500 616114900 540256700 606284400 471321500 457869300 598402100 790988600 497521700 665872800 2019-06-01 10122.87 10501.10 9927.05 10501.10 10501.10 505796600 2019-07-01 10501.10 10922.98 10464.53 10857.75 10857.75 513425600 2019-08-01 10857.75 10927.10 10424.08 10757.20 10757.20 656060000 2019-09-01 10757.20 11222.31 10685.50 10925.62 10925.62 575635200 2019-10-01 10927.31 11179.68 10733.95 10787.82 10787.82 565581000 2019-11-01 10787.82 11337.45 10723.28 11316.58 11316.58 679989600 2019-12-01 11323.68 11642.78 11173.86 11491.90 11491.90 461875900 2020-01-01 11491.90 11910.73 11489.05 11717.44 11717.44 758222800 2020-02-01 11717.44 12107.45 11098.79 11261.16 11261.16 619303800 2020-03-01 11261.16 11720.08 8209.04 9796.75 9796.75 1424757500 2020-04-01 9796.75 10889.74 9694.64 10532.07 10532.07 1148400400 2020-05-01 10532.07 11109.34 10279.28 10882.41 10882.41 1090611400 2020-06-01 10883.18 11590.54 10646.09 11451.05 11451.05 1230996600 2020-07-01 11451.05 11815.15 11329.22 11727.63 11727.63 789810700 2020-08-01 11727.63 12114.76 11338.85 11937.56 11937.56 776366800 2.3 1.56 458208 2.4 1.62 548253 2.35 1.59 302434 2.38 1.62 1.64 2.41 2.4 367237 430290 314166 1.63 2.45 2.5 2.28 2.3 2.5 2.3 2.42 2.55 2.35 2.44 2.44 2.3 2.38 2.43 2.3 2.36 2.45 2.3 2.4 2.4 2.33 2.37 2.55 2.37 2.55 2.65 2.45 2.46 2.5 2.37 2.4 2.54 2.38 2.5 2.64 2.5 2.37 1.61 188429 2.55 1.73 177568 2.46 1.67 1.67 2.38 2.5 234630 185410 432298 341086 1.75 2.62 1.83 2.65 2.7 2.59 2.7 1.89 2.7 2.86 2.7 2.85 2.00 2.85 3 2.8 1.99 2.84 2.85 230409 212118 651006 777719 196532 246018 2.83 2.03 2.9 2.66 3.1 2.8 2.85 3.07 2.19 2.97 2013-07-01 2013-08-01 2013-09-01 2013-10-01 2013-11-01 2013-12-01 2014-01-01 2014-02-01 2014-03-01 2014-04-01 2014-05-01 2014-06-01 2014-07-01 2014-08-01 2014-09-01 2014-10-01 2014-11-01 2014-12-01 2015-01-01 2015-02-01 2015-03-01 2015-04-01 2015-05-01 2015-06-01 2015-07-01 2015-08-01 2015-09-01 2015-10-01 2015-11-01 2015-12-01 2016-01-01 2016-02-01 2016-03-01 2016-04-01 2016-05-01 2016-06-01 2.12 2.14 3 500950 2.95 250684 2.10 2.03 2.85 329602 2.83 2.08 253455 2.86 2.10 3.1 3.1 2.85 2.97 3.01 2.91 3 3.07 2.95 2.95 3.08 2.84 2.84 2.92 2.8 2.83 2.96 2.81 2.86 2.95 2.81 2.9 2.9 2.7 2.9 2.98 2.7 2.83 3 2.76 2.84 2.89 2.7 2.88 2.89 2.74 2.9 2.13 2.12 365797 377151 707715 299889 2.89 2.77 2.03 2.84 2.08 260966 2.89 2.17 392519 281903 2.87 2.15 2.87 2.15 159658 2.87 2.94 2.82 2.87 2.96 2.82 2.85 2.14 203337 2.93 2.20 307963 3 661081 2.89 2.97 2.85 2.95 3.23 2.91 3 3.04 2.93 3.03 3.31 3.03 3.18 3.18 3.04 3.03 2.25 2.34 2.54 805510 3.28 349158 412112 3.12 2.41 3.1 3.43 3.1 3.39 2.62 167005 3.3 3.85 3.27 3.82 4 3.7 3.78 3.84 227651 318967 2.92 2.97 2.99 2.92 3.75 3.78 3.6 3.78 580030 3.78 3.85 3.6 3.7 315485 4.03 3.98 3.75 4.04 3.75 4.03 4.08 3.96 3.98 4.55 3.98 4.37 4.54 4.25 4.36 4.5 4 4.37 4.35 4.06 4.16 3.93 4.02 3.84 3.25 3.24 3.27 2016-07-01 2016-08-01 2016-09-01 2016-10-01 2016-11-01 2016-12-01 2017-01-01 2017-02-01 2017-03-01 2017-04-01 2017-05-01 2017-06-01 2017-07-01 2017-08-01 2017-09-01 2017-10-01 2017-11-01 2017-12-01 2018-01-01 2018-02-01 2018-03-01 2018-04-01 2018-05-01 2018-06-01 2018-07-01 2018-08-01 2018-09-01 2018-10-01 2018-11-01 2018-12-01 2019-01-01 2019-02-01 2019-03-01 2019-04-01 2019-05-01 2019-06-01 4.06 4.18 3.85 4.15 4.15 3.9 3.92 4.12 3.9 4.02 4.09 3.84 3.83 3.83 3.25 3.26 3.4 3.12 3.26 3.3 3.15 3.28 3.45 3.23 3.45 3.52 3.35 3.44 3.55 3.4 3.45 3.71 3.44 3.57 3.58 3.35 3.5 3.58 3.4 3.52 3.57 3.45 3.55 3.56 3.46 3.45 3.19 122608 3.15 153754 3.45 214680 3.44 1463748 3.29 281812 3.37 601683 3.18 196595 3.26 290820 3.11 415208 2.63 630131 2.68 1285315 2.71 2107504 2.86 533397 2.82 450274 2.84 350377 2.96 619596 2.99 496060 3.01 602138 3.03 359840 2.98 338116 3.06 458181 3.09 706868 2.85 364177 3.4 3.43 3.57 3.5 3.52 3.55 3.49 3.58 3.5 3.6 3.5 3.6 3.61 3.48 3.61 3.6 3.6 3.24 3.34 3.03 3.35 3.49 3.26 3.49 3.5 3.3 3.47 3.38 2.95 220847 252288 358950 3.24 2.83 2.97 3.4 3.38 3.38 3.21 3.23 3.44 3.2 3.4 3.44 3.25 3.26 3.35 3.24 3.33 3.47 3.26 3.4 3.4 3.29 3.26 3.33 2.85 3.02 290534 651930 664772 773965 328868 3.4 3.08 3.37 3.05 3.43 631659 3.11 3.22 3.55 3.30 3.64 3.65 3.74 475161 728287 389384 370121 3.38 3.47 3.37 3.49 3.31 3.44 3.62 3.43 3.58 3.75 3.55 3.64 3.67 3.56 3.66 3.8 3.61 3.74 3.88 3.72 3.88 4.49 3.85 3.9 4.23 3.75 3.6 3.75 2.35 2.84 3.44 2.64 3.88 3.60 275142 2019-07-01 2019-08-01 2019-09-01 2019-10-01 2019-11-01 2019-12-01 2020-01-01 2020-02-01 2020-03-01 2020-04-01 2020-05-01 2020-06-01 2020-07-01 2020-08-01 3.9 3.75 2.84 3.15 3.62 326953 3.48 333887 2.63 1268603 3.05 896585 2.96 1679147 3.05 774658 3.31 794131 3.43 523644 3.06 3.16 3.19 3 3.06 3.33 3.05 3.15 3.11 3.42 3.5 3.07 3.6 3.13 3.45 3.55 Date Open High Low Close Adj Close Volume 2010-07-01 2.08 2.22 2.07 2.20 1.70 19029448 2010-08-01 2.20 2.24 2.14 2.21 1.70 21136031 2010-09-01 2.21 2.32 2.21 2.28 1.76 29419474 2010-10-01 2.29 2.36 2.27 2.33 1.80 25098595 2010-11-01 2.33 2.41 2.28 2.31 1.79 27741176 2010-12-01 2.29 2.48 2.17 2.42 1.87 20245143 2011-01-01 2.44 2.54 2.43 2.49 1.92 11901304 2011-02-01 2.48 2.54 2.46 2.47 1.91 23888400 2011-03-01 2.48 2.54 2.34 2.46 1.90 29950358 2011-04-01 2.46 2.50 2.24 2.47 1.91 17479859 2011-05-01 2.46 2.60 2.46 2.56 1.98 16184480 2011-06-01 2.56 2.58 2.30 2.47 1.92 28604882 2011-07-01 2.49 2.60 2.49 2.51 1.95 19730085 2011-08-01 2.51 2.56 2.31 2.56 1.98 21616510 2011-09-01 2.56 2.59 2.48 2.56 1.98 19767504 2011-10-01 2.53 2.62 2.36 2.61 2.03 16098587 2011-11-01 2.59 2.63 2.53 2.60 2.02 23162190 2011-12-01 2.61 2.80 2.27 2.80 2.18 18289693 2012-01-01 2.77 2.88 2.70 2.73 2.12 14872647 2012-02-01 2.73 2.78 2.67 2.67 2.08 12913541 2012-03-01 2.67 2.76 2.67 2.73 2.13 26178272 2012-04-01 2.73 2.84 2.69 2.81 2.20 17500767 2012-05-01 2.80 2.91 2.78 2.86 2.24 19905546 2012-06-01 2.83 2.86 2.64 2.71 2.12 31947997 2012-07-01 2.72 2.82 2.68 2.77 2.16 20821322 2012-08-01 2.76 2.92 2.76 2.89 2.26 20344480 2012-09-01 2.88 2.98 2.84 2.91 2.27 16195610 2012-10-01 2.92 3.02 2.86 2.98 2.33 19452888 2012-11-01 2.96 3.00 2.92 2.98 2.34 20235396 2012-12-01 2.97 3.03 2.89 2.97 2.33 15172010 2013-01-01 2.97 3.16 2.97 3.15 2.47 17684648 2013-02-01 3.15 3.28 2.98 3.14 2.47 153640916 2013-03-01 3.13 3.27 3.01 3.27 2.57 56867889 2013-04-01 3.27 3.44 3.18 3.44 2.71 37937240 2013-05-01 3.42 3.54 3.26 3.34 2.63 39058605 3.34 3.40 3.11 3.30 3.52 3.22 3.30 3.50 2.60 2.76 3.42 2.69 28275870 32734353 101611878 54236774 30720050 24668165 2.90 3.00 3.68 3.81 3.91 3.92 3.09 3.10 22921767 3.51 3.67 3.42 3.44 3.78 3.41 3.62 3.89 3.59 3.82 4.00 3.67 3.93 4.02 3.87 3.92 4.12 3.91 4.07 4.17 3.94 4.16 4.44 4.13 4.24 4.31 3.84 3.97 4.18 3.86 4.06 3.20 18838226 4.16 3.28 27977337 4.23 3.34 32153327 3.97 3.14 21064221 3.86 3.20 38531448 3.90 3.24 3.17 3.82 3.86 3.93 3.75 3.90 3.95 3.76 3.79 3.83 3.66 3.69 3.90 3.69 3.67 3.04 3.85 3.19 3.87 3.21 3.87 3.27 2013-06-01 2013-07-01 2013-08-01 2013-09-01 2013-10-01 2013-11-01 2013-12-01 2014-01-01 2014-02-01 2014-03-01 2014-04-01 2014-05-01 2014-06-01 2014-07-01 2014-08-01 2014-09-01 2014-10-01 2014-11-01 2014-12-01 2015-01-01 2015-02-01 2015-03-01 2015-04-01 2015-05-01 2015-06-01 2015-07-01 2015-08-01 2015-09-01 2015-10-01 2015-11-01 2015-12-01 2016-01-01 2016-02-01 2016-03-01 2016-04-01 2016-05-01 3.80 3.90 3.71 3.88 4.11 3.84 3.90 4.44 3.87 4.23 4.54 4.18 4.23 26117610 24238520 20873852 40243975 29830992 24515284 24459456 15627602 23431714 31412504 18454610 21433511 28091818 4.45 3.57 3.76 3.68 3.80 3.96 4.17 4.35 4.50 4.61 4.85 4.94 4.24 5.41 4.65 27908537 4.95 4.25 29526640 4.41 4.55 4.22 4.35 4.60 4.35 4.48 4.69 4.46 4.62 4.94 4.54 4.85 5.13 4.76 4.94 5.42 4.94 5.41 5.64 4.75 4.97 5.11 4.76 4.90 5.44 4.75 5.28 5.57 5.05 5.26 5.77 5.14 5.70 5.78 5.41 5.58 6.34 5.50 6.13 6.90 6.11 6.40 6.57 6.07 4.88 23457897 4.19 4.58 5.26 21542315 5.28 4.60 21144946 5.75 19506082 5.01 4.84 5.55 19594596 6.10 5.32 6.43 5.60 27032552 34231197 25531957 56194015 6.15 5.43 6.13 6.70 6.11 6.24 5.51 2016-06-01 37962562 6.50 7.38 5.74 6.52 34997392 7.50 6.62 28521666 7.35 26215316 6.59 6.49 5.89 5.50 6.16 6.25 5.59 6.12 25066114 33405790 29522808 22005924 17651691 6.84 7.34 6.56 6.05 6.76 6.90 6.26 6.99 6.34 7.13 6.47 24716833 21058586 19115005 24904448 18318865 22911678 38448802 6.95 6.79 6.31 6.16 5.84 6.44 6.23 5.65 6.38 5.88 2016-07-01 2016-08-01 2016-09-01 2016-10-01 2016-11-01 2016-12-01 2017-01-01 2017-02-01 2017-03-01 2017-04-01 2017-05-01 2017-06-01 2017-07-01 2017-08-01 2017-09-01 2017-10-01 2017-11-01 2017-12-01 2018-01-01 2018-02-01 2018-03-01 2018-04-01 2018-05-01 2018-06-01 2018-07-01 2018-08-01 2018-09-01 2018-10-01 2018-11-01 2018-12-01 2019-01-01 2019-02-01 2019-03-01 2019-04-01 2019-05-01 6.26 6.54 6.10 6.49 7.44 6.49 7.31 7.55 6.99 7.50 7.75 6.72 7.25 7.36 6.50 6.59 6.79 6.00 6.17 6.68 6.07 6.52 6.91 6.25 6.84 7.34 6.67 7.25 7.43 6.74 6.76 6.95 6.56 6.85 7.07 6.75 6.99 7.36 6.90 7.10 7.13 6.78 6.97 7.06 6.67 6.79 6.79 6.30 6.44 6.46 6.17 6.25 6.52 6.02 6.44 6.76 6.43 6.48 6.73 6.26 6.69 6.69 6.21 6.45 6.45 6.12 6.12 6.43 6.11 6.36 6.77 6.32 6.59 6.99 6.52 6.77 6.94 6.67 6.71 7.20 6.64 7.10 7.49 6.81 7.31 7.35 6.75 7.00 7.27 6.91 7.14 7.48 6.88 7.18 7.72 7.07 7.35 7.77 7.26 7.75 8.24 7.48 8.14 8.40 7.91 7.99 8.78 7.95 6.48 5.98 6.17 6.70 6.45 5.95 26329410 32515304 22830258 20067225 16629126 33365472 21395010 29247997 20148266 21985706 6.12 5.64 6.38 5.99 6.60 6.19 6.78 6.36 6.68 6.26 6.71 7.15 14156376 32459134 7.30 6.85 6.99 6.56 27035210 20030663 7.20 6.86 7.18 6.84 24676072 7.35 7.00 16437916 7.77 7.40 21544274 8.14 28699830 7.97 7.76 7.70 8.47 20190124 8.77 33586319 2019-06-01 2019-07-01 2019-08-01 2019-09-01 2019-10-01 2019-11-01 2019-12-01 2020-01-01 2020-02-01 2020-03-01 2020-04-01 2020-05-01 2020-06-01 2020-07-01 2020-08-01 8.77 9.85 8.51 9.85 9.75 9.77 9.30 9.31 9.30 9.90 9.12 9.62 9.58 9.77 8.92 9.15 9.16 9.48 8.79 9.30 9.23 9.47 8.91 9.03 9.06 9.20 8.62 8.75 8.75 9.21 8.50 8.65 8.50 8.79 7.77 7.87 7.69 7.98 4.26 4.99 5.00 6.15 4.99 6.09 6.05 6.70 5.60 6.50 6.50 7.32 6.11 6.57 6.49 6.62 5.92 6.38 6.29 6.75 6.00 6.63 9.52 21476358 8.99 26429634 9.29 22417179 8.84 20534524 8.98 20288121 8.83 25310829 8.56 19850135 8.46 18727588 7.70 33575796 4.88 101760988 6.09 126011688 6.50 6.57 49291087 63038754 41657554 33422601 6.38 6.63 Instructions 1. Please use the excel FINANCE 251 A1S12021Data.xls file to do the calculations. 2. This excel file can be found through the link given in the assignment. 3. You can also download the data from Yahoo.com as specified but data may vary depending on what date you download. To avoid such issues we are providing you with the data set. 4. The data is provided in separate sheets for Auckland International Airports Limited (AIA.NZ), Briscoes Group Limited (BGP.NZ) and the S&P/NZX 50 Index (^N250) 5. Start Date is 1 July 2010 and the End Date is 1 August 2020. 6. The data is monthly. In any blank column (J onwards) calculate the return for each period of one month using the data from column H Adjusted Close (this includes an adjustment for accrued dividends so you don't need to calculate the Cash Flow part of the usual formula) For instance on the row for 1 August 2010 (i.e. for the month 1 July 2010 to 1 August 2010) the return calculated as: PriceAugust- PriceJuly PriceJuly Date Open High Low Close Adj Close Volume 2010-07-01 2972.09 3047.31 2929.09 3034.62 3034.62 517329800 2010-08-01 3034.62 3069.33 2987.46 3036.10 3036.10 644828200 2010-09-01 3036.10 3252.68 3034.00 3178.09 3178.09 767437700 2010-10-01 3178.09 3309.62 3178.09 3304.89 3304.89 633354000 2010-11-01 3304.89 3344.11 3246.64 3264.50 3264.50 783159300 2010-12-01 3264.50 3338.87 3253.29 3309.03 3309.03 756935500 2011-01-01 3309.03 3377.01 3309.03 3338.74 3338.74 408749600 2011-02-01 3338.74 3413.43 3333.11 3370.52 3370.52 763824800 2011-03-01 3370.52 3444.14 3304.76 3439.85 3439.85 909177000 2011-04-01 3439.85 3519.94 3426.39 3519.33 3519.33 578633600 2011-05-01 3519.33 3584.46 3484.97 3547.64 3547.64 1054188600 2011-06-01 3547.64 3554.50 3414.92 3448.35 3448.35 794012400 2011-07-01 3448.35 3491.58 3369.63 3395.63 3395.63 863799400 2011-08-01 3395.63 3507.84 3055.09 3323.07 3323.07 855707800 2011-09-01 3323.07 3343.95 3247.08 3343.35 3343.35 729560400 2011-10-01 3343.35 3397.27 3257.89 3332.56 3332.56 631748000 2011-11-01 3332.56 3365.17 3211.60 3270.21 3270.21 703188200 2011-12-01 3270.21 3303.99 3198.27 3274.71 3274.71 601153400 2012-01-01 3274.71 3307.95 3209.49 3296.20 3296.20 480122000 2012-02-01 3296.20 3353.77 3279.02 3322.53 3322.53 718206800 2012-03-01 3322.53 3549.62 3318.68 3509.55 3509.55 1016087200 2012-04-01 3509.55 3562.32 3452.64 3555.87 3555.87 557634400 2012-05-01 3555.87 3616.12 3460.02 3488.29 3488.29 875327600 2012-06-01 3488.29 3495.63 3376.20 3399.83 3399.83 744419400 2012-07-01 3399.83 3545.72 3399.83 3545.01 3545.01 770878600 2012-08-01 3545.01 3692.22 3526.18 3666.68 3666.68 1008576600 2012-09-01 3666.68 3843.08 3662.30 3834.15 3834.15 766982200 2012-10-01 3830.03 4004.26 3830.03 3957.88 3957.88 517570000 2012-11-01 3957.88 4052.03 3900.99 4050.09 4050.09 304638900 2012-12-01 4023.36 4089.28 3974.73 4066.51 4066.51 192945000 2013-01-01 4082.37 4207.16 4072.35 4199.82 4199.82 125501800 2013-02-01 4252.65 4253.73 4166.37 4214.60 4214.60 307827000 2013-03-01 4320.01 4423.24 4241.11 4422.75 4422.75 1236954200 2013-04-01 4430.17 4616.01 4391.55 4614.37 4614.37 734659400 2013-05-01 4614.37 4680.11 4466.69 4511.35 4511.35 1064676800 4316.99 4440.17 4440.17 4511.35 4440.17 4518.32 4608.46 4407.83 4537.98 4537.98 4540.97 4736.39 4590.85 4783.97 4494.61 4530.52 2013-06-01 2013-07-01 2013-08-01 2013-09-01 2013-10-01 2013-11-01 2013-12-01 2014-01-01 4537.98 4540.97 4782.68 4540.97 4782.68 4909.73 4909.73 4983.60 4794.95 4909.73 4794.95 4737.01 4876.41 4799.90 4951.17 2014-02-01 2014-03-01 4990.04 5160.39 4737.01 4874.58 4990.04 5139.98 5232.68 4978.23 5232.68 5232.91 5178.44 5129.00 5223.21 5177.91 5136.56 5114.36 5212.00 5256.09 5396.20 5429.09 5577.20 5741.89 5884.57 5816.91 5196.44 5196.60 5248.15 5289.48 5405.31 5537.99 5599.03 5141.48 5167.99 5223.30 5255.04 5820.00 5878.47 5927.10 719784200 717650400 949183600 847818500 895557200 1464603700 894659900 640540800 752586200 992838700 801659300 910159700 827390700 798375200 721732800 827570600 845591000 980400700 805633500 581708000 813148900 1008754900 714697700 812986800 966490300 900951600 1532862700 926746200 1164370800 1002010100 953601600 4708.75 4909.73 4786.04 4794.95 4672.24 4737.01 4736.38 4874.58 4780.05 4990.04 4969.59 5139.98 5016.38 5232.68 5094.36 5178.44 5091.02 5141.48 5080.70 5167.99 5038.23 5223.30 5142.34 5255.04 5097.08 5387.83 5387.83 5424.45 5401.44 5568.28 5541.62 5744.00 5717.05 5878.47 5811.50 5833.99 5734.28 5791.34 5704.76 5844.95 5684.05 5726.96 5686.99 5920.96 5461.73 5656.24 5542.03 5593.36 5573.71 5986.37 5945.14 6100.15 6012.86 6324.26 6035.88 6170.22 5910.03 6230.87 6233.53 6752.42 6695.20 6820.58 6783.92 7039.42 2014-04-01 2014-05-01 2014-06-01 2014-07-01 2014-08-01 2014-09-01 2014-10-01 2014-11-01 2014-12-01 2015-01-01 2015-02-01 2015-03-01 2015-04-01 2015-05-01 2015-06-01 2015-07-01 2015-08-01 2015-09-01 2015-10-01 2015-11-01 2015-12-01 2016-01-01 2016-02-01 2016-03-01 2016-04-01 2016-05-01 5387.83 5424.45 5568.28 5744.00 5878.47 5833.99 5791.34 5884.72 5844.95 5898.59 5844.95 5778.82 5850.18 5726.96 5920.95 5937.57 5963.05 5726.96 5920.96 5656.24 5593.36 5986.37 5656.24 5725.89 5593.36 6014.48 5986.37 6100.15 6324.26 6107.47 6324.26 6170.22 6233.53 6753.32 6819.67 6127.23 6333.33 6324.26 6254.72 6758.01 6917.57 7046.83 6170.22 6230.87 6752.42 6820.58 7039.42 534614300 817777500 986542200 922883100 938581500 6587.42 6897.53 6897.53 977416900 724856900 848945700 801154200 682417900 859040700 730225100 502450500 643494300 949770800 706381200 740188000 778998000 700165600 789859400 730212900 752025200 986135600 2016-06-01 7043.88 7049.02 2016-07-01 6909.04 7357.72 2016-08-01 7348.13 7481.68 2016-09-01 7405.56 7585.29 2016-10-01 7352.22 7372.49 2016-11-01 6960.68 6960.68 2016-12-01 6901.29 6973.45 2017-01-01 6881.22 7135.73 2017-02-01 7050.75 7187.44 2017-03-01 7168.73 7212.33 2017-04-01 7188.94 7386.89 2017-05-01 7378.75 7501.50 2017-06-01 7424.52 7688.63 2017-07-01 7611.44 7732.75 2017-08-01 7693.99 7890.58 2017-09-01 7817.45 7955.76 2017-10-01 7931.60 8167.60 2017-11-01 8146.34 8190.21 2017-12-01 8188.91 8423.39 2018-01-01 8398.08 8468.05 2018-02-01 8442.01 8442.01 2018-03-01 8380.10 8634.71 2018-04-01 8271.78 8492.59 2018-05-01 8443.58 8765.66 2018-06-01 8664.40 9049.60 2018-07-01 8943.13 9084.04 2018-08-01 8922.09 9369.78 2018-09-01 9313.20 9381.23 2018-10-01 9352.69 9352.69 2018-11-01 8752.31 8959.34 2018-12-01 8828.63 8917.22 2019-01-01 8811.27 9153.59 2019-02-01 8985.34 9367.38 2019-03-01 9326.02 9844.95 2019-04-01 9844.95 10083.81 2019-05-01 10013.83 10265.46 6897.52 7348.13 7348.13 7277.40 7398.83 7398.83 7183.38 7361.09 7361.09 6892.27 6960.68 6960.68 6642.03 6896.95 6896.95 6748.62 6881.22 6881.22 6881.22 7050.75 7050.75 7030.26 7167.46 7167.46 7019.87 7196.78 7196.78 7182.46 7378.75 7378.75 7349.37 7418.90 7418.90 7400.31 7611.44 7611.44 7583.95 7693.99 7693.99 7687.06 7817.10 7817.10 7719.19 7930.40 7930.40 7905.54 8146.34 8146.34 7959.69 8186.82 8186.82 8130.86 8398.08 8398.08 8211.37 8442.01 8442.01 8031.08 8373.82 8373.82 8278.61 8319.07 8319.07 8250.83 8443.58 8443.58 8419.96 8658.79 8658.79 8588.34 8943.13 8943.13 8857.52 8922.09 8922.09 8832.68 9313.20 9313.20 9043.24 9351.06 9351.06 8490.76 8752.31 8752.31 8652.37 8823.54 8823.54 8657.06 8811.27 8811.27 8664.50 8985.34 8985.34 8972.16 9325.03 9325.03 9302.67 9844.95 9844.95 9705.70 10013.83 10013.83 9938.51 10117.99 10117.99 561139300 514644000 611871400 736044500 467637500 835861100 603563300 474596100 541538500 616114900 540256700 606284400 471321500 457869300 598402100 790988600 497521700 665872800 2019-06-01 10122.87 10501.10 9927.05 10501.10 10501.10 505796600 2019-07-01 10501.10 10922.98 10464.53 10857.75 10857.75 513425600 2019-08-01 10857.75 10927.10 10424.08 10757.20 10757.20 656060000 2019-09-01 10757.20 11222.31 10685.50 10925.62 10925.62 575635200 2019-10-01 10927.31 11179.68 10733.95 10787.82 10787.82 565581000 2019-11-01 10787.82 11337.45 10723.28 11316.58 11316.58 679989600 2019-12-01 11323.68 11642.78 11173.86 11491.90 11491.90 461875900 2020-01-01 11491.90 11910.73 11489.05 11717.44 11717.44 758222800 2020-02-01 11717.44 12107.45 11098.79 11261.16 11261.16 619303800 2020-03-01 11261.16 11720.08 8209.04 9796.75 9796.75 1424757500 2020-04-01 9796.75 10889.74 9694.64 10532.07 10532.07 1148400400 2020-05-01 10532.07 11109.34 10279.28 10882.41 10882.41 1090611400 2020-06-01 10883.18 11590.54 10646.09 11451.05 11451.05 1230996600 2020-07-01 11451.05 11815.15 11329.22 11727.63 11727.63 789810700 2020-08-01 11727.63 12114.76 11338.85 11937.56 11937.56 776366800 2.3 1.56 458208 2.4 1.62 548253 2.35 1.59 302434 2.38 1.62 1.64 2.41 2.4 367237 430290 314166 1.63 2.45 2.5 2.28 2.3 2.5 2.3 2.42 2.55 2.35 2.44 2.44 2.3 2.38 2.43 2.3 2.36 2.45 2.3 2.4 2.4 2.33 2.37 2.55 2.37 2.55 2.65 2.45 2.46 2.5 2.37 2.4 2.54 2.38 2.5 2.64 2.5 2.37 1.61 188429 2.55 1.73 177568 2.46 1.67 1.67 2.38 2.5 234630 185410 432298 341086 1.75 2.62 1.83 2.65 2.7 2.59 2.7 1.89 2.7 2.86 2.7 2.85 2.00 2.85 3 2.8 1.99 2.84 2.85 230409 212118 651006 777719 196532 246018 2.83 2.03 2.9 2.66 3.1 2.8 2.85 3.07 2.19 2.97 2013-07-01 2013-08-01 2013-09-01 2013-10-01 2013-11-01 2013-12-01 2014-01-01 2014-02-01 2014-03-01 2014-04-01 2014-05-01 2014-06-01 2014-07-01 2014-08-01 2014-09-01 2014-10-01 2014-11-01 2014-12-01 2015-01-01 2015-02-01 2015-03-01 2015-04-01 2015-05-01 2015-06-01 2015-07-01 2015-08-01 2015-09-01 2015-10-01 2015-11-01 2015-12-01 2016-01-01 2016-02-01 2016-03-01 2016-04-01 2016-05-01 2016-06-01 2.12 2.14 3 500950 2.95 250684 2.10 2.03 2.85 329602 2.83 2.08 253455 2.86 2.10 3.1 3.1 2.85 2.97 3.01 2.91 3 3.07 2.95 2.95 3.08 2.84 2.84 2.92 2.8 2.83 2.96 2.81 2.86 2.95 2.81 2.9 2.9 2.7 2.9 2.98 2.7 2.83 3 2.76 2.84 2.89 2.7 2.88 2.89 2.74 2.9 2.13 2.12 365797 377151 707715 299889 2.89 2.77 2.03 2.84 2.08 260966 2.89 2.17 392519 281903 2.87 2.15 2.87 2.15 159658 2.87 2.94 2.82 2.87 2.96 2.82 2.85 2.14 203337 2.93 2.20 307963 3 661081 2.89 2.97 2.85 2.95 3.23 2.91 3 3.04 2.93 3.03 3.31 3.03 3.18 3.18 3.04 3.03 2.25 2.34 2.54 805510 3.28 349158 412112 3.12 2.41 3.1 3.43 3.1 3.39 2.62 167005 3.3 3.85 3.27 3.82 4 3.7 3.78 3.84 227651 318967 2.92 2.97 2.99 2.92 3.75 3.78 3.6 3.78 580030 3.78 3.85 3.6 3.7 315485 4.03 3.98 3.75 4.04 3.75 4.03 4.08 3.96 3.98 4.55 3.98 4.37 4.54 4.25 4.36 4.5 4 4.37 4.35 4.06 4.16 3.93 4.02 3.84 3.25 3.24 3.27 2016-07-01 2016-08-01 2016-09-01 2016-10-01 2016-11-01 2016-12-01 2017-01-01 2017-02-01 2017-03-01 2017-04-01 2017-05-01 2017-06-01 2017-07-01 2017-08-01 2017-09-01 2017-10-01 2017-11-01 2017-12-01 2018-01-01 2018-02-01 2018-03-01 2018-04-01 2018-05-01 2018-06-01 2018-07-01 2018-08-01 2018-09-01 2018-10-01 2018-11-01 2018-12-01 2019-01-01 2019-02-01 2019-03-01 2019-04-01 2019-05-01 2019-06-01 4.06 4.18 3.85 4.15 4.15 3.9 3.92 4.12 3.9 4.02 4.09 3.84 3.83 3.83 3.25 3.26 3.4 3.12 3.26 3.3 3.15 3.28 3.45 3.23 3.45 3.52 3.35 3.44 3.55 3.4 3.45 3.71 3.44 3.57 3.58 3.35 3.5 3.58 3.4 3.52 3.57 3.45 3.55 3.56 3.46 3.45 3.19 122608 3.15 153754 3.45 214680 3.44 1463748 3.29 281812 3.37 601683 3.18 196595 3.26 290820 3.11 415208 2.63 630131 2.68 1285315 2.71 2107504 2.86 533397 2.82 450274 2.84 350377 2.96 619596 2.99 496060 3.01 602138 3.03 359840 2.98 338116 3.06 458181 3.09 706868 2.85 364177 3.4 3.43 3.57 3.5 3.52 3.55 3.49 3.58 3.5 3.6 3.5 3.6 3.61 3.48 3.61 3.6 3.6 3.24 3.34 3.03 3.35 3.49 3.26 3.49 3.5 3.3 3.47 3.38 2.95 220847 252288 358950 3.24 2.83 2.97 3.4 3.38 3.38 3.21 3.23 3.44 3.2 3.4 3.44 3.25 3.26 3.35 3.24 3.33 3.47 3.26 3.4 3.4 3.29 3.26 3.33 2.85 3.02 290534 651930 664772 773965 328868 3.4 3.08 3.37 3.05 3.43 631659 3.11 3.22 3.55 3.30 3.64 3.65 3.74 475161 728287 389384 370121 3.38 3.47 3.37 3.49 3.31 3.44 3.62 3.43 3.58 3.75 3.55 3.64 3.67 3.56 3.66 3.8 3.61 3.74 3.88 3.72 3.88 4.49 3.85 3.9 4.23 3.75 3.6 3.75 2.35 2.84 3.44 2.64 3.88 3.60 275142 2019-07-01 2019-08-01 2019-09-01 2019-10-01 2019-11-01 2019-12-01 2020-01-01 2020-02-01 2020-03-01 2020-04-01 2020-05-01 2020-06-01 2020-07-01 2020-08-01 3.9 3.75 2.84 3.15 3.62 326953 3.48 333887 2.63 1268603 3.05 896585 2.96 1679147 3.05 774658 3.31 794131 3.43 523644 3.06 3.16 3.19 3 3.06 3.33 3.05 3.15 3.11 3.42 3.5 3.07 3.6 3.13 3.45 3.55 Date Open High Low Close Adj Close Volume 2010-07-01 2.08 2.22 2.07 2.20 1.70 19029448 2010-08-01 2.20 2.24 2.14 2.21 1.70 21136031 2010-09-01 2.21 2.32 2.21 2.28 1.76 29419474 2010-10-01 2.29 2.36 2.27 2.33 1.80 25098595 2010-11-01 2.33 2.41 2.28 2.31 1.79 27741176 2010-12-01 2.29 2.48 2.17 2.42 1.87 20245143 2011-01-01 2.44 2.54 2.43 2.49 1.92 11901304 2011-02-01 2.48 2.54 2.46 2.47 1.91 23888400 2011-03-01 2.48 2.54 2.34 2.46 1.90 29950358 2011-04-01 2.46 2.50 2.24 2.47 1.91 17479859 2011-05-01 2.46 2.60 2.46 2.56 1.98 16184480 2011-06-01 2.56 2.58 2.30 2.47 1.92 28604882 2011-07-01 2.49 2.60 2.49 2.51 1.95 19730085 2011-08-01 2.51 2.56 2.31 2.56 1.98 21616510 2011-09-01 2.56 2.59 2.48 2.56 1.98 19767504 2011-10-01 2.53 2.62 2.36 2.61 2.03 16098587 2011-11-01 2.59 2.63 2.53 2.60 2.02 23162190 2011-12-01 2.61 2.80 2.27 2.80 2.18 18289693 2012-01-01 2.77 2.88 2.70 2.73 2.12 14872647 2012-02-01 2.73 2.78 2.67 2.67 2.08 12913541 2012-03-01 2.67 2.76 2.67 2.73 2.13 26178272 2012-04-01 2.73 2.84 2.69 2.81 2.20 17500767 2012-05-01 2.80 2.91 2.78 2.86 2.24 19905546 2012-06-01 2.83 2.86 2.64 2.71 2.12 31947997 2012-07-01 2.72 2.82 2.68 2.77 2.16 20821322 2012-08-01 2.76 2.92 2.76 2.89 2.26 20344480 2012-09-01 2.88 2.98 2.84 2.91 2.27 16195610 2012-10-01 2.92 3.02 2.86 2.98 2.33 19452888 2012-11-01 2.96 3.00 2.92 2.98 2.34 20235396 2012-12-01 2.97 3.03 2.89 2.97 2.33 15172010 2013-01-01 2.97 3.16 2.97 3.15 2.47 17684648 2013-02-01 3.15 3.28 2.98 3.14 2.47 153640916 2013-03-01 3.13 3.27 3.01 3.27 2.57 56867889 2013-04-01 3.27 3.44 3.18 3.44 2.71 37937240 2013-05-01 3.42 3.54 3.26 3.34 2.63 39058605 3.34 3.40 3.11 3.30 3.52 3.22 3.30 3.50 2.60 2.76 3.42 2.69 28275870 32734353 101611878 54236774 30720050 24668165 2.90 3.00 3.68 3.81 3.91 3.92 3.09 3.10 22921767 3.51 3.67 3.42 3.44 3.78 3.41 3.62 3.89 3.59 3.82 4.00 3.67 3.93 4.02 3.87 3.92 4.12 3.91 4.07 4.17 3.94 4.16 4.44 4.13 4.24 4.31 3.84 3.97 4.18 3.86 4.06 3.20 18838226 4.16 3.28 27977337 4.23 3.34 32153327 3.97 3.14 21064221 3.86 3.20 38531448 3.90 3.24 3.17 3.82 3.86 3.93 3.75 3.90 3.95 3.76 3.79 3.83 3.66 3.69 3.90 3.69 3.67 3.04 3.85 3.19 3.87 3.21 3.87 3.27 2013-06-01 2013-07-01 2013-08-01 2013-09-01 2013-10-01 2013-11-01 2013-12-01 2014-01-01 2014-02-01 2014-03-01 2014-04-01 2014-05-01 2014-06-01 2014-07-01 2014-08-01 2014-09-01 2014-10-01 2014-11-01 2014-12-01 2015-01-01 2015-02-01 2015-03-01 2015-04-01 2015-05-01 2015-06-01 2015-07-01 2015-08-01 2015-09-01 2015-10-01 2015-11-01 2015-12-01 2016-01-01 2016-02-01 2016-03-01 2016-04-01 2016-05-01 3.80 3.90 3.71 3.88 4.11 3.84 3.90 4.44 3.87 4.23 4.54 4.18 4.23 26117610 24238520 20873852 40243975 29830992 24515284 24459456 15627602 23431714 31412504 18454610 21433511 28091818 4.45 3.57 3.76 3.68 3.80 3.96 4.17 4.35 4.50 4.61 4.85 4.94 4.24 5.41 4.65 27908537 4.95 4.25 29526640 4.41 4.55 4.22 4.35 4.60 4.35 4.48 4.69 4.46 4.62 4.94 4.54 4.85 5.13 4.76 4.94 5.42 4.94 5.41 5.64 4.75 4.97 5.11 4.76 4.90 5.44 4.75 5.28 5.57 5.05 5.26 5.77 5.14 5.70 5.78 5.41 5.58 6.34 5.50 6.13 6.90 6.11 6.40 6.57 6.07 4.88 23457897 4.19 4.58 5.26 21542315 5.28 4.60 21144946 5.75 19506082 5.01 4.84 5.55 19594596 6.10 5.32 6.43 5.60 27032552 34231197 25531957 56194015 6.15 5.43 6.13 6.70 6.11 6.24 5.51 2016-06-01 37962562 6.50 7.38 5.74 6.52 34997392 7.50 6.62 28521666 7.35 26215316 6.59 6.49 5.89 5.50 6.16 6.25 5.59 6.12 25066114 33405790 29522808 22005924 17651691 6.84 7.34 6.56 6.05 6.76 6.90 6.26 6.99 6.34 7.13 6.47 24716833 21058586 19115005 24904448 18318865 22911678 38448802 6.95 6.79 6.31 6.16 5.84 6.44 6.23 5.65 6.38 5.88 2016-07-01 2016-08-01 2016-09-01 2016-10-01 2016-11-01 2016-12-01 2017-01-01 2017-02-01 2017-03-01 2017-04-01 2017-05-01 2017-06-01 2017-07-01 2017-08-01 2017-09-01 2017-10-01 2017-11-01 2017-12-01 2018-01-01 2018-02-01 2018-03-01 2018-04-01 2018-05-01 2018-06-01 2018-07-01 2018-08-01 2018-09-01 2018-10-01 2018-11-01 2018-12-01 2019-01-01 2019-02-01 2019-03-01 2019-04-01 2019-05-01 6.26 6.54 6.10 6.49 7.44 6.49 7.31 7.55 6.99 7.50 7.75 6.72 7.25 7.36 6.50 6.59 6.79 6.00 6.17 6.68 6.07 6.52 6.91 6.25 6.84 7.34 6.67 7.25 7.43 6.74 6.76 6.95 6.56 6.85 7.07 6.75 6.99 7.36 6.90 7.10 7.13 6.78 6.97 7.06 6.67 6.79 6.79 6.30 6.44 6.46 6.17 6.25 6.52 6.02 6.44 6.76 6.43 6.48 6.73 6.26 6.69 6.69 6.21 6.45 6.45 6.12 6.12 6.43 6.11 6.36 6.77 6.32 6.59 6.99 6.52 6.77 6.94 6.67 6.71 7.20 6.64 7.10 7.49 6.81 7.31 7.35 6.75 7.00 7.27 6.91 7.14 7.48 6.88 7.18 7.72 7.07 7.35 7.77 7.26 7.75 8.24 7.48 8.14 8.40 7.91 7.99 8.78 7.95 6.48 5.98 6.17 6.70 6.45 5.95 26329410 32515304 22830258 20067225 16629126 33365472 21395010 29247997 20148266 21985706 6.12 5.64 6.38 5.99 6.60 6.19 6.78 6.36 6.68 6.26 6.71 7.15 14156376 32459134 7.30 6.85 6.99 6.56 27035210 20030663 7.20 6.86 7.18 6.84 24676072 7.35 7.00 16437916 7.77 7.40 21544274 8.14 28699830 7.97 7.76 7.70 8.47 20190124 8.77 33586319 2019-06-01 2019-07-01 2019-08-01 2019-09-01 2019-10-01 2019-11-01 2019-12-01 2020-01-01 2020-02-01 2020-03-01 2020-04-01 2020-05-01 2020-06-01 2020-07-01 2020-08-01 8.77 9.85 8.51 9.85 9.75 9.77 9.30 9.31 9.30 9.90 9.12 9.62 9.58 9.77 8.92 9.15 9.16 9.48 8.79 9.30 9.23 9.47 8.91 9.03 9.06 9.20 8.62 8.75 8.75 9.21 8.50 8.65 8.50 8.79 7.77 7.87 7.69 7.98 4.26 4.99 5.00 6.15 4.99 6.09 6.05 6.70 5.60 6.50 6.50 7.32 6.11 6.57 6.49 6.62 5.92 6.38 6.29 6.75 6.00 6.63 9.52 21476358 8.99 26429634 9.29 22417179 8.84 20534524 8.98 20288121 8.83 25310829 8.56 19850135 8.46 18727588 7.70 33575796 4.88 101760988 6.09 126011688 6.50 6.57 49291087 63038754 41657554 33422601 6.38 6.63