In: Finance
Your firm is contemplating the purchase of a new $700,000 computer-based order entry system. The system will be depreciated straight-line to zero over its five-year life. It will be worth $60,000 at the end of that time. You will need to increase your working capital by $81,000 by purchasing additional inventory at the beginning of the project (this is a one-time increase). The tax rate is 34 percent and the required return on the project is 15 percent.
If the pretax cost savings are $344,000 per year, what is the NPV of this project?
DEPRECIATION = 700000-60000/5= 128000
| 
 YEAR  | 
 0  | 
 1  | 
 2  | 
 3  | 
 4  | 
 5  | 
|
| 
 INITIAL OUTLAY  | 
 -700000  | 
||||||
| 
 WORKING CAPITAL  | 
 -81000  | 
||||||
| 
 COST SAVINGS  | 
 344000  | 
 344000  | 
 344000  | 
 344000  | 
 344000  | 
||
| 
 LESS:-  | 
 DEPRECIATION  | 
 128000  | 
 128000  | 
 128000  | 
 128000  | 
 128000  | 
|
| 
 PRE TAX INCOME  | 
 216000  | 
 216000  | 
 216000  | 
 216000  | 
 216000  | 
||
| 
 LESS:-  | 
 TAX @ 34%  | 
 73440  | 
 73440  | 
 73440  | 
 73440  | 
 73440  | 
|
| 
 AFTER TAX INCOME  | 
 142560  | 
 142560  | 
 142560  | 
 142560  | 
 142560  | 
||
| 
 ADD:-  | 
 DEPRECIATION  | 
 128000  | 
 128000  | 
 128000  | 
 128000  | 
 128000  | 
|
| 
 CASH FLOWS  | 
 -781000  | 
 270560  | 
 270560  | 
 270560  | 
 270560  | 
 270560  | 
|
| 
 RELEASING OF WORKING CAPITAL  | 
 81000  | 
||||||
| 
 SALVAGE VALUE  | 
 60000  | 
||||||
| 
 CASH FLOW IN FIFTH YEAR  | 
 411560  | 
||||||
| 
 PVIF @ 15%  | 
 1.000  | 
 0.8696  | 
 0.7561  | 
 0.6575  | 
 0.5718  | 
 0.4972  | 
|
| 
 PRESENT VALUES  | 
 -781000  | 
 235279  | 
 204570  | 
 177893  | 
 154706  | 
 204628  | 
|
| 
 NPV = (-781000+235279+204570+177893+154706+204628)  | 
|||||||
| 
 NPV = 196076  |