| Microsoft Excel 9.0 Answer Report | ||||||
| Worksheet: [invest0.xls]Model | ||||||
| Report Created: 10/22/2001 5:20:11 PM | ||||||
| Target Cell (Min) | ||||||
| Cell | Name | Original Value | Final Value | |||
| $D$5 | Stnd. Dev. | 2.95 | 1.24 | |||
| Adjustable Cells | ||||||
| Cell | Name | Original Value | Final Value | |||
| $F$5 | Portfolio Weights x(j) | 0.0% | 23.2% | |||
| $G$5 | 100.0% | 26.4% | ||||
| $H$5 | 0.0% | 50.4% | ||||
| Constraints | ||||||
| Cell | Name | Cell Value | Formula | Status | Slack | |
| $C$5 | Return | 1.00 | $C$5>=$C$7 | Binding | 0.00 | |
| $J$5 | Weights | 100% | $J$5=$J$7 | Binding | 0 | |