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.
Leave a Reply
You must be logged in to post a comment.