I have this problem and am needing help to solve it.
Problem 11-3 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 12%, while the Blue Chip fund has a projected annual return of 9%. 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 4 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 250. What about a risk rating of 150?
The question(s) ask the following:
(b) Build a spreadsheet model and solve the problem using Solver. What is the recommended investment portfolio for this client?
Internet Fund=
Blue chip fund=
Annual Return=
(c) 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 310. What is the recommended investment portfolio for this aggressive investor?
Internet Fund=
Blue chip fund=
Annual Return=
(d) 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=
I have this problem and am needing help to solve it.
Problem 11-3 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 12%, while the Blue Chip fund has a projected annual return of 9%. 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 4 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 250. What about a risk rating of 150?
The question(s) ask the following:
(b) | Build a spreadsheet model and solve the problem using Solver. What is the recommended investment portfolio for this client? Internet Fund= Blue chip fund= Annual Return=
|
For unlimited access to Homework Help, a Homework+ subscription is required.
Related questions
The discounted dividend model can be used to value divisions and firms that do not pay dividends. For the discounted dividend model, a firm's weighted average cost of capital is used as the discount rate. For the corporate valuation model, a firm's cost of equity is used as the discount rate. |
For the constant growth model to hold, a firm's cost of equity needs to be greater than its constant dividend growth rate (i.e., rs > g). From the constant growth model, if the constant dividend growth rate is equal to zero, a firm's share price is equal to the constant dividend divided by the cost of equity (i.e., g=0). If a company's constant dividend growth rate is negative, the formula for the constant growth model cannot be applied. |
The internal rate of return method (IRR) assumes that cash flows are reinvested at the internal rate of return. The modified internal rate of return method (MIRR) assumes that cash flows are reinvested at the weighted average cost of cpaital. For mutually exclusive projects, if there is a conflict between NPV and IRR, the project with the highest IRR is chosen. The IRR is independent of a firm's weighted average cost of capital. |
The WACC only represents the "hurdle rate" for a typical project with average risk. Therefore, the project's WACC should be adjusted to reflect the project's risk. Firms with riskier projects generally have a lower WACC. Holding all else constant, an increase in the target debt ratio tends to lower the WACC. |
Short-term bond prices are less sensitive than long-term bond prices to interest rate changes. Companies are not likely to call bonds unless interest rates have declined significantly. Thus, the call provision is valuable to firms but detrimental to long term investors. On balance, bonds that have a sinking fund are regarded as being safer than those without such a provision. |
If beta < 1.0, the security is less risky than average. According to the Security Market Line (SML), in general, a companyâs expected return will double when its beta doubles. According to the Security Market Line (SML), if a portfolio of real world stocks has a beta of zero, the required rate of return for the portfolio is equal to the risk-free rate. |
7.37%. 11.05%. 8.32%. |
It ignores cash flows occurring after the payback period. It ignores the time value of money, that is, dollars received in different years are all given the same weight. |
1.82. 2.00. 1.94 |
undervalued. overvalued. |
13.92%. 16.34%. 12.17%. |
$221.86. $195.23. $257.35. |
10.82%. 11.76%. 9.64%. |
10 years. 4.58 years. 6.12 years. |
12.04%. 14.93%. 9.15%. |
1.24 years. 1.62 years. 1.15 years.
|