Three restrictions on the bank portfolio

Assignment Help Operation Management
Reference no: EM131427875

A bank is attempting to determine where its assets should be invested during the current year. At present, $500,000 is available for investment in bonds, home loans, auto loans and personal loans. The annual rate of return on each type of investment is known to be: bonds, 10%; home loans, 16%; auto loans, 13%; personal loans, 20%.

To ensure that the bank’s portfolio is not too risky, the bank’s investment manager has placed the following three restrictions on the bank’s portfolio:

Constraint 1: The amount invested in personal loans cannot exceed the amount invested in bonds.

Constraint 2: The amount invested in home loans cannot exceed the amount invested in auto loans.

Constraint 3: No more than 25% of the total amount invested may be in personal loans The bank’s objective is to maximize the annual return on its investment portfolio. Formulate and solve an LP that will enable the bank to meet this goal.

Solve using Microsoft Excel Solver. Be sure to show formulas inputed into Microsoft Excel Solver and show all constraints.

Reference no: EM131427875

Questions Cloud

Training for a local environmental volunteer organization : Consider the following: Jamie recently attended training for a local environmental volunteer organization. She expected that this training would prepare her to lead local river clean-ups with school children.
Impact of corporate social responsibility : What is the impact of corporate social responsibility on a company's strategic positioning?
What is the appropriate tax rate to be used in wacc : What's the appropriate tax rate to be used in WACC? Suppose a firm pays total dividends of $1,240,000 out of a net income of $8 million. What would the firm's payout ratio be
Common conflicts among health professionals : Which one of the common conflicts among health professionals do you find the most prominent in healthcare? What are the effects of that conflicts? Explain with an Example.
Three restrictions on the bank portfolio : A bank is attempting to determine where its assets should be invested during the current year. At present, $500,000 is available for investment in bonds, home loans, auto loans and personal loans. To ensure that the bank’s portfolio is not too risky,..
What type of financial incentives are offered on website : The use of website advertising has become a highly effective method of reaching consumers. Why is this the case? The purpose of this assignment is to answer that question and to identify the characteristics of an effective website design by compar..
How these design elements encourage learning and transfer : Traditionally, Autodesk used to hold tow annual training events for its partners in the United States and Canada. Autodesk decided to convert the face-to-face, instructor-led training event to a virtual classroom, the program’s core content was revie..
Pros and cons for a formal disciplinary process : Conclude your essay by defending at least three specific recommendations you would make to the university ,paper should be 6-8 pages, in APA format, and include atleast 4 references.
Analyze the execution strategy for the sbu : Select a publicly traded organization that you have not used previously in this course. You are strongly encouraged to use the same organization that you are using for your Unit 10 assignment - Analyze the execution strategy for the SBU and What el..

Reviews

Write a Review

Operation Management Questions & Answers

  Percentage of calls being answered by a physician in the us

What is the percentage of calls being answered by a physician in the US? (Write the percentage, that is, if your answer is 53.22%, input 53.22 as the answer.)

  What did the organization miss in its macro environment

What did the organization miss in its macro environment? Discuss the strategic implications of this omission. Did rivals or other organizations in other industries also miss the signs of this pending threat or opportunity?

  Company produces a grain combine

The Farm-4-Less Tractor Company produces a grain combine (GC) in addition to both a large (LT) and small size tractor (SM). Its production manager desires to produce to customer demand using a mixed model production line. The current sequence of prod..

  The lake charles location would increase system

The Lake Charles location would increase system transportation costs by $50,000 per year, the Houma location by $60,000 per year, and the Gulf Port location by $29,600 per year

  Intro to public safety administration

Intro to Public Safety Administration really gave me a perspective on what it is about. Before taking this class, I did not know how in depth Public Safety was. I plan on using the knowledge gained from this course and from future public safety admin..

  What is meant by the term strategic group

What is meant by the term “strategic group,” and why is it important for managers to understand this in order to position their companies in a competitive marketplace?

  Which type of machine would be chosen

With high certainty of annual demand, which type of machine would be chosen if that was an important consideration? With low certainty, which type of machine would be chosen?

  What is involved in setting the stage for compensation

What is involved in setting the stage for compensation? In your discussion include the concepts of traditional bases for pay, the roles of seniority, merit, and performance appraisal systems. Share information regarding the limitations of merit pay s..

  Determine the average time and the normal time

Claudine Soosay recorded the following times assembling a watch. Determine (a) the average time, (b) the normal time, and (c) the standard time taken by her, using a performance rating of 95% and a personal allowance of 8%

  Audits are commonly associated with the financial

Audits are commonly associated with the financial and accounting records of the business. Using the publicly available financial statements of Mcdonald's

  Economies satisfying the assumptions of the solow model

There are two islands, Avalon and Baltia, which have identical economies satisfying the assumptions of the Solow model. In particular, output in both economies is produced with the neoclassical production function F(K, AL) using inputs capital K, tec..

  Legal concepts of express and implied

After reading Exodus 22:7 discuss the legal concepts of "express and implied" warranties and relate these concepts to the biblical instructions concerning business responsibility for the performance of and damages caused by products sold to the publi..

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