PLEASE IF YOU GONNA ATTEMPT, DO ALL THE QUESTION, 1, 2 AND 3 WITH A SPREADSHEET MODEL AND STEP BY STEP SOLUTIONS.. EXPERTS PLEASE HELP...

1 Project Selection at Ewing Natural Gas D3 Inputs All values in millions 4 Project index Functional Area (FA) Capex Year 1 Capex Year 2 Capex Year 3 NPV 1 FAI 250.00 60.00 100.00 100.00 G 2 FAI 165.00 oco cq.00 40 3 FAI 100.00 200.00 40.00 50.00 4 FAI 500.00 310.00 750.00 300.00 5 FAI 600.00 150.00 300.00 165.00 10 6 FA 500.00 150.00 150.00 90.00 11 7 FA2 750.00 750.00 300.00 410.00 12 8 FA 800.00 700.00 600.00 280.00 13 FA2 268.00 402.00 536.00 254.60 14 10 400.00 100.00 200.00 100.00 FA3 11 350.00 250.00 150.00 130.00 FA3 D16 12 FA3 1500.00 400.00 400.00 340.00 18 Decisions Capex for company 1 Project Selection at Ewing Natural Gas D3 Inputs All values in millions 4 Project index Functional Area (FA) Capex Year 1 Capex Year 2 Capex Year 3 NPV 1 FAI 250.00 60.00 100.00 100.00 G 2 FAI 165.00 oco cq.00 40 3 FAI 100.00 200.00 40.00 50.00 4 FAI 500.00 310.00 750.00 300.00 5 FAI 600.00 150.00 300.00 165.00 10 6 FA 500.00 150.00 150.00 90.00 11 7 FA2 750.00 750.00 300.00 410.00 12 8 FA 800.00 700.00 600.00 280.00 13 FA2 268.00 402.00 536.00 254.60 14 10 400.00 100.00 200.00 100.00 FA3 11 350.00 250.00 150.00 130.00 FA3 D16 12 FA3 1500.00 400.00 400.00 340.00 18 Decisions Capex for company