In: Finance
Masters Machine Shop is considering a four-year project to improve its production efficiency. Buying a new machine press for $1,113,600 is estimated to result in $371,200 in annual pretax cost savings. The press falls in the MACRS five-year class (MACRS Table), and it will have a salvage value at the end of the project of $162,400. The press also requires an initial investment in spare parts inventory of $46,400, along with an additional $6,960 in inventory for each succeeding year of the project. If the shop's tax rate is 23 percent and its discount rate is 9 percent, what is the NPV for this project?
A. $ 90,832.98
B. $ 93,658.87
C. $ (43,900.23)
D. $ 95,374.63
E. $ 86,291.33
| MARCs Depreciation table | |||||||
| Year | Rate | Depreciation | Accumulated Depreciation | Book Value | |||
| 0 | $0.00 | $0.00 | $1,113,600.00 | ||||
| 1 | 20.00% | $222,720 | $222,720 | $890,880 | |||
| 2 | 32.00% | $356,352 | $579,072 | $534,528 | |||
| 3 | 19.20% | $213,811 | $792,883 | $320,717 | |||
| 4 | 11.52% | $128,287 | $921,170 | $192,430 | |||
| 5 | 11.52% | $128,287 | $1,049,457 | $64,143 | |||
| 6 | 5.76% | $64,143 | $1,113,600 | $0 | |||
| year | 0 | 1 | 2 | 3 | 4 | NPV | |
| Initial investment | (1,113,600) | ||||||
| Working capital | (46,400) | (6,960) | (6,960) | (6,960) | 67,280 | ||
| Operating cash flow | |||||||
| Saving in cost | 371,200 | 371,200 | 371,200 | 371,200 | |||
| depreciation | 222,720 | 356,352 | 213,811 | 128,287 | |||
| Profit before tax | 148,480 | 14,848 | 157,389 | 242,913 | |||
| Tax @ 23% | 34,150 | 3,415 | 36,199 | 55,870 | |||
| Net income | 114,330 | 11,433 | 121,189 | 187,043 | |||
| Operating cash flow | 337,050 | 367,785 | 335,001 | 315,330 | |||
| Post tax salvage value | |||||||
| 162400-(162400-192430)*23% | 169306.9 | ||||||
| Net cash flow | (1,160,000) | 330,090 | 360,825 | 328,041 | 551,917 | ||
| PVIF @ 9% | 1 | 0.917431193 | 0.841679993 | 0.77218348 | 0.70842521 | ||
| Present value | (1,160,000) | 302,834 | 303,699 | 253,308 | 390,992 | $ 90,832.98 | |
| answer =option A | $ 90,832.98 | ||||||