Models
This model illustrates a portfolio optimization model which uses detailed financial calculations on a number of project worksheets to obtain project NPVs and present values of project costs. The goal is to select the projects for the portfolio that maximize the mean portfolio NPV, but to ensure with 95% confidence that the total present value of costs stays below the budget of $1.5 million.