Dollars available for investment in five different stocks

Assignment Help Operation Management

Reference no: EM131034668

An investment company currently has 1 million dollars available for investment in five different stocks. The company wants to maximize the interest earned over the next year. The five investment possibilities along with the expected interest earned are shown below. To manage risk, the investment firm wishes to have at least 35% of the investment in stocks A and B. Furthermore, no more than 15% of the investment may be in stock E. Model and solve this problem in Excel.

Investment Expected Interest Earned (%)

Stock A 7

Stock B 9

Stock C 8

Stock D 10

Stock E 11

Reference no: EM131034668

Questions Cloud

Does firm have low or high capital intensity : Describe each of the key decisions made by the firm in the operations area. For each decision, identify the choices available to the firm, the selection made, the process used to decide, and the firm's rationale. The following should be included i..

Faced great risk in their business operations : Do you think society should have allowed banks to fail since they too faced great risk in their business operations? Why save big organizations and not small businesses in failure?

Contrast two leadership theories and styles : Compare and contrast two leadership theories/styles (Transactional, Transformational, Charismatic, Servant, and Situational Leadership). do this by describing the similarities and differences between two leadership theories/styles, defining the leade..

Where might the bacteria be located : If so, where might the bacteria be located? How might they be different, beneficial or harmful compared to known bacterial species?

Dollars available for investment in five different stocks : An investment company currently has 1 million dollars available for investment in five different stocks. The company wants to maximize the interest earned over the next year. The five investment possibilities along with the expected interest earned a..

Role of responsibility in management : Management Given the role of responsibility in management, can you think of some examples that demonstrate your ability to accept responsibility? How has accepting responsibility helped your career? How might accepting more responsibilities help you ..

Interviewing for a position in an organization : Suppose you are interviewing for a position in an organization. How might SWOT analysis help you prepare for an interview? Now suppose you've just started working at an organization. How might SWOT analysis help you better understand your position an..

What are its advantages-disadvantages for project managers : Describe the process of developing, running, and analyzing a Monte Carlo simulation as if you were teaching it to someone who had never heard of it before. For what types of project management tasks can Monte Carlo simulation be used? What are its ad..

Write respond about trichomoniasis : Write respond about Trichomoniasis. Trichomonas vaginalis is also known as "Trichomoniasis" or "trich" for short term. It is a commonly sexually transmitted infection.

User Account

All Pages