Cowboy Corp. is about to expand its operations and they have several projects with various cash flows available in Excel upload file. Each project has an 8-year life and the firm has a cost of capital at 8%. The firm has $15,000 for the expansion and will invest in multiple projects with that capital constraint.

1.Calculate NPV for each project

2.Find the project combination that maximizes total NPV for Cowboy Corp. and calculate total capital spending

3.Find the optimum combination under following constraints; Project A and C can only be invested together and at least one out of Project E, F or G must be invested.

please show calculations in excel