hello i want solve in execl

1- formulate and solve a binary integer prohramming model in a spepreatd sheet determine which project should be pursued ti maximise total expected NPV ?

after adding the following below contingacy concstrints formaulate and solve a BIP model again

3 6 2. A company is planning its capital budget over the next several years. Ther are eight potential projects under consideration. A calculation has been made of the expected NPV (Net Present Value cash outflow that would be required over the four year. These data, along with the cash that is available each year, are shown in the table below Cash Outflow Required (Smillion) Project (5 Year Year Year's Year NPV(mil) Formate seu llinary Integer Programming model in spreadsheet to determine which projects should be pared to maximize the total expected NPV 25 scores) ding the following below costcy Corint, focolate and solve a Pala (25 scores) () at least one of project 1, 2 or 3 must be done (6) project 6 and 7 ot be 0 3 1 2 2 0 5 10 1 12 11 IS 24 17 16 18 project can only be doned project is done