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

  Discuss about the paranoid schizophrenia

Discuss about the Paranoid schizophrenia .Symptoms What is going on with the person, how do they act and rook?

  What is social responsibility

What is social responsibility

  How do scientists determine topography of the ocean floor

How do scientists determine the topography (shape) of the ocean floor - What is the water depth in meters if the average speed of sound in water is 1500 meters per second? Assume the echo sound took

  National drilling company ships its only pump to american

national drilling company ships its only pump to american hydraulics corporation the manufacturer for repair. national

  Recognize and explain the two strategies that older

q1. older children typically remember more than younger children.q2. identify and describe two strategies that older

  Describing best game productions dilemma

Write a persuasive memo of at least 1,000 words to an internal stakeholder describing Best Game Productions' dilemma. Include the benefits and rationale.

  Effective and least effective for the country you researched

Explain which of the policies is most effective and least effective for the country you researched? Provide a rationale with your answer.

  How community development block grants have aided

how community development block grants have aided in community revitalization

  Optimal sample definitions and data collection

It is known that through optimal sample definitions and data collection, test norms are not absolute. With this they can change with time or with a different norm group.

  Plant growing in an environment

Consider a plant growing in an environment where all abiotic factors for growth are ideal EXCEPT one single factor that is too high (above its limit of tolerance). How would this most likely affect the plant's growth?

  Consider photographic technique-lighting-framing-family

Which Mann has used her family in her work, including both the Immediate Family series, pictures of her children from the early 1990's and the Proud Flesh series of her husband (Consider photographic technique, lighting, framing, focus, meaning, and/..

  What the contingency plan needs to include

How the contingency plan's particulars will be communicated to the various stakeholders (employees, consumers, local and national authorities, etc.).

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