how can I add the excel sheet?

D E F G H IK M N P Using the data in worksheet YieldsUSD, consider the yield curves on 30 Apr 1974 and 31 Oct 2001 Suppose that you live in a Vasiced world For both dates find the parameters R_0 (short rate today), kappa (reversion speed), and theta (reversion level) that best fit the two yield curves. Estimate the Vasicek yields by using the expectations of the short rate neglecting convexity, NOT the closed-form expression for the yield. Based on this fit, on both dates, which-maturity bonds would you have bought and which ones would you have sold if you believe in the Vasicek model? Just by looking at the two yield curves, what do you think inflation expectations were on 30 Apr 1974 and on 31 Oct 2021? What about the state of the economy? B D E F G H K L M N Yields in percentage points for maturities 1 to 10 years. These are the yields, y(t,t) in P(t,T) = exp[-y(t,T) * (T-t)], and P(t,T) 1 2 3 4 6 6 7 8 9 10 31-Dec-71 4.354162 4.791196 5.108662 5.343862 5.520015 5.65539 5.760985 5.844772 5.912345 5.96768 31-Jan-72 4.24298 4.9197 5.331099 5.594204 5.770983 5.895829 5.986439 6.055598 6.109691 6.153078 29-Feb-72 4.203598 4.847638 5.258242 5.530596 5.718486 5.853054 5.952814 6.029088 6.089002 6.137175 31-Mar-72 5.02078 5.571516 5.814833 5.943781 6.022099 6.07444 6.111844 6.139899 6.161721 6.179178 30-Apr-72 4.54588 5.176614 5.52613 5.735484 5.870263 5.962647 6.029353 6.079591 6.118726 6.150053 4.568982 5.06066 5.387028 5.610614 5.768717 5.8840125.970569 6.03731 6.090023 6.132552 30-Jun-72 5.076862 5.508857 5.736798. 5.869119 5.952791 6.009611 6.050457 6.081157 6.105052 6.124173 31-Jul-72 4.777276 5.398942 5.69029 5.84877 5.945988 6.011069 6.057652 6.0926 6.119784 6.141531 31-Aug-72 5.3263 5.723706 5.947801 6.083616 6.17168 6.282284 6.276135 6.309193 6.334957 6.355585 30-Sep-72 5.443795 5.819477 6.014534 6.126665 6.197201 6.244981 6.279291 6.305068 6.325127 6.341177 31-Oct-72 5.443668 5.841855 6.01996 6114829 6.172547 6.211188 6.23872 6.259409 6.275501 6.288375 30-Nov-72 5.32231 5.69649 5.891862 6.004553 6.075567 6.128712 6.158297 6.184283 6.204507 6.220689 31-Dec-72 5.657006 5.920408 6.0546896.131057 6.178831 6.211111 6.294267 6.251656 6.265186 6.276011 31-Jan-73 6.1379096.278958 6.329152 6.352081 6.865015 6.873412 6.379354 6.388797 6.38725 6.390012 28-Feb-73 6.43448 6.59703 6.636906 6.629029 6.605366 6.578886 6.654848 8.538097 6.515159 6.500119 31-Mar-73 6.990484 6.867873 6.767522 6.704806 6.669906 6.68653 6.616899 6.602162 6.590698 6.581526 30-Apr-73 6.731442 6.70186 6.660324 6.63505 6.619808 6.608847 8.60108T 6.595698 6.591307 6.587799 ######### 7.034226 6.820018 6.741526 6.70227 6.678716 6.668018 6.650797 0.643385 6.636842 6.631608 30-Jun-73 7.588722 7.098127 6.919373 6.8299576.776307 Gwa054 614990 6.695882 6.680929 6.669007 31-Jul-73 8.694604 8.066407 7758796 7.599983 7,50448 440802995318 361205 7.334672 7.313446 eldsUSD Problem 1 Problem 2 Problem 3 Problem Cells Editing N B. D E F G H K L M 31-Aug-73 8.294437 7.620825 7.285406 7.119972 7.0396687.001766 6.984802 6.978035 6.9761196.976417 30-Sep-73 7.271147 6.867648 6.669995 6.590123 6.575635 6.595703 6.632471 6.675827 6.72024 6.762853 31-Oct-73 7.002675 6.75096 6.685928 6.663135 6.651978 6.645098 6.640301 6.636726 6.63395 6.63173 30-Nov-73 7.182191 6.812505 6.689144 6.627463 6.590455 6.565782 6.5481596.534942 6.524662 6.516438 31-Dec-73 7.202427 6.788452 6.678153 6.663157 6.674683 6.691082 6.706235 6.718907 6.72925 6.737703 31-Jan-74 6.992641 6.734656 6.719091 6.757668 6.800057 6.835372 6.863048 6.884632 6.901694 6.915435 28-Feb-74 6.988122 6.814953 6.825326 6.842358 6.854131 6.862165 6.867926 6.872248 6.875611 6.878301 31-Mar-74 8.157268 7.727641 7.567799 7.487153 7.438732 7.40645 7.383391 7.366097 Z.352646 7.341885 30-Apr-74 8.780782 8.313789 3.080198 7.948774 7.866989 7.811856 7.772343 7.74268 7.719602 7.701139 * 8.453975 8.072947 7.901994 7.810816 7.755321 7.71821 7.691685 7.671789 7.656314 7.643934 30-Jun-74- 8.545928 8.301757 8.132798. 8.012988 7.925896 7.861019 7.811535 7.772943 7.742219 7.717297 31-Jul-74 8.647321 8.525108 8.407003 8.292851 8.182502 8.075814 7.972648 7.872874 7.776365 7.683 31-Aug-74. 9.441083 8.792225 8.498849 8.348335 8.257864 8.197543 8.154457 8.122142 8.097008 8.076901 30-Sep-74 8.066429 7.971256 7.908891 7.875811 7.855865 7.842564 7.833063 7.825937 7.820394 7.81596 31-Oct-74 7.7573 7.771225 7.770874 7.7577287.733143 7.69836 7.654516 7.602647 7.543701 7.478543 30-Nov-74 7.410717 7.401289 7.391271 7.38084 7.369976 7.358706 7.347054 7.335046 7.322705 7.310054 31-Dec-74 7.144667 7.153767 7.157061 7.158708 7.159696 7.160355 7.160825 7.161178 7.161453 7.161672 31-Jan-75 6.238884 6.670026 6.910766 7.041402 71120725 7.173689 7.211528 7.239907 7.26198 7.279638 28-Feb-75 5.916754 6.278823 6.594526 6.800582 6.934522 7.0259 7.09158 7.14092 7.17931 7.210025 31-Mar-75 6.241704 6.757098 7.029764 7.176597 7 265656 7.8251127367588 7.399445 7.424224 7.444046 30-Apr-75 6.791323 7.412003 7.642909 7.758737828228 7.87456 7.907654 7.932475 7.95178 7.967224 ######### 6.106194 6.781078 7.132689 7.32714 7.446869 7.526196 758326 7.626064 7.659356 7.68599 7.62125 30-Jun-75 6.7608397.1348597.845354 7.464416 7.582246 7571287 7.594085 7.607667 7.615981 775 268 7788416 7.725472 7.714215 31-Jul-75 7.182333 7.571362 7.721802 7.769942 7776166766727 YieldsUSD Problem 1 Problem 2 Problem Problem 4 N B C D E F G H J K M 6.106194 6.781078 7.132689 7.32714 7.446369 7.526196 7.58326 7.626064 7.659356 7.68599 30-Jun-75 6.760839 7.134859 7.345354 7.464416 7.532246 7.571287 7.594085 7.607667 7.615981 7.62125 31-Jul-75 7.182333 7.571362 7.721802 7.769942 7.776166 7.766727 7.75268 7.738416 7.725472 7.714215 31-Aug-75 7.343583 7.680185 7.818212 7.873644 7.894988 7.902454 7.904411 7.904291 7.903473 7.902495 30-Sep-75 7.542572 7.948055 8.10542 8.1608 8.175485 8.174841 8.169133 8.162346 8.155907 8.150227 31-Oct-75 6.343828 6.926467 7.248536 7.428004 7.538085 7.611771 7.664441 7.703948 7.734676 7.759258 30-Nov-75 6.585255 7.14157 7.436603 7.606706 7.713088 7.784598 7.835622 7.873793 7.903423 7.927098 31-Dec-75 6.132501 6.694378 7.026044 7.231367 7.365675 7.458391 7.525532 7.576154 7.615605 7.647187 31-Jan-76 5.562749 6.402937 6.886578 7.160338 7.329107 7.442231 7.523114 7.583788 7.630979 7.668733 29-Feb-76 6.095195 6.737825 7.05579 7.22868 7.334174 7.40472 7.455137 7.492953 7.522365 7.545895 31-Mar-76 6.026208 6.631534 6.955598. 7.14541 7.266025 7.348131 7.407218 7.45165 7.486239 7.513919 30-Apr-76 5.989143 6.581984 6.910413 7.1071 7.23371 7.320489 7.383147 7.430335 7.467094 7.496519 6.699513 7.201074 7.423787 7.536549 7.601623 7.64356 7.672919 7.694716 7.711592 7.725066 -30-Jun-76 6.393175 6.883009 7.158252 7.324665 7.43241 7.506496 7.560078 7.600464 7.631935 7.657131 31-Jul-76 6.116084 6.668979 7.000798 7.2109897.351281 7.449538 7.521343 7.575766 7.618296 7.652393 31-Aug-76 5.927478 6.442705 6.7808 7.010273 7.171367 7.288213 7.375596 7.442795 7.495777 7.538474 30-Sep-76 5.80559 6.250972 6.575996 6.817253 6.999466 7.139505 - 7.2489937.336032 7.406331 7.463963 31-Oct-76 5.542671 5.992233 6.330944 6.589555 6.789716 6.946783 7.071736 7.172487 7.25479 7.322868 30-Nov-76 5.017973 5.36609 5.671781 5.940863 6.178302 6.388344 6.574621 6.740247 6.887894 7.019858 31-Dec-76 4.931329 5.360665 5.707722 5.979706 6.190744 6.354768 6.483328 6.585324 6.667384 6.73437 31-Jan-77 5.655414 6.16855 6.500975 6.724226 6.879656 6.991692 7.075105 7.139054 7.189371 7.229868 28-Feb-77 5.530458 6.094023 6.467998 6.724114 6.905162 7.037153 7.136221 7.212594 7.272906 7.321561 31-Mar-77 5.427464 5.993653 6.392266 6.673139 6.874026 7.020935 7.131111 7.21587 7.282657 7.336439 30-Apr-77 5.506987 6.049413 6.424761 6.690926 6.884407 7.028538 7.138472 7.224209 7.292466 7.347832 YieldsUSD Problem 1 Problem 2 Problem 3 Problem 4 1 D E F G H IK M N P Using the data in worksheet YieldsUSD, consider the yield curves on 30 Apr 1974 and 31 Oct 2001 Suppose that you live in a Vasiced world For both dates find the parameters R_0 (short rate today), kappa (reversion speed), and theta (reversion level) that best fit the two yield curves. Estimate the Vasicek yields by using the expectations of the short rate neglecting convexity, NOT the closed-form expression for the yield. Based on this fit, on both dates, which-maturity bonds would you have bought and which ones would you have sold if you believe in the Vasicek model? Just by looking at the two yield curves, what do you think inflation expectations were on 30 Apr 1974 and on 31 Oct 2021? What about the state of the economy? B D E F G H K L M N Yields in percentage points for maturities 1 to 10 years. These are the yields, y(t,t) in P(t,T) = exp[-y(t,T) * (T-t)], and P(t,T) 1 2 3 4 6 6 7 8 9 10 31-Dec-71 4.354162 4.791196 5.108662 5.343862 5.520015 5.65539 5.760985 5.844772 5.912345 5.96768 31-Jan-72 4.24298 4.9197 5.331099 5.594204 5.770983 5.895829 5.986439 6.055598 6.109691 6.153078 29-Feb-72 4.203598 4.847638 5.258242 5.530596 5.718486 5.853054 5.952814 6.029088 6.089002 6.137175 31-Mar-72 5.02078 5.571516 5.814833 5.943781 6.022099 6.07444 6.111844 6.139899 6.161721 6.179178 30-Apr-72 4.54588 5.176614 5.52613 5.735484 5.870263 5.962647 6.029353 6.079591 6.118726 6.150053 4.568982 5.06066 5.387028 5.610614 5.768717 5.8840125.970569 6.03731 6.090023 6.132552 30-Jun-72 5.076862 5.508857 5.736798. 5.869119 5.952791 6.009611 6.050457 6.081157 6.105052 6.124173 31-Jul-72 4.777276 5.398942 5.69029 5.84877 5.945988 6.011069 6.057652 6.0926 6.119784 6.141531 31-Aug-72 5.3263 5.723706 5.947801 6.083616 6.17168 6.282284 6.276135 6.309193 6.334957 6.355585 30-Sep-72 5.443795 5.819477 6.014534 6.126665 6.197201 6.244981 6.279291 6.305068 6.325127 6.341177 31-Oct-72 5.443668 5.841855 6.01996 6114829 6.172547 6.211188 6.23872 6.259409 6.275501 6.288375 30-Nov-72 5.32231 5.69649 5.891862 6.004553 6.075567 6.128712 6.158297 6.184283 6.204507 6.220689 31-Dec-72 5.657006 5.920408 6.0546896.131057 6.178831 6.211111 6.294267 6.251656 6.265186 6.276011 31-Jan-73 6.1379096.278958 6.329152 6.352081 6.865015 6.873412 6.379354 6.388797 6.38725 6.390012 28-Feb-73 6.43448 6.59703 6.636906 6.629029 6.605366 6.578886 6.654848 8.538097 6.515159 6.500119 31-Mar-73 6.990484 6.867873 6.767522 6.704806 6.669906 6.68653 6.616899 6.602162 6.590698 6.581526 30-Apr-73 6.731442 6.70186 6.660324 6.63505 6.619808 6.608847 8.60108T 6.595698 6.591307 6.587799 ######### 7.034226 6.820018 6.741526 6.70227 6.678716 6.668018 6.650797 0.643385 6.636842 6.631608 30-Jun-73 7.588722 7.098127 6.919373 6.8299576.776307 Gwa054 614990 6.695882 6.680929 6.669007 31-Jul-73 8.694604 8.066407 7758796 7.599983 7,50448 440802995318 361205 7.334672 7.313446 eldsUSD Problem 1 Problem 2 Problem 3 Problem Cells Editing N B. D E F G H K L M 31-Aug-73 8.294437 7.620825 7.285406 7.119972 7.0396687.001766 6.984802 6.978035 6.9761196.976417 30-Sep-73 7.271147 6.867648 6.669995 6.590123 6.575635 6.595703 6.632471 6.675827 6.72024 6.762853 31-Oct-73 7.002675 6.75096 6.685928 6.663135 6.651978 6.645098 6.640301 6.636726 6.63395 6.63173 30-Nov-73 7.182191 6.812505 6.689144 6.627463 6.590455 6.565782 6.5481596.534942 6.524662 6.516438 31-Dec-73 7.202427 6.788452 6.678153 6.663157 6.674683 6.691082 6.706235 6.718907 6.72925 6.737703 31-Jan-74 6.992641 6.734656 6.719091 6.757668 6.800057 6.835372 6.863048 6.884632 6.901694 6.915435 28-Feb-74 6.988122 6.814953 6.825326 6.842358 6.854131 6.862165 6.867926 6.872248 6.875611 6.878301 31-Mar-74 8.157268 7.727641 7.567799 7.487153 7.438732 7.40645 7.383391 7.366097 Z.352646 7.341885 30-Apr-74 8.780782 8.313789 3.080198 7.948774 7.866989 7.811856 7.772343 7.74268 7.719602 7.701139 * 8.453975 8.072947 7.901994 7.810816 7.755321 7.71821 7.691685 7.671789 7.656314 7.643934 30-Jun-74- 8.545928 8.301757 8.132798. 8.012988 7.925896 7.861019 7.811535 7.772943 7.742219 7.717297 31-Jul-74 8.647321 8.525108 8.407003 8.292851 8.182502 8.075814 7.972648 7.872874 7.776365 7.683 31-Aug-74. 9.441083 8.792225 8.498849 8.348335 8.257864 8.197543 8.154457 8.122142 8.097008 8.076901 30-Sep-74 8.066429 7.971256 7.908891 7.875811 7.855865 7.842564 7.833063 7.825937 7.820394 7.81596 31-Oct-74 7.7573 7.771225 7.770874 7.7577287.733143 7.69836 7.654516 7.602647 7.543701 7.478543 30-Nov-74 7.410717 7.401289 7.391271 7.38084 7.369976 7.358706 7.347054 7.335046 7.322705 7.310054 31-Dec-74 7.144667 7.153767 7.157061 7.158708 7.159696 7.160355 7.160825 7.161178 7.161453 7.161672 31-Jan-75 6.238884 6.670026 6.910766 7.041402 71120725 7.173689 7.211528 7.239907 7.26198 7.279638 28-Feb-75 5.916754 6.278823 6.594526 6.800582 6.934522 7.0259 7.09158 7.14092 7.17931 7.210025 31-Mar-75 6.241704 6.757098 7.029764 7.176597 7 265656 7.8251127367588 7.399445 7.424224 7.444046 30-Apr-75 6.791323 7.412003 7.642909 7.758737828228 7.87456 7.907654 7.932475 7.95178 7.967224 ######### 6.106194 6.781078 7.132689 7.32714 7.446869 7.526196 758326 7.626064 7.659356 7.68599 7.62125 30-Jun-75 6.7608397.1348597.845354 7.464416 7.582246 7571287 7.594085 7.607667 7.615981 775 268 7788416 7.725472 7.714215 31-Jul-75 7.182333 7.571362 7.721802 7.769942 7776166766727 YieldsUSD Problem 1 Problem 2 Problem Problem 4 N B C D E F G H J K M 6.106194 6.781078 7.132689 7.32714 7.446369 7.526196 7.58326 7.626064 7.659356 7.68599 30-Jun-75 6.760839 7.134859 7.345354 7.464416 7.532246 7.571287 7.594085 7.607667 7.615981 7.62125 31-Jul-75 7.182333 7.571362 7.721802 7.769942 7.776166 7.766727 7.75268 7.738416 7.725472 7.714215 31-Aug-75 7.343583 7.680185 7.818212 7.873644 7.894988 7.902454 7.904411 7.904291 7.903473 7.902495 30-Sep-75 7.542572 7.948055 8.10542 8.1608 8.175485 8.174841 8.169133 8.162346 8.155907 8.150227 31-Oct-75 6.343828 6.926467 7.248536 7.428004 7.538085 7.611771 7.664441 7.703948 7.734676 7.759258 30-Nov-75 6.585255 7.14157 7.436603 7.606706 7.713088 7.784598 7.835622 7.873793 7.903423 7.927098 31-Dec-75 6.132501 6.694378 7.026044 7.231367 7.365675 7.458391 7.525532 7.576154 7.615605 7.647187 31-Jan-76 5.562749 6.402937 6.886578 7.160338 7.329107 7.442231 7.523114 7.583788 7.630979 7.668733 29-Feb-76 6.095195 6.737825 7.05579 7.22868 7.334174 7.40472 7.455137 7.492953 7.522365 7.545895 31-Mar-76 6.026208 6.631534 6.955598. 7.14541 7.266025 7.348131 7.407218 7.45165 7.486239 7.513919 30-Apr-76 5.989143 6.581984 6.910413 7.1071 7.23371 7.320489 7.383147 7.430335 7.467094 7.496519 6.699513 7.201074 7.423787 7.536549 7.601623 7.64356 7.672919 7.694716 7.711592 7.725066 -30-Jun-76 6.393175 6.883009 7.158252 7.324665 7.43241 7.506496 7.560078 7.600464 7.631935 7.657131 31-Jul-76 6.116084 6.668979 7.000798 7.2109897.351281 7.449538 7.521343 7.575766 7.618296 7.652393 31-Aug-76 5.927478 6.442705 6.7808 7.010273 7.171367 7.288213 7.375596 7.442795 7.495777 7.538474 30-Sep-76 5.80559 6.250972 6.575996 6.817253 6.999466 7.139505 - 7.2489937.336032 7.406331 7.463963 31-Oct-76 5.542671 5.992233 6.330944 6.589555 6.789716 6.946783 7.071736 7.172487 7.25479 7.322868 30-Nov-76 5.017973 5.36609 5.671781 5.940863 6.178302 6.388344 6.574621 6.740247 6.887894 7.019858 31-Dec-76 4.931329 5.360665 5.707722 5.979706 6.190744 6.354768 6.483328 6.585324 6.667384 6.73437 31-Jan-77 5.655414 6.16855 6.500975 6.724226 6.879656 6.991692 7.075105 7.139054 7.189371 7.229868 28-Feb-77 5.530458 6.094023 6.467998 6.724114 6.905162 7.037153 7.136221 7.212594 7.272906 7.321561 31-Mar-77 5.427464 5.993653 6.392266 6.673139 6.874026 7.020935 7.131111 7.21587 7.282657 7.336439 30-Apr-77 5.506987 6.049413 6.424761 6.690926 6.884407 7.028538 7.138472 7.224209 7.292466 7.347832 YieldsUSD Problem 1 Problem 2 Problem 3 Problem 4 1