FL A B 1 Integrative Case 5 2 C D E 3 Lasting Impressions Company 4 5 Lasting Impressions (LI) Company is a medium-sized commercial printer of 6 promotional advertising brochures, booklets, and other direct-mail pieces. The 7 firm's major clients are ad agencies based in New York and Chicago. The typical 8 job is characterized by high quality and production runs of more than 50,000 9 units. Ll has not been able to compete effectively with larger printers because 10 of its existing older, inefficient presses. The firm is currently having problems 11 meeting run length requirements as well as meeting quality standards in a cost- 12 effective manner. 13 14 The general manager has proposed the purchase of one of two large, six-color 15 presses designed for long, high-quality runs. The purchase of a new press would 16 enable LI to reduce its cost of labor and therefore the price to the client, putting the 17 firm in a more competitive position. The key financial characteristics of the old press 18 and of the two proposed presses are summarized as follows: 19 20 21 22 23 24 22 25 Old press Originally purchased 3 years ago at an installed cost of $400,00, it is being depreciated under MACRS, using a 5-year recovery period. The old press has a remaining economic life of 5 years. It can be sold today to net $420,000 before taxes; if it is retained, it can be sold to net $150,000 before taxes at the end of 5 years. A 26 27 28 29 30 31 32 33 34 35 36 B C D E F Press A This highly automated press can be purchased for $830,000 and will require $40,000 in installation costs. It will be depreciated under MACRS, using a 5-year recovery period. At the end of the 5 years, the machine could be sold to net $400,000 before taxes. If this machine is acquired, it is anticipated that the current account changes shown in the following table would result. Cash Accounts receivable + Inventories Accounts payable + $25,400 $120,000 $20,000 $35,000 37 38 39 40 41 Press B This press is not as sophisticated as press A. It costs $640,000 and requires $20,000 in installation costs. It will be depreciated under MACRS, using a 5-year recovery period. At the end of 5 years, it can be sold to net $330,000 before taxes. Acquisition of this press will have no effect on the firm's net working capital investment. 42 The firm estimates that its earnings before depreciation, interest, and taxes with the old 43 press and with press A or press B for each of the 5 years would be as shown in the table 44 below. The firm is subject to a 40% tax rate, The firm's cost of capital, r, applicable to the 45 proposed replacement is 14%. 46 G A B C D E F G H 47 48 49 Earnings before Depreciation, Interest, and Taxes for Lasting Impressions Company's Presses 50 51 52 53 54 Year 1 2 3 4 5 Old press Press A Press B $120,000 $250,000 $210,000 $120,000 $270,000 $210,000 $120,000 $300,000 $210,000 $120,000 $330,000 $210,000 $120,000 $370,000 $210,000 55 56 57 a. 1. Calculation of initial investment for Lasting Impressions Company: 58 Press A 59 Installed cost of new press 60 Cost of new press 61 + Installation costs 62 63 64 65 66 67 68 69 Total cost - new press -After-tax proceeds-sale of old asset Proceeds from sale of old press + Tax on sale of old press Total proceeds-sale of old press + Change in net working capital Initial investment Press B A B C D E F 71 a. 2. Depreciation 72 Year Cost Rate Depreciation 73 Press A 74 1 $870,000 20% 75 2 $870,000 32% 76 3 $870,000 19% 77 4 $870,000 12% 78 5 $870,000 12% 79 6 $870,000 5% 80 Total 81 82 Press B 83 1 $660,000 20% 84 2 $660,000 32% 85 3 $660,000 19% 86 4 $660,000 12% 87 5 $660,000 12% 88 6 $660,000 5% 89 Total 90 91 Existing Press 92 1 $400,000 12% 93 2 $400,000 12% 94 3 $400,000 5% 95 4 $0 0% 0 96 5 $0 0% 0 97 60 $0 0% 0 98 99 Total A B C D E F G Year 1 Year 2 Year 3 Year 4 Year 5 101 102 Existing Press H Year 6 103 Earnings before depr., int. and taxes $ 120,000 $ 120,000 $120,000 $120,000 $120,000 $ - 104 - Depreciation $ $ $ $ $ - $ 105 Earnings before interest and taxes 106 - Taxes 40% 107 Net operating profits after taxes 108 + Depreciation 109 Operating cash flows $ $ $ $ $ $ 110 111 Press A 112 Earnings before depr., int. and taxes $ 250,000 $ 270,000 $300,000 $330,000 $370,000 $ 113 - Depreciation $ $ $ $ $ - $ 114 Earnings before interest and taxes 115 - Taxes 40% 116 Net operating profits after taxes 117+ Depreciation $ $ $ $ $ $ 118 Operating cash flows 119 Old cash flow $ $ $ $ $ $ 120 Incremental cash flow A B C D 123 Press B 124 Earnings before depr., int. and taxes 125 - Depreciation 126 Earnings before interest and taxes 127 - Taxes 40% 128 Net operating profits after taxes $ 210,000 $ $ $ E F G H | 210,000 $210,000 $210,000 $210,000 $ $ $ $ $ 129 + Depreciation $ $ $ - $ $ $ 130 Operating cash flows 131 Old cash flow $ $ $ - $ $ $ 132 Incremental cash flow 133 134 a. 3. Terminal cash flow 135 Press A Press B 136 After-tax proceeds from sale of new press 137 Proceeds from sale of new press 138 Tax on sale of new press 139 Total proceeds - new press 140 141 After-tax proceeds from sale of old press 142 Proceeds on sale of old machine 143 Tax on gain of old press 144 Total proceeds - old press 145 Change in net working capital 146 Terminal Cash Flow 147 B D E F H A G 149 b. Using the data developed in part a, find and depict on a timeline the relevant cash flow stream associated with each of the two proposed replacement presses, assuming that each isterminated at the end of 5 years. 150 151 152 Cash Flows 153 Year Press A Press B Initial 154 investment $ 155 1 156 2 157 3 158 4 159 5 SASA SASASA $ SASA $ $ $ $ $ SSS $ - $ - 160 Insert graph 161 162 c. Using the data developed in part b, apply each of the following decision techniques: 163 1. Payback period. 164 Press A: Cumulative Cash Flows 165 Year 166 Press A Press B 167 0 $ $ 168 1 169 2 170 3 171 4 172 5 5 173 174 Press A 175 Press B 176 A B 178 2. Net present value (NPV) C D 179 Cost of capita 14% 180 Press A Press B 181 Year Cash Flow Year Cash Flow 182 0 183 184 185 186 012345 187 188 189 Press A 190 Press B 191 192 193 3. Internal Rate of Return (IRR) 194 Press A 112345 Press B A B D E F G H 197 d. Draw NVP profiles for the two replacement presses on the same set of axes, and discuss conflicting rankings of the two presses resulting 198 from use of NPV and IRR decision techniques. 199 200 201 Data for NPV Profile NPV 202 Discount rate Press A Press B 203 0% 204 14% 205 206 0.00% 0.00% 207 208 209 210 211 0 0 Insert graph 212 213 214 e. Recommend which, if either, of the presses the firm should acquire if the firm has (1) unlimited funds or (2) captial rationing 215 216 217 218 f. The operating cash inflows associated with press A are characterized as very risky, in contrast to the low-risk operating cash inflows of 219 press B. What impact does that have on your recommendation? 220 A 57 a. 1. 58 B C D E Calculation of initial investment for Lasting Impressions Company: G H Press A Press B 59 60 Installed cost of new press Cost of new press $ 830,000 $ 640,000 61 + Installation costs $ 40,000 $ 20,000 62 Total cost - new press $ 870,000 $ 660,000 63 -After-tax proceeds-sale of old asset 64 65 66 67 Proceeds from sale of old press $ 68 69 + Tax on sale of old press Total proceeds-sale of old press + Change in net working capital Initial investment SS 420,000 $ 420,000 $ 108,000 $ 108,000 $ 312,000 $ 312,000 $ 160,400 $ $ 718,400 $ 348,000 A B C D E 71 a. 2. Depreciation 72 Year Cost Rate Depreciation 73 Press A 74 1 $870,000 20% $174,000 75 2 $870,000 32% $278,400 76 3 $870,000 19% $165,300 77 4 $870,000 12% $104,400 78 5 $870,000 12% $104,400 79 6 $870,000 5% $43,500 80 Total $870,000 81 82 Press B 83 1 $660,000 20% $132,000 84 2 $660,000 32% $211,200 85 3 $660,000 19% $125,400 86 4 $660,000 12% $79,200 87 5 $660,000 12% $79,200 88 6 $660,000 5% $33,000 89 Total $660,000 90 91 Existing Press 92 1 $400,000 12% $48,000 93 2 $400,000 12% $48,000 94 3 $400,000 5% $20,000 95 4 $0 0% 0 96 5 $0 0% 0 97 6 $0 0% 98 Total $116,000 99 A B C D E F G H | 101 102 Existing Press Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 103 Earnings before depr., int. and taxes $ 120,000 $ 120,000 104 - Depreciation $ 48,000 $ $120,000 $ 48,000 $ 20,000 $ 120,000 $120,000 $ $ $ 105 Earnings before interest and taxes 106 - Taxes 40% 107 Net operating profits after taxes 108 + Depreciation 109 Operating cash flows 110 SSSSSA $ 72,000 $ 72,000 $100,000 $ 120,000 $120,000 $ $ 43,200 $ 43,200 $ 60,000 $ 72,000 $ 72,000 $ $ 28,800 $ 28,800 $ 40,000 $ 48,000 $ 48,000 $ $ 48,000 $ 48,000 $ 20,000 $ $ $ 76,800 $ 76,800 $ 60,000 $ 48,000 $ 48,000 $