| Home > Forum Home > Excel Portfolio Optimization Template > Setting up portfolio with cash > Use the minimum constraint | Share |
Use the minimum constraint
Excel Help for Use The Minimum Constraint in Excel Portfolio Optimization Template
| Forum Topic | Login |
Use The Minimum Constraint | Rate this: (3/5 from 1 vote) |
 | You can specify a minimum constraint of 10% for the cash fund in the Input sheet. This will include it as and investment in the portfolio optimization but ensure that its weighting is at least 10%. Alternatively, you can simply opt to omit the cash investment from the optimization and then add it back into the portfolio by adjusting the weightings accordingly. | |
| Excel Business Forums Administrator | ||
| Posted by Excel Helper on | ||
| View Full Post |
| Find relevant Excel templates and add-ins for Use the minimum constraint in the Excel Business Solutions Directory |