Question: Consider the same four projects in Problem 9, that is : Project Investment NPV PI A 200,000 230,000 1.15 B 125,000 141,250 1.13 C 175,000
Consider the same four projects in Problem 9, that is :
| Project | Investment | NPV | PI |
| A | 200,000 | 230,000 | 1.15 |
| B | 125,000 | 141,250 | 1.13 |
| C | 175,000 | 194,250 | 1.11 |
| D | 150,000 | 162,000 | 1.08 |
Given we have a hard budget constraint that the total investment cannot be higher than $300,000, after creating the capital budgeting optimization model in Excel, answer the following questions:
What is the total required investment in the optimal solution? $______ (enter an integer value with or without the thousand comma separator)
What is the total NPV of the projects in the optimal solution? $_______ (enter an integer value with or without the thousand comma separator)
What is the combined profitability index of the optimal solution? _______ (enter your value in the x.xx format)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help