In: Finance
|
Eggz, Inc., is considering the purchase of new equipment that will allow the company to collect loose hen feathers for sale. The equipment will cost $440,000 and will be eligible for 100 percent bonus depreciation. The equipment can be sold for $54,000 at the end of the project in 5 years. Sales would be $287,000 per year, with annual fixed costs of $50,000 and variable costs equal to 37 percent of sales. The project would require an investment of $31,000 in NWC that would be returned at the end of the project. The tax rate is 23 percent and the required return is 10 percent. |
|
Calculate the NPV of this project. (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) |
| Years | 0 | 1 | 2 | 3 | 4 | 5 |
| Cost of New equipment | -440000 | |||||
| Sales | 287000 | 287000 | 287000 | 287000 | 287000 | |
| (-) Fixed costs | 50000 | 50000 | 50000 | 50000 | 50000 | |
| (-) Variable costs [37% of sales ] | 106190 | 106190 | 106190 | 106190 | 106190 | |
| (-) Depreciation | 440000 | |||||
| Profit before tax | -309190 | 130810 | 130810 | 130810 | 130810 | |
| (-) Taxes @ 23% | -71113.70 | 30086.30 | 30086.30 | 30086.30 | 30086.30 | |
| Net income | -238076.30 | 100723.70 | 100723.70 | 100723.70 | 100723.70 | |
| (+) Depreciation | 440000 | |||||
| (+) Net working capital | -31000 | 31000 | ||||
| (+) After tax salvage value [ 54000*(1-23%) ] | 41580 | |||||
| Free cash flow | -471000 | 201923.70 | 100723.70 | 100723.70 | 100723.70 | 173303.70 |
| Present value factor @ 10% | 1 | 0.909090909 | 0.826446281 | 0.751314801 | 0.683013455 | 0.620921323 |
| Present value | -471000.00 | 183567.00 | 83242.73 | 75675.21 | 68795.64 | 107607.96 |
| Net present value (NPV) | 47888.54 |