show me how you plugged it in excel to get the answer and how you generate the answer report.

A private equity firm is considering five competing projects in which to invest in the upcoming quarter. The firm needs to decide how to allocate its available capital based upon the combination of projects (denoted as 1 to 5 ) selected to maximize returns (based upon net present value (NPV)). Table 1 below presents the capital requirements and the NPV for each project, along with the associated risk (given as a percentage of the initial investment). The company has $85 million in capital to allocate, with the goal of having an average associated risk of no more than 6%. There are some additional constraints to be met: (i) if project 2 is selected, then project 5 is also selected; (ii) either project 1 is selected or project 3 selected, but not both; (iii) at least one of projects 1,2 , and 4 is selected. First, provide the IP formulation for this problem using information given above. Then, Setup and solve the problem and generate the answer report. Decision Varrables Qhiective Punction 1) 2) 3) 4) A private equity firm is considering five competing projects in which to invest in the upcoming quarter. The firm needs to decide how to allocate its available capital based upon the combination of projects (denoted as 1 to 5 ) selected to maximize returns (based upon net present value (NPV)). Table 1 below presents the capital requirements and the NPV for each project, along with the associated risk (given as a percentage of the initial investment). The company has $85 million in capital to allocate, with the goal of having an average associated risk of no more than 6%. There are some additional constraints to be met: (i) if project 2 is selected, then project 5 is also selected; (ii) either project 1 is selected or project 3 selected, but not both; (iii) at least one of projects 1,2 , and 4 is selected. First, provide the IP formulation for this problem using information given above. Then, Setup and solve the problem and generate the answer report. Decision Varrables Qhiective Punction 1) 2) 3) 4)