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
