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.5 pts) 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.5 pts)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
