Question: 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

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 rates of return on each type of investment are known to be the following: bonds, 10%; home loans, 16%; auto loans, 13%; and 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:

■ The amount invested in personal loans cannot exceed the 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.

Help the bank maximize the annual return on its investment portfolio.

Step by Step Solution

★★★★★

3.45 Rating (177 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Bank assets Range names used AnnReturn ModelB15 Annual rates Auto ModelD11 Bonds ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

1497_604065b98d5d3_694822.xlsx

300 KBs Excel File

Students Have Also Explored These Related Practical Management Science Questions!

A heating oil retailer has been buying heating oil at $2.82 per gallon and keeps a 30-day supply on hand. He sells 5,000 gallons per day and has been charging his customers $3.25 per gallon. The...

Oriental Bank is attempting to determine the cost behavior of its small business lending operations. One of the major activities is the application activity. Two possible activity drivers have been...

Comparison of Regression Equations Friendly Bank is attempting to determine the cost behavior of its small business lending operations. One of the major activities is the application activity. Two...

GMS Corporation is attempting to determine whether to lease or purchase research equipment. The firm is in the 40% tax bracket, and its after-tax cost of debt is currently 6%. The terms of the lease...

3 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....

M3_A3. 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...

To be done on Excel 2. (32 pts) 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,...

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....

A bank is attempting to determine where its assets should be invested during the current year. At present, $400,000 is available for investment in bonds, home loans, auto loans, and personal loans....

A bank is attempting to determine where its assets should be invested during the current year. At present, $1,000,000 is available for investment in bonds, home loans, auto loans, and personal loans....

Define the notion of arbitrage. How does it affect the issue of capital structure?

You are considering some put and call options and have available the following data: a. Comparing the two calls, should DEF sell for more or less than ABC? Why? b. What is the time value for ABC? c....

11. [(Q P) (Q R)] (P R) Use truth tables to determine whether the following symbolized statements are tautologous, self-contradictory, or contingent.

For the truss structure Determine the governing equilibrium equation. Pf = KffU; + Pro Consider the applied loads and a distributed load wy = 5kN/m on member AC in the direction shown. Member AB is...

For the truss structure Determine the governing equilibrium equation. P; = KrFUf + Pro Consider the applied loads and a distributed load w, = 5kN/m on member AC in the direction shown. Member AB is...

3: Please clearly show how to compute 2144 mod 101 (without applying Fermat's Little Theorem or Euler's Theorem, if you already know them) using no more than 8 multiplications in Z/(101). Hint: It...

5. Determine if the following integrals converge or diverge by using the indicated tests next to them. -x+ 2r2 + etz J 2 - PAreseer e-21 dx (DCT) dr (DCT) b) *Valnr + fr-/2 3/2 + Arcsecr + Inx -dr...

2.4. An insurance company issues 20 year annuities-due to lives aged 55 on January I, 1982 when the single premiums are payable. The amount of the total annuity payments if $1,460,000 in 1990...

Give an example of a foreign-made product (other than an automobile) that you pe r sonally have purchased. Give some reasons why you purchased that product. Do you think that there was a good...

ko, Inc.s managers are comparing the profitability of a target marketing strategy with a mass marketing strategy. The spreadsheet gives information about both approaches. The mass marketing strategy...

Do you think it makes sense for a firm to base its mission statement on the type of product it produces? For example, would it be good for a division that produces electric motors to have as its...

There is an inverse relationship between bond prices and yields. This inverse relationship will be demonstrated by calculating bond prices to show that interest rates move inversely: if yields rise,...

I have a few multiple choice questions it would be great if you could help. Thanks 1) In experimental study the treatment group is: a)are not treated with a placebo b) is called the control group...

please help Question 6 2 pts Finish times (to the nearest hour) for 10 dogsled teams are shown below. Make a frequency table showing class limits, class boundaries, midpoints, frequency, relative...