include depreciation and working capital in the following NPV analysis, because depreciation for the machinery goes for longer than the project timeline, and working capital needs to be accounted for as a percentage of sales.
Project timeline - 4 years
Investment required 1,200,000
- 1 mil for new machinery depreciated over 4 years, zero salvage value at end of 4 years
- 200,000 for building extension depreciated over 10 years
400,000 units will be sold equally spread over the 4 year timeline, at a fixed cost of 20 per unit
Cost of good sold is as following:
year 1 - 1,100,000
year 2 - 1,180,000
year 3 - 2,200,000
year 4 - 2, 360,000
Working capital is 10% of sales recovered at end of year 4
Depreciation - 20% diminishing value
Tax rate - 25%
required rate of return is 12%