HW HELP

ho Data table (Click on the icon here in order to copy the contents of the data table below into a spreadsheet.) Rounded Depreciation Percentages by Recovery Year Using MACRS for First Four Property Classes Percentage by recovery year* Recovery year 3 years 5 years 7 years 1 33% 20% 14% 2 45% 32% 25% 3 15% 19% 18% 4 7% 12% 12% 5 12% 9% 6 5% 9% 9% 4% 9 10 11 Totals 100% 100% 100% *These percentages have been rounded to the nearest whole percent to simplify retaining realism. To calculate the actual depreciation for tax purposes, be sure to CONO Initial investment at various sale prices Edwards Manufacturing Company (EMC) is considering replacing one machine with another. The old machine was purchased 3 years ago for an installed cost of $10,000. The firm is depreciating the machine under MACRS, using a 5-year recovery period. (See table for the applicable depreciation percentages.) The new machine costs $25,000 and requires $2,040 in installation costs. The firm is subject to a 40% tax rate. In each of the following cases, calculate the initial investment for the replacement a. EMC sells the old machine for $12,300. b. EMC sells the old machine for $6,950. c. EMC sells the old machine for $2,900. d. EMC sells the old machine for $1,600. Calculate the initial investment at various sale prices below. a. EMC sells the old machine for $12,300. (Round to the nearest dollar.) Cost of new asset Installation cost Total installed cost (a) 25,000 2,040 $ 27,040 (12,300) 1900 Proceads from sale of old asset Tax on sale of old asset Total after-tax proceeds Initial investment $ $ $ $ 14200 $