A company is considering the following five investment proposals for acceptance. The capital required for each project over the next five years is shown in Table 3.10, along with the amount of budgeted capital. Management wants to maximise the rate of return, i.e., maximise the total NPV of the selected proposals. Using Excel’s linear programming tool – Solver – find the optimal set of investments and the resulting NPV of the investments.