Question: This problem is to be solved and presented on Excel. From the Bank of Canada website obtain the following data (on excel): A. 1-Month Treasury
This problem is to be solved and presented on Excel. From the Bank of Canada website obtain the following data (on excel): A. 1-Month Treasury Bills Yields at daily frequency from Jan 1, 2019 till Sep 30, 2022. (1 pt) B. 10-Year Bonds Yields at daily frequency from Jan 1, 2019 till Sep 30, 2022. (1 pt) C. Draw on the same graph the 1-Month Treasury Bills Yields and the 10-Year Bonds Yields that you have obtained from steps A and B above. (3 pts) D. What do you observe? Can you link the trends that you observe to some events happening around you? ( 1.5pts) This problem is to be solved and presented on Excel. From the Bank of Canada website obtain the following data (on excel): A. 1-Month Treasury Bills Yields at daily frequency from Jan 1, 2019 till Sep 30, 2022. (1 pt) B. 10-Year Bonds Yields at daily frequency from Jan 1, 2019 till Sep 30, 2022. (1 pt) C. Draw on the same graph the 1-Month Treasury Bills Yields and the 10-Year Bonds Yields that you have obtained from steps A and B above. (3 pts) D. What do you observe? Can you link the trends that you observe to some events happening around you? ( 1.5pts)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
