In: Finance
The Sausage Hut is looking at a new sausage system with an equipment cost of $450,000. This cost will be depreciated straight-line to zero over the project's 5-year life, at the end of which the sausage system can be sold at a salvage value of $80,000. The sausage system is estimated to generate $250,000 in annual sales, with COGS and administrative expenses of $72,000. The system requires an initial investment in net working capital of $30,000, which will be recouped at project end. If the tax rate is 35 percent and the required return is 10 percent, what is the NPV of this project?
0 | 1 | 2 | 3 | 4 | 5 | |
OCF | ||||||
ΔNWC | ||||||
Cap. Spending | ||||||
CFFA |
NPV | $128,919.36 |
Workings
Year | 0 | 1 | 2 | 3 | 4 | 5 |
Sales | 250000 | 250000 | 250000 | 250000 | 250000 | |
Less: Expenses | 72000 | 72000 | 72000 | 72000 | 72000 | |
Depreciation | 90000 | 90000 | 90000 | 90000 | 90000 | |
EBIT | 88000 | 88000 | 88000 | 88000 | 88000 | |
Les tax | 30800 | 30800 | 30800 | 30800 | 30800 | |
Earnings after tax |
57200 | 57200 | 57200 | 57200 | 57200 | |
Add Depreciation |
90000 | 90000 | 90000 | 90000 | 90000 | |
OCF | 147200 | 147200 | 147200 | 147200 | 147200 | |
NWC | -30000 | 30000 | ||||
Cap spending | -450000 | 52000 | ||||
CFFA | -480000 | 147200 | 147200 | 147200 | 147200 | 229200 |
NPV | $128,919.36 |