In Excel Form !!!

Terminal cash flow-Replacement decision Russell Industries is considering replacing a fully depreciated machine that has a remaining useful life of 10 years with a newer, more sophisticated machine. The new machine will cost $202,000 and will require $29,900 in installation costs. It will be depreciated under MACRS using a 5 -year recovery period (see the table for the applicable depreciation percentages). A $21,000 increase in net working capital will be required to support the new machine. proposed purchase of the new machine. The firm is subject to a 40% tax rate. The terminal cash flow for the replacement decision is shown below: (Round to the nearest dollar.) Rounded Depreciation Percentages by Recovery Year Using MACRS for First Four Property Classes 'I hese percentages have been rounded to the nearest whole percent to simplity calculations while retaining realism. To calculate the actual depreciation for tax purposes, be sure to apply the actual unrounded percentages or directly apply double-declining balance (200%) depreciation using the half-year convention