question 5

Integrative-Determining relevant cash flows Lombard Company is contemplating the purchase of a new high-speed widget grinder to replace the existing grinder. The existing grinder was purchased 2 years ago at an installed cost of $58,700; it was being depreciated under MACRS using a 5-year recovery period. The existing grinder is expected to have a usable life of 5 more years. The new grinder costs $108,600 and requires $5,100 in installation costs; it has a 5-year usable life and would be depreciated under MACRS using a 5-year recovery period. Lombard can currently sell the existing grinder for $69,700 without incurring any removal or cleanup costs. To support the increased business resulting from purchase of the new grinder, accounts receivable would increase by $39,500, inventories by $29,100, and accounts payable by $58,600. At the end of 5 years, the existing grinder would have a market value of zero; the new grinder would be sold to net $28,600 after removal and cleanup costs and before taxes. The firm is subject a 40% tax rate. The estimated earnings before depreciation, interest, and taxes over the 5 years for both the new and the existing grinder are shown in the following table (Table contains the applicable MACRS depreciation percentages.) a. Calculate the initial investment associated with the replacement of the existing grinder by the new ono b. Determine the operating cash inflows associated with the proposed grinder replacement. (Note: Be sure to consider the depreciation a. Calculate the initial investment associated with replacement of the old machine by the new ono. Calculate the initial investment below: (Round to the nearest dollar) Cost of new asset Installation conts Total cost of new asset Proceeds from sale of old asset Tax on sale of old asset Totalment acce Enter any number in the edit fields and then click Check Answer costs $108,600 and requires $5,100 in installation costs; it has a 5-year usable life and would be depreciated under MACRS using a 5-year recovery period. Lombard can currently sell the existing grinder for $69,700 without incurring any removal or cleanup costs. To support the increased business resulting from purchase of the new grinder, accounts receivable would increase by $39,500, inventories by $29, 100, and accounts payable by $58,600. At the end of 5 years, the existing grinder would have a market value of zero the new grinder would be sold to net $28,500 after removal and cleanup costs and before taxes. The firm is subject a 40% tax rate. The estimated earnings before depreciation, interest, and taxes over the 5 years for both the new and the existing grinder are shown in the following table (Table contains the applicable MACRS depreciation percentages.) a. Calculate the initial investment associated with the replacement of the existing grinder by the new one. b. Determine the operating cash inflows associated with the proposed grinder replacement. (Note: Be sure to consider the depreciation in year 6.) c. Determine the terminal cash flow expected at the end of year 5 from the proposed grinder replacement d. Depict on a timeline the relevant cash flows associated with the proposed grinder replacement decision Cost of new asset Installation costs Total 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 Initial investment Enter any number in the edit fields and then click Check Answer ld have a firm is sub] i Data Table me existing es.) te the initial mine the opel (Click on the icon here in order to copy the contents of the data table below :) into a spreadsheet) mine the term ton a time lir Earnings before depreciation, interest, and taxes st of new ass Year New grinder Existing grinder tallation costs 1 $42,900 $26,700 Total cost of nel 2 42,900 24,700 3 42,900 22,700 roceeds from se 4 42,900 20.700 ax on sale of old 5 42,900 18,700 Total proceeds Change in workin Print Done Initial investment ar any number in the edit fields and then click Check Answer. - Data Table 10 years DI 3 (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% 10% 2 45% 32% 25% 18% 15% 19% 18% 14% 4 7% 12% 12% 12% 5 12% 9% 9% 5% 9% 8% 7 9% 7% B 4% 6% 9 6% 10 6% 4% Totals 100% 100% 100% 100% *These percentages have been rounded to the nearest whole percent to simplify 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 6 11 convention Entel Print Done