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.)

Don't use plagiarized sources. Get Your Custom Essay on
Module II: Excel Assignment – Part 1
Just from $13/Page
Order Essay

   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.  

Calculate your order
Pages (275 words)
Standard price: $0.00
Client Reviews
4.9
Sitejabber
4.6
Trustpilot
4.8
Our Guarantees
100% Confidentiality
Information about customers is confidential and never disclosed to third parties.
Original Writing
We complete all papers from scratch. You can get a plagiarism report.
Timely Delivery
No missed deadlines – 97% of assignments are completed in time.
Money Back
If you're confident that a writer didn't follow your order details, ask for a refund.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00
Power up Your Academic Success with the
Team of Professionals. We’ve Got Your Back.
Power up Your Study Success with Experts We’ve Got Your Back.
Live Chat+1(978) 822-0999EmailWhatsApp

Order your essay today and save 20% with the discount code GOODESSAY