Please solve using EXCEL formulas and provide the formulas!!

Q$\mathrm{.}1$: Compare the following two investment options using Net Present Value $($NPV$).$Which should the company choose?

Q$\mathrm{.}2$: Compare the following two investment options using Net Present Value $($NPV$)$ and Internal Rate of Return $($IRR$).$ Is the IRR greater than the discount rate $($i$.$e$.,$ cost of capital or hurdle rate$)$ in each case? Which option has the higher IRR?