Home / Questions / A bank is attempting to determine where its assets should be invested during the current y...
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 returns are shown in the table below.
Investment Annual Rate of Return 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 banks portfolio:
· The amount invested in personal loans cannot exceed the annual amount invested in bonds.
· The amount invested in home loans cannot exceed the amount invested in auto loans
· No more than 25% of the total amount invested can be in personal loans. Formulate and solve this problem in Excel to determine how the bank should invest in assets to meet the requirements and maximize the annual return of its investment portfolio.
a) How many decision variables does this problem have?
b) Not counting the non-negativity constraint - how many constraints does this problem have?
c) What is the total return for the investments based on your optimal solution (the value of the objective function)?
d) How much should be invested in Bonds based on your optimal solution?
e) How much should be invested in Home Loans based on your optimal solution?
f) How much should be invested in Auto Loans based on your optimal solution?
g) How much should be invested in Personal Loans based on your optimal solution?
Apr 11 2020 Read more Less More
In a supply-and-demand diagram, show how a tax on car buyers of $1,000 per car affects the quantity of cars sold and the price of cars. In another diagram, show how a tax...
Mar 29 2020Choose from the following list of terms/phrases to best complete the statements below. a. Fiscal year b. Timeliness c. Calendar year d. Accounting period e. Annual financ...
May 22 2020Write a program that reads daily maximum and minimum temperatures for the most recent full month of January from a data file. Store the temperatures in a 2-dimensional ar...
May 27 2020On January 1, Evangel Company issued 9% bonds in the face amount of $100,000, which mature in 5 years. The bonds were issued for $96,207 to yield 10%, resulting in a bond...
Mar 20 2020The irreversible elementary reaction 2A —+ B takes place in the gasphase in an isothermal tubular (plug-Jlow) reactor. Reactant A and a diluentC are fed in equimolar rati...
Jul 31 2020Cost-plus, target pricing, working backward. The new CEO of Rusty Manufacturing has asked for information about the operations of the firm from last year. The CEO is give...
Jul 19 2020Summarize the pros and cons of the different ways an entrepreneur with a small business can get an inflow of cash.
Apr 17 20201. What role does manufacturing play relative to the standard of living of a country?
May 23 2020Freedom Wireless reports operating expenses of $255,000. Operating expenses include both rent expense and salaries expense. Prepaid rent decreases during the year by $10,...
Jan 27 2020Create a class named Order that performs order processing of a single item. The class has the following five fields: •Customer name •Customer number •Quantity ordered ...
May 27 2020Welcome to MyCourseHelp Services, World's leading Academic solutions provider with Millions of Happy Students.