In: Finance
Compute the daily interest (yield) changes, ∆y = y(t) − y(t − 1), for the 10 year constant yields over time. Also, please show the calculations you use for the first 5 answers
| Date | 10 year Treasury Constant Maturity Rate | △Y | 
| 2015-01-02 | 2.12 | |
| 2015-01-05 | 2.04 | |
| 2015-01-06 | 1.97 | |
| 2015-01-07 | 1.96 | |
| 2015-01-08 | 2.03 | |
| 2015-01-09 | 1.98 | |
| 2015-01-12 | 1.92 | |
| 2015-01-13 | 1.91 | |
| 2015-01-14 | 1.86 | |
| 2015-01-15 | 1.77 | |
| 2015-01-16 | 1.83 | |
| 2015-01-19 | #N/A | |
| 2015-01-20 | 1.82 | |
| 2015-01-21 | 1.87 | |
| 2015-01-22 | 1.90 | |
| 2015-01-23 | 1.81 | |
| 2015-01-26 | 1.83 | |
| 2015-01-27 | 1.83 | |
| 2015-01-28 | 1.73 | |
| 2015-01-29 | 1.77 | |
| 2015-01-30 | 1.68 | |
| 2015-02-02 | 1.68 | |
Daily interest rate change for a day = △Y = Y(t) - Y(t-1)
where Y(t) = 10 year treasury constant maturity rate for the day and Y(t-1) = 10 year treasury constant maturity rate for previous trading day
Daily interest rate change for 05-01-2015 = 10 year treasury constant maturity rate for 05-01-2015 - 10 year treasury constant maturity rate for 02-01-2015 = 2.04 - 2.12 = -0.08
Daily interest rate change for 06-01-2015 = 10 year treasury constant maturity rate for 06-01-2015 - 10 year treasury constant maturity rate for 05-01-2015 = 1.97 - 2.04 = -0.07
Daily interest rate change for 07-01-2015 = 10 year treasury constant maturity rate for 07-01-2015 - 10 year treasury constant maturity rate for 06-01-2015 = 1.96 - 1.97 = -0.01
Daily interest rate change for 08-01-2015 = 10 year treasury constant maturity rate for 08-01-2015 - 10 year treasury constant maturity rate for 07-01-2015 = 2.03 - 1.96 = 0.07
Daily interest rate change for 09-01-2015 = 10 year treasury constant maturity rate for 09-01-2015 - 10 year treasury constant maturity rate for 08-01-2015 = 1.98 - 2.03 = -0.05
Similarly values can be calculated for other days, As there no value available of yield for 19-01-2015, hence we will not calculate daily interest change for 19-01-2015 and 20-01-2015.
We get the following table
| Date | 10 year Treasury Constant Maturity Rate | △Y | 
| 02-01-2015 | 2.12 | |
| 05-01-2015 | 2.04 | -0.08 | 
| 06-01-2015 | 1.97 | -0.07 | 
| 07-01-2015 | 1.96 | -0.01 | 
| 08-01-2015 | 2.03 | 0.07 | 
| 09-01-2015 | 1.98 | -0.05 | 
| 12-01-2015 | 1.92 | -0.06 | 
| 13-01-2015 | 1.91 | -0.01 | 
| 14-01-2015 | 1.86 | -0.05 | 
| 15-01-2015 | 1.77 | -0.09 | 
| 16-01-2015 | 1.83 | 0.06 | 
| 19-01-2015 | #N/A | #N/A | 
| 20-01-2015 | 1.82 | #N/A | 
| 21-01-2015 | 1.87 | 0.05 | 
| 22-01-2015 | 1.9 | 0.03 | 
| 23-01-2015 | 1.81 | -0.09 | 
| 26-01-2015 | 1.83 | 0.02 | 
| 27-01-2015 | 1.83 | 0.00 | 
| 28-01-2015 | 1.73 | -0.10 | 
| 29-01-2015 | 1.77 | 0.04 | 
| 30-01-2015 | 1.68 | -0.09 | 
| 02-02-2015 | 1.68 | 0.00 |