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 |