Question 10 (2 points) Saved Consider the screenshot below (if it doesn't display properly, you can download the source spreadsheet from this link) which shows a potential solution for a Capital Budgeting problem. When it comes time to fill out Solver, which of the following is a correctly-modeled constraint? B D E G H 1 Capital budgeting 2. 3. Note: All cash amounts are in Smillions 4 5 Cash outflows in various years, NPV of projects 6 Project 1 Project 2 Project 3 Project 4 Project 5 Project 6 Project 7 7 Year 1 $1 $3 $4 $6 $5 $4 $8 8 Year 2 $3 $4 $4 $5 $1 $5 $7 9 Year 3 $4 $2 $3 $3 $2 $2 $1 10 Year 4 $1 $1 $2 $2 $3 $5 $1 11 Year 5 $1 $2 $1 $3 $8 $5 $1 12 NPV $20 $25 $30 $35 $40 $42 $39 13 14 Selected projects (1 if selected, 0 if not) 15 Project 1 Project 2 Project 3 Project 4 Project 5 Project 6 Project 12 16 1 1 1 1 0 17 18 Budget constraints 19 Outflow Relation Budget 20 Year 1 $19 $20 21 Year 2 $17 $20 22 Year 3 $14 $20 23 Year 4 $9 $20 24 Year 5 $15 $20 25 28 Total NPV $150 19 20 Year 1 21 Year 2 22 Year 3 23 Year 4 24 Year 5 25 26 Total NPV Outflow Relation Budget $19 $20 $17 $20 $14 $20 $9 $20 $15 $20 $150 B20:B24 = binary B20:B24 > D20:D24 B20:B24 D20:D24 B20:B24