You have a business making widgets. You are considering buying a new machine which costs $1,000,000. You expect to be able to sell it for $50,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 $30,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 $20,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 50,000 per year at $25 each.

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

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

a.      Calculate the Initial Investment of the project, and the Terminal Cash Flow of the project.

b.     Calculate the Operating Cash Flow (OCF) for each year of the project. Remember to calculate the EBIT and show each item that goes into the OCF on its own row, and label each row you use.

c.      Calculate the Total Cash Flow for each year of the project.

d.     Calculate the project’s NPV