How investment be diversified to make most interest income

Assignment Help Financial Accounting

Reference no: EM131184295

For the following question, use blended methodology.

An investor wishes to invest some or all of his $12.5 million in a diversified portfolio through a commercial lender. The types of investments, the expected interest per year, and the maximum allowed percentage investment he will consider are shown on the following table. He wants at least 35% of his investments to be in nonmortgage instruments and no more than 60% to be in high-yield (and high-risk) instruments (i.e., expected interest >8%). How should his investment be diversified to make the most interest income?

Investment	Expected Interest	Maximum Allowed
Low-income mortgage loans	7.00%	20%
Conventional mortgage loans	6.25%	40%
Government-sponsored mortgage loans	8.25%	25%
Bond investments	5.75%	12%
Stock investments	8.75%	15%
Futures trading	9.50%	10%

PROVIDE EXCEL SHEET including SOLVER SOLUTION AND SENSITIVY REPORT.

Reference no: EM131184295

Questions Cloud

Identify service that should be offered by queen zaria brand : MKT203 Services Marketing Individual Report Assignment. Identify the services that should be offered by Queen Zaria brand. Identify the steps Queen Zaria brand needs to take to ensure excellent 'Word of Mouth' at the point of customer contact

How do you handle the given situation : Another departments supervisor fails to give you information that you should have received. As a result your departments manager productivity has gone down. How do you handle the situation?

Find the location and number of image charges : Find the location and number of image charges if the charge in Figure 5.12a is placed at a distance d from the upper plate and a distance b from the lower plate while the angle between the plates is 30°.

Which factors would most favor felipe : Which of the factors you consider important would most favor Taneshia. Which factors would most favor Felipe? Which would most favor Amanda?

How investment be diversified to make most interest income : use blended methodology.- An investor wishes to invest some or all of his $12.5 million in a diversified portfolio through a commercial lender.- How should his investment be diversified to make the most interest income?

Calculate the energy per unit length stored in the cylinder : Energy per unit length. A line of charge with line charge density PI is surrounded by a dielectric layer as shown in Figure 4.80. The permittivity of the layer is ε. Calculate the energy per unit length stored in the cylinder (a ≤ r ≤b.

Develop an action plan for the final presentation : Identify the audience, for example a board of directors or a new management team following an acquisition or a merger, for your final presentation due in Week Five. Provide a rationale for your audience selection.

How tall of a water column in inches equals one psig : How tall of a water column in inches equals 1 psig? 29.9 inches of mercury provides 1 atmosphere of pressure. How many inches of mercury will provide 1 psi of pressure?

Four trends in the macro market environment : Four trends in the macro/market environment that will have or recently had an influence on the selected industry.

User Account

All Pages