Weights

$1\mathrm{.}000$ In solver: This cell must equal $1($i$.$e$.$ weights sum to $100\%)$

I. Asset Allocation Problem

PORTFOLIO STATISTICS

SOLVER SOLUTION

IN SOLVER:

This should equal the target expected return

Minimze this $($Set objective, minimze$)$

RISK$\_$FREE RATE

TARGET EXPECTED RETURN

Weights

P $$

Weights

U$.$S$.$ Equities

U$.$S$.$ Long$-$term corporate bonds

PORTFOLIO RETURN $[$E $[$:$(r_p)$