Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Download last 5 years monthly price data for AMZN and GM (May 2017 - April 2022) and use adjusted close prices in your calculations. (You
Download last 5 years monthly price data for AMZN and GM (May 2017 - April 2022) and use adjusted close prices in your calculations. (You can get historical data from finance.yahoo.com) a) b) c) Calculate monthly returns for AMZN and GM. Calculate variance and standard deviation of monthly stock returns. Consider you have a portfolio with 20 shares of AMZN shares and 1000 shares of GM. For the last 5 years, calculate monthly portfolio return, then portfolio variance and standard deviation based on monthly portfolio returns. Get stock beta for AMZN and GM. Calculate expected returns of each stock. (Assume market return is 7% and use 1.25% as your risk-free rate) d) Download last 5 years monthly price data for AMZN and GM (May 2017 - April 2022) and use adjusted close prices in your calculations. (You can get historical data from finance.yahoo.com) a) b) c) Calculate monthly returns for AMZN and GM. Calculate variance and standard deviation of monthly stock returns. Consider you have a portfolio with 20 shares of AMZN shares and 1000 shares of GM. For the last 5 years, calculate monthly portfolio return, then portfolio variance and standard deviation based on monthly portfolio returns. Get stock beta for AMZN and GM. Calculate expected returns of each stock. (Assume market return is 7% and use 1.25% as your risk-free rate) d)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started