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 $425,000 and will be eligible for 100 percent bonus depreciation. The equipment can be sold for $25,000 at the end of the project in 5 years. Sales would be $275,000 per year, with annual fixed costs of $47,000 and variable costs equal to 35 percent of sales. The project would require an investment of $25,000 in NWC that would be returned at the end of the project. The tax rate is 22 percent and the required return is 9 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 | -425000 | |||||
| Sales | 275000 | 275000 | 275000 | 275000 | 275000 | |
| (-) Fixed costs | 47000 | 47000 | 47000 | 47000 | 47000 | |
| (-) Variable costs [ 36% of sales ] | 96250 | 96250 | 96250 | 96250 | 96250 | |
| (-) Depreciation | 425000 | |||||
| Profit before tax | -293250 | 131750 | 131750 | 131750 | 131750 | |
| (-) Taxes @ 22% | -64515.00 | 28985.00 | 28985.00 | 28985.00 | 28985.00 | |
| Net income | -228735.00 | 102765.00 | 102765.00 | 102765.00 | 102765.00 | |
| (+) Depreciation | 425000 | |||||
| (+) Net working capital | -25000 | 25000 | ||||
| (+) After tax salvage value [ 25000*(1-22%) ] | 19500 | |||||
| Free cash flow | -450000 | 196265.00 | 102765.00 | 102765.00 | 102765.00 | 147265.00 |
| Present value factor @ 9% | 1 | 0.91743119 | 0.841679993 | 0.77218348 | 0.708425211 | 0.649931386 |
| Present value | -450000.00 | 180059.63 | 86495.24 | 79353.44 | 72801.32 | 95712.15 |
| Net present value (NPV) | 64421.78 |