Chapter 32: Analyzing Data Using Goal Seeking and Solver
3232
■ (^) Unsecured loans should make up no more than 25% of the portfolio. This con-
straint is represented as
E8<=.25
■ At least 10% of the portfolio should be in bank CDs. This constraint is repre-
sented as
E9>=.10
■ (^) The total amount invested is $5,000,000.
■ All investments should be positive or zero.
The changing cells are C5:C9, and the goal is to maximize the total yield in cell D12.
Starting values of 1,000,000 have been entered in the changing cells. When you run Solver
with these parameters, it produces the solution shown in Figure 32.17, which has a total
yield of 9.25%.
FIGURE 32.17
The results of the portfolio optimization