Blair & Rosen, Inc. (B&R) is a brokerage firm that specializes in investment por
ID: 2781329 • Letter: B
Question
Blair & Rosen, Inc. (B&R) is a brokerage firm that specializes in investment portfolios designed to meet the specific risk tolerances of its clients. A client who contacted B&R this past week has a maximum of $55,000 to invest. B&R's investment advisor decides to recommend a portfolio consisting of two investment funds: an Internet fund and a Blue Chip fund. The Internet fund has a projected annual return of 17%, while the Blue Chip fund has a projected annual return of 8%. The investment advisor requires that at most $25,000 of the client's funds should be invested in the Internet fund. B&R services include a risk rating for each investment alternative. The Internet fund, which is the more risky of the two investment alternatives, has a risk rating of 5 per thousand dollars invested. The Blue Chip fund has a risk rating of 5 per thousand dollars invested. For example, if $10,000 is invested in each of the two investment funds, B&R's risk rating for the portfolio would be 5(10) + 5(10) = 100. Finally, B&R developed a questionnaire to measure each client's risk tolerance. Based on the responses, each client is classified as a conservative, moderate, or aggressive investor. Suppose that the questionnaire results classified the current client as a moderate investor. B&R recommends that a client who is a moderate investor limit his or her portfolio to a maximum risk rating of 240.
1.Build a spreadsheet model and solve the problem using Solver. What is the recommended investment portfolio for this client?
Internet Fund =
Blue Chip Fund =
2.Suppose that a second client with $55,000 to invest has been classified as an aggressive investor. B&R recommends that the maximum portfolio risk rating for an aggressive investor is 350. What is the recommended investment portfolio for this aggressive investor?
Internet Fund=
Blue Chip Fund=
Suppose that a third client with $55,000 to invest has been classified as a conservative investor. B&R recommends that the maximum portfolio risk rating for a conservative investor is 150. Develop the recommended investment portfolio for the conservative investor.
internet fund
blue chip fund
annual return
What is the annual return for the portfolio?Explanation / Answer
1. Solving using solver, we get:
Investment in internet fund =25000
Investment in blue chip fund = 23000
Total amount invested = 48000
2. For this, the constraint of internet fund remaining at 25000.
Total risk for remaining fund to be invested in bluechip is 150 (30000/1000*5)
Hence, max risk = 240
Amount invested in internet fund = 25000
Amount invested in bluechip fund = 30000
Annual return = 12%
3.
Here the maximum amount invested is 30000.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.