Investment Portfolios

Your company manages investments for your clients, where you build portfolios based on anticipated yield and risk. (Yield and risk are generally based on historical performance of the investment instruments.)

The three instruments you are considering for a client are growth, income, and money market funds, which you determine to have risks of .1, .05, and .01 respectively. Furthermore, you project the yields of these funds to be 20%, 10%, and 6% respectively.

Your client insists that you diversify, with at least 10% in each of the growth and income funds, and at least 20% in the money market fund.

Your client wants to assume no more that 5% risk, where overall risk is calculated based on a weighted average of the risks of each individual instrument, and where the weightings are the percents of the investment that go towards each instrument.

If your client has $1,000,000 to invest, how should you allocate his funds?

How much can your yield estimates for each instrument change (individually) before you have to change this allocation?

Please show and explain steps using solver.