Dropdown choices:

a. Projects 1 and 4 ; Projects 2, 3 and 5 ; Projects 1, 2 and 5 ; Projects 1, 3 and 5 ; Not in the choices ; Projects 1, 2 and 3

b. $58 millions ; Not in the choices ; $55 millions ; $50 millions ; $47 millions ; $21 millions

c. $6 millions ; $0 million ; Not in the choices ; $34 millions ; $12 millions ; $40 millions

d. $2 millions ; Not in the choices ; $0 million; $11 millions ; $13 millions ; $12 million

Trax Construction Company is considering a number of different development projects (P1 to P5). The cash outflows that would be required to complete each project are indicated in the table, along with the expected net present value of each project and the available funds to invest in these projects for each year (all in millions of dollars). P1 P2 P3 P4 P5 Available Cash Year 1 $8 $10 $12 $4 $14 $40 Year 2 6 6 6 3 25 Year 3 3 7. 8 0 5 16 Year 4 0 6 5 2 7 12 NPV $12 $15 $20 $9 $23 The company's policy is to choose their projects to maximize their expected NPV. Formulate and solve the BIP model on spreadsheet. Determine the following: a) Which projects should be pursued? (Select] b) What is the possible maximum NPV? (Select] c) How much is the possible excess funds in Year 1 if any? I Select] d) How much is the expected investment cost in Year 4? Select