Please solve the problems below using Excel Solver. Please use the necessary settings. Also, please continue to adhere to the spreadsheet modeling principles.

Selecting a Portfolio: A portfolio manager has developed a list of six investment alternatives for

a multi$-$year horizon. These are Treasury bills, Common stock, Corporate bonds, Real Estate,

Growth Funds, and Savings and Loans. These investments and their various financial factors are

described below. In the table, the length represents the estimated number of years required for

the annual rate of return to be realized. The annual rate of return is the expected rate over the

multi$-$year horizon. The risk coefficient is a subjective estimate representing the manager's

appraisal of the relative safety of each alternative, on a scale of $10.$ The growth potential is also

a subjective estimate of the potential increase in value over the horizon.

he manager wishes to maximize the annual rate of return on a $$3$ million portfolio, subject to the

ollowing restrictions:

The weighted average length should not exceed $7$ years.

The weighted average risk coefficient should not exceed $5.$

The weighted average growth potential should be at least $10$ percent.

The investment in real estate should be no more than twice the investment in stocks and bonds

$($CS$,$ CB$,$ and GF$)$ combined.

What is the optimal return $($as a percentage$)$ and the optimal allocation of investment funds?

What is the marginal rate of return? That is$,$ what would be the return on the next dollar

invested, if there were one more dollar in the portfolio?

For additional investment beyond the original $$3$ million, how will the optimal allocation change?