I need help in this question. please do it correctly and 100%

You work for the 3T company, which expects to earn at least 20 percent on its investments. You have to choose between two similar projects. Your analysts predict that inflation rate will be a stable 3 percent over the next 7 years. Below is the cash flow information for each project. Which of the two projects would you fund if the decision is based only on project NPV? (5 points) Omega Year YO Y1 Y2 Y3 Y4 YS Y6 Inflow 0 0 $150,000 220,000 215,000 205,000 197,000 100,000 1,087,000 Outflow Netflow $225,000 -225,000 190,000 -190,000 0 150.000 30,000 190.000 0 215,000 30,000 175,000 0 197,000 30,000 505,000 582,000 Alpha Year YO Y1 Y2 Y3 Y4 Y5 Y6 47 Total Inflow Outflow 0 $300,000 $50,000 100,000 150,000 0 250,000 50,000 250,000 0 200,000 50,000 180,000 0 120,000 30,000 1,200,000 530,000 Netflow -300,000 -50,000 150,000 200,000 250,000 150,000 180,000 90.000 670,000 Y7 70,000 Total You may work these problems by hand or by using MS Excel. Be sure to show any formulas or other key methods that explain how you arrived at your answer. You can insert pictures of your calculations or screenshots. After completing the assignment