How should his investment be diversified

Reference no: EM131559333

Question - For the following question, use financial application 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-sponsoredmortgage loans	8.25%	25%
Bond investments	5.75%	12%
Stock investments	8.75%	15%
Futures trading	9.50%	10%

Attachment:- Assignment Files.rar

Reference no: EM131559333

Questions Cloud

Find the probability distribution associated with the data : MONEY MARKET RATES The interest rates paid by 30 financial institutions on a certain day for money market deposit accounts are shown in the accompanying table.

What would be likely economic impact of import restrictions : What would be the likely economic impact of import restrictions and limitations on immigration, policies currently being proposed by the Trump Administration?

Calculate the expected cash flows as well as the npv : Create data table in excel. Set up spreadsheet to calculate the expected cash flows as well as the NPV, IRR and Profitabiity Index.

Draw the histogram representing the probability distribution : WAITING LINES The accompanying data were obtained in a study conducted by the manager of SavMore Supermarket. In this study, the number of customers waiting.

How should his investment be diversified : For the following question, use financial application methodology. How should his investment be diversified to make the most interest income

Who gains and who loses from import restrictions : Who gains and who loses from import restrictions? Make sure to mention all workers, import-competing industries, consumers and exporting industries.)

What are their portfolio and direct investments : What is their absolute advantage. What are their portfolio and direct investments

Mechanical properties of sample rocks to field situations : Discuss the problem and limitation of extrapolating mechanical properties of sample rocks to field situations.

Saving leads to a higher standard of living : Consider how to explain how higher saving leads to a higher standard of living. What might deter a policymaker from trying to raise the rate of saving?

Reviews

len1559333

7/10/2017 2:40:48 AM

I need a spreadsheet of the solution to the answer. There is no objective function outcome value and there are no values for the LHS S RHS constraints. Sensitivity reports are also wrong. As is this submission is assessed at zero point. I suggest read the assigned chapters very carefully, and actually do the solved problems before attempting to do the homework.

len1559333

7/10/2017 2:40:42 AM

Application of Methods, Tools, and Techniques - Able to put key concepts in formulating the problem, developing the LP layout, using appropriate formulas for objective function and constraints, applies Excel Solver program for finding solutions, producing output reports, and correctly interpreting results to answer questions asked. Analysis - Analysis demonstrates an excellent understanding of the use and limitations of Linear Programming. Critical Thinking - Conclusions and Recommendations - Draws informed conclusions that are justified with evidence from the output reports and correctly interpreting results. Writing(Mechanics/Style) - No errors related to organization and grammar. Style is professional, compelling, and uses appropriate vocabulary.

Write a Review

Required(*) Message

Finance Basics Questions & Answers

Financial reporting and analysis

Finance is about Gunns Ltd, a company in dealing with forestry products in Australia. The company has also been listed in Australian Stock Exchange. As many companies producing forestry products, even Gunns Ltd is facing various problems. Due to the ..

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!

Submit Assignment

User Account

All Pages