1 N- 33% 45% 15% 7% 3 4 5 6 7 20% 32% 19% 12% 12% 5% 14% 25% 18% 12% 9% 9% 10% 18% 14% 12% 99 896 9% B 4% 9 10 11 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- convention Print Done Integrative: Complete Investment decision Wells Printing is considering the purchase of a new printing press. The total installed cost of the press is $2.11 million. This outlay would be partially offset by the sale of an existing press. The old press has zero book value, cost $1.05 million 10 years ago, and can be sold currently for $1.14 million before taxes. As a result of acquisition of the new press, sales in each of the next 5 years are expected to be $1.58 million higher than with the existing press, but product costs (excluding depreciation) will represent 55% of sales. The new press will not affect the firm's net working capital requirements. The new press will be depreciated under MACRS using a five-year recovery period. The firm is subject to a 40% tax rate. Welis Printing's cost of capital is 11.5%. (Note: Assume that the old and the new presses will each have a terminal value of $0 at the end of year 6.) a. Determine the initial cash flow required by the new press. b. Determine the periodic cash inflows attributable to the new press. (Note: Be sure to consider the depreciation in year 6.) c. Determine the payback period. d. Determine the net present value (NPV) and the internal rate of return (IRR) related to the proposed new press. e. Make a recommendation to accept or reject the new press, and justify your answer. a. Determine the initial cash flow required by the new press. Calculate the initial cash flow will be: (Round to the nearest dollar.) S $ Installed cost of new press Proceeds from sale of existing press Taxes on sale of existing press Total after-tax proceeds from sale Initial cash flow $ $ Data table (Click on the icon here in order to copy the contents of the data table below into a spreadsheet.) 10 years 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% 2 45% 32% 25% 3 15% 19% 18% 4 7% 12% 12% 5 12% 9% 6 5% 9% 7 9% 8 4% 9 10% 18% 14% 12% 9% 8% 7% 6% 6% 6% 10 AA An Print Done