Using the following information I need help solving this cashflow problem.

Initial cost of the item is $100,000 which can be depreciated using MACRS 5- year recovery period

The item will last 8 years.

Time saved per part is 45 minutes

The cost to the company of the labor is $65/hr.

The company makes 4000 parts per year. The production volume will increase at a rate of 5% per year

The item will be sold at the end of the 8 years for $2000.

Tax rate is 28%

1) Calculate the after tax cash flow for this investment in the new item year by year.

2) What is the payback from this investment?

3) What is the NPV with a 6% discount rate .

4) What is the internal rate of return?

5) Using Goal Seek, what is the initial breakeven cost (at year 0).