please use excel to solve this and show all formulas/steps taken. thank you

Problem 2:2 New Foundations Real Estate has to make a capital budgeting decision around six different projects that they have to decide if they want to undertake or not. Each of these six projects are different real estate investments that the company can undertake. For a list of the projects, see the table below. The numbers are in millions of dollars. Your total budget is $220 million Project 1 2 3 4 5 Pittsburgh Cleveland Wheeling Columbus Philadelphia Apartment Shopping Medical Office Apartment Complex Mall Building Building Complex $15 $5 $13 $14 $20 6 Erie Shopping Mall $9 Net Present Value ($ Millions) Expenditure Required ($ Millions) $90 $34 $81 $70 $114 $50 There are conditions that limit the investment alternatives: HINTL (In order to see if this works, think about adding up 1's Yes and O's No from the model to see if the sum is 2 or more). At least two pf the projects 1,3,5 and 6 must be undertaken If either project 3 or 5 is undertaken, they must bot be undertaken Project 4 cannot be undertaken unless both projects 1 and 3 are also undertaken. . . Objective: Determine which projects to undertake (hint hint it's a yes or no) in order to maximize your net present value