SUPERIOR-PAPERS.COM essay writing company is the ideal place for homework help. If you are looking for affordable, custom-written, high-quality and non-plagiarized papers, your student life just became easier with us. Click the button below to place your order.
Order a Similar Paper Order a Different Paper
Module II: Excel Assignment – Part 1
Part 1: Analyzing “stock market condition”. (Note: Collect S&P500 index prices using Yahoo! Finance.)
1) From Nasdaq (https://www.nasdaq.com/market-activity/index/spx/historical), download S&P500 daily index prices over the period from Dec. 31, 2019, to Jun 30, 2021. (Note: Select 5Y and find the data range.)
2) Calculate daily S&P500 index returns and daily cumulative returns over the sample period.
3) Plot the cumulative returns and analyze the plot.
Module II: Excel Assignment – Part 2
Part 2: Analyzing “TED Spread”. (Note: Use FRED Economic Research Data.)
1) Download daily “3-month London Interbank Offered Rate (LIBOR), based on U.S. Dollar” over the period from Dec.31, 2019, to Jun 30, 2021. ( https://fred.stlouisfed.org/series/USD3MTD156N )
2) Download daily “3-month Treasury Constant Maturity Rate” from Dec.31, 2019, to Jun 30, 2021. ( https://fred.stlouisfed.org/series/DGS3MO)
3) Calculate daily TED spreads over the sample period.
4) Plot the spreads and analyze the plot.