An investor is considering allocating $10,000 among five investment alternatives. The five alternatives and their respective fund categories, risk levels, and average annual returns are shown below: Name of Fund Category of Fund Money Market Fund Money Market Fund Adams Barney Chilton Dunster Excelsior Bond Fund Bond Fund Risk Level Average Annual Return 1 2 2 The maximum annual return is $ 3 Aggressive Growth Fund 5 4.50% 5.62% 6.80% 10.15% 20.60% The risk level of each investment is rated on a scale of 1 to 5, where 1 is very conservative and 5 is very risky. The investor would like to maximize the average annual return on his investment subject to the following restrictions: 1. The weighted average risk level of the entire investment should not exceed 2.5, where the weight of each fund is proportional to the amount of money invested into the fund. 2. At least 30% of the investment should be placed in money market funds. 3. At most $2,000 should be invested in the aggressive growth fund. Let A, B, C, D, E denote the amounts of money invested in Funds Adams, Barney, Chilton, Dunster and Excelsior, respectively. Construct the math model using the decision variables defined to solve this decision problem. Please solve your math model using Excel solver to determine the optimal allocation of the investor's money.

Solved: An investor is considering allocating $10,000 among five investment al

Home
questions and answers
an investor is considering allocating usd10 000 among five investment

Question

An investor is considering allocating $10,000 among five investment alternatives. The five alternatives and their respective fund categories, risk levels, and average annual returns are shown below: Name of Fund Category of Fund Money Market Fund Money Market Fund Adams Barney Chilton Dunster Excelsior Bond Fund Bond F