Transcribed Image Text
Problem 11-10Replacement AnalysisSt. Johns River Shipyards' welding machine is 15 years old,fully depreciated, and has no salvage value. However, even thoughit is old, it is still functional as originally designed and can beused for quite a while longer. The new welder will cost $80,500 andhave an estimated life of 8 years with no salvage value. The newwelder will be much more efficient, however, and this enhancedefficiency will increase earnings before depreciation from $26,000to $52,000 per year. The new machine will be depreciated over its5-year MACRS recovery period, so the applicable depreciation ratesare 20.00%, 32.00%, 19.20%, 11.52%, 11.52%, and 5.76%. Theapplicable corporate tax rate is 40%, and the project cost ofcapital is 13%. Should the old welder be replaced by the newone?1)Old welder be replaced.2)What is the NPV of the project? Do not round intermediatecalculations. Round your answer to the nearest cent. **Please showthe formulas that would be used in excel