Interest Rate Swap Let T., i=1, ... ,n be a set of dates, on which payments of the floating leg of an interest rate swap occur. The payoff of the floating leg of the swap at time Ti is Fi+s where Fi is the reference rate of the floating leg and s is a constant spread. For simplicity, let's assume that the floating and fixed payments happen on the same dates. Also, ri is the risk-free rate on the same tenor. Let N be the notional of the swap. 1) What is the fixed semiannual swap rate calculated from the risk-free rates? Please specify mathematical formula (no need for exact numerical result at this point). 2) Let the semiannual swap rate calculated in 1) be the fixed leg payment of the swap. What is the constant spread s which sets the present value of the swap position to be zero? Please specify mathematical formula (no need for exact numerical result at this point). The risk free curve and reference curve data can be found in the Excel file. Let's suppose the analysis date is 12 June 2013 and both fixed and floating payment happens semi- annually, with the first payment date half year from analysis date. The swap notional equals to USD 100 000, the maturity of the swap is 5 years, and the swap currency is USD Please provide a MATLAB code or Excel spreadsheet that computes... 1) The answer for the first two questions based on the input data given in the attached Excel file. 2) The PV of the swap position on 12 August 2013. 3) The PV of the swap position on 12 February 2014. Date Intl Business Machines Corp Msci Inc Microsoft Corp 20130327 210.89000000 34.04000000 28.37000000 20130328 213.30000000 33.93000000 28.60500000 20130329 213.30000000 33.93000000 28.60500000 20130401 212.38000000 33.35000000 28.61000000 20130402 214.36000000 33.13000000 28.80000000 20130403 212.66000000 32.43000000 28.56000000 20130404 211.31000000 32.66000000 28.59500000 20130405 209.41000000 32.34000000 28.70000000 20130408 209.32000000 32.67000000 28.59000000 20130409 209.22000000 32.51000000 29.61000000 20130410 212.00000000 33.22000000 30.28000000 20130411 212.92000000 33.57000000 28.93500000 20130412 211.38000000 33.52000000 28.79000000 20130415 209.26000000 32.35000000 28.69000000 20130416 212.00000000 32.90000000 28.97000000 20130417 209.67000000 32.58000000 28.82500000 20130418 207.15000000 32.41000000 28.79000000 20130419 190.00000000 32.82000000 29.76500000 20130422 187.83000000 32.90000000 30.83000000 20130423 191.61000000 33.28000000 30.60000000 20130424 191.71000000 33.23000000 31.76000000 20130425 193.95000000 33 31000000 31 94000000 20130426 194.31000000 33.22000000 31.79000000 20130429 199.15000000 33.45000000 32.61000000 20130430 202.54000000 34.10000000 33.10000000 20130501 199.63000000 33.26000000 32.72000000 20130502 202.39000000 33.65000000 33.16000000 20130503 204.51000000 33.32000000 33.49000000 20130506 202.78000000 33.33000000 33.75000000 20130507 203.63000000 33.56000000 33.31000000 20130508 204.82000000 34.14000000 32.99000000 20130509 203.24000000 33.86000000 32.66000000 20130510 204.47000000 33.95000000 32.69000000 20130513 202.47000000 33.94000000 33 03000000 20130514 203.21000000 34.45000000 33.53000000 20130515 203.32000000 34.26000000 33.84500000 20130516 204.69000000 34.57000000 34.08000000 20130517 208.44000000 34.66000000 34.87000000 20130520 207.60000000 34.53000000 35.08000000 20130521 208.65000000 34.72000000 34.85000000 20130522 206.99000000 34.24000000 34,61000000 20130523 206.16000000 34.49000000 34.15000000 20130524 205.72000000 34.47000000 34.26900000] 20130527 205.72000000 34.47000000 34.26900000 20130528 207.78000000 35.04000000 35.02000000 20130529 207.92000000 35.22000000 34.8.8000000 20130530 209.36000000 35.73000000 35.03000000 20130531 208.02000000 35.24000000 34.90000000 20130603 208.95000000 35.17000000 35.59000000 20130604 206.19000000 34.98000000 34.99000000 20130605 202.74000000 34.28000000 34.78000000 2013060 2013/10 20130610 | 20130611 20130612 2013/6 13 2013061 20130617 201306 1 20130619 201306 20130621 20130624 20130625 | 20130626 20130627 20130629 | 20130701 20130702 20130709 2013070 20130T05 20130709 | 20130709 20130710 20130711 20130712 20130T15 20130716 20130717 20131 20130719 2013072 20130723 20130724 20130725 20130726 | 20130729 20130730 20130731 2013/A401 20130802 2013 E05 20130906 201307 2013-808 20130609 20130812 2013813 20130814 20130815 | 20130816 203.000oooo 34,0000000 206.35000000 34.70000000 205.02000000 34.8000 0000 203.9800000 4,58000000 201.20000000 34.05000000 203.77000000 34.3400 Cooo 202.2000000 34.16000000 203.04 000000 4,5000 6000 20.87000000 34.59000000 20194000000 33,98000000 197.35000000 33.45000000 195.46000000 33.0700AO000 193.54000000 32. 20000000 14.980ooooo | 32.97000000 194 000000 32.8900000 195.6500000] 32.000000 191.11000000 33.27000000 191.28000000 | 34.12000000 1910000000 33.9000000 193.2500000 34.1500 root 193.25000000 34.15000000 194.93000000 34.4500000 194 99000AO000 34.5400 0000 191.30000000 34.25000000 192.25000000 33.72000000 192.30000000 34.4000 rooo 192.07000000 34,56000000 199.00000000 34.6700 0000 193.85000000 34.4300 2000 19,55000000 34,9000000 197.99000000 34,0000000 193.54000000 34.33000000 194.0900cmn00 35.37000000 194.9800000) 35 24500AO00 19681000000 35.08000000 197.2200000 35.39000000 197.35000000 35.13000000 196.2100AO00 | 34.00000 196.01000000 34.92000000 195.0400000 35.05000000 195.41000000 3 5200000 195.16000000 | 37 45000000 195.50000000 37.700AO000 190.99000000 37.82000000 184.5600000 37.41000000 1879300oooo 37.83000000 187.8200oooo | 37.99000000 189.09000000 37.4900000 163.4200000 37.92000000 1875300AO00 37.83000000 185.79000c00] 37.5500 2000 | 185.3400000 | 37.44000000 34,96000000 35.670000 35.47000000 34.84000000 35.00000000 34.7150000 34.40000000 35,00000000 4,98000000 4,59000000 3,000000 3.26500000 33.71500000 33.6700000 34.35000000 34.62000000 34.54500000 4.36000000 3.94000000 34.61000000 Q1000000 34.21000000 34.32500000 34.35000000 34,70000000 35.66600000 35.670pp000 3.17000000 36.27000000 35.74000000 35.44000000 31.40000000 32.01000000 31.82000000 3196000000 3139000000 31.62000000 3154000000 31.85000000 31.34000000 31.70000 31.49000000 31.700000 31.58000000 32.06300000 32.49000000 32.70000000) 32.47000000 32.23000000 32,35000000 3179000000 31.80000000 201919 2013020 20130821 20130622 | 20130823 20130826 20130827 200 13062 2013-829 2013030 20130902 20130903 2013 Poor 2013/05 20130906 201609 20139 10 | 20130611 20130912 20130913 201308 16 20130917 201391 2013/019 | 20130920 2013063 20130924 20130025 20130926 20130927 2013 20131001 20131002 20131003 20131004 20131007 | 2013100g 20131009 2013 1010 2013 1011 20131014 | 20131015 20131016 2013 1017 | 20131018 2013 1021 2013 1022 | 20131023 20131024 2013 1025 2013 102 | 2013 1029 16.23000000 38,00000000 JB0000 30.25000000 18,000000 38.08 00 0000 165.19000000 38.5000000 185.4200AO00 38.47000000 184.7400000 38.60000000 1274000000 37.57000000 12.16000000 38.0800 2000 182.64000000 38.000000 182.27000000 37.51000000 162.27 0oooool 37.5100000 183.96000000 37.400000 183.1300AO000 38.17000000 184.150ooooo | 38.43000000 183.03000000 34,7600 0000 B49400000 39.4600000 186.0000000 39.84000000 190.70000000 | 39.67000000 190,73000000 39,500000 192.1700000] 38.6600000 193.15000000 0.05000000 192.1600000 40,6400000 196 4700000 41.01 000000 193.39 0ooooo 40.78000000 190.02000000 40.3200000g | 190.90ooooo 0.2400000 1899DDDDDD 40.25000000 189.4700000 40.3300tooo 190.22000000 | 0.67000000 18692000000 40.2300000 185.1800000 40,2600cb00 186.38000000 40.53000000 184,96000000 40.07000000 163.00000 39.91000000 184 10000000 40.26.00 Conn 182.01000000 39,4300000 173.72000000 38.91000000 181.32000000 38.3100 D000 1B4.77000000 39.19000000 186.1600000 39.68000000 186.97000000 39.7200000 184. S600000 39,54000000 186.73000000 39.000 0000 174.83000000 40.00000000 | 17378000000 40.35000000 172.16000000 0.51000000 174.97000000 40.60000000 175.7700000 40.93000000 177.000000 41.32000000 17835000000 41.37000000 177.350ooooo 41.34000000 182.12000000 41.90000000 313300000 31.62000000 31.61000000 32.39000000 34.75000000 34.1500000 33.25000000 33.02000000 33.5 5000000 33.40oooo00 3,40000000 31.4000000 31.18500000 | 31.23500000 31.15200000 1,550000 32.39000000 32.740ooooo 32,89000000 33.03000000 32.0100000 32.9300000 3332000000 33.400000 32.79100000 32.74000000 32.45500000 32.50600000 32.77000000 33.27000000 33.26000000 33.56000000 33.92000000 33.86000000 33.4B000000 33,3000000 33.01000000 33.07000000 33.76000000 4.13000000 34.4500Mb000 34.49000000 4.4000000 34.32000000 34.96000000 34.99000000 34.56000000 3376000000 33200DDDD 35.73000000 35.5Totoooo 35.52000000 2013 1030 2013031 20131101 2013110 20131105 20131106 20131107 20131108 | 20131111 2013 1112 20131113 20131114 20131115 20131118 | 20131119 20131120 20131121 20131122 20131125 20131125 20131127 20131128 20131129 20131202 20131203 2013120 | 20131205 | 2013120 2013 1209 | 20131210 2013 1211 20131212 | 20131213 | 20131216 20131217 20131218 2013 1219 20131220 2013 122 2013 122 2013 1225 20131226 20131227 | 20131230 20131231 20140101 20140102 20140103 20140106 20140107 20140108 | 20140109 160.15000000 41.2100 6000 179.21000000 0.7000000 179 23000000 40.9700tooo 180.27000000 41.42000000 177.85000000 41.38000000 179.19000000 41.4200000 1180.0000000 40.83000000 179.99000000 41.62000000 182.3800000|41.78000000 16307 000000 41.91000000 183.5500000|42.38000000 | 182.21000000 43.0200000 183.1900AO00 43.48000000 14.47000000 43.02000000 18523000000 43.04000000 1851900000 3.1000000 184.1300000 43.96000000 181,30000000 4.08000000 173.94000000 44.4500000 177.3100000|44.57000000 173.97000000 44.50000000 173.97000000 4.5000000 179.6800cm000 44.39000000 177.4000000 44.71000000 176.08000000 4.18000000 175.74000CO01 43.9100 6000 176.0000000 47.8700000 ITT.67000000 44.2100000 177.46000000 44.15000000 | 177.1200000 3.00 0000 175.20000000 42.14000000 173.37000000 43.47000000 172.0000000 43.46000000 177.85000000 43.1900 room 175 760000.00 42.87000000 13.70000000 42.00 Cond 10.22000000 42.0500000 180.02000000 42.60000000 182 23000000 43.00000000 183.22000000 3.34000000 163.22000000 43.34000000 185.35000000 | 43.39000000 185.0800000 43.4700 CD00 18641000000 43.84000000 187.5700000 43.72000000 18757000000) 43.72000000 1855100000 43.1500CO00 186.6400000 43.1700000 16.0000000 43.1000 CD00 189,71000000 43.54000000 18797booco 43.4700 bodo 187.38000000 43.82000000 35.54000000 35.4050000 35.52500000 5,94000000 36.54000000 38.1 B000000 37.50000000 377000000 37.59000000 37.36000000 38.15500000 38.02100000 37.84100000 37.20000000 35,74000000 37.A6000000 37 40000000 | 37.57000000 37.84000000 37.35000000 370000000 37.000000 38.13000000 38.45000000 38.31000000 38.94000000 39,00000000 38.36000000 38,70500000 38.11000000 37.10000 37.22000000 36.69000000 36.8600000 36.52000000] 36.5000000 36.25000000 36.40000000 36.6200000 37.0B000000 37,0000000 37 44000000 37.290000 37.29000000 37.41000000 37.41000000 37.16000000 3,81000000 3.13000000 36.41000000 35.76oooooo 35.53000000 | 2010110 20140113 | 2014011 | 20140115 | 20140116 20140117 20140120 2016121 2016122 20140123 2014012 201012 20140124 20140129 20140190 2014 01:31 20140203 | 20140204 20140205 20140206 20140207 2014 D210 20140211 20140212 20140213 2014021 | 20140217 20140218 20140219 2010220 20140221 2014022- | 20140275 20140226 20140227 2014022 20140909 | 2014030 20140305 | 20140306 2014 030 | 20140310 20140311 201404312 20140313 20103.1 2014-17 20140318 20140219 20140320 20140621 | 20140324 1872000000 3.7800*600 14.16000000 43.12000000 185.92000000 3.6600 0000 187.74000000|43.4300 2000 | 1183.76000000 44.0000000 190.0900000 44.22000000 10.09000000 4 2000000 183.43000000 44.1000000 182.2500wooo ,000000 182.73000000 44.90000000 179.64000000 42.7000000 177.90000000 4277000000 17645000000 2.34000000 176.4000000 41.5000000 177.36000000 42.5000000 176.a000000 42.7200000 172 90000000 41.01000000 172.4000000 41.72000000 174.24000000 41.5100000 17.7000000 0.74000000 177 25000000 40.28000000 177.1400000 40.6800000 179 70000AO000 41 46000000 160.2400mhoo 42.2600oooo 181.34000000 42.45000000 183.69000000|2.7400 2000 | 163.9000000 42.74000000 183.1900000 43.4700 6000 18295000000 43.4900 2000 16,26000000 44.980ooooo 182.7900000 4.5-300AO00 183.45000000 44.21000000 183 24000000 43.85000000 14.0600AO00 43.8300 roup 185 37000000 | 43.72000000 185.1700000 43.7100000 184,26000000 44.1800cb00 186.4400000 45.60000000 187.14000000 45.14000000 1874000000 45.74000000 187.A000000 5.75000000 186.39000000 | 45.74000000 18.700000 45.00 DD00 186.22000000 48.27000000 183.9000000 45.27000000 182.210000|45.21000000 185.81000000 | 45.2000000 186.4100000 45.63000000 100DDD 45.00 TMD00 18790000000 45.48000000 186.670ooooo | 45.3200oooo | 180.25000000 44.44000000 ,04000000 34,9010 35.7Bottooo 36,76000000 36.39000000 36.36000000 36,38000000 3.17000000 35.43000000 36,05500000 36.80500000 ,03000000 36.27000000 | 36,600000 36 6000000 37.84000000 36.48000000 3,35000000 35.82000000 3.16000000 3,56000000 3,8000000 3717500000 37.4700000 37. 1000000 37.62000000 37.620pp000 37.42000000 37.51000000 37.75000000 37.960000 37.69000000 37.54000000 37.47000000 37.86000000 38.3100000 37.7Booooo0 38.41000000 38.11000000 3.15000000 37.900000 37.42000000 38.020000 38.27000000 37 49000000 3770000000] 38.05000000 55000000 39.2700000 0.33000000 0.16000000 40.50000000 Date Intl Business Machines Corp Msci Inc Microsoft Corp 20130327 210.89000000 34.04000000 28.37000000 20130328 213.30000000 33.93000000 28.60500000 20130329 213.30000000 33.93000000 28.60500000 20130401 212.38000000 33.35000000 28.61000000 20130402 214.36000000 33.13000000 28.80000000 20130403 212.66000000 32.43000000 28.56000000 20130404 211.31000000 32.66000000 28.59500000 20130405 209.41000000 32.34000000 28.70000000 20130408 209.32000000 32.67000000 28.59000000 20130409 209.22000000 32.51000000 29.61000000 20130410 212.00000000 33.22000000 30.28000000 20130411 212.92000000 33.57000000 28.93500000 20130412 211.38000000 33.52000000 28.79000000 20130415 209.26000000 32.35000000 28.69000000 20130416 212.00000000 32.90000000 28.97000000 20130417 209.67000000 32.58000000 28.82500000 20130418 207.15000000 32.41000000 28.79000000 20130419 190.00000000 32.82000000 29.76500000 20130422 187.83000000 32.90000000 30.83000000 20130423 191.61000000 33.28000000 30.60000000 20130424 191.71000000 33.23000000 31.76000000 20130425 193.95000000 33 31000000 31.94000000 20130426 194.31000000 33.22000000 31.79000000 20130429 199.15000000 33.45000000 32.61000000 20130430 202.54000000 34.10000000 33.10000000 20130501 199.63000000 33.26000000 32.72000000 20130502 202.39000000 33.65000000 33.16000000 20130503 204.51000000 33.32000000 33.49000000 20130506 202.78000000 33.33000000 33.75000000 20130507 203.63000000 33.56000000 33.31000000 20130508 204.82000000 34.14000000 32.99000000 20130509 203.24000000 33.86000000 32.66000000 20130510 204.47000000 33.95000000 32.69000000 20130513 202.47000000 33.94000000 33 03000000 20130514 203.21000000 34.45000000 33.53000000 20130515 203.32000000 34.26000000 33.84500000 20130516 204.69000000 34.57000000 34.08000000 20130517 208.44000000 34.66000000 34.87000000 20130520 207.60000000 34.53000000 35.08000000 20130521 208.65000000 34.72000000 34.85000000 20130522 206.99000000 34.24000000 34.61000000 20130523 206.16000000 34.49000000 34.15000000 20130524 205.72000000 34.47000000 34.26900000 20130527 205.72000000 34.47000000 34.26900000 20130528 207.78000000 35.04000000 35.02000000 20130529 207.92000000 35.22000000 34.88000000 20130530 209.36000000 35.73000000 35,03000000 20130531 208.02000000 35.24000000 34.90000000 20130603 208.95000000 35.17000000 35.59000000 20130604 206.19000000 34.98000000 34.99000000 20130605 202.74000000 34.28000000 34.78000000 2014035 20144032 | 20140327 19540ooooo 42.7200000 192.62000000 41.77000000 19.300DM000 41.87000000 0.34000000 39.79000000 39.36000000 Interest Rate Swap Let T., i=1, ... ,n be a set of dates, on which payments of the floating leg of an interest rate swap occur. The payoff of the floating leg of the swap at time Ti is Fi+s where Fi is the reference rate of the floating leg and s is a constant spread. For simplicity, let's assume that the floating and fixed payments happen on the same dates. Also, ri is the risk-free rate on the same tenor. Let N be the notional of the swap. 1) What is the fixed semiannual swap rate calculated from the risk-free rates? Please specify mathematical formula (no need for exact numerical result at this point). 2) Let the semiannual swap rate calculated in 1) be the fixed leg payment of the swap. What is the constant spread s which sets the present value of the swap position to be zero? Please specify mathematical formula (no need for exact numerical result at this point). The risk free curve and reference curve data can be found in the Excel file. Let's suppose the analysis date is 12 June 2013 and both fixed and floating payment happens semi- annually, with the first payment date half year from analysis date. The swap notional equals to USD 100 000, the maturity of the swap is 5 years, and the swap currency is USD Please provide a MATLAB code or Excel spreadsheet that computes... 1) The answer for the first two questions based on the input data given in the attached Excel file. 2) The PV of the swap position on 12 August 2013. 3) The PV of the swap position on 12 February 2014. Date Intl Business Machines Corp Msci Inc Microsoft Corp 20130327 210.89000000 34.04000000 28.37000000 20130328 213.30000000 33.93000000 28.60500000 20130329 213.30000000 33.93000000 28.60500000 20130401 212.38000000 33.35000000 28.61000000 20130402 214.36000000 33.13000000 28.80000000 20130403 212.66000000 32.43000000 28.56000000 20130404 211.31000000 32.66000000 28.59500000 20130405 209.41000000 32.34000000 28.70000000 20130408 209.32000000 32.67000000 28.59000000 20130409 209.22000000 32.51000000 29.61000000 20130410 212.00000000 33.22000000 30.28000000 20130411 212.92000000 33.57000000 28.93500000 20130412 211.38000000 33.52000000 28.79000000 20130415 209.26000000 32.35000000 28.69000000 20130416 212.00000000 32.90000000 28.97000000 20130417 209.67000000 32.58000000 28.82500000 20130418 207.15000000 32.41000000 28.79000000 20130419 190.00000000 32.82000000 29.76500000 20130422 187.83000000 32.90000000 30.83000000 20130423 191.61000000 33.28000000 30.60000000 20130424 191.71000000 33.23000000 31.76000000 20130425 193.95000000 33 31000000 31 94000000 20130426 194.31000000 33.22000000 31.79000000 20130429 199.15000000 33.45000000 32.61000000 20130430 202.54000000 34.10000000 33.10000000 20130501 199.63000000 33.26000000 32.72000000 20130502 202.39000000 33.65000000 33.16000000 20130503 204.51000000 33.32000000 33.49000000 20130506 202.78000000 33.33000000 33.75000000 20130507 203.63000000 33.56000000 33.31000000 20130508 204.82000000 34.14000000 32.99000000 20130509 203.24000000 33.86000000 32.66000000 20130510 204.47000000 33.95000000 32.69000000 20130513 202.47000000 33.94000000 33 03000000 20130514 203.21000000 34.45000000 33.53000000 20130515 203.32000000 34.26000000 33.84500000 20130516 204.69000000 34.57000000 34.08000000 20130517 208.44000000 34.66000000 34.87000000 20130520 207.60000000 34.53000000 35.08000000 20130521 208.65000000 34.72000000 34.85000000 20130522 206.99000000 34.24000000 34,61000000 20130523 206.16000000 34.49000000 34.15000000 20130524 205.72000000 34.47000000 34.26900000] 20130527 205.72000000 34.47000000 34.26900000 20130528 207.78000000 35.04000000 35.02000000 20130529 207.92000000 35.22000000 34.8.8000000 20130530 209.36000000 35.73000000 35.03000000 20130531 208.02000000 35.24000000 34.90000000 20130603 208.95000000 35.17000000 35.59000000 20130604 206.19000000 34.98000000 34.99000000 20130605 202.74000000 34.28000000 34.78000000 2013060 2013/10 20130610 | 20130611 20130612 2013/6 13 2013061 20130617 201306 1 20130619 201306 20130621 20130624 20130625 | 20130626 20130627 20130629 | 20130701 20130702 20130709 2013070 20130T05 20130709 | 20130709 20130710 20130711 20130712 20130T15 20130716 20130717 20131 20130719 2013072 20130723 20130724 20130725 20130726 | 20130729 20130730 20130731 2013/A401 20130802 2013 E05 20130906 201307 2013-808 20130609 20130812 2013813 20130814 20130815 | 20130816 203.000oooo 34,0000000 206.35000000 34.70000000 205.02000000 34.8000 0000 203.9800000 4,58000000 201.20000000 34.05000000 203.77000000 34.3400 Cooo 202.2000000 34.16000000 203.04 000000 4,5000 6000 20.87000000 34.59000000 20194000000 33,98000000 197.35000000 33.45000000 195.46000000 33.0700AO000 193.54000000 32. 20000000 14.980ooooo | 32.97000000 194 000000 32.8900000 195.6500000] 32.000000 191.11000000 33.27000000 191.28000000 | 34.12000000 1910000000 33.9000000 193.2500000 34.1500 root 193.25000000 34.15000000 194.93000000 34.4500000 194 99000AO000 34.5400 0000 191.30000000 34.25000000 192.25000000 33.72000000 192.30000000 34.4000 rooo 192.07000000 34,56000000 199.00000000 34.6700 0000 193.85000000 34.4300 2000 19,55000000 34,9000000 197.99000000 34,0000000 193.54000000 34.33000000 194.0900cmn00 35.37000000 194.9800000) 35 24500AO00 19681000000 35.08000000 197.2200000 35.39000000 197.35000000 35.13000000 196.2100AO00 | 34.00000 196.01000000 34.92000000 195.0400000 35.05000000 195.41000000 3 5200000 195.16000000 | 37 45000000 195.50000000 37.700AO000 190.99000000 37.82000000 184.5600000 37.41000000 1879300oooo 37.83000000 187.8200oooo | 37.99000000 189.09000000 37.4900000 163.4200000 37.92000000 1875300AO00 37.83000000 185.79000c00] 37.5500 2000 | 185.3400000 | 37.44000000 34,96000000 35.670000 35.47000000 34.84000000 35.00000000 34.7150000 34.40000000 35,00000000 4,98000000 4,59000000 3,000000 3.26500000 33.71500000 33.6700000 34.35000000 34.62000000 34.54500000 4.36000000 3.94000000 34.61000000 Q1000000 34.21000000 34.32500000 34.35000000 34,70000000 35.66600000 35.670pp000 3.17000000 36.27000000 35.74000000 35.44000000 31.40000000 32.01000000 31.82000000 3196000000 3139000000 31.62000000 3154000000 31.85000000 31.34000000 31.70000 31.49000000 31.700000 31.58000000 32.06300000 32.49000000 32.70000000) 32.47000000 32.23000000 32,35000000 3179000000 31.80000000 201919 2013020 20130821 20130622 | 20130823 20130826 20130827 200 13062 2013-829 2013030 20130902 20130903 2013 Poor 2013/05 20130906 201609 20139 10 | 20130611 20130912 20130913 201308 16 20130917 201391 2013/019 | 20130920 2013063 20130924 20130025 20130926 20130927 2013 20131001 20131002 20131003 20131004 20131007 | 2013100g 20131009 2013 1010 2013 1011 20131014 | 20131015 20131016 2013 1017 | 20131018 2013 1021 2013 1022 | 20131023 20131024 2013 1025 2013 102 | 2013 1029 16.23000000 38,00000000 JB0000 30.25000000 18,000000 38.08 00 0000 165.19000000 38.5000000 185.4200AO00 38.47000000 184.7400000 38.60000000 1274000000 37.57000000 12.16000000 38.0800 2000 182.64000000 38.000000 182.27000000 37.51000000 162.27 0oooool 37.5100000 183.96000000 37.400000 183.1300AO000 38.17000000 184.150ooooo | 38.43000000 183.03000000 34,7600 0000 B49400000 39.4600000 186.0000000 39.84000000 190.70000000 | 39.67000000 190,73000000 39,500000 192.1700000] 38.6600000 193.15000000 0.05000000 192.1600000 40,6400000 196 4700000 41.01 000000 193.39 0ooooo 40.78000000 190.02000000 40.3200000g | 190.90ooooo 0.2400000 1899DDDDDD 40.25000000 189.4700000 40.3300tooo 190.22000000 | 0.67000000 18692000000 40.2300000 185.1800000 40,2600cb00 186.38000000 40.53000000 184,96000000 40.07000000 163.00000 39.91000000 184 10000000 40.26.00 Conn 182.01000000 39,4300000 173.72000000 38.91000000 181.32000000 38.3100 D000 1B4.77000000 39.19000000 186.1600000 39.68000000 186.97000000 39.7200000 184. S600000 39,54000000 186.73000000 39.000 0000 174.83000000 40.00000000 | 17378000000 40.35000000 172.16000000 0.51000000 174.97000000 40.60000000 175.7700000 40.93000000 177.000000 41.32000000 17835000000 41.37000000 177.350ooooo 41.34000000 182.12000000 41.90000000 313300000 31.62000000 31.61000000 32.39000000 34.75000000 34.1500000 33.25000000 33.02000000 33.5 5000000 33.40oooo00 3,40000000 31.4000000 31.18500000 | 31.23500000 31.15200000 1,550000 32.39000000 32.740ooooo 32,89000000 33.03000000 32.0100000 32.9300000 3332000000 33.400000 32.79100000 32.74000000 32.45500000 32.50600000 32.77000000 33.27000000 33.26000000 33.56000000 33.92000000 33.86000000 33.4B000000 33,3000000 33.01000000 33.07000000 33.76000000 4.13000000 34.4500Mb000 34.49000000 4.4000000 34.32000000 34.96000000 34.99000000 34.56000000 3376000000 33200DDDD 35.73000000 35.5Totoooo 35.52000000 2013 1030 2013031 20131101 2013110 20131105 20131106 20131107 20131108 | 20131111 2013 1112 20131113 20131114 20131115 20131118 | 20131119 20131120 20131121 20131122 20131125 20131125 20131127 20131128 20131129 20131202 20131203 2013120 | 20131205 | 2013120 2013 1209 | 20131210 2013 1211 20131212 | 20131213 | 20131216 20131217 20131218 2013 1219 20131220 2013 122 2013 122 2013 1225 20131226 20131227 | 20131230 20131231 20140101 20140102 20140103 20140106 20140107 20140108 | 20140109 160.15000000 41.2100 6000 179.21000000 0.7000000 179 23000000 40.9700tooo 180.27000000 41.42000000 177.85000000 41.38000000 179.19000000 41.4200000 1180.0000000 40.83000000 179.99000000 41.62000000 182.3800000|41.78000000 16307 000000 41.91000000 183.5500000|42.38000000 | 182.21000000 43.0200000 183.1900AO00 43.48000000 14.47000000 43.02000000 18523000000 43.04000000 1851900000 3.1000000 184.1300000 43.96000000 181,30000000 4.08000000 173.94000000 44.4500000 177.3100000|44.57000000 173.97000000 44.50000000 173.97000000 4.5000000 179.6800cm000 44.39000000 177.4000000 44.71000000 176.08000000 4.18000000 175.74000CO01 43.9100 6000 176.0000000 47.8700000 ITT.67000000 44.2100000 177.46000000 44.15000000 | 177.1200000 3.00 0000 175.20000000 42.14000000 173.37000000 43.47000000 172.0000000 43.46000000 177.85000000 43.1900 room 175 760000.00 42.87000000 13.70000000 42.00 Cond 10.22000000 42.0500000 180.02000000 42.60000000 182 23000000 43.00000000 183.22000000 3.34000000 163.22000000 43.34000000 185.35000000 | 43.39000000 185.0800000 43.4700 CD00 18641000000 43.84000000 187.5700000 43.72000000 18757000000) 43.72000000 1855100000 43.1500CO00 186.6400000 43.1700000 16.0000000 43.1000 CD00 189,71000000 43.54000000 18797booco 43.4700 bodo 187.38000000 43.82000000 35.54000000 35.4050000 35.52500000 5,94000000 36.54000000 38.1 B000000 37.50000000 377000000 37.59000000 37.36000000 38.15500000 38.02100000 37.84100000 37.20000000 35,74000000 37.A6000000 37 40000000 | 37.57000000 37.84000000 37.35000000 370000000 37.000000 38.13000000 38.45000000 38.31000000 38.94000000 39,00000000 38.36000000 38,70500000 38.11000000 37.10000 37.22000000 36.69000000 36.8600000 36.52000000] 36.5000000 36.25000000 36.40000000 36.6200000 37.0B000000 37,0000000 37 44000000 37.290000 37.29000000 37.41000000 37.41000000 37.16000000 3,81000000 3.13000000 36.41000000 35.76oooooo 35.53000000 | 2010110 20140113 | 2014011 | 20140115 | 20140116 20140117 20140120 2016121 2016122 20140123 2014012 201012 20140124 20140129 20140190 2014 01:31 20140203 | 20140204 20140205 20140206 20140207 2014 D210 20140211 20140212 20140213 2014021 | 20140217 20140218 20140219 2010220 20140221 2014022- | 20140275 20140226 20140227 2014022 20140909 | 2014030 20140305 | 20140306 2014 030 | 20140310 20140311 201404312 20140313 20103.1 2014-17 20140318 20140219 20140320 20140621 | 20140324 1872000000 3.7800*600 14.16000000 43.12000000 185.92000000 3.6600 0000 187.74000000|43.4300 2000 | 1183.76000000 44.0000000 190.0900000 44.22000000 10.09000000 4 2000000 183.43000000 44.1000000 182.2500wooo ,000000 182.73000000 44.90000000 179.64000000 42.7000000 177.90000000 4277000000 17645000000 2.34000000 176.4000000 41.5000000 177.36000000 42.5000000 176.a000000 42.7200000 172 90000000 41.01000000 172.4000000 41.72000000 174.24000000 41.5100000 17.7000000 0.74000000 177 25000000 40.28000000 177.1400000 40.6800000 179 70000AO000 41 46000000 160.2400mhoo 42.2600oooo 181.34000000 42.45000000 183.69000000|2.7400 2000 | 163.9000000 42.74000000 183.1900000 43.4700 6000 18295000000 43.4900 2000 16,26000000 44.980ooooo 182.7900000 4.5-300AO00 183.45000000 44.21000000 183 24000000 43.85000000 14.0600AO00 43.8300 roup 185 37000000 | 43.72000000 185.1700000 43.7100000 184,26000000 44.1800cb00 186.4400000 45.60000000 187.14000000 45.14000000 1874000000 45.74000000 187.A000000 5.75000000 186.39000000 | 45.74000000 18.700000 45.00 DD00 186.22000000 48.27000000 183.9000000 45.27000000 182.210000|45.21000000 185.81000000 | 45.2000000 186.4100000 45.63000000 100DDD 45.00 TMD00 18790000000 45.48000000 186.670ooooo | 45.3200oooo | 180.25000000 44.44000000 ,04000000 34,9010 35.7Bottooo 36,76000000 36.39000000 36.36000000 36,38000000 3.17000000 35.43000000 36,05500000 36.80500000 ,03000000 36.27000000 | 36,600000 36 6000000 37.84000000 36.48000000 3,35000000 35.82000000 3.16000000 3,56000000 3,8000000 3717500000 37.4700000 37. 1000000 37.62000000 37.620pp000 37.42000000 37.51000000 37.75000000 37.960000 37.69000000 37.54000000 37.47000000 37.86000000 38.3100000 37.7Booooo0 38.41000000 38.11000000 3.15000000 37.900000 37.42000000 38.020000 38.27000000 37 49000000 3770000000] 38.05000000 55000000 39.2700000 0.33000000 0.16000000 40.50000000 Date Intl Business Machines Corp Msci Inc Microsoft Corp 20130327 210.89000000 34.04000000 28.37000000 20130328 213.30000000 33.93000000 28.60500000 20130329 213.30000000 33.93000000 28.60500000 20130401 212.38000000 33.35000000 28.61000000 20130402 214.36000000 33.13000000 28.80000000 20130403 212.66000000 32.43000000 28.56000000 20130404 211.31000000 32.66000000 28.59500000 20130405 209.41000000 32.34000000 28.70000000 20130408 209.32000000 32.67000000 28.59000000 20130409 209.22000000 32.51000000 29.61000000 20130410 212.00000000 33.22000000 30.28000000 20130411 212.92000000 33.57000000 28.93500000 20130412 211.38000000 33.52000000 28.79000000 20130415 209.26000000 32.35000000 28.69000000 20130416 212.00000000 32.90000000 28.97000000 20130417 209.67000000 32.58000000 28.82500000 20130418 207.15000000 32.41000000 28.79000000 20130419 190.00000000 32.82000000 29.76500000 20130422 187.83000000 32.90000000 30.83000000 20130423 191.61000000 33.28000000 30.60000000 20130424 191.71000000 33.23000000 31.76000000 20130425 193.95000000 33 31000000 31.94000000 20130426 194.31000000 33.22000000 31.79000000 20130429 199.15000000 33.45000000 32.61000000 20130430 202.54000000 34.10000000 33.10000000 20130501 199.63000000 33.26000000 32.72000000 20130502 202.39000000 33.65000000 33.16000000 20130503 204.51000000 33.32000000 33.49000000 20130506 202.78000000 33.33000000 33.75000000 20130507 203.63000000 33.56000000 33.31000000 20130508 204.82000000 34.14000000 32.99000000 20130509 203.24000000 33.86000000 32.66000000 20130510 204.47000000 33.95000000 32.69000000 20130513 202.47000000 33.94000000 33 03000000 20130514 203.21000000 34.45000000 33.53000000 20130515 203.32000000 34.26000000 33.84500000 20130516 204.69000000 34.57000000 34.08000000 20130517 208.44000000 34.66000000 34.87000000 20130520 207.60000000 34.53000000 35.08000000 20130521 208.65000000 34.72000000 34.85000000 20130522 206.99000000 34.24000000 34.61000000 20130523 206.16000000 34.49000000 34.15000000 20130524 205.72000000 34.47000000 34.26900000 20130527 205.72000000 34.47000000 34.26900000 20130528 207.78000000 35.04000000 35.02000000 20130529 207.92000000 35.22000000 34.88000000 20130530 209.36000000 35.73000000 35,03000000 20130531 208.02000000 35.24000000 34.90000000 20130603 208.95000000 35.17000000 35.59000000 20130604 206.19000000 34.98000000 34.99000000 20130605 202.74000000 34.28000000 34.78000000 2014035 20144032 | 20140327 19540ooooo 42.7200000 192.62000000 41.77000000 19.300DM000 41.87000000 0.34000000 39.79000000 39.36000000