Integrative Determining relevant cash flows***Please make sure screen shot answer is viewable***
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 $ 61,400; 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 $ 105,600 and requires $ 4,900 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 $ 71,200 without incurring any removal or cleanup costs. To support the increased business resulting from purchase of the new grinder, accounts receivable would increase by $ 42,200, inventories by $ 32,800, and accounts payable by $ 59,300. At the end of 5 years, the existing grinder would have a market value of zero; the new grinder would be sold to net $ 29,400 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 LOADING.... (Table LOADING... contains the applicable MACRS depreciation percentages.)
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 time line the relevant cash flows associated with the proposed grinder replacement decision.
.
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 $60,500; 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 $109,100 and requires $5,400 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 $70,200 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,000, inventories by $29,400, and accounts payable by $59,000. At the end of 5 years, the existing grinder would have a market value of zero; the new grinder would be sold to net $30,000 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 E . (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 time line the relevant cash flows associated with the proposed grinder replacement decision. Calculate the initial investment below: (Round to the nearest dollar.) Cost of new asset $ 109,100 5,400 Installation costs Total cost of new asset Proceeds from sale of old asset $ 114,500 $ (70,200) 16,464 Tax on sale of old asset Total proceeds, sale of old asset Change in working capital $ (53,736) 9,400 Initial investment 70,164 b. Determine the incremental operating cash inflows associated with the proposed replacement. (Note: Be sure to consider the depreciation in year 6.) Calculate the cash flows with the old machine below: (Round to the nearest dollar.) Year Profit before depreciation and taxes Depreciation Net profit before taxes Taxes Net profit after taxes Operating cash inflows Enter any number in the edit fields and then click Check Answer. A Data Table (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) Year Earnings before depreciation, interest, and taxes New grinder Existing grinder $42,800 $26,300 42,800 24,300 42,800 22,300 42,800 20,300 42,800 18,300 Print Done 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 $60,500; 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 $109,100 and requires $5,400 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 $70,200 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,000, inventories by $29,400, and accounts payable by $59,000. At the end of 5 years, the existing grinder would have a market value of zero; the new grinder would be sold to net $30,000 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 E . (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 time line the relevant cash flows associated with the proposed grinder replacement decision. Calculate the initial investment below: (Round to the nearest dollar.) Cost of new asset $ 109,100 5,400 Installation costs Total cost of new asset Proceeds from sale of old asset $ 114,500 $ (70,200) 16,464 Tax on sale of old asset Total proceeds, sale of old asset Change in working capital $ (53,736) 9,400 Initial investment 70,164 b. Determine the incremental operating cash inflows associated with the proposed replacement. (Note: Be sure to consider the depreciation in year 6.) Calculate the cash flows with the old machine below: (Round to the nearest dollar.) Year Profit before depreciation and taxes Depreciation Net profit before taxes Taxes Net profit after taxes Operating cash inflows Enter any number in the edit fields and then click Check Answer. A Data Table (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) Year Earnings before depreciation, interest, and taxes New grinder Existing grinder $42,800 $26,300 42,800 24,300 42,800 22,300 42,800 20,300 42,800 18,300 Print Done
