using net cash flows in this table and a discount of 10%, calculate the NPV of both projects 1 and 2. if doing by hand please show all work, if doing on excel please show formulas and values used

\begin{tabular}{crr} Year & Project 1 NCF & Project 2 NCF \\ \cline { 2 - 3 } 2 & (150,000) & (400,000) \\ 2 & 25,000 & (50,000) \\ 3 & 50,000 & (25,000) \\ 4 & 50,000 & (25,000) \\ 5 & 75,000 & 175,000 \\ 6 & (25,000) & 225,000 \\ 7 & 75,000 & 275,000 \\ 8 & 100,000 & 250,000 \\ 9 & 100,000 & 1,000,000 \\ 10 & 100,000 & 1,000,000 \\ Total & 400,000 & 2,425,000 \\ & & \\ IRR & 29% & 29% \\ NPV@12\% & $125,830 & $690,557 \end{tabular}