Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please download daily price data for S&P500 index, Costco, General Motors stocks and the exchange rates between CAD and USD in year 2020 using Yahoo

  1. Please download daily price data for S&P500 index, Costco, General Motors stocks and the exchange rates between CAD and USD in year 2020 using Yahoo Finance.

    1. (a) Plot daily prices of General Motors (GM) along with its 50-day moving averages from March 23, 2020 to December 31, 2020. What are the highest and lowest prices of GM in 2020?

    2. (b) Compare two investment plans with the same initial capital, one holds Costco only, and the other purchases S&P500 index ETF only. Which one has higher variation in 2020? Provide risk measures.

    3. (c) Compared with Costco and General Motors, which stock is cyclical and which is defensive? Cal- culate the beta of both stocks to support your conclusion. ( = cov(ri,rm))

      m2

    4. (d) A Canadian investor and purchased GM stock at $26.5 per share on March 10 and held it until the end of that year. The investor exchanged CAD to USD at 0.731 on March 10. During that period, did the Canadian dollar appreciate or depreciate compared with USD? What are your investment returns in US dollar and in Canadian dollar?

    5. (e) Suppose you have $100,000 and you borrow $40,000 to invest Costco stock at $350 per share. Assuming the loan rate is 0%. Calculate and plot the return on investment for a margin trade and a trade with no margin for ending stock prices that range from $300 to $400 in increments of $10.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions