PLEASE PROVIDE THE FUNCTIONS

On the workbook's Project Evaluation tab:

• 1.Calculate the NPV using Excel's NPV function.
• 2.Calculate the IRR using Excel's IRR function.
• 3.Calculate the Payback Period using the formula: Initial Invesment / Cash Flows. Note: Nest this formula in the ABS (absolute value) function to remove the negative sign.
• 4.Calculate the Profitability Index using Excel's NPV function. Note: Nest this function in the ABS (absolute value) function to remove the negative sign.
• 5.Evaluate whether or not the results indicate you should accept the project by recording a "Yes" or "No" for alongside each result in column F. Use the PowerPoint slide presentation for reference as needed.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 A Years B Cash Flows 0 -155,000.00 1 29,500.00 2 29,500.00 3 29,500.00 4 29,500.00 5 29,500.00 6 29,500.00 7 4,000.00 D Discount Rate NPV IRR Payback PI E 15% F G H I J