25 Nov Complete Chapter 12 Case Problem: ‘Investment Strategy.’ If using Excel or Minitab for your calculations, charts, and graphs, please copy and paste your work into the Word document.? Do not attac
– In a single Word document, complete Chapter 12 Case Problem: "Investment Strategy." If using Excel or Minitab for your calculations, charts, and graphs, please copy and paste your work into the Word document. Do not attach Excel or Minitab as separate documents.
-response should be a minimum of 2-3 pages . The font is Times New Roman, font size should be 12, and the paragraphs are single-spaced. There should be a minimum of one reference supporting your observations. Citations are to follow APA 7.0. double space.
– no plagiarism, need plagiarism report
11/24/22, 3:25 PM Print Preview
https://ng.cengage.com/static/nb/ui/evo/index.html?deploymentId=5994142305022023695824496950&eISBN=9780357131824&id=1635156341&sna… 1/2
Chapter 12: Linear Optimization Models Case Problem: Investment Strategy Book Title: Business Analytics Printed By: Jigar Jitendrak Patel ([email protected]) © 2021 Cengage Learning, Cengage Learning
Chapter Review
Case Problem: 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 recommends the portion of each client’s portfolio to be invested in a growth stock fund, an income fund, and a money market fund. To maintain diversity in each client’s portfolio, the firm places limits on the percentage of each portfolio that may be invested in each of the three funds. General guidelines indicate that the amount invested in the growth fund must be between 20% and 40% of the total portfolio value. Similar percentages for the other two funds stipulate that between 20% and 50% of the total portfolio value must be in the income fund and that at least 30% of the total portfolio value must be in the money market fund.
In addition, the company attempts to assess the risk tolerance of each client and adjust the portfolio to meet the needs of the individual investor. For example, Williams just contracted with a new client who has $800,000 to invest. Based on an evaluation of the client’s risk tolerance, Williams assigned a maximum risk index of 0.05 for the client. The firm’s risk indicators show the risk of the growth fund at 0.10, the income fund at 0.07, and the money market fund at 0.01. An overall portfolio risk index is computed as a weighted average of the risk rating for the three funds, where the weights are the fraction of the client’s portfolio invested in each of the funds.
Additionally, Williams is currently forecasting annual yields of 18% for the growth fund, 12.5% for the income fund, and 7.5% for the money market fund. Based on the information provided, how should the new client be advised to allocate the $800,000 among the growth, income, and money market funds? Develop a linear programming model that will provide the maximum yield for the portfolio. Use your model to develop a managerial report.
Managerial Report
1. Recommend how much of the $800,000 should be invested in each of the three funds. What is the annual yield you anticipate for the investment recommendation?
2. Assume that the client’s risk index could be increased to 0.055. How much would the yield increase, and how would the investment recommendation change?
11/24/22, 3:25 PM Print Preview
https://ng.cengage.com/static/nb/ui/evo/index.html?deploymentId=5994142305022023695824496950&eISBN=9780357131824&id=1635156341&sna… 2/2
3. Refer again to the original situation, in which the client’s risk index was assessed to be 0.05. How would your investment recommendation change if the annual yield for the growth fund were revised downward to 16% or even to 14%?
4. Assume that the client expressed some concern about having too much money in the growth fund. How would the original recommendation change if the amount invested in the growth fund is not allowed to exceed the amount invested in the income fund?
5. The asset allocation model you developed may be useful in modifying the portfolios for all of the firm’s clients whenever the anticipated yields for the three funds are periodically revised. What is your recommendation as to whether use of this model is possible?
Chapter 12: Linear Optimization Models Case Problem: Investment Strategy Book Title: Business Analytics Printed By: Jigar Jitendrak Patel ([email protected]) © 2021 Cengage Learning, Cengage Learning
© 2022 Cengage Learning Inc. All rights reserved. No part of this work may by reproduced or used in any form or by any means – graphic, electronic, or mechanical, or in any other manner – without the written permission of the copyright holder.
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.