Required:

Using Excel, calculate the NPV and IRR of each project. Assume Gunnell Incorporated uses a discount rate of $8\%.$

Note: Round your NPV answer to the nearest dollar amount and your IRR answer to $2$ decimal places $($i$.$e$.0\mathrm{.}1234=12\mathrm{.}34\%).$