APPLE Inc. is considering expanding its offerings to their consumers. Three different projects have been submitted for brand expansion.

But analysis shows that there are only resources to choose one. CFO, has said that the required rate of return is 14%.

Project A: NPV = $18,863, IRR = 10%

Project B: NPV = $18,663, IRR = 14%

Project C: NPV = $19,300, IRR = 12%

What is your decision?:

a. Accept all the projects

b. None of the projects are clearly better than the others

c. Project A

d. Project B

e. Project C

f. There is not enough information to decide

*Answer with excel formula

thanks