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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!