Integrative: Determining net cash flows Atlantic Drydock is replacing an existing hoist and is considering one of two newer, more efficient pieces of equipment. The existing hoist is 3 years old, cost $31,700, and is being depreciated under MACRS using a 5-year recovery period. Although the existing hoist has only 3 years (years 4, 5, and 6) of depreciation remaining under MACRS, it has a remaining usable life of 5 years. Hoist A, one of the two possible replacement hoists, costs $40,900 to purchase and $7,600 to install. It has a 5-year usable life and will be depreciated under MACRS using a 5-year recovery period. Hoist B costs $53,600 to purchase and $5,500 to install. It also has a 5-year usable life and will be depreciated under MACRS using a 5-year recovery period. Increased investments in net working capital will accompany the decision to acquire hoist A or hoist B. Purchase of hoist A would result in a $4.500 increase in net working capital, hoist B would result in a $6.400 increase in net working capital. The projected earnings before depreciation, interest, and taxes with each alternative hoist and the existing hoist are given in the following table The existing hoist can currently be sold for $18,200 and will not incur any removal or cleanup costs. At the end of 5 years, the existing hoist can be sold to net $1,000 before taxes. Hoists A and B can be sold to net $11,700 and $20,700 before taxes, respectively, at the end of the 5-year period (see MACRS table :). The firm is subject to a 21% tax rate. a. Calculate the initial cash flow associated with each alternative. b. Calculate the periodic cash flows associated with each alternative. (Note: sure to consider the depreciation in year 6.) c. Calculate the terminal cash flow at the end of year 5 associated with each alternative. d. Depict on a time line the net cash flows associated with each alternative. Initial Cash Flow A Cost of new asset $ Installation costs $ Installed cost of new asset $ Proceeds from sale of old asset $ Tax on sale of old asset $ Total proceeds, sale of old asset $ Change in working capital $ c Drydock is replacing an existing hoist and is considering one of two newer, more efficient pieces of equipment. The existing ho period. Although the existing hoist has only 3 years (years 4, 5, and 6) of depreciation remaining under MACRS, it has a remain purcha period. depre the de ing nterest Data table taxes. and e 5-ye ch alte each ar 5 a ed with (Click on the icon here in order to copy the contents of the data table below into a spreadsheet.) Earnings before depreciation, interest, and taxes Year With hoist A With hoist B With existing hoist 1 $20,000 $21,800 $13,200 2 20,000 24,000 13,200 3 20,000 25,800 13,200 4 20,000 25,800 13,200 5 20,000 25,800 13,200 A | Print Done Ik ? VS ar re 40,9 and in ble or 5 een ed ciat end sas Question 1, P11-27 (simi... HW Score: 20.45%, 12.27 of 60 points Data table 5 years kable li B costs to aco (Click on the icon here in order to copy the contents of the data table below into a spreadsheet.) taxes v Rounded Depreciation Percentages by Recovery Year Using MACRS for First Four Property Classes s A and Percentage by recovery year Recovery year 3 years 5 years 7 years 10 years 1 33% 20% 14% 10% 2 45% 32% 25% 18% 3 15% 19% 18% 14% 4 7% 12% 12% 12% 5 12% 9% 9% 6 5% 9% 8% 7 9% 7% 8 4% 6% 9 6% 10 6% 11 4% Totals 100% 100% 100% 100% *These percentages have been rounded to the nearest whole percent to simplify calculations while Print Done near leara