1.Go to the U.S. Federal Reserve Bank website (or other appropriate data source). There you will find a database (Downloadable into Excel) that will provide you data for the (nominal) U.S. yield curve. Plot the yield curve for the following dates (see figure 5.4 from the textbook as an example).
a.First week of June 1981
b.First week of June 1991
c.First week of June 2001
d.First week of June 2011
e.First week of June 2021
2.Go to the Bank of Canada website (or other appropriate data source). Plot the Canadian (zero-coupon bond) Yield curve for:
a.First week of June 2011
b.First week of June 2021
3.What are the next three rate policy dates for the Bank of Canada? Explain what you believe their next policy rate value will be. (This should be really easy to do!)
4.Construct a live Excel sheet that takes as inputs:
a)The time to maturity of a bond
b)The yield to maturity of a bond
c)The coupon rate of a bond
Your output will be the price of the bond. Assume that the bond pays semi-annual coupons.
0 comments