PLEASE USE EXCEL FUNCTIONS IN ANSWER

Period Cash Flows (22,321) 2 (23,119) 3 (18,506) (17,795) 5 (19,860) Present value of net cash flows (101,601) Cost of Asset Net Present Value (1,601) Requirement 3 Compute the net present value of the investment using Excel's NPV function. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Data table or if you type the number will be marked wrong.) Present value of net cash flows Cost of asset Net Present Value Requirement 4 Compute the profitability index, rounded to two decimal places. Note: All amounts used in the calculation should be positive. If a cell referenced in the calculation contains a negative value, use a"-" in front of reference (ie, -C30) (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Data table or if you type the number will be marked wrong.) Profitability index Requirement 5 Compute the internal rate of return of the investment using Excel's IRR function. Display to two decimal places, but do not round. Note: IRR requires a negative amount for the investment. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Data table or if you type the numb will be marked wrong.) IRR