\begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline & A & B & c & D & E & F & G & H & I \\ \hline 1 & \multicolumn{2}{|l|}{ Input Area } & & \multicolumn{3}{|c|}{ Upfront Cost (Year 0): } & $25,000 & & \\ \hline 2 & Discount Rate: & 8% & & \multicolumn{3}{|c|}{ Yearly Net Income: } & $50,000 & & \\ \hline 3 & No. of Useful Years: & 5 & & \multicolumn{3}{|c|}{ Yearly Recurring Costs: } & $20,000 & & \\ \hline \\ \hline 5 & & Year 0 & Year 1 & Year 2 & Year 3 & Year 4 & Year 5 & Present Value & NPV Check \\ \hline 6 & Net Income & & $50,000 & $50,000 & $50,000 & $50,000 & $50,000 & $618,827,59 & \\ \hline 7 & Upfront Cost & $(25,000) & & & & & & (25,000.00) & \\ \hline 8 & Recurring Costs & & 20,000 & 20,000 & 20,000 & 20,000 & 20,000 & (79,854.20) & \\ \hline 9 & Net Yearly Benefit & & $30,000 & $30,000 & $30,000 & $30,000 & $30,000 & $513,973.39 & \$ 74,363.81 \\ \hline \\ \hline 11 & & & & & & & & & \\ \hline \end{tabular} The investment period is on an annual basis rather than a monthly basis. Insert a comment in cell H6 that identifies the error and correct the error. Review the NPV function and formula in cell 19. Review the NDV information covered earlier in this chapter. Insert a comment in cell 19 that identifies the error and correct the error