Integrative Determining relevant cash flowsLombard 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,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 $103,400 and requires $5,200 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,300 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,900, inventories by $29,600, and accounts payable by $57,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,800 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 time line the relevant cash flows associated with the proposed grinder replacement decision.

Earnings before depreciation, interest, and taxes

Year New grinder Existing grinder

1 $42,800 $26,400

2 42,800 24,400

3 42,800 22,400

4 42,800 20,400

Jacob Billerudeaux B - = P age Layout Share Comments AutoSave CH File Home t X Parte O 6 Insert Draw Calibri Colibri B I data-4.29 2020-4_07 PM - Excel Formulas Data Review View - 11 = = = A = = = Search Help General $ E. 29 V A % ) Conditional Formatting Format as Table cel Styles Insert Delete - U Formato p Ideas Sensitivity Clipwed Alime Style filing Sensitivity A1 -T X Rounded Depreciation Percentages by Recovery Year Using MACRS for C D E F G H I J K L M N 15 years 7 years 1 Rounded Depreciation Percentages by Recovery Year Using MACRS for First four Property Classes Percentage by recovery year 3 Recovery year 3 years 1 33% 2 45% 3 15% 10 years 10% 18% 32% 19% 12% 12% 10 4% 15 Totals 100% 100% 100% 33 Display Settings -- 100% # A + 3:09 PM 4/29/2020 u ou Type here to search 6 . 4 of 25