Required: You are Cassandra's top financial analyst, and she has asked you to analyze the four projects using Excel. Part A For each project, calculate 1) the total 5-year increase in after-tax income, 2) the payback period, 3) internal rate of return (lRR), 4) the net present value (NPV), and 5) the Profitability Index (PI). ' Ignore the impact of |Capital Cost Allowance (CCA) and use the tax calculations provided. ' Use 11.0 percent for the cost of capital in your calculations (i.e. discount rate) Excel formulas must be used to calculate NPV, IR and PI . You must use the Excel template provided on Blackboard as your starting point. You must use the Windows version of Excel as I will be unable to open a Mac version