What is the formula to solve this problem in excel...
Comparing capital budgeting tools: Capital budgeting analysis of mutually exclusive projects A and B yields the following. What project should management choose? Explain why.
Project A
IRR: 19.00%
NPV: $385,000
Payback Period: 2.8 years
Project B
IRR: 24.00%
NPV: $350,000
Payback Period: 2.2 years