In: Finance
Geary Machine Shop is considering a four-year project to improve its production efficiency. Buying a new machine press for $816,000 is estimated to result in $272,000 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 $119,000. The press also requires an initial investment in spare parts inventory of $34,000, along with an additional $5,100 in inventory for each succeeding year of the project. |
Required : |
If the shop's tax rate is 34 percent and its discount rate is 11 percent, what is the NPV for this project? (Do not round your intermediate calculations.) |
Annual Operating cashflows: | |||||||
Year-1 | Year-2 | Year-3 | Year-4 | ||||
Annual Pre tax savings | 272000 | 272000 | 272000 | 272000 | |||
Less: Depreciation | 163200 | 261120 | 156672 | 94003.2 | |||
(816000*20%) | (816000*32%) | (816000*19.20%) | (816000*11.52%) | ||||
Annual Income before tax | 108800 | 10880 | 115328 | 177996.8 | |||
Less: tax @ 34% | 36992 | 3699.2 | 39211.52 | 60518.91 | |||
After tax income | 71808 | 7180.8 | 76116.48 | 117477.9 | |||
Add: Depreciation | 163200 | 261120 | 156672 | 94003.2 | |||
Annual Operating cashflows | 235008 | 268300.8 | 232788.5 | 211481.1 | |||
After tax Salvage value | |||||||
Sales value of FA | 119000 | ||||||
Book value of FA (816000*17.28%) | 141004.8 | ||||||
Loss on sales | -22004.8 | ||||||
Tax shield on loss @ 34% | 7482 | ||||||
After tax Salvage value | (119000+7482) | 126482 | |||||
Cashflows of each year: | |||||||
Year-0 | Year-1 | Year-2 | Year-3 | Year-4 | |||
Initial investment | -816000 | ||||||
Workin capital investment | -34000 | -5100 | |||||
Annual operating cashflows | 235008 | 268301 | 232789 | 211481 | |||
After tax salvage | 126482 | ||||||
WC release | 39100 | ||||||
Cash flows | -850000 | 229908 | 268301 | 232789 | 377063 | ||
PVF at 11% | 1 | 0.900901 | 0.811622 | 0.731191 | 0.658731 | ||
Present value of cashflowws | -850000 | 207124.3 | 217759.1 | 170213.3 | 248383.1 | ||
NPV | -6520 | ||||||