Develop a linear programming model

Assignment Help Other Subject
Reference no: EM131386670

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 rec¬ommends 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 percent of the total portfolio value. Similar percentages for the other two funds stipulate that between 20 and 50 Percent of the total portfolio value must be in the income fund and that at least 30 percent 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 percent for the growth fund, 12.5 percent for the income fund, and 7.5 percent 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 fund? 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 yields 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?

3. Refer again to the original situation where 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 download to 16 percent or even to 14 percent?

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?

Attachment:- Case.rar

Verified Expert

1. Linear modelling in excel - Solver (Excel file) 2. Essay on case study This assignment is based on the linear modelling and asset allocation model creation for optimum allocation of available funds in a portfolio comprising of a number of investment opportunities, while retaining the risk within specified levels.

Reference no: EM131386670

Questions Cloud

Break-down structure and implementation timeframe : Based on the Case Study above, develop a project proposal, which you will present to the management team of Koala Chocolates, including the sales manager, the warehouse and inventory manager and the CEO.
Explain whether the plaintiffs should prevail : The daughters claim that the asbestos products were defective and unreasonably dangerous and that Owens-Corning was negligent in failing to warn of the dangers associated with their products. Explain whether the plaintiffs should prevail.
Explore the website and then write : Explore the website and then write approximately 300 words about a subject that you found to be of interest and why.
Provide decision in the given situation : Heckman, an employee of Clark Equipment Company, severely injured his left hand when he caught it in a power press that he was operating at work.- The jury awarded Heckman $750,000, and Federal appealed. Decision?
Develop a linear programming model : Develop a linear programming model that will provide the maximum yield for the portfolio. Use your model to develop a managerial report. Recommend how much of the $800,000 should be invested in each of the three funds. What is the annual yields you..
Saving rate is initially greater than golden rule : Suppose the saving rate is initially greater than the golden rule saving rate. We know with certainty that an increase in the saving rate will cause
Describe the main purpose of the hajj in the muslim faith : Describe the main purpose of the Hajj in the Muslim faith, and identify two (2) specific aspects of the Hajj that you find fascinating or significant. Next, explain the association between Muhammad and the area of the Dome of the Rock in Jerusalem..
Is montgomery ward liable under a warranty : Ward claimed that there was no way to detect the disease in the one-day-old chicks, nor was there medication available to prevent this disease from occurring.- Is Montgomery Ward liable under a warranty and/or strict liability cause of action? Expl..
Branch office direct printing feature : What do you believe is the biggest advantage of the Print and Document Services role? Why? Out of all the tasks that can be performed from the Print Management snap-in, which do you believe you would use the most? Why? Which do you find to be the l..

Reviews

inf1386670

2/27/2017 5:18:16 AM

For me it is to satisfy the scholarly prerequisites as well as to locate the most ideal arrangement or to contribute something better by gaining from all boulevards by investigating numerous and different assets. Yes, it is valid, it is excessive and tedious and massively chafing, yet that is what is required in the event that one needs to fulfill that merits investigating. I genuinely welcome that every one of you are paying special mind to me to furnish quality services with reasonable cost in opportune way. It is my pleasure to work with you and this expert.

len1386670

2/8/2017 5:35:13 AM

Case problem investment strategy on page 587 from the book Essentials of Business Analytics ISN# 978-1-285-18727-3. Please make sure paper is to be written in 6th edition APA formatting, and should be no less than 5 pages in length (excluding cover and reference page). Also, you should use at least 2 academic references to support your analysis and critical thinking.

Write a Review

Other Subject Questions & Answers

  Cross-cultural opportunities and conflicts in canada

Short Paper on Cross-cultural Opportunities and Conflicts in Canada.

  Sociology theory questions

Sociology are very fundamental in nature. Role strain and role constraint speak about the duties and responsibilities of the roles of people in society or in a group. A short theory about Darwin and Moths is also answered.

  A book review on unfaithful angels

This review will help the reader understand the social work profession through different concepts giving the glimpse of why the social work profession might have drifted away from its original purpose of serving the poor.

  Disorder paper: schizophrenia

Schizophrenia does not really have just one single cause. It is a possibility that this disorder could be inherited but not all doctors are sure.

  Individual assignment: two models handout and rubric

Individual Assignment : Two Models Handout and Rubric,    This paper will allow you to understand and evaluate two vastly different organizational models and to effectively communicate their differences.

  Developing strategic intent for toyota

The following report includes the description about the organization, its strategies, industry analysis in which it operates and its position in the industry.

  Gasoline powered passenger vehicles

In this study, we examine how gasoline price volatility and income of the consumers impacts consumer's demand for gasoline.

  An aspect of poverty in canada

Economics thesis undergrad 4th year paper to write. it should be about 22 pages in length, literature review, economic analysis and then data or cost benefit analysis.

  Ngn customer satisfaction qos indicator for 3g services

The paper aims to highlight the global trends in countries and regions where 3G has already been introduced and propose an implementation plan to the telecom operators of developing countries.

  Prepare a power point presentation

Prepare the power point presentation for the case: Santa Fe Independent School District

  Information literacy is important in this environment

Information literacy is critically important in this contemporary environment

  Associative property of multiplication

Write a definition for associative property of multiplication.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd