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...
-
A non-uniform linear charge distribution given by = bx, where b is a constant, is located along an x axis from x = 0 to r = 0.20 m. If b = 20nC/m2 and V = 0 at infinity, what is the electric...
-
Which is not a mechanical property of a material? (a) Hardness (b) Yield strength (c) Poisson's ratio (d) Endurance limit
-
Which of the following is true? a. ERS systems use disbursement vouchers. b. Setting up petty cash as an imprest fund violates segregation of duties. c. The EOQ formula is used to identify the...
-
At December 31, 2014, House Co. reported the following information on its balance sheet. Accounts receivable .............$960,000 Less: Allowance for doubtful accounts ..... 80,000 During 2015, the...
-
which og the following statements best highlights a promary differnce between butcoin ans the us dollar
-
A work sheet for Juanita's Consulting is shown on the following page. There were no additional investments made by the owner during the month. REQUIRED 1. Prepare an income statement. 2. Prepare a...
-
What is the critical path of a synchronous clock domain and how does it affect performance? [2 marks] (b) Name two tools that can be used for locating the critical paths of a system on chip before...
-
You purchase a bond that pays a semi-annual coupon with a coupon rate of 3.8%. The bond current yield is 7.6% and has a par value of $1,000. What is the price?
-
Company F is planning its launch of a multi-platform open-world game with a contemporary and engaging storyline in 2025. Given this scenario and based upon the information provided, please provide...
-
When a horse pulls a 85 kg buggy down the road with a force of 38 N, the buggy hitch makes an angle of 35 degrees above the horizontal. Neglecting friction, what is the magnitude of the buggy's...
-
A 81 kg hockey player skating at 7.9 m/s fakes a defender and goes around him to score. While performing the maneuver he changes direction by 40 and maintains his speed. (A) What is his linear...
-
Consider the network shown in Figure-Q1.2. (No need to explain) A B C D Figure-Q1.2 E F (i)_[2 marks] The average degree (k)= (ii) [2 marks] The average distance of Node A to all other nodes (iii) [2...
-
Addressing the need for institutions that support workers willing to fill the demand for long-term employment in low-skill jobs and ensuring they receive a living wage is crucial for creating fair...
-
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?
-
Why is it so important for monopolistically competitive firms to advertise?
-
Monopolistic competition is similar to both _________ and perfect competition. As in monopoly, firms have some control over market _________, but as in perfect competition, they face _________ from...
-
Due to the free entry of new firms, long-run economic profits in monopolistic competition are _________.
Study smarter with the SolutionInn App