There are five independent projects that must be evaluated on the basis of the profitability index.

(a) Given an investment limit of $35 million and a MARR of 10% per year, select from the projects.

(b) Write the spreadsheet function for a project, specifically for project 5, which will correctly display the PI value used to rank the project.

Life, First Cost, NCF, $1000 $1000/Year Project Years 900 -4,000 -7,000 1,900 10 -17,000 2,900 15 4 -15,000 3,600 10 5 -30,000 5,000