Solve with formulas.

The Jones Company is considering an investment with an initial cost of $$947,000$ and annual cash inflows as

follows. The company requires a return of $6\mathrm{.}0\%.$

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).$

Students: The scratchpad area is for you to do any additional work you need to solve this question or can be used to show your work.

Nothing in this area will be graded, but it will be submitted with your assignment.