Capital Budgeting Problem:

You have a business making widgets. You are considering buying a new machine which costs $800,000. You expect to be able to sell it for $40,000 at the end of its useful life in 7 years and will straight-line depreciate it.

You are going to take a robot arm off an old machine to use to run the new one. The old machine could be sold for $20,000 today if you didn't take parts off it, but is worthless without the robot arm. You also have some old material that you're not using, which you had bought for $10,000 to make a prototype for some possible new products.

You think you will be able to sell a new type of widget that you will make on this machine. You expect to sell 60,000 per year at $18 each.

You expect $45,000 in fixed costs, and variable cost of 75% of sales on the new widgets. You also expect to need additional Net Working Capital to start the project of $50,000, which you will recover in Year 7.

Your tax rate is 35% and your cost of capital is 10%.

a.Calculate the project's NPV (NOTE: The Excel NPV function may not work the same way as your calculator's NPV function. Make sure to use the Excel NPV function correctly).

i.State whether the firm should accept or reject the project based on NPV.

ii.Explain why you accepted or rejected the project based on NPV. In other words, what does it mean for the NPV to be positive or negative (whichever you calculated)?