The following cash flows are estimated for two mutually exclusive projects:

except EXCEL

Year Project A CF Project B CF

$0-$$$100,000-$$$100,000$

$1$ $$60,000$ $$30,000$

$2$ $$40,000$ $$40,000$

$3$ $$20,000$ $$20,000$

$4$ $$10,000$ $$50,000$

a$.$ Calculate the internal rate of return for each project.

b$.$ Calculate the cross$-$over rate of projects A and B$.$

c$.$ When is the project B more lucrative than the project A$?$ When is the project A is more lucrative

than the project B$?$

d$.$ When the discount rate $($r$)$ is $12\%,$ which project should the investor choose?