$\backslash$table$[[$a$-1.,$Project A$,,\%],[,$Project B$,,],[$a$-2.,,,],[$b$-1.,$Project A$,,],[,$Project B$,,],[$b$-2.,,,\%],[$c$-1.,,,\%],[$c$-2.,,,\%],[$d$.,$Discount rate,,$\%]]$Bruin$,$ Incorporated, has identified the following two mutually exclusive projects

Please help me solve this problem using Excel.Bruin, Incorporated, has identified the following two mutually exclusive

projects:

a$-1.$ What is the IRR for each of these projects?

Note: Do not round intermediate calculations and enter your answers as a

percent rounded to $2$ decimal places, e$.$g$.,32\mathrm{.}16.$

a$-2.$ If you apply the IRR decision rule, which project should the company

accept?

$b-1.$ Assume the required return is $15$ percent. What is the NPV for each of

these projects?

Note: Do not round intermediate calculations and round your answers to

$2$ decimal places, e$.$g$.,32\mathrm{.}16.$

b$-2.$ Which project will you choose of you apply the NPV decision rule?

c$-1.$ Over what range of discount rates would you choose Project A$?$

Note: Do not round intermediate calculations and enter your answer as a

percent rounded to $2$ decimal places, e$.$g$.,32\mathrm{.}16.$

$c-2.$ Over what range of discount rates would you choose Project B$?$

Note: Do not round intermediate calculations and enter your answer as a

percent rounded to $2$ decimal places, e$.$g$.,32\mathrm{.}16.$

d$.$ At what discount rate would you be indifferent between these two

projects?

Note: Do not round intermediate calculations and enter your answer as a

percent rounded to $2$ decimal places, e$.$g$.,32\mathrm{.}16.$