21 EX2-4 (Algo) You work for the 3T company, which... 4.16 points eBook Hint Print You work for the 3T company, which expects to earn at least 15 percent on its investments. You have to choose between two similar projects. Below is the cash flow information for each project. Calculate the NPV of each project. (Use the NPV function in Excel to solve this problem.) Which of the two projects would you fund if the decision is based only on financial information and you could only choose one of the projects? References Omega Year YO Inflow 0 Y1 Outflow 223,000 170,000 Hotflow (223,000) YO (170,000) YI Alpha Year Inflow Dutflow Netflow 215,000 (215,000) Y2 150,000 150,000 92 150,000 190,000 (190,000) 150,000 Y3 220,000 30,000 190,000 Y3 220,000 30,000 190,000 24 209,000 209,000 24 185,000 185,000 205,000 32,000 173,000 YS 205,000 40,000 165,000 Y6 197,000 197,000 16 197,000 0 197,000 Y7 100,000 30,000 Total 1,081,000 485,000 70,000 596,000 Y 100,000 30,000 70,000 Total 1,057,000 505,000 552,000 The NPV for Omega is The NPV for Alpha is The better project is Omega Help Save & Exi Checle