You are considering an investment in the stock. In the stock market, there are two risky...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You are considering an investment in the stock. In the stock market, there are two risky stocks (A and B) and a risk free claim, C (you can think of it as the t-bill). The covariances and returns of these three stocks are described in the following table: Covariance A A ABC C Return 0.25 0.06 0 12.50% B U = E(r) — - 0.06 0.15 0 9.75% 1 2 Assume that you have a mean-variance utility function with risk aversion A=5. That is, your utility function is C 5 * 0² 0 0 0 4.00% a) Let P be the risky portfolio that consists of stocks A and B. Let wp be the weight of stock A in portfolio P and let Wp = 1 - WP. be the weight of stock B in the portfolio P. Write down the Sharpe ratio of portfolio P as a function of WPA- b) Compute the weight of the optimal risky portfolio, wÃÃ, that maximizes the Sharpe ratio. (Hint: See equation 7.13) c) However, instead of maximizing the Sharpe ratio directly, you decide to use the Markowitz Portfolio Optimization Model. In the next couple of questions, we will compute the optimal risky portfolio using the Markowitz procedure. As before, let wo be the weight of stock A in portfolio P and let wp₂ = 1 — w be the weight of stock B in the portfolio P. a. First, we want to find the weights of the optimal risky portfolio that minimizes the variance. i. Write the down the Lagrangian of this minimization problem as a function of Wp and WP g ii. Write down the first-order conditions. iii. Write down the system of equations in matrix form. iv. Solve the system. In this question you are expected to solve the system in matrix form by hand (I urge you to do it!). Please include (only) the solution. (Use Excel to double check your answer). Hint: In this case, the matrix A-¹ is: A-¹ [1.785714 -1.78571 0.3214291 -1.78571 1.785714 0.678571 0.321429 0.678571 -0.24214] v. Is the solution similar to the solution in b)? Explain. b. Second, we want to compute the weights of the optimal risky portfolio that minimizes the variance subject to a portfolio return of 10.50%. i. Write down the Lagrangian of this minimization problem as a function of WPA and WP g ii. Write down the first-order conditions. iii. Write down the system of equations in matrix form. iv. Solve the system using Excel. v. Is the solution similar to the solution in b)? Explain. c. Third, we want to compute the weights of the optimal portfolio on the efficient frontier that has the highest Sharpe ratio. i. What is the "standard" name of this portfolio? ii. Compute the weights of this portfolio. iii. Is the solution similar to the solution in b)? Explain. You are considering an investment in the stock. In the stock market, there are two risky stocks (A and B) and a risk free claim, C (you can think of it as the t-bill). The covariances and returns of these three stocks are described in the following table: Covariance A A ABC C Return 0.25 0.06 0 12.50% B U = E(r) — - 0.06 0.15 0 9.75% 1 2 Assume that you have a mean-variance utility function with risk aversion A=5. That is, your utility function is C 5 * 0² 0 0 0 4.00% a) Let P be the risky portfolio that consists of stocks A and B. Let wp be the weight of stock A in portfolio P and let Wp = 1 - WP. be the weight of stock B in the portfolio P. Write down the Sharpe ratio of portfolio P as a function of WPA- b) Compute the weight of the optimal risky portfolio, wÃÃ, that maximizes the Sharpe ratio. (Hint: See equation 7.13) c) However, instead of maximizing the Sharpe ratio directly, you decide to use the Markowitz Portfolio Optimization Model. In the next couple of questions, we will compute the optimal risky portfolio using the Markowitz procedure. As before, let wo be the weight of stock A in portfolio P and let wp₂ = 1 — w be the weight of stock B in the portfolio P. a. First, we want to find the weights of the optimal risky portfolio that minimizes the variance. i. Write the down the Lagrangian of this minimization problem as a function of Wp and WP g ii. Write down the first-order conditions. iii. Write down the system of equations in matrix form. iv. Solve the system. In this question you are expected to solve the system in matrix form by hand (I urge you to do it!). Please include (only) the solution. (Use Excel to double check your answer). Hint: In this case, the matrix A-¹ is: A-¹ [1.785714 -1.78571 0.3214291 -1.78571 1.785714 0.678571 0.321429 0.678571 -0.24214] v. Is the solution similar to the solution in b)? Explain. b. Second, we want to compute the weights of the optimal risky portfolio that minimizes the variance subject to a portfolio return of 10.50%. i. Write down the Lagrangian of this minimization problem as a function of WPA and WP g ii. Write down the first-order conditions. iii. Write down the system of equations in matrix form. iv. Solve the system using Excel. v. Is the solution similar to the solution in b)? Explain. c. Third, we want to compute the weights of the optimal portfolio on the efficient frontier that has the highest Sharpe ratio. i. What is the "standard" name of this portfolio? ii. Compute the weights of this portfolio. iii. Is the solution similar to the solution in b)? Explain.
Expert Answer:
Related Book For
Financial Analysis with Microsoft Excel
ISBN: 978-1285432274
7th edition
Authors: Timothy R. Mayes, Todd M. Shank
Posted Date:
Students also viewed these accounting questions
-
You are considering an investment in the stock market and have identified two potential stocks (XYZ and ABC) to purchase. The historical returns for the past five years are shown in the table below....
-
You are considering an investment in the stock market and have identified two potential stocks (XYZ and ABC) to purchase. The historical returns for the past five years are shown in the table below....
-
As an investor, you are considering an investment in the bonds of the Front Range Electric Company. The bonds pay interest quarterly, will mature in 12 years, and have a coupon rate of 3.25% on a...
-
With reference to the Auditors Report, answer the following questions: The recent final audit report of an FMCG carries a line which is read as in the manner so required and respectively give a true...
-
Are real world financial markets perfect? If not, in what ways are they imperfect?
-
In Exercises 3 and 4, consider a Markov chain on {1; 2; 3} with the given transition matrix P. In each exercise, use two methods to find the probability that, in the long run, the chain is in state...
-
Verify that the computing formulas for \(S S T, S S(T r)\), \(S S(B l)\), and \(S S E\), given on page 409 , are equivalent to the corresponding terms of the identity of Theorem 12.2. Data From...
-
1. How does Toyotas approach to social responsibility relate to the three concepts of social responsibility described in the text (profit responsibility, stakeholder responsibility, and societal...
-
The Spice Saga has two production departments, Assembly and Finishing. The following information was used to calculate overhead application rates: Estimated overhead Direct labor hours Machine hours...
-
Dr. Smith learned that one sorority on campus had purchased several Macintosh computers and another sorority had purchased several Windows-based computers. Dr. Smith was interested in whether the...
-
A network domain supports connectivity for its users as well as transit traffic flows between other domains. All transit traffic to/from an external network domain must adhere to strict rate (speed)...
-
What is the difference between flexibility and agility?
-
Why did Milton Friedman cast doubt on the likely success of the project to launch a single currency across Europe?
-
Briefly describe the three main types of transactions.
-
For a common currency area to work effectively it is argued that on joining, member states need to be at a similar stage in the economic cycle. Why do you think this is the case?
-
Use an example to explain prospect theory.
-
1. A commercial bank "A" sells bonds it holds on the economy to the BEAC on the "open market", for an amount of 250 million. Subsequently, bank "A" grants a credit to the company CIMENCAM, up to the...
-
2. In the circuit given in Figure 2, i,(t) = 5.67cos(5t)A and v (t) = 70.71 cos(5t 60) V a) Find the equivalent load impedance. State whether the load is inductive or capacitive. b) Calculate the...
-
Write a user-defined function to calculate a firm's return on equity using the DuPont method as defined by (4-29) on page 125. You will need the function to accept three arguments: the net profit...
-
Income Statements for Xcel Energy from 2011 to 2013 appear below. a. Enter the data into your worksheet. Assume that Cost of Revenue and Operation and Maintenance costs are variable. Depreciation and...
-
Suppose that TRM Consulting Services has discussed its need for capital with its investment bankers. The bankers have estimated that TRM can raise new funds in the capital markets under the following...
-
A and B contribute $20,000 each to form the AB partnership and agree to share profits and losses 80% to A and 20% to B. ABs partnership items for the year are as follows: (a) What is As portion of...
-
A and B form the AB equal general partnership. A contributes \($10,000\) cash and a depreciable asset with an adjusted basis of \($40,000\) and a fair market value of \($90,000.\) B contributes...
-
Which of the following taxpayers is engaged in a specified service trade or business? (a) A lawyer (b) An architect (c) A professional soccer player (d) A freelance writer who publishes articles and...
Study smarter with the SolutionInn App