CASH FLOWS FROM THE EXISTING MACHINE YEAR 1 - YEAR 6.
CASH FLOWS FROM NEW MACHINE YEAR 1 - YEAR 6.
Integrative: Investment decision Holliday Manufacturing is considering the replacement of an existing machine. The new machine costs $1.14 million and requires installation costs of $157,000. The existing machine can be sold currently for $195,000 before taxes. It is 2 years old, cost $792,000 new, and has a $380,160 book value and a remaining useful life of 5 years. It was being depreciated under MACRS using a 5-year recovery period and therefore has the final 4 years of depreciation remaining. If it is held for 5 more years, the machine's market value at the end of year 5 will be $0. Over its 5-year life, the new machine should reduce operating costs by $359,000 per year. The new machine will be depreciated under MACRS using a 5-year recovery period. The new machine can be sold for $203,000 net of removal and cleanup costs at the end of five years. An increased investment in net working capital of $29,000 will be needed to support operations if the new machine is acquired. Assume that the firm has adequate operating income against which to deduct any loss experienced on the sale of the existing machine. The firm has a 9.4% cost of capital and is subject to a 40% tax rate. a. Develop the net cash flows needed to analyze the proposed replacement. b. Determine the net present value (NPV) of the proposal. c. Determine the internal rate of return (IRR) of the proposal. d. Make a recommendation to accept or reject the replacement proposal, and justify your answer. e. What is the highest cost of capital that the firm could have and still accept the proposal? a. Develop the net cash flows needed to analyze the proposed replacement. Calculate the initial cash flow: (Round to the nearest dollar.) S S S Cost of the new machine Installation cost Installed cost of new asset Proceeds from sale of existing machine Tax on sale of existing machine Total after-tax proceeds from sale Increase in not working capital S S S $ Initial cash flow S - Data table (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% 4 7% 12% 12% 12% 5 12% 9% 9% 6 5% 9% 8% 7 9% 7% 8 4% 6% 9 6% 10 6% 11 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 convention. Calculate the operating cash flows from the existing machine: (Round to the nearest dollar.) Cash Inflows Existing Machine Year 1 Depreciation $ Net profits before taxes $ Taxes $ Net profits after taxes $ Operating cash inflows $ (Round to the nearest dollar.) Cash Inflows Existing Machine Year 2 $ Depreciation Net profits before taxes $ Taxes $ Net profits after taxes $ Operating cash inflows $ (Round to the nearest dollar.) Cash Inflows Existing Machine Year 3 Calculate the terminal cash flow: (Round to the nearest dollar.) Proceeds from sale of new asset $ Tax on sale of new asset $ Total proceeds-sale of new asset $ Change in net working capital $ Terminal cash flow $ TA b. Determine the net present value (NPV) of the proposal. The net present value is $ 1. (Round to the nearest dollar.) c. Determine the internal rate of return (IRR) of the proposal. The internal rate of return is %. (Round to one decimal place.) d. Make a recommendation to accept or reject the replacement proposal, and justify your answer. (Select from the drop-down menus.) Since the NPV O and the IRR cost of capital, the new machine be purchased. e. The highest cost of capital that the firm could have and still accept the proposal is %. (Round to one decimal place.)
