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
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 $55,300; it was being depreciated straight-line for 5 years. The existing grinder is expected to have a usable life of 5 more years. The new grinder costs $105,800 and requires $4,500 in installation costs; it has a 5-year usable life andwould be depreciated on a straight-line basis. Lombard can currently sell the existing grinder for $70,900 without incurring any removal or cleanup costs. To support the increased business resulting from purchase of the new grinder, accounts receivable would increase by $40,400, inventories by $29,000, 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 $29,200 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
| |||
Year | New grinder | Existing grinder | |
1 | $43,600 | $25,200 | |
2 | 43600 | 23200 | |
3 | 43600 | 21200 | |
4 | 43600 | 19200 | |
5 | 43600 | 17200 |
a. Calculate the initial investment associated with replacement of the old machine by the new one.
Calculate the initial investment below:(Round to the nearest dollar.)
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: |
|
|
|
|
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 | 1 | |
Profit before depreciation and taxes | $ |
|
Depreciation | $ |
|
Net profit before taxes | $ |
|
Taxes | $ |
|
Net profit after taxes | $ |
|
Operating cash inflows | $ |
|
(Round to the nearest dollar.)
Year | 2 | |
Profit before depreciation and taxes | $ |
|
Depreciation | $ |
|
Net profit before taxes | $ |
|
Taxes | $ |
|
Net profit after taxes | $ |
|
Operating cash inflows | $ |
|
(Round to the nearest dollar.)
Year | 3 | |
Profit before depreciation and taxes | $ |
|
Depreciation | $ |
|
Net profit before taxes | $ |
|
Taxes | $ |
|
Net profit after taxes | $ |
|
Operating cash inflows | $ |
|
(Round to the nearest dollar.)
Year | 4 | |
Profit before depreciation and taxes | $ |
|
Depreciation | $ |
|
Net profit before taxes | $ |
|
Taxes | $ |
|
Net profit after taxes | $ |
|
Operating cash inflows | $ |
|
(Round to the nearest dollar.)
Year | 5 | |
Profit before depreciation and taxes | $ |
|
Depreciation | $ |
|
Net profit before taxes | $ |
|
Taxes | $ |
|
Net profit after taxes | $ |
|
Operating cash inflows | $ |
|
(Round to the nearest dollar.)
Year | 6 | |
Profit before depreciation and taxes | $ |
|
Depreciation | $ |
|
Net profit before taxes | $ |
|
Taxes | $ |
|
Net profit after taxes Net profit after taxes | $ |
|
Operating cash inflows | $ |
|
Calculation the cash flows with the new machine and the incremental cash flows below:(Round to the nearest dollar.)
Year | 1 | |
Profit before depreciation and taxes | $ |
|
Depreciation | $ |
|
Net profit before taxes | $ |
|
Taxes | $ |
|
Net profit after taxes | $ |
|
Operating cash inflows | $ |
|
Incremental cash flows | $ |
|
(Round to the nearest dollar.)
Year | 2 | |
Profit before depreciation and taxes | $ |
|
Depreciation | $ |
|
Net profit before taxes | $ |
|
Taxes | $ |
|
Net profit after taxes | $ |
|
Operating cash inflows | $ |
|
Incremental cash flows | $ |
|
(Round to the nearest dollar.)
Year | 3 | |
Profit before depreciation and taxes | $ |
|
Depreciation | $ |
|
Net profit before taxes | $ |
|
Taxes | $ |
|
Net profit after taxes | $ |
|
Operating cash inflows | $ |
|
Incremental cash flows | $ |
|
(Round to the nearest dollar.)
Year | 4 | |
Profit before depreciation and taxes | $ |
|
Depreciation | $ |
|
Net profit before taxes | $ |
|
Taxes | $ |
|
Net profit after taxes | $ |
|
Operating cash inflows | $ |
|
Incremental cash flows | $ |
|
(Round to the nearest dollar.)
Year | 5 | |
Profit before depreciation and taxes | $ |
|
Depreciation | $ |
|
Net profit before taxes | $ |
|
Taxes | $ |
|
Net profit after taxes | $ |
|
Operating cash inflows | $ |
|
Incremental cash flows | $ |
|
(Round to the nearest dollar.)
Year | 6 | |
Profit before depreciation and taxes | $ |
|
Depreciation | $ |
|
Net profit before taxes | $ |
|
Taxes | $ |
|
Net profit after taxes | $ |
|
Operating cash inflows | $ |
|
Incremental cash flows | $ |
|
c. Determine the terminal cash flow expected at the end of year 5 from the proposed grinder replacement.
Calculate the terminal cash flow below:(Round to the nearest dollar.)
Proceeds from sale of new asset | $ |
|
|
|
Tax on sale of new asset |
|
|
|
|
Total proceeds from sale of new asset |
|
| $ |
|
Change in working capital |
| |||
Terminal cash flow |
|
| $ |
|
d. Depict on a time line the relevant cash flows associated with the proposed grinder replacement decision.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started