PepsiCo is considering a $2,200,000 investment in new production lines. The project will depreciate at a rate of 15% annually, leaving book values of $1,870,000, $1,540,000, $1,210,000, $880,000, $550,000, $220,000, and $0 at the end of each year. Expected annual cash flows are $400,000, $450,000, $350,000, $300,000, $250,000, $200,000, and $150,000. The profits are projected at $80,000, $130,000, $30,000, $-20,000, $-70,000, $-120,000, and $-170,000, resulting in ARR percentages of 3.64%, 8.44%, 2.48%, -1.61%, -5.89%, -10.88%, and -18.09%. The average profit is $-34,714, with an average investment of $1,100,000, yielding an average ARR of -3.16%. The cumulative cash flows indicate a payback period of 5.5 years. The NPV, discounted at 12%, is calculated to be $55,000.

Requirements:

1. Determine the ARR, payback period, and NPV for the investment.
2. Discuss the project's potential financial benefits and drawbacks.
3. Provide a final recommendation on the investment decision.