Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Urgent!! Please answer what you can, I will upvote. If possible answer all parts. Thank you in advance!! Question 4: The purpose of this question

Urgent!! Please answer what you can, I will upvote. If possible answer all parts. Thank you in advance!!

image text in transcribed

Question 4: The purpose of this question is to put the theoretical knowledge learned from chapter 13 to empirical use. Make sure to include all the relevant information in your answers and provide the references for your work. We will focus on two public companies, JPMorgan Chase & Co. (JPM) and Apple Inc. (AAPL). The historical information for the price is available online from January 18, 2019, to January 1st, 2021 (the Market Insider website or other sources such as Yahoo Finance). Download the historical daily share prices for this horizon. Select the S&P500 index as a measure of the market for this horizon and download historical daily prices for this index as well. To be able to calculate the risk- free rate, we need the yield of US treasury bonds with the same duration of 2 years. Note that the yield reported for treasury bonds is an annual rate of return, so you must calculate the daily risk- free rate. a) (8 marks) Calculate the arithmetic average daily return on the stocks of the companies for the horizon. Calculate the variance and standard deviation of the return on the stocks of the companies as well. Based on your answers and selecting the standard deviation as the measure of risk, does higher risk, higher return hold? Discuss. Also, calculate the correlation coefficient between the returns of two stocks using Excel. b) (7 marks) Assume that CAPM holds. Based on the given information, calculate the beta for each of the two stocks. Based on the returns calculated in the previous part, and selecting the beta as the measure of risk, does higher risk, higher return hold? Discuss. c) (5 marks) Assume that you want to create three portfolios from the two stocks you selected (but not the risk-free rate or the market index). The weights of each stock for each of the three portfolios are given below. For each portfolio, calculate the return and beta. Which portfolio has the higher return? Also, calculate the portfolio standard deviation for each pair of the weights. Keeping the beta as a measure of risk, does higher risk, higher return hold? Discuss. X Z Portfolio Y 0.25 0.75 Weights AAPL JPM 0.5 0.5 0.6 0.4 ** Please show all calculations. Question 4: The purpose of this question is to put the theoretical knowledge learned from chapter 13 to empirical use. Make sure to include all the relevant information in your answers and provide the references for your work. We will focus on two public companies, JPMorgan Chase & Co. (JPM) and Apple Inc. (AAPL). The historical information for the price is available online from January 18, 2019, to January 1st, 2021 (the Market Insider website or other sources such as Yahoo Finance). Download the historical daily share prices for this horizon. Select the S&P500 index as a measure of the market for this horizon and download historical daily prices for this index as well. To be able to calculate the risk- free rate, we need the yield of US treasury bonds with the same duration of 2 years. Note that the yield reported for treasury bonds is an annual rate of return, so you must calculate the daily risk- free rate. a) (8 marks) Calculate the arithmetic average daily return on the stocks of the companies for the horizon. Calculate the variance and standard deviation of the return on the stocks of the companies as well. Based on your answers and selecting the standard deviation as the measure of risk, does higher risk, higher return hold? Discuss. Also, calculate the correlation coefficient between the returns of two stocks using Excel. b) (7 marks) Assume that CAPM holds. Based on the given information, calculate the beta for each of the two stocks. Based on the returns calculated in the previous part, and selecting the beta as the measure of risk, does higher risk, higher return hold? Discuss. c) (5 marks) Assume that you want to create three portfolios from the two stocks you selected (but not the risk-free rate or the market index). The weights of each stock for each of the three portfolios are given below. For each portfolio, calculate the return and beta. Which portfolio has the higher return? Also, calculate the portfolio standard deviation for each pair of the weights. Keeping the beta as a measure of risk, does higher risk, higher return hold? Discuss. X Z Portfolio Y 0.25 0.75 Weights AAPL JPM 0.5 0.5 0.6 0.4 ** Please show all calculations

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

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

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

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

Get Started

Recommended Textbook for

Risk Sharing Finance

Authors: Bakkali Mirakhor, Saad Abbas

1st Edition

3110590468, 978-3110590463

More Books

Students also viewed these Finance questions

Question

c. What groups were least represented? Why do you think this is so?

Answered: 1 week ago

Question

7. Describe phases of multicultural identity development.

Answered: 1 week ago