Please solve with EXCEL FORMULAS.

24 1. Compute the annual net cash inflow from the project. 2. Complete the table to compute the net present value of the investment. \begin{tabular}{|l|l|l|l|l|} \hline Initial investment \\ \hline Annual cost savings \\ \hline Salvage value of the new machine \\ \hline Total cash flows \\ Discount factor \\ Present value of the cash flows \\ \hline Net present value \\ \hline \end{tabular} Use Excel's PV function to compute the present value of the future cash flows 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 46 5. Compute the project's simple rate of return. 24 1. Compute the annual net cash inflow from the project. 2. Complete the table to compute the net present value of the investment. \begin{tabular}{|l|l|l|l|l|} \hline Initial investment \\ \hline Annual cost savings \\ \hline Salvage value of the new machine \\ \hline Total cash flows \\ Discount factor \\ Present value of the cash flows \\ \hline Net present value \\ \hline \end{tabular} Use Excel's PV function to compute the present value of the future cash flows 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 46 5. Compute the project's simple rate of return