Please solve highlighted areas and include all formulas used.

2. Complete the table to compute the net present value of the investment. Initial investment \begin{tabular}{|c|c|} \hline Now & Year(s) \\ \hline \end{tabular} Annual cost savings Salvage value of the new machine Total cash flows Discount factor 1.000 Present value of the cash flows Net present value Use Excel's PV function to compute the present value of the future cash fiows Deduct the cost of the investment Net present value 3. Use Excel's RATE function to compute the project's internal rate of return 4. Compute the project's payback period. years 5. Compute the project's simple rate of retur