Question
M5.2An investor wishes to invest allof her $8million in a diversified portfolio through a commercial lender. The types of investments, the expected annual interest rate
M5.2An investor wishes to invest allof her $8million in a diversified portfolio through a commercial lender. The types of investments, the expected annual interest rate for the investment, and the maximum allowed percentage of the total portfolio that the investment can represent are shown in the table below:INVESTMENTEXPECTED INTERESTMAXIMUM ALLOWED (% of total portfolio)Low-income mortgage loans4.80%30%Conventional mortgage loans4.20%25%Government sponsored mortgage loans8.20%15%Bond investments4.45%40%Stock investments7.50%15%Futures trading8.50%10%She wants at least 30% of her total investment in non-mortgage instruments. Furthermore, she wants no more than 20% of her total investment to be in high-yield and high-riskinstruments (i.e. expected interest rate of investment is 8% or greater). Formulate and solve this problem in Excel to determine how her money should be diversified in a manner which will meet the requirements and maximize the amount of interest income. (Hint: Make sure that the LHS and RHS of constraints are the same units)SOLUTION:The optimal solution, the value of the interest income,should be $478,800($10 for rounding). The minimum invested in any one investment is $800,000. The maximuminvested in any one investment is $2,400,000.Questions:a)Based on your solution, how much should be invested in government sponsored mortgage loans?b)Based on your solution, how much should be invested in stock investments?c)If you could increase the maximum allowed for the investments (in order to increase overall return) -which would you choose: conventional mortgage loans, bond investments, or governmental sponsored mortgage loans.Explain.d)If the return on low-income mortgage loans was reduced to 4%, how much should be invested in these low-income mortgage loansbased on your new solution?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started