please use excel spreadsheet implementing the PARAMETERS, MODEL, AND CONSTRAINTS

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. Also, the total budget is 220 million 6 Project 2 Pittsburgh Cleveland Apartment Shopping Complex Mall $15 $5 3 Wheeling Medical Building $13 4 5 Columbus Philadelphia Office Apartment Building Complex $14 $20 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: HINT(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