Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The Assignment A for this Workshop is to perform an analysis which, given a Treasury yield curve, computes the corresponding spot rates. You will
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.
Step by Step Solution
★★★★★
3.55 Rating (162 Votes )
There are 3 Steps involved in it
Step: 1
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 ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started