Please answer using excel and show formulas used.

injection de cated on e is being depreciated rrent book value is $2,100 reciation expense is $2.100 4 for $500 at the end of is $2,100, d. Should the machine be purchuur 12-10 REPLACEMENT ANALYSIS The Dauten Toy Corporation currently use ing machine that was purchased 2 years ago. This machine is ha straight-line basis, and it has 6 years of remaining life. Its currenthe it can be sold for $2,500 at this time. Thus, the annual depreciation $350 per year. If the old machine is not replaced, it can be sold force useful life. Dauten is offered a replacement machine which has a cost of so useful life of 6 years, and an estimated salvage value of $800. This ma MACRS 5-year class so the applicable depreciation rates are 20%. 32 and 6%. The replacement machine would permit an output expansions rear: even so, the new machine's much greater efficiency operating expenses to decline by $1,500 per year. The new machine would re inventories be increased by $2,000, but accounts payable would simultaneo by $500. Dauten's marginal federal-plus-state tax rate is 40%, and its WACC is 110 She it replace the old machine? cost of $8,000, an estimassa This machine falls into are 20%, 32%, 19%, 12%, 11 put expansion, so sales would or efficiency would cause chine would require that would simultaneously increase