Please show work in Excel.

Question 2 15 points Save Answer You are considering an investment into a new market and have two mutually exclusive and normal cash flow projects, X and Y, under consideration. Project X has an IRR of 11.5%, while project Y has an IRR of 13.2%. For a rate of return of 15.5%, the NPV of project X is equal to the NPV of project Y. If the required rate of return is 8.8%, which project should be chosen? Be sure to explain your reasoning. For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac). B I Paragraph Arial 14px IX % E X2 X2 > T + ABC ... EX + E | {:} o O WORDS POWERED BY TINY