use Excels solver function to solve the question 3. (Wealth management) An investor is constructing a portfolio
Fantastic news! We've Found the answer you've been seeking!
Question:
use Excel’s solver function to solve the question
Transcribed Image Text:
3. (Wealth management) An investor is constructing a portfolio that consists of four assets. Let us denote by x = (x,...,x4) a vector of portfolio weights such that 1x;= 1. The investor is endowed with an initial wealth Wo= 100. The scenarios, or outcomes, are indexed i = 1,..., 30. In scenario i, the return of asset j is rij, so the final wealth in this scenario is W(i) = Wo Ex(1+rij). j=1 Given final wealth W (i), the investor obtains utility u(W (i)) (to be specified below). The goal of the investor is to find the optimal weights of the assets to maximize the expected utility: u(W (i)). 4 Use the data in the worksheet HW1_Q3 of the file HW1.xlsx and the Solver add-in can be used for the parts below. The data in the spreadsheet corresponds to four assets and thirty scenarios. (a) Suppose that the investor's utility is simply equal to the wealth; that is, u(w) = w. In this case, the investor solves the following optimization problem: max X 30 w(i) i=1 4 subject to W (i) = Woxj (1+rij) j=1 max X 4 x; =1, x > 0 j=1 Discuss whether this is a linear model or a non-linear model. Find the optimal portfolio weights and record the corresponding expected utility, the average portfolio return, and the standard deviation of the portfolio return. (b) Suppose that the investor's utility is u(w)=-w-25/25. This means that the investor is significantly risk-averse; that is, the investor is sensitive to losses than to gains. In this case, the investor solves the following optimization problem: 30 -(w (i))^25/25 i=1 subject to W (i) = Wo x, (1 + rij) j=1 xj = 1, x>0 j=1 Discuss whether this is a linear model or a non-linear model. Repeat the analysis in part (a). Hint: The Solver can fail with "poorly scaled" problems. One way to avoid this is to replace the objective function by an equivalent objective function which is better scaled. The basic idea is that maximizing f(x) is equivalent to maximizing 1000f(x), f(x) +500, ef(x) or ln(f(x)) (if f(x) > 0). With the right choice you should not have to change any Solver settings to get optimal solutions. 3. (Wealth management) An investor is constructing a portfolio that consists of four assets. Let us denote by x = (x,...,x4) a vector of portfolio weights such that 1x;= 1. The investor is endowed with an initial wealth Wo= 100. The scenarios, or outcomes, are indexed i = 1,..., 30. In scenario i, the return of asset j is rij, so the final wealth in this scenario is W(i) = Wo Ex(1+rij). j=1 Given final wealth W (i), the investor obtains utility u(W (i)) (to be specified below). The goal of the investor is to find the optimal weights of the assets to maximize the expected utility: u(W (i)). 4 Use the data in the worksheet HW1_Q3 of the file HW1.xlsx and the Solver add-in can be used for the parts below. The data in the spreadsheet corresponds to four assets and thirty scenarios. (a) Suppose that the investor's utility is simply equal to the wealth; that is, u(w) = w. In this case, the investor solves the following optimization problem: max X 30 w(i) i=1 4 subject to W (i) = Woxj (1+rij) j=1 max X 4 x; =1, x > 0 j=1 Discuss whether this is a linear model or a non-linear model. Find the optimal portfolio weights and record the corresponding expected utility, the average portfolio return, and the standard deviation of the portfolio return. (b) Suppose that the investor's utility is u(w)=-w-25/25. This means that the investor is significantly risk-averse; that is, the investor is sensitive to losses than to gains. In this case, the investor solves the following optimization problem: 30 -(w (i))^25/25 i=1 subject to W (i) = Wo x, (1 + rij) j=1 xj = 1, x>0 j=1 Discuss whether this is a linear model or a non-linear model. Repeat the analysis in part (a). Hint: The Solver can fail with "poorly scaled" problems. One way to avoid this is to replace the objective function by an equivalent objective function which is better scaled. The basic idea is that maximizing f(x) is equivalent to maximizing 1000f(x), f(x) +500, ef(x) or ln(f(x)) (if f(x) > 0). With the right choice you should not have to change any Solver settings to get optimal solutions.
Expert Answer:
Answer rating: 100% (QA)
To solve the optimization problems using Excels Solver function follow these steps a Investors Utility uw w 1 Open the provided Excel file HW1xlsx and ... View the full answer
Related Book For
Fundamentals of Investments, Valuation and Management
ISBN: 978-1259720697
8th edition
Authors: Bradford Jordan, Thomas Miller, Steve Dolvin
Posted Date:
Students also viewed these accounting questions
-
Management at the Daily Grind wants to install an espresso bar in its restaurant that costs $140,000 and has a 10-year-life. It will generate annual net cash inflows of $35,000. Management requires a...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
You are an investment manager for Simple Asset Management, a company that specializes in developing simple investment portfolios consisting of no more than three assets such as stocks, bonds, etc.,...
-
You will act as a senior HR manager of a very large, publicly traded company known as XYZ Inc. The CEO of XYZ Inc. has asked you to prepare an important orientation presentation for the global HR...
-
Did the directors of RSL Plc violate their duty of care to the corporation?
-
Explain the rationale behind each method.
-
Niagra Ltd reported the following financial data over a 5-year period. Required (a) Prepare a trend analysis of the data using 2021 as the base year. (b) Graph the trends and discuss if the trends...
-
Wheeled Coach, based in Winter Park, Florida, is the worlds largest manufacturer of ambulances. Working four 10-hour days each week, 350 employees make only customer-made ambulances: Virtually every...
-
In a multi-product break-even analysis, we use a blended or weighted average contribution margin. Why must we use this "fictitious" number rather than actual contribution margins in computing a...
-
In addition to providing polarity data, like those you interpreted in Part B, most terrestrial lava flows contain minerals that can be precisely dated using radiometric age-dating techniques. The...
-
Wedding.com earned net income of $73,000 after deducting depreciation of $8,000 and all other expenses. Current assets decreased by $7,000, and current liabilities increased by $9,000. How much was...
-
Discuss the two signs suggestive of long-term structural problems and the cost of persistent unemployment from the Great Recession. In doing so, discuss how the automation of routine task activities...
-
What type of costs do you perceive that Advocate Trinity Hospital will incur due to hospital-acquired conditions? Explain.
-
What role do conspiracy theories play in the spread of right-wing extremism ?
-
If an object in uniform circular motion at a radius r , and a velocity v , has a centripetal acceleration of 2 0 m / s ^ 2 . What will the acceleration be if the velocity becomes 2 X as big. ( v > >...
-
Discuss each of the four implications of the spatial equilibrium model in one of the new "cool" cities attracting Millennials. In doing so, discuss the impact of labor mobility on the Millennials,...
-
1.During a two-hour period, the temperature in a city dropped from a high of 57F to a low of 19F. What was the range of the temperatures during this period? F 2. On an examination given to 8,400...
-
Calculate the change in entropy when 100 kJ of energy is transferred reversibly and isothermally as heat to a large block of copper at (i) 0 C, (ii) 50 C.
-
You found the following stock quote for Gigantus Corporation in todays newspaper. What was the stock selling for on January 1? Use the following bond quote for Problems 9 and 10: Data From Problem 9...
-
Based on the information in the case, which one of the following portfolios should the Analees choose? a. Portfolio A b. Portfolio B c. Portfolio C Allocation Expected Return Portfolio A Portfolio B...
-
What is the single monthly mortality assuming the conditional prepayment rate is 7 percent?
-
Consider a scenario where you negotiate with a company over the salary and perks being offered for a position. Create a class diagram for this using negotiation patterns as your base and draw a...
-
Consider a scenario where an online trade application is being developed. The two registered users can negotiate over the price of a product being traded. Create a class diagram for this application...
-
Explain main disadvantages of starting analysis from scratch for each project.
Study smarter with the SolutionInn App