Capital Budgeting with Financial Statements

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.

linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram