Using the returns and the market risk premium data provided to you, answer the following: 1)...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Using the returns and the market risk premium data provided to you, answer the following: 1) If I only use historical means and historical covariances to make estimates, what are the a. Expected return on the risk-free asset b. expected returns and the expected excess return for the five stocks and, C. volatility of the expected returns d. the expected return for the market and expected market risk premium e. volatility of the expected return for the market f. Correlation between the 5 stocks (10 correlations need to computed since there are 10 ways to choose 2 stocks out of 5 stocks) g. Market Beta of each stock 1 ym RET AAPL RET PG RET_JNJ RET JPM RET ADBE rf mktrf 14 2013ml -11.83 0.30 2.00 -3.30 6.18 0.00 -1.20 15 2013m2 14.12 5.08 8.90 6.29 3.78 0.00 5.65 16 2013m3 8.34 -3.00 -6.88 -9.33 -3.24 0.00 -2.71 17 2013m4 -2.15 -2.95 0.32 2.30 13.53 0.00 3.77 18 2013m5 9.64 7.62 6.83 0.44 4.39 0.00 4.18 19 2013m6 6.97 4.30 2.93 11.02 4.72 0.00 3.13 20 2013m7 0.89 -3.34 -3.24 2.20 5.46 0.00 2.81 21 2013m8 -10.77 -5.14 -3.41 -4.69 -1.15 0.00 -3.32 22 2013m9 5.73 2.66 4.87 2.64 15.95 0.00 4.65 23 2013m10 2.00 2.47 6.63 6.85 -4.21 0.00 0.43 24 2013m11 9.94 3.22 3.12 -7.17 -6.16 0.00 -0.19 25 2013m12 7.83 -2.13 0.86 -0.73 4.62 0.00 2.06 26 2014m1 2.77 -2.72 3.11 3.69 12.12 0.00 2.61 27 2014m2 2.87 -0.80 -4.33 0.78 -4.30 0.00 -2.04 28 2014m3 7.71 7.49 4.34 3.09 3.83 0.00 4.24 29 2014m4 -1.71 0.76 2.76 1.33 -3.77 0.00 -1.97 30 2014m5 7.20 4.98 1.12 1.06 1.34 0.00 2.52 31 2014m6 10.56 3.62 1.09 -0.53 5.08 0.00 2.55 32 2014m7 -7.19 0.73 -3.40 4.02 -1.33 0.00 -0.06 33 2014m8 6.14 -6.76 -4.24 -12.46 -3.54 0.00 -3.11 34 2014m9 10.05 1.00 3.07 12.69 12.79 0.00 6.13 35 2014m10 -3.14 -3.75 -1.86 -1.14 -6.52 0.00 -1.12 36 2014m11 0.58 -2.16 -1.39 5.08 2.87 0.00 0.59 37 2014m12 4.51 -1.41 1.70 3.98 3.98 0.00 1.36 38 2015ml -3.73 -0.19 -2.68 3.01 2.43 0.00 -1.53 39 2015m2 -3.29 -1.12 2.82 1.79 1.21 0.00 1.54 40 2015m3 -6.61 -7.86 -5.47 -6.46 -4.17 0.00 -6.04 41 2015m4 -2.18 1.80 -0.67 -4.88 4.65 0.00 -3.07 42 2015m5 8.34 7.09 8.23 6.10 7.83 0.00 7.75 43 2015m6 -0.57 -2.02 0.95 3.78 3.16 0.00 0.56 44 2015m7 -11.02 6.11 1.46 -0.97 2.71 0.01 -2.17 45 2015m8 -7.52 3.71 1.67 -9.22 -5.12 0.01 -5.77 46 2015m9 -0.13 -1.71 1.46 -5.38 -4.47 0.02 -0.08 47 2015m10 12.72 2.52 2.84 5.19 10.16 0.02 6.96 48 2015m11 -13.99 -1.85 3.59 7.46 0.45 0.01 0.92 49 2015m12 7.14 1.15 1.26 3.28 5.57 0.01 1.78 50 2016ml -4.27 4.48 7.64 -4.80 -3.70 0.02 -0.05 51 2016m2 9.01 1.88 3.24 3.72 2.16 0.02 3.95 52 2016m3 2.36 2.01 -4.06 5.52 4.55 0.02 0.50 53 2016m4 6.55 2.79 -1.01 -1.35 6.09 0.02 0.25 54 2016m5 0.43 -2.54 -1.81 4.73 -0.95 0.02 -2.02 55 2016m6 -2.16 -5.00 -3.35 15.75 -4.37 0.01 4.86 56 2016m7 4.80 1.96 3.51 7.63 0.14 0.03 1.81 57 2016m8 4.77 4.98 -1.70 -1.37 10.13 0.04 1.94 58 2016m9 13.36 3.96 8.62 7.08 4.37 0.04 3.57 59 2016m10 4.87 -1.34 1.91 -3.07 9.96 0.03 0.17 60 2016m11 -0.01 -2.04 -0.87 -0.39 2.77 0.05 1.09 61 2016m12 6.78 0.87 4.55 -5.57 6.07 0.06 1.06 Using the returns and the market risk premium data provided to you, answer the following: 1) If I only use historical means and historical covariances to make estimates, what are the a. Expected return on the risk-free asset b. expected returns and the expected excess return for the five stocks and, C. volatility of the expected returns d. the expected return for the market and expected market risk premium e. volatility of the expected return for the market f. Correlation between the 5 stocks (10 correlations need to computed since there are 10 ways to choose 2 stocks out of 5 stocks) g. Market Beta of each stock 1 ym RET AAPL RET PG RET_JNJ RET JPM RET ADBE rf mktrf 14 2013ml -11.83 0.30 2.00 -3.30 6.18 0.00 -1.20 15 2013m2 14.12 5.08 8.90 6.29 3.78 0.00 5.65 16 2013m3 8.34 -3.00 -6.88 -9.33 -3.24 0.00 -2.71 17 2013m4 -2.15 -2.95 0.32 2.30 13.53 0.00 3.77 18 2013m5 9.64 7.62 6.83 0.44 4.39 0.00 4.18 19 2013m6 6.97 4.30 2.93 11.02 4.72 0.00 3.13 20 2013m7 0.89 -3.34 -3.24 2.20 5.46 0.00 2.81 21 2013m8 -10.77 -5.14 -3.41 -4.69 -1.15 0.00 -3.32 22 2013m9 5.73 2.66 4.87 2.64 15.95 0.00 4.65 23 2013m10 2.00 2.47 6.63 6.85 -4.21 0.00 0.43 24 2013m11 9.94 3.22 3.12 -7.17 -6.16 0.00 -0.19 25 2013m12 7.83 -2.13 0.86 -0.73 4.62 0.00 2.06 26 2014m1 2.77 -2.72 3.11 3.69 12.12 0.00 2.61 27 2014m2 2.87 -0.80 -4.33 0.78 -4.30 0.00 -2.04 28 2014m3 7.71 7.49 4.34 3.09 3.83 0.00 4.24 29 2014m4 -1.71 0.76 2.76 1.33 -3.77 0.00 -1.97 30 2014m5 7.20 4.98 1.12 1.06 1.34 0.00 2.52 31 2014m6 10.56 3.62 1.09 -0.53 5.08 0.00 2.55 32 2014m7 -7.19 0.73 -3.40 4.02 -1.33 0.00 -0.06 33 2014m8 6.14 -6.76 -4.24 -12.46 -3.54 0.00 -3.11 34 2014m9 10.05 1.00 3.07 12.69 12.79 0.00 6.13 35 2014m10 -3.14 -3.75 -1.86 -1.14 -6.52 0.00 -1.12 36 2014m11 0.58 -2.16 -1.39 5.08 2.87 0.00 0.59 37 2014m12 4.51 -1.41 1.70 3.98 3.98 0.00 1.36 38 2015ml -3.73 -0.19 -2.68 3.01 2.43 0.00 -1.53 39 2015m2 -3.29 -1.12 2.82 1.79 1.21 0.00 1.54 40 2015m3 -6.61 -7.86 -5.47 -6.46 -4.17 0.00 -6.04 41 2015m4 -2.18 1.80 -0.67 -4.88 4.65 0.00 -3.07 42 2015m5 8.34 7.09 8.23 6.10 7.83 0.00 7.75 43 2015m6 -0.57 -2.02 0.95 3.78 3.16 0.00 0.56 44 2015m7 -11.02 6.11 1.46 -0.97 2.71 0.01 -2.17 45 2015m8 -7.52 3.71 1.67 -9.22 -5.12 0.01 -5.77 46 2015m9 -0.13 -1.71 1.46 -5.38 -4.47 0.02 -0.08 47 2015m10 12.72 2.52 2.84 5.19 10.16 0.02 6.96 48 2015m11 -13.99 -1.85 3.59 7.46 0.45 0.01 0.92 49 2015m12 7.14 1.15 1.26 3.28 5.57 0.01 1.78 50 2016ml -4.27 4.48 7.64 -4.80 -3.70 0.02 -0.05 51 2016m2 9.01 1.88 3.24 3.72 2.16 0.02 3.95 52 2016m3 2.36 2.01 -4.06 5.52 4.55 0.02 0.50 53 2016m4 6.55 2.79 -1.01 -1.35 6.09 0.02 0.25 54 2016m5 0.43 -2.54 -1.81 4.73 -0.95 0.02 -2.02 55 2016m6 -2.16 -5.00 -3.35 15.75 -4.37 0.01 4.86 56 2016m7 4.80 1.96 3.51 7.63 0.14 0.03 1.81 57 2016m8 4.77 4.98 -1.70 -1.37 10.13 0.04 1.94 58 2016m9 13.36 3.96 8.62 7.08 4.37 0.04 3.57 59 2016m10 4.87 -1.34 1.91 -3.07 9.96 0.03 0.17 60 2016m11 -0.01 -2.04 -0.87 -0.39 2.77 0.05 1.09 61 2016m12 6.78 0.87 4.55 -5.57 6.07 0.06 1.06
Expert Answer:
Related Book For
Principles of Corporate Finance
ISBN: 978-1260013900
13th edition
Authors: Richard Brealey, Stewart Myers, Franklin Allen
Posted Date:
Students also viewed these finance questions
-
"internet radios" for streaming audio, and personal video recorders and players. Describe design and evaluation processes that could be used by a start-up company to improve the usability of such...
-
Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...
-
Solve the inequality. Write the solution in interval notation. 6 IV
-
Which of the following are functionals? (a) «f(x) dx; (d) [f(x) + 1]2, (e) df(x) / dx | x = 0. x) dr; )da
-
In Exercises 2527, use the formula for the sum of the first n terms of an arithmetic sequence to find the indicated sum. 16 (3i + 2) i=1
-
Alternatives 1, 2, and 3 have lives of 3, 4, and 6 years, respectively. Their net cash flow (NCF) and salvage value (SV) profiles are as follows: Additional explanation is necessary: The NCF profile...
-
A manufacturer of prefabricated homes has decided to subcontract four components of the homes. Several companies are interested in receiving this business, but none can handle more than one...
-
Consider the activity-on-arc network diagram below: 1 2 C E 2 4 5 6 3 D 5 5 F G 7 2 8 2 2 1.1 Calculate the early and late event times for each activity in the project network dia- gram. (8) 1.2...
-
Determine and compare the ranges of f (x) and g(x) using complete sentences. g(x) f(x) Find h(x) and determine any asymptotes. Let h(x)= Let k be the function given by k(x) = (create an original...
-
Two railway trucks are travelling in opposite directions on the same track. The first truck has a mass of 12 tonnes, and is moving north at 8 km/h. The second truck has a mass of 18 tonnes and is...
-
The image shows a ribosome translating a membrane protein that will end up in the plasma membrane of the cell. Cytosol = cytoplasm, Endoplasmic reticulum lumen = inside of ER. Sketch the cell and the...
-
A packet between two hosts passes through 5 switches and 3 routers until it reaches its destination. Between the sending application and the receiving application, how often is it handled by the data...
-
The following table shows rates of return for a mutual fund and the market portfolio (S&P 500). A B C 1 Year Fund Market 2 1 14% 13% 3 2 -30% -14% 4 3 -6% -2% 5 4 5% 28% 6 10 14% 8% 7 6 11% 8% Part 1...
-
A block of mass m= 15,6 kg slides down a ramp that makes an angle of 0 =20,4 degree with the horizontal, accelerating at a = 1,17 m/s. Find the coefficient of kinetic friction between the block and...
-
After reviewing the case studies (business continuity and disaster recovery reference guide, data security - top threats to data protection, business continuity, disaster recovery and data center...
-
Phosgene, COCl2, is a toxic gas used in the manufacture of urethane plastics. The gas dissociates at high temperature. At 400oC, the equilibrium constant Kc is 8.05 104. Find the percentage of...
-
Do you think the trend discussed in the case will help companies hire more skilled managers and employees to staff foreign operations? Explain. According to a recent report by the Chronicle of Higher...
-
Some companies agree that the move toward internationalization by U.S. universities primarily reflect an attempt to get more money because foreign buyers are willing to pay top dollar to obtain a...
-
Form teams of five. Each team will come up with a list of five positives and five negatives for the trend discussed in the case. Each team will outline a set of implications of what this trend means...
Study smarter with the SolutionInn App