LP Assignment Munchin Investments (S5) Muchin Investments is a financial services firm that manages funds for...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
LP Assignment Munchin Investments (S5) Muchin Investments is a financial services firm that manages funds for numerous clients. The company uses a proprietary asset allocation model that recommends the portion of each client's portfolio to be invested in growth fund, income fund and hedge fund. To maintain diversity in each client's portfolio, the firm places limits on the percentage of a portfolio that may be invested in each of the three funds, and assigns a limit on the portfolio's risk index. A new client, Benjamin Rich should be advised on allocation of $360,000. Based on an evaluation of the client's risk tolerance, the Munchin Investments assigned a maximum risk index of .05 to the portfolio. The firm's risk indicators show the risk rating for the growth stock fund at .06, while the risk ratings for income fund and hedge fund are at .045 and .015 respectively. An overall portfolio's risk index is computed as a weighted average of the risk rating for the three funds, where the weights are the fraction of the portfolio invested in each of the funds. Higher value of the risk index represents a more risky portfolio. To maintain diversity the following investment guidelines are used: • The amount invested in growth stock fund should be between 15% and 40% of the total portfolio value. • The amount invested in income fund should be between 25% and 40% of the total portfolio value. • At least 30% of the total portfolio value must be in in hedge fund. Furthermore, the amount invested in growth stock fund should be at least as high (>=) as the amount invested in income fund. The firm is forecasting annual yields (returns) of 7.9% for the growth stock fund, 6% for income fund and 3.5% for the hedge fund. Based on the information provided, how should the new client be advised to allocate the $360,000 among the three funds to maximize the overall yield from the portfolio? Formulate a linear programming model for this portfolio selection problem (define decision variables, write down the objective function, develop constraints-show all steps/calculations) and solve it using Excel's Solver. Generate Answer report and sensitivity reports. LP Assignment Munchin Investments (S5) Muchin Investments is a financial services firm that manages funds for numerous clients. The company uses a proprietary asset allocation model that recommends the portion of each client's portfolio to be invested in growth fund, income fund and hedge fund. To maintain diversity in each client's portfolio, the firm places limits on the percentage of a portfolio that may be invested in each of the three funds, and assigns a limit on the portfolio's risk index. A new client, Benjamin Rich should be advised on allocation of $360,000. Based on an evaluation of the client's risk tolerance, the Munchin Investments assigned a maximum risk index of .05 to the portfolio. The firm's risk indicators show the risk rating for the growth stock fund at .06, while the risk ratings for income fund and hedge fund are at .045 and .015 respectively. An overall portfolio's risk index is computed as a weighted average of the risk rating for the three funds, where the weights are the fraction of the portfolio invested in each of the funds. Higher value of the risk index represents a more risky portfolio. To maintain diversity the following investment guidelines are used: • The amount invested in growth stock fund should be between 15% and 40% of the total portfolio value. • The amount invested in income fund should be between 25% and 40% of the total portfolio value. • At least 30% of the total portfolio value must be in in hedge fund. Furthermore, the amount invested in growth stock fund should be at least as high (>=) as the amount invested in income fund. The firm is forecasting annual yields (returns) of 7.9% for the growth stock fund, 6% for income fund and 3.5% for the hedge fund. Based on the information provided, how should the new client be advised to allocate the $360,000 among the three funds to maximize the overall yield from the portfolio? Formulate a linear programming model for this portfolio selection problem (define decision variables, write down the objective function, develop constraints-show all steps/calculations) and solve it using Excel's Solver. Generate Answer report and sensitivity reports.
Expert Answer:
Related Book For
Quantitative Methods for Business
ISBN: 978-0324651751
11th Edition
Authors: David Anderson, Dennis Sweeney, Thomas Williams, Jeffrey cam
Posted Date:
Students also viewed these mathematics questions
-
Investment Strategy J. D. Williams, Inc. is an investment advisory firm that manages more than $120 million in funds for its numerous clients. The company uses an asset allocation model that...
-
J. D. Williams, Inc., is an investment advisory firm that manages more than $120 million in funds for its numerous clients. The company uses an asset allocation model that recommends the portion of...
-
Caro-Life is a financial services firm that specializes in selling life-, auto-, and home- insurance to residential consumers in the state of North Carolina The company is planning to expand and...
-
Some economists argue that Inflation numbers calculated by CPI are not accurate especially during the pandemic. Explain why do they believe inflation numbers are not that accurate during pandemic?
-
In the following list of nuclides, identify (a) Those with filled nucleon shells, (b) Those with one nucleon outside a filled shell, and (c) Those with one vacancy in an otherwise filled shell: 13C,...
-
Consider a 5.25% coupon bond issued by General Electric that matures on December 6, 2017. The bonds yield to maturity is 4.386%. Given the information below, compute the I-spread. The information is...
-
Mustang Properties completed the following stock issuance transactions: Requirements 1. Journalize the transactions. Explanations are not required. 2. How much paid-in capital did these transactions...
-
Under the decimal system of computing time worked at Carman's Company, production workers who are tardy are "docked" according to the schedule shown below. Minutes Late in Ringing inFractional Hour...
-
Identify three to five specific budgeting objectives for a mental health center (these should be specific, measurable, achievable, realistic, and have a time element).
-
What does the following SystemVerilog statement do? result = | (data[15:0] & 16'hC820);
-
4. The graph (right), which has vertex (1, 9), is of: f(x) = a cos(x+ k). 10 i. Write down the value of a. (1 mark) ii. What is the phase shift? (1 mark) 9. iii. Write down the equation for f. f(x)...
-
Mod 19.8: Based on the following information from ZYX Co's income statement and other sources for the year ended 12/31/X1, compute ZYX's net cash flows from financing activities: Net Sales for the...
-
What are the key checkpoints in the cell cycle, and what role do tumor suppressor genes play in ensuring proper cell cycle regulation ?
-
03 Cost of Goods Manufactured & Partial Income Statement Aikman Corporation has the following cost records for June 2012: Inventory Work In Process Finished Goods 1-Jun-22 ######## 3,045 S 3,048...
-
How does electrostatic force differs from gravitational force. Provide an example that illustrates the differences and similarities between these two forces.
-
Assume you have an interview for a marketing position in a global marketing organization. This assignment requires you to come up with a personal value proposition for the position, based on your...
-
Investigate the city by using publicly available sources (e.g., a city website or U.S. Census data). Then, give some relevant background information about the city. It must include (1) general...
-
KD Insurance Company specializes in term life insurance contracts. Cash collection experience shows that 20 percent of billed premiums are collected in the month before they are due, 60 percent are...
-
The Robotics Manufacturing Company operates an equipment repair business where emergency jobs arrive randomly at the rate of three jobs per 8-hour day. The companys repair facility is a...
-
Consider the following linear program: Min8X + 12Y s.t. 1X + 3Y 9 2X + 2Y 10 6X + 2Y 18 X, Y 0 a. Use the graphical solution procedure to find the optimal solution. b. Assume that the objective...
-
For the Hawkins Company, the monthly percentages of all shipments that were received on time over the past 12 months are 80, 82, 84, 83, 83, 84, 85, 84, 82, 83, 84, and 83. a. Compare a three-month...
-
A Laplacian operator is given by a. \(\frac{\partial^{2}}{\partial x \partial y}\) b. \(\frac{\partial^{2}}{\partial x^{2}}+\frac{\partial^{2}}{\partial y^{2}}+2 \frac{\partial^{2}}{\partial x...
-
A cable of length \(l\) and mass \(ho\) per unit length is stretched under a tension \(P\). One end of the cable is connected to a mass \(m\), which can move in a frictionless slot, and the other end...
-
Fill in the Blank. The quantities \(E I\) and \(G J\) are called the ___________ and ____________ stiffnesses, respectively.
Study smarter with the SolutionInn App