In: Finance
| 1. Intial cash flow | ||||||||||||
| Equipment cost | 144000 | |||||||||||
| Investment in NWC | 30000 | |||||||||||
| 174000 | ||||||||||||
| 2. In between flows | ||||||||||||
| Sales | Variable cost | Fixed cost | Net income | Deprecition | CABT | Tax | CAT | Add: depreciation | Balance | Add: Working capital recapture | NET cash flow | |
| Year1 | 540000 | 144000 | 60000 | 336000 | 48000 | 288000 | 72000 | 216000 | 48000 | 264000 | 264000 | |
| Year2 | 540000 | 144000 | 60000 | 336000 | 48000 | 288000 | 72000 | 216000 | 48000 | 264000 | 264000 | |
| Year 3 | 540000 | 144000 | 60000 | 336000 | 48000 | 288000 | 72000 | 216000 | 48000 | 264000 | 30000 | 294000 | 
| **Depreciation = 144000/3 | ||||||||||||
| 3. NPV | ||||||||||||
| CF | PVF | PVF x CF | ||||||||||
| Year 0 | -174000 | 1 | -174000 | |||||||||
| Year1 | 264000 | 0.9009 | 237837.6 | |||||||||
| Year2 | 264000 | 0.8116 | 214262.4 | |||||||||
| Year 3 | 294000 | 0.7311 | 214943.4 | |||||||||
| NPV | 493043.4 |