The purpose of this question is to put the theoretical knowledge learned from chapter 13 to...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 1st, 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. Weights AAPL JPM X 0.5 0.5 Portfolio Y 0.25 0.75 Z 0.6 0.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 1st, 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. Weights AAPL JPM X 0.5 0.5 Portfolio Y 0.25 0.75 Z 0.6 0.4
Expert Answer:
Answer rating: 100% (QA)
1 JPM 2 AAPL 3 Index 1 Daily return ending price beginning price beginning pr... View the full answer
Posted Date:
Students also viewed these accounting questions
-
The purpose of this exercise is to provide practice using LINGO or Excel Solver. Find the values of X and Y that minimize the function Min X2 - 4X + Y2 + 8Y + 20 Do not assume non-negativity of the X...
-
The goal of this question is to analyze how an organization can help employees gain the new skills required by and for the change effort. For this assignment, you will examine your expectations that...
-
The purpose of this question is to use an affinity diagram to brainstorm and identify root causes of the organizational problem and potential solutions for addressing it. Now that you have identified...
-
Assume that your team has been in contract with the headquarters of a company that owns several restaurants in different states in the US. Your team is to provide software that manages these...
-
Dwights Trophy Shop is considering the following accounting changes: a. Increase the allowance for uncollectible accounts. b. When costs are going up, change from LIFO to FIFO. c. Change from the...
-
During the fourth quarter of 2013, there were seven biweekly paydays on Friday (October 4, 18; November 1, 15, 29; December 13, 27) for Clarke's Roofing. Using the forms supplied on pages 4-58 to...
-
The technique that recognizes the time value of money by discounting the after-tax cash flows for a project over its life to time period zero using the company's minimum desired rate of return is...
-
(Liberatore and Miller, 1985) A manufacturing facility uses two production lines to produce three products over the next 6 months. Backlogged demand is not allowed. However, a product may be...
-
The law of cosines is a+b2-2abcosC = c2. Find the value of 2abcosC. 2 2 AB 1 A. 3.5 B. 7 C. -7 D 25
-
A drunk starts out from a lamppost in the middle of a street, taking steps of equal length either to the right or to the left with equal probability. What is the probability that the man will again...
-
The following data were collected during a study of consumer buying patterns: Observation x y Observation x y 1 11 77 8 23 78 2 30 77 9 10 69 3 44 82 10 19 70 4 34 84 11 23 87 5 47 92 12 19 90 6 42...
-
An air-gap parallel plate capacitor of capacitance Co = 20 nF is connected to a battery with voltage V = 12 V. While the capacitor remains connected to the battery, we insert a dielectric (K = 2.6)...
-
Your assistant prepared the following bank reconciliation statement. It appears that the statement is unacceptable and the task of preparing a proper reconciliation falls upon you Balance per books...
-
Write the Linear Approximation to f(x, y) = x(1 + y) at (a, b) = (8, 1) in the form f(a + h, b + k) f(a, b) + fx(a, b)h + fy(a, b)k (Give an exact answer. Use decimal notation and fractions where...
-
You need to hang a traffic light in the middle of a tight cable supported by two poles on opposite sides of the road. You don't want to cable to sag too much in the middle; otherwise, trucks might...
-
The height at time t (in seconds) of a mass, oscillating at the end of a spring, is s(t) = 300 + 32 sin(r) cm. Find the velocity and acceleration at = s. (Use symbolic notation and fractions where...
-
Requirement 3 (25 points) a. Calculate the standard cost per unit for direct materials and standard rate per unit for direct labor. (The formulas are given above next to the "Direct Materials" and...
-
Wilsons Auto Repair ended 2011 with Accounts Receivable of $85,000 and a credit balance in Allowance for Uncollectible Accounts balance of $11,000. During 2012, Wilsons Auto Repair had the following...
-
Assume your U.S. firm currently exports to Mexico on a monthly basis. The goods are priced in pesos. Once material is received from a source, it is quickly used to produce the product in the United...
-
Using the information in the previous question, consider a proposal to price the exports to Mexico in dollars and to use the U.S. source for material. Would this proposal eliminate the exchange rate...
-
Assume that the dollar is expected to strengthen against the euro over the next several years. Explain how this will affect the consolidated earnings of U.S.-based MNCs with subsidiaries in Europe.
Study smarter with the SolutionInn App