1 Below are a list of potential capital budgeting projects for DVX Inc. 2 Create a...

Transcribed Image Text:

1 Below are a list of potential capital budgeting projects for DVX Inc. 2 Create a vlookup which will populate the list of projects to be selected based on the following criteria 3 1. Budget of $4,000,000 per region. 4 5 2. Populate the Include column to indicate which project from each region should be selected, based on the project in each region with the highest NPV while staying below the total budget constraint. If functions may be useful in this step. 3. Use the vlookup to insert the project number, cost, and NPV of the selected project from each region into the table. 6 7 8 9 10 11 12 DVX Inc. Optimal Capital Budget 13 Under Capital Rationing 14 Include Region Project 15 Europe 1 Cost $1,200,000 NPV $172,036 16 Europe 2 $2,000,000 $362,283 17 Europe 3 $500,000 $147,487 18 Asia 4 $600,000 $72,076 19 Asia 5 $700,000 $129.35 21 24 222222222202 Asia 6 $3,000,000 $527,127 Asia 7 $1,500,000 $343,632 Africa 8 $200,000 $52,836 Africa 9 $2,400,000 $275,936 Africa 10 $1,000,000 $175,824 Constraint 4,000,000 Europe Asia Africa Project Cost NPV - 1 Below are a list of potential capital budgeting projects for DVX Inc. 2 Create a vlookup which will populate the list of projects to be selected based on the following criteria 3 1. Budget of $4,000,000 per region. 4 5 2. Populate the Include column to indicate which project from each region should be selected, based on the project in each region with the highest NPV while staying below the total budget constraint. If functions may be useful in this step. 3. Use the vlookup to insert the project number, cost, and NPV of the selected project from each region into the table. 6 7 8 9 10 11 12 DVX Inc. Optimal Capital Budget 13 Under Capital Rationing 14 Include Region Project 15 Europe 1 Cost $1,200,000 NPV $172,036 16 Europe 2 $2,000,000 $362,283 17 Europe 3 $500,000 $147,487 18 Asia 4 $600,000 $72,076 19 Asia 5 $700,000 $129.35 21 24 222222222202 Asia 6 $3,000,000 $527,127 Asia 7 $1,500,000 $343,632 Africa 8 $200,000 $52,836 Africa 9 $2,400,000 $275,936 Africa 10 $1,000,000 $175,824 Constraint 4,000,000 Europe Asia Africa Project Cost NPV -