I would like you to answer myassignment by following the details provided.

profileCaiden
assignment-tips.pptx

Assignment tips

Yield curve formation example

Time to maturity YTM note
1 yr 2 yrs 3yrs 5 yrs 8% 8.5% 8.9% 9.2% One year T-bond Two year T-bond Three year T-bond five year T-bond
Time to maturity YTM note
1 yr 2 yrs 3yrs 5 yrs 8% 8.5% 8.9% 9.2% One year T-bond Two year T-bond Three year T-bond five year T-bond

How the slope of the Yield is derived

  March February January
3-month Treasury bill rate (percent) 0.10 0.13 0.08
10-year Treasury bond rate (percent) 2.04 2.00 1.87
Yield curve slope (basis points) 194 187 179

yield curve

7.40%

7.60%

7.80%

8.00%

8.20%

8.40%

8.60%

8.80%

9.00%

9.20%

9.40%

1235

TTM

Series1

Chart1

1
2
3
5
TTM
YTM
yield curve
0.08
0.085
0.089
0.092

Sheet1

1 8.00%
2 8.50%
3 8.90%
5 9.20%

Sheet1

time to maturity
ytm
yiled curve

Sheet2

TTM
YTM
yield curve

Sheet3