a) Determine the NPV (if the required return is 7%) and IRR for each of the following two mutually exclusive projects:

Year	Cash Flows Project (A) $	Cash Flows Project (B) $
0	-23,.400	-26,600
1	13,100	14,700
2	9,480	10,120
3	7,390	9,180

b) Based on the information in a) above,

1) determine the crossover rate,

2) explain which project the company should invest in (or when) and provide a rational for this, and

3) discuss your decision in 2. above in the context of the profitability index for each project. detailed excel worksheet and formula please