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...
-
We assumed frictionless flow in solving the bump case, Prob. 10.65, for which V2 = 1.21 m/s and y2 = 0.826 m over the crest when hmax = 15 cm, V1 = 1 m/s, and y1 = 1 m. However, if the bump is long...
-
On May 28, 2021, Pesky Corporation acquired all of the outstanding common stock of Harman, Inc., for $420 million. The fair value of Harmans identifiable tangible and intangible assets totaled $512...
-
This activity requires teamwork to reinforce understanding of accounting for partnerships. Required 1. Assume that Baker, Warner, and Rice form the BWR Partnership by making capital contributions of...
-
Rich Importing Company engaged in the following transactions involving promissory notes: May 3 Sold engines to Kabel Company for $30,000 in exchange for a 90-day, 11 percent promissory note. 16 Sold...
-
7. e kolu olan bir merdiven, bir ucu duvar zerine gelecek biimde zemin zerinde konumlandnda oluan a lleri ekilde veriliyor. Duvar Zemin X E 55 65 B A' B' A, E ve B' dorusal olduuna gre, m(AEA') = x...
-
In this mini-case you will perform some procedures required as a part of audit planning. For ease your audit manager has already organized the workpapers and completed several of the required...
-
Intro to Biophysical Measurements BMEN:305 HW-01: Circuits Analysis DIRECTIONS Solve each problem below, showing all of your work and clearly marking your final answer. For each of the circuits,...
-
Wildhorse Company purchased a machine at a price of $109,900 by signing a note payable, which requires a single payment of $142,324 in 3 years. Click here to view factor tables. Assuming annual...
-
29. A 50.0-kg projectile is fired at an angle of 30.0 above the horizontal with an initial speed of 1.20 x 102 m/s from the top of a cliff 142 m above level ground, where the ground is taken to be y...
-
What is your topic? Who is your target audience? Share examples of logos, pathos, and ethos you will include in the speech. What other persuasive techniques and/or appeals will you use? How will you...
-
Skater 1 (78 kg) and skater 2 (56 kg) are moving together going east. Skater 2 pushes skater 1 with a force of 64 N [W]. a) Determine the acceleration of each skater. b) What will happen to the...
-
Tamarisk Corporation donates equipment and a truck to the community Home Assistance Centre. The equipment had a cost of $110,000, accumulated depreciation to the contribution date of $51,000, and a...
-
On January 1, 2022, the Carla Vista Company budget committee has reached agreement on the following data for the 6 months ending June 30, 2022. Sales units: Ending raw materials inventory: First...
-
Find the radius of convergence in two ways: (a) Directly by the CauchyHadamard formula in Sec. 15.2. (b) From a series of simpler terms by using Theorem 3 or Theorem 4.
-
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?
-
Identify the issues related to performance evaluation using DCF models.
-
Identify relevant cash flows for DCF analyses.
-
Andrea Boss, Inc. is interested in using its activity-based costing system to improve its operating efficiency and its profit margins by applying activity-based management techniques. As part of this...
Study smarter with the SolutionInn App