PLEASE ANSWER ALL QUESTIONS IN THE TABLE FORMAT PROVIDED BY THE QUESTION!! LOOK AT ALL IMAGES, THANK YOU WILL LEAVE THUMBS UP$!!!!$ Interstate Manufacturing is considering either overhauling an old machine or replacing it with a new machine. Information about the Complete this question by entering your answers in the tabs below.

Required $1$

Required $3$

Determine the net present value of alternative $1.$

Note: Do not round intermediate calculations. Round your present value factor to $4$ decimals and final answers to the nearest

whole dollar. Complete this question by entering your answers in the tabs below.

Required $1$

Determine the net present value of alternative $2.$

Note: Negative net present values should be indicated with a minus sign. Do not round intermediate calculations. Round your present value factor to $4$ decimals and final answers to the nearest whole dollar.

$\backslash$table$[[,\backslash$table$[[$Net Cash$],[$Flows$]],\backslash$table$[[$Present Value$],[$Factors at $8\%]],\backslash$table$[[$Present Value of$],[$Cash Flows$]]],[$Year $1-5,,,],[$Salvage value$-$new machine,,,$],[$Salvage value$-$old machine,,,$],[$Totals$,,,],[$Initial investment,,,$],[$Net present value,,,$]]$ Complete this question by entering your answers in the tabs below.

Which alternative should management select based on net present value?

Management should select

two alternatives follows. Management requires a $8\%$ rate of return on its investments. $($PV of $$1,$ FV of $$1,$ PVA of $$1,$ and FVA of $$1)$

Note: Use appropriate factor$($s$)$ from the tables provided.

Alternative $1$: Keep the old machine and have it overhauled. This requires an initial investment of $$156,000$ and results in $$49,000$ of

net cash flows in each of the next five years. After five years, it can be sold for a $$21,000$ salvage value.

Alternative $2$: Sell the old machine for $$46,000$ and buy a new one. The new machine requires an initial investment of $$305,000$ and

can be sold for a $$13,000$ salvage value in five years. It would yield cost savings and higher sales, resulting in net cash flows of

$$64,000$ in each of the next five years.

Required:

Determine the net present value of alternative $1.$

Determine the net present value of alternative $2.$

Which alternative should management select based on net present value?