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,800, and is being depreciated under MACRS using a 5-year recovery period. Although the existing hoist has only 3 years (years 4, 5, and 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.800 to purchase and $8,200 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,500 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 $3,900 increase in net working capital; hoist B would result in a $6,100 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 $17.900 and will not incur any removal or cleanup costs. At the end of 5 years, the existing hoist can be sold to net $1,300 before taxes. Hoists A and B can be sold to net $11,600 and $20,900 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: Be 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. Data table (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,700 $22.200 $14.500 2 20,700 24,700 14,500 3 20,700 26,300 14,500 4 20.700 26,300 14,500 5 20,700 26,300 14,500 Print Done Data table WN (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 10 years 1 33% 20% 14% 10% 2 45% 32% 25% 18% 3 15% 19% 18% 14% 12% 12% 12% 5 12% 9% 9% 6 9% 8% 7 9% 7% 8 4% 6% 9 6% 10 6% 11 4% Totals 100% 100% 100% 100% 4 7% 5% T: Print Done