Problem $6-30$ Calculating Project NPV

Calligraphy Pens is deciding when to replace its old machine. The machine's current salvage value is $$2,900,000.$ Its current book value is $$1,725,000.$ If not sold, the old machine will require maintenance costs of $$695,000$ at the end of the year for the next five years. Depreciation on the old machine is $$345,000$ per year. At the end of five years, it will have a salvage value of $$140,000$ and a book value of $$0.$ A replacement machine costs $$4,500,000$ now and requires maintenance costs of $$365,000$ at the end of each year during its economic life of five years. At the end of the five years, the new machine will have a salvage value of $$730,000.$ It will be fully depreciated by the straight$-$line method. In five years, a replacement machine will cost $$3,500,000.$ The company will need to purchase this machine regardless of what choice it makes today. The corporate tax rate is $22$ percent and the appropriate discount rate is $8$ percent. The company is assumed to earn sufficient revenues to generate tax shields from depreciation. Calculate the NPV for the new and old machines. $($Do not round intermediate calculations and enter your answers in dollars, not millions of dollars, rounded to $2$ decimal places, e$.$g$.,1,234,567\mathrm{.}89.)$

Answer is complete but not entirely correct.

$\backslash$table$[[$New machine,$$,75,900\mathrm{.}00ox$

PLEASE SHOW WORK IN EXCEL