Each team will write a single report and work should be distributed as evenly as possible....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Each team will write a single report and work should be distributed as evenly as possible. Reports should be professionally prepared, for example, properly sectioned, neatly written and formatted. While the computer should be used to provide much of the results, the report should not be just a collection of printouts. Relevant printouts can be attached as exhibits, and should be properly referenced, but there should be a narrative report that discusses issues, interprets the numerical output, and hopefully goes beyond the immediate conclusions to draw insights and generalize. Markowitz won the Nobel Prize for his work in stock portfolio theory. He was the first to measure portfolio risk using the variance of returns. He introduced stock selection based on an "efficient frontier", namely, by picking the stocks that give the portfolio "with minimum variance for a given return" and "maximum return for a given variance." This project involves an application of Markowitz's portfolio optimization method to the following data: An investor is considering to purchase a combination of three stocks - "Alpha," "Bravo," and "Charlie." The expected returns and risk of these three stocks are given in Table 1. Table 1. Return and Risk Data Stock Alpha excipting 0.062 Bravo Expected Return Charlie 0.146 0.128 Risk (variance of returns) 0.0146 0.0854 0.0289 madmus You should propose to this investor a portfolio of these three stocks that gives at least a TARGETRETURN% "expected return" at the lowest possible risk. The value of TARGETRETURN is different for each team: Specifically, TARGETRETURN equals 9.5 + 0.1 x TEAMNUMBER. For example, for TEAM 7, TARGETRETURN = 9.5+ 0.1 x 7 = 10.2%. A portfolio's variance depends on how each individual stock's price fluctuations are correlated with every other stock's, known as the covariance of returns. The covariances for the three stocks considered here are given in the variance-covariance matrix in Table 2. For example, the covariance between Alpha and Bravo is 0.0187. Table 2. Variance-Covariance Matrix of Returns Alpha Bravo Charlie The final report include: 0.0187 Alpha 0.0146 Bravo 0.0187 0.0854 0.0104 0.0145 Charlie 0.0145 0.0104 0.0289 Markowitz showed that the variance of a portfolio that invests x₁, x₂, x3 in these three stocks can be computed according to the following function of covariances: V = 0.0146x₁x₁ +0.0187x₁x₂ + 0.0145x1x3 +0.0187x₂x₁ +0.0854x2x2 +0.0104x2x3 +0.0145x3x₁ +0.0104x3x2 +0.0289x3x3. 2 should be at most 3 pages and should 1) Statement of the problem, and underlying issues that make it important. 2) A complete description and the mathematical model representation of the decision variables, the objective function, and the constraints as well as why you believe they make sense. 3) A copy of the relevant parts of the Excel output - not the entire output. 4) Interpretation of results. This step is very important and will carry maximum weight toward the final project grade. 5) An appendix (that does not count towards the 3-page limit) should include the raw data in tabular form. 6) The Excel file including your SOLVER formulation and solution. Each team will write a single report and work should be distributed as evenly as possible. Reports should be professionally prepared, for example, properly sectioned, neatly written and formatted. While the computer should be used to provide much of the results, the report should not be just a collection of printouts. Relevant printouts can be attached as exhibits, and should be properly referenced, but there should be a narrative report that discusses issues, interprets the numerical output, and hopefully goes beyond the immediate conclusions to draw insights and generalize. Markowitz won the Nobel Prize for his work in stock portfolio theory. He was the first to measure portfolio risk using the variance of returns. He introduced stock selection based on an "efficient frontier", namely, by picking the stocks that give the portfolio "with minimum variance for a given return" and "maximum return for a given variance." This project involves an application of Markowitz's portfolio optimization method to the following data: An investor is considering to purchase a combination of three stocks - "Alpha," "Bravo," and "Charlie." The expected returns and risk of these three stocks are given in Table 1. Table 1. Return and Risk Data Stock Alpha excipting 0.062 Bravo Expected Return Charlie 0.146 0.128 Risk (variance of returns) 0.0146 0.0854 0.0289 madmus You should propose to this investor a portfolio of these three stocks that gives at least a TARGETRETURN% "expected return" at the lowest possible risk. The value of TARGETRETURN is different for each team: Specifically, TARGETRETURN equals 9.5 + 0.1 x TEAMNUMBER. For example, for TEAM 7, TARGETRETURN = 9.5+ 0.1 x 7 = 10.2%. A portfolio's variance depends on how each individual stock's price fluctuations are correlated with every other stock's, known as the covariance of returns. The covariances for the three stocks considered here are given in the variance-covariance matrix in Table 2. For example, the covariance between Alpha and Bravo is 0.0187. Table 2. Variance-Covariance Matrix of Returns Alpha Bravo Charlie The final report include: 0.0187 Alpha 0.0146 Bravo 0.0187 0.0854 0.0104 0.0145 Charlie 0.0145 0.0104 0.0289 Markowitz showed that the variance of a portfolio that invests x₁, x₂, x3 in these three stocks can be computed according to the following function of covariances: V = 0.0146x₁x₁ +0.0187x₁x₂ + 0.0145x1x3 +0.0187x₂x₁ +0.0854x2x2 +0.0104x2x3 +0.0145x3x₁ +0.0104x3x2 +0.0289x3x3. 2 should be at most 3 pages and should 1) Statement of the problem, and underlying issues that make it important. 2) A complete description and the mathematical model representation of the decision variables, the objective function, and the constraints as well as why you believe they make sense. 3) A copy of the relevant parts of the Excel output - not the entire output. 4) Interpretation of results. This step is very important and will carry maximum weight toward the final project grade. 5) An appendix (that does not count towards the 3-page limit) should include the raw data in tabular form. 6) The Excel file including your SOLVER formulation and solution.
Expert Answer:
Answer rating: 100% (QA)
Report on Portfolio Optimization using Markowitzs Method 1 Statement of the Problem The problem at h... View the full answer
Related Book For
Fundamentals of Cost Accounting
ISBN: 978-0077398194
3rd Edition
Authors: William Lanen, Shannon Anderson, Michael Maher
Posted Date:
Students also viewed these general management questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Googles ease of use and superior search results have propelled the search engine to its num- ber one status, ousting the early dominance of competitors such as WebCrawler and Infos- eek. Even later...
-
While you may not work for a large corporation, there is merit to the notion that the organization must speak with one voice and speak quickly in a crisis. What forces (tradition, practice, and...
-
A counter flowing heat exchanger cools air at 600 K, 400 kPa to 320 K using a supply of water at 20C, 200 kPa. The water flow rate is 0.1 kg/s and the air flow rate is 1 kg/s. Assume this can...
-
What is garbage collection?
-
Why do the terms of the attorney-client relationship need to be established in writing?
-
On January 1, 2014, Cron Corporation issued $700,000 in bonds that mature in five years. The bonds have a stated interest rate of 13 percent and pay interest on June 30 and December 31 each year....
-
Question1 Motivationis agoal-oriented characteristicthat helpsapersonachievehis objectives. It pushesanindividualtoworkhardatachievinghisorhergoals.Anexecutivemusthavethe...
-
Jerry Stevenson is the manager of a medical clinic in Scottsdale, AZ. He wants to analyze patient data to identify high-risk patients for cardiovascular diseases. From medical literature, he learned...
-
On career day Mrs. Rockman invites in non-stereotypical role models (such as male nurses and female engineers) to speak to her students. Of the following, the most likely reason Mrs. Rockman does...
-
You are the assistant manager of a small community clinic. It's a busy Monday morning, two of your staff called in sick: the clinic manager and a clerk. A Centers for Medicare and Medicaid Services...
-
Lorenzo Lamas is the auditor for Falcons Crest Ltd (FCL), a winery situated in the Hunter Valley of New South Wales. Lorenzo is in the process of valuing the wine that is currently ageing in the...
-
Calculate the patient out-of-pocket obligations for each situation. The health insurance policy has the following characteristics: Office visit copays: $25 in-network and $50 out-of-network...
-
How do model predictive control (MPC) systems compare with traditional PID control in maintaining stability and efficiency in high-throughput chemical production environments ?
-
1- Create a new Android project. 2- Type the following code in the text window, and then observe the changes in the design window. I
-
Mr X is a director of company ABC. Mr Y, the chairperson of the board of directors for company ABC, informs Mr X that as a director of the company, he has an obligation to perform to the best of his...
-
CLASS PERIO Solving Linear Equations: Variable on Both Sides Solve each equation. 1) 6r+ 7 = 13 + 7r 3) -7x-3x+2=-8x-8 5)-14 +66+7-26=1+5b 7) n-3n = 14-4n 2) 13-4x=1-x 4)-8-x= x - 4x 6)n+2=-14-n 8)...
-
Prepare a scattergraph based on the overhead and machine-hour data in Exercise 5-26.
-
We cant drop our prices below $210 per hundred pounds, exclaimed Greg Berman, manager of Forwarders, a division of Custom Freight Systems. Our margins are already razor thin. Our costs just wont...
-
Terracotta, Inc., makes toy soldiers. Company management believes that a new model would sell well at a price of $65. The company estimates unit materials costs to be $16 for the model, and overhead...
-
Find the free-vibration response of the spring-mass system shown in Fig. 6.6 (a) for \(k_{1}=k, k_{2}=2 k, k_{3}=3 k, m_{1}=m, m_{2}=2 m\), and \(m_{3}=3 m\) corresponding to the initial conditions...
-
Find the free-vibration response of the tightly stretched string shown in Fig. 6.33 for \(m_{1}=2 m, m_{2}=m, m_{3}=3 m\), and \(l_{i}=l(i=1,2,3,4)\). Assume the initial conditions as...
-
Find the free-vibration response of the triple pendulum shown in Fig. 6.10 for \(l_{i}=l(i=1,2,3)\) and \(m_{i}=m(i=1,2,3)\) for the initial conditions \(\theta_{1}(0)=\theta_{2}(0)=0\),...
Study smarter with the SolutionInn App