In: Finance
You consider a new piece of equipment that will cost $400,000, and will require $20,000 for shipping and installation. NWC will increase immediately by $25,000. The project will last 3 years and the equipment has a 5 year class life. Revenues will increase by $220,000/year, and defect costs will decrease by $220,000/year. Operating costs will increase by $30,000/year. The market value of the equipment after year 3 is $200,000. The cost of capital is 12%; marginal tax rate is 30%. What is the NPV?
| Operating cashflows | |||||||
| Year1 | YEar2 | YEar3 | |||||
| Revenue generated | 220000 | 220000 | 220000 | ||||
| savings in defects cpst | 220000 | 220000 | 220000 | ||||
| Operating cost | -30000 | -30000 | -30000 | ||||
| Depreciation | -84000 | -134400 | -80640 | ||||
| (420000*20%) | (420000*32%) | (420000*19.20%) | |||||
| Net Income before tax | 326000 | 275600 | 329360 | ||||
| Less: tax @ 30% | 97800 | 82680 | 98808 | ||||
| After tax Income | 228200 | 192920 | 230552 | ||||
| Add: Dep | 84000 | 134400 | 80640 | ||||
| Annual Operating cashflows | 312200 | 327320 | 311192 | ||||
| After tax salvage: | |||||||
| Market value of FA | 200000 | ||||||
| Less: Book value of assets (420000*28.80%) | 120960 | ||||||
| Gain on sales | 79040 | ||||||
| tax on gain | 23712 | ||||||
| Net cash flows from Sales | 55328 | ||||||
| NPV: | |||||||
| Year0 | Year1 | Year2 | Year3 | ||||
| Annual operating cashflows | 0 | 312200 | 327320 | 311192 | |||
| After tax salvage | 55328 | ||||||
| Release in NWC | 25000 | ||||||
| Investment in FA | -420000 | ||||||
| Investment in WC | -25000 | ||||||
| Netcashflows | -445000 | 312200 | 327320 | 391520 | |||
| PVF at 12% | 1 | 0.892857 | 0.797194 | 0.71178 | |||
| Present value of cashflows | -445000 | 278750 | 260937.5 | 278676.2 | |||
| NPV | 373364 | ||||||