Based on the following information, calculate net present value (NPV), internal rate of return (IRR), and payback for the investment opportunity:

• EEC expects to save $500,000 per year for the next 10 years by purchasing the supplier.
• EEC's cost of capital is 14%.
• EECbelievesitcanpurchasethesupplierfor$2million.

This needs to be in an excel spreadsheet.