Using the NPV function, compute the net present value of this investment.

Using the IRR function, compute the internal rate of return for this investment.

Using an IF statement, decide if the project should be accepted $($cell A$24),$ or rejected $($cell B$24).$

Navigation:

Use the Open Excel in New Tab button to launch this question.

When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect.

SHOW THE REQUIRED FORMULAS TO ENTER INTO EXCELThe Jones Company is considering an investment with an initial cost of $$823,000$ and annual cash inflows as follows. The company

requires a return of $7\mathrm{.}0\%$

Required:

Using the NPV function, compute the net present value of this investment.

Using the IRR function, compute the internal rate of return for this investment,

Using an IF statement, decide if the project should be accepted $($cell A$24),$ or rejected $($cell B$24).$

Navigation:

Use the Open Excel in New Tab button to launch this question.

When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect.

Show all required

formulas for each cell

and what to input