***Please solve using Excel and show/explain formulas.***

Consider the following two mutually exclusive projects: If the discount rate is 10%, what are the NPV of Project A and the IRR of Project B? Multiple Choice Then NPV for project A is $5.9 and the IRR for project B is 14.5% Then NPV for project A is $20 and the IRR for project B is 13.3% Then NPV for project A is $5.9 and the IRR for project B is 11.9% Then NPV for project A is $8 and the IRR for project B is 9%