EX$2-4($Algo$)$ You work for the $3$T company, which...

You work for the $3$T company, which expects to earn at least $12$ 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?

$\backslash$table$[[\backslash$table$[[$Omega$],[$Year$]],$Inflow,Outflow,Netflow,$\backslash$table$[[$Alpha$],[$Year$]],$Inflow,Outflow,Netflow$],[$Y$0,0,221,000,(221,000),$Y$0,0,213,000,(213,000)$