The Assignment A for this Workshop is to perform an analysis which, given a Treasury yield...

Transcribed Image Text:

The Assignment A for this Workshop is to perform an analysis which, given a Treasury yield curve, computes the corresponding spot rates. You will be working with daily yield data for 2021. In all computations for this question, assume that the bonds are trading at par; i.e., S == F. The work involved is the following: 1. Load the necessary data. The required URL and Import[] logic are provided below. 1.1. Download the daily Treasury yield curves for 2020. 1.2. Use TableForm[] to provide a formatted output for the data. 1.3. For each column of data (i.e., the term of the note or bond) in the yield curves, compute the mean yield experienced over the year 2020. This mean yield curve is what will be used in all further computations. 1.4. Build an order-2 interpolation function for the observed yields for the observed periods; i.e., one month out to 30 years. 1.5. DateListPlot[] to plot the points of the mean yield curve. 1.6. Use Plot[] to plot the interpolated yield from one month to 30 years. 2. Using the interpolated yield function produced in 1.4 above, bootstrap the spot rates for the same monthly periods in the yields and for every year from one out to 30, inclusive. Assume that the price of each instrument is the same as its face value. Without loss of generality, as long as the coupon amounts (i.e., base the coupons on the appropriate yield) and prices are consistent the actual price assumed may as well be $1. 3. Using TableForm [], produce a table showing the values of the yields and spot rates for each term in the original data. The Assignment A for this Workshop is to perform an analysis which, given a Treasury yield curve, computes the corresponding spot rates. You will be working with daily yield data for 2021. In all computations for this question, assume that the bonds are trading at par; i.e., S == F. The work involved is the following: 1. Load the necessary data. The required URL and Import[] logic are provided below. 1.1. Download the daily Treasury yield curves for 2020. 1.2. Use TableForm[] to provide a formatted output for the data. 1.3. For each column of data (i.e., the term of the note or bond) in the yield curves, compute the mean yield experienced over the year 2020. This mean yield curve is what will be used in all further computations. 1.4. Build an order-2 interpolation function for the observed yields for the observed periods; i.e., one month out to 30 years. 1.5. DateListPlot[] to plot the points of the mean yield curve. 1.6. Use Plot[] to plot the interpolated yield from one month to 30 years. 2. Using the interpolated yield function produced in 1.4 above, bootstrap the spot rates for the same monthly periods in the yields and for every year from one out to 30, inclusive. Assume that the price of each instrument is the same as its face value. Without loss of generality, as long as the coupon amounts (i.e., base the coupons on the appropriate yield) and prices are consistent the actual price assumed may as well be $1. 3. Using TableForm [], produce a table showing the values of the yields and spot rates for each term in the original data.

Answer rating: 100% (QA)

To perform the analysis and compute the spot rates for the given Treasury yield curve data we will follow the steps outlined in the assignment Step 1 ... View the full answer