4 g Question 4 (2 points) 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 should be your decision variables? B D E G 1 Capital budgeting 2 3 Note: All cash amounts are in Smillions 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 $ $1 $5 $7 9 Year 3 $4 $2 $ $ $2 $2 $1 10 Year 4 $1 $1 $ $2 $3 $5 $ 11 Year 5 $1 $2 $1 $ $8 $5 $1 12 NPV $20 $25 $30 $35 $40 $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 26 Total NPV $150 8555 23335 &333&S B558 $42 $ B7:H12 B20:B24 B16:H16 B26 D20:D24 B20:B24 D20:D24 OB20:B24 = binary OB20:B24