1) Use the 3-month LIBOR as attached: 3month_LIBOR.xlsx ( 3month_LIBOR.xlsx ). https://1drv.ms/x/c/93eb7036ae3cd992/EYRb0xLD7NFJpS-Dt0Thd-MBF-DUqDE0FoRrdORcv_-QiQ
2) Download daily “3-month Treasury Constant Maturity Rate” from Jan. 2, 2019, to Dec 29, 2023.
(https://fred.stlouisfed.org/series/DGS3MO)
3) Compute the daily average rate of return and standard deviation with a 3-month T-bill rate over the sample period,
4) Plot the cumulative rate of return (X-axis: Date, Y-axis: Cumulative Return) from 3). Explain the plot thoroughly.
5) Compare the daily average return and standard deviation from Part 1 and Part 2. Explain any similarities or differences.
6) Calculate daily TED spreads over the sample period. (TED Spread = 3-month LIBOR – 3-month Treasury Constant Maturity Rate.)
7) Plot the TED spreads (X-axis: Date, Y-axis: TED Spread) over the sample period. Explain the plot by identifying periods of stress or relaxation in the financial markets.
1) Use the 3-month LIBOR as attached: 3month_LIBOR.xlsx ( 3month_LIBOR.xlsx ). h
Important - Read this before proceeding
These instructions reflect a task our writers previously completed for another student. Should you require assistance with the same assignment, please submit your homework details to our writers’ platform. This will ensure you receive an original paper, you can submit as your own. For further guidance, visit our ‘How It Works’ page.
