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?
Contributed capital as shown on a corporate balance sheet includes the share accounts and any contributed surplus as well as retained earnings.22) Preferred shares are a ...Dec 09 2019
What is the difference between using brainstorming and the Delphi technique for risk identification? What are some of the advantages and disadvantages of each approach? D...Jun 03 2020
1 adelante Audio Heading treinta y uno 31 Lectura Antes de leer BUVEINTICINCO NA VEINTIZZzz. Estrategia Recognizing cognates As you learned earlier in this lesson, cognat...Apr 15 2021
Refer to the following information. Amount Invested 8,000 shares of Stock A S16,000 15,000 shares of Stock B 25,000 shares of Stock C $48,000 $96,000 Beta Beta = 1.3 Bet...Feb 08 2020
You have heard the following statements made. Comment critically on them.(a) ‘Equity only increases or decreases as a result of the owners putting more cash into the busi...Dec 05 2019
How many days after fertilization does the zygote become a ball of cells?a.five daysb.four daysc.one to two daysd.six to eight dayse.it depends on the age of the mother2....Dec 19 2019
Real income in year X is equal to:a. year X nominal income x 100. year X real GDPb. year X nominal income x 100. year X real outputc. year X nominal income CPI/1...Jun 08 2021
Compute the NPV statistic for Project U if the appropriate cost of capital is 11 percent. (Negative amount should be indicated by a minus sign. Do not round intermediate ...Aug 12 2020
The principle that states that assets acquired by the business should be recorded at their exchange price is the:A) objectivity principleB) cost principle of measurementC...Dec 14 2019
Use the graph to state the absolute and local maximum and minimum values of the function.Jun 15 2021