$\backslash$table$[[,$A$,,$B$,,$C$,$D$,$E$,$F$,$H$],[1,,,,,,,,,],[2,$Erber your last name here:,,,,,,,,$],[3,,,,,,,,,],[4,$The Jones Compary is considering an investment with an initial cont of $$432,000$ and annoal cash inflows as follows. The company requires a return of $12\mathrm{.}0\%.,,,],[5,,,,,,,,,],[6,,,,,,,,,],[7,$Initial cost,,,$$482,000,,,,,],[8,$Required rate of return,,,$12\mathrm{.}0\%,,,,,],[9,,,,,,,,,],[10,$Year,,Cash inflows $($outflomes$),,,,,,],[11,,0,,($$$482,000],,,,,],[12,,1,,$$$105,400,,,,,],[13,,2,,85,700,,,,,],[14,,3,,65,490,,,,,],[15,,4,,194,700,,,,,],[16,,5,,155,400,,,,,],[17,,6,,124,300,,,,,],[18,,7,,90,400,,,,,],[19,,8,,79\mathrm{.}500,,,,,],[20,,,,,,,,,],[21,$Using the NPV function, compute the net present value of this irrestment.,,,,,,,,$],[22,$Using the Ilir function, compute the internal rate of return for this inveitment.,,,,,,,,$],[23,$Using an IF statement, decide if the project should be accepted $($cell A$24),$ or rejected $($cell in$24).,,,,,,,,],[24,$Accept the project,,Pricat theproxit,,,,,,$]]$