Answer:
Project Ahas IRR of 19.71%
Project B has IRR of 18.76%
Explanation:
The IRRs were computed using the IRR formula in excel given as irr(values)
It is important to note that initial investments were negative amounts as that represented the initial cash parted with, so as to have cash inflows subsequently.
Find attached for detailed calculations.