Milliken uses a digitally controlled dyer for placing intricate and integrated patterns on manufactured carpet squares for home and commercial use. It is purchased for $400,000. It is expected to last 8 years and has a salvage value of $32,000. Increased before tax cash flow due to this dyer is $100,000 per year. Milliken's tax rate is 25%, and the after-tax MARR is 12%. Develop tables using a spreadsheet to determine the ATCF for each year and the after-tax PW, AW, IRR, and ERR after 8 years. a. Use straight-line depreciation (no half-year convention). b. Use MACRS-GDS and state the appropriate property class. c. Use double declining balance depreciation (no half-year convention, no switching). PW AW IRR ERR a. $ $ % % b. $ $ 07 % % C. $ $ % % Round your answer to 2 decimal places for PW and AW. Do not round intermediate computations. Tolerance is 1. Round to 2 decimal places and present in percentage format IRR and ERR. Tolerance is +0.02. Milliken uses a digitally controlled dyer for placing intricate and integrated patterns on manufactured carpet squares for home and commercial use. It is purchased for $400,000. It is expected to last 8 years and has a salvage value of $32,000. Increased before tax cash flow due to this dyer is $100,000 per year. Milliken's tax rate is 25%, and the after-tax MARR is 12%. Develop tables using a spreadsheet to determine the ATCF for each year and the after-tax PW, AW, IRR, and ERR after 8 years. a. Use straight-line depreciation (no half-year convention). b. Use MACRS-GDS and state the appropriate property class. c. Use double declining balance depreciation (no half-year convention, no switching). PW AW IRR ERR a. $ $ % % b. $ $ 07 % % C. $ $ % % Round your answer to 2 decimal places for PW and AW. Do not round intermediate computations. Tolerance is 1. Round to 2 decimal places and present in percentage format IRR and ERR. Tolerance is +0.02