Answer with Excel

PROBLEMS 11-7 CAPITAL BUDGETING CRITERIA A firm with a 14% WACC is evaluating two projects for this year's capital budget. After-tax cash flows, including depreciation, are as follows: 0 4 Project A $6,000 $2,000 2,000 $2,000 $2,000 $2,000 Project B $18,000 $5,600 $5,600 $5,600 $5,600 $5,600 a. Calculate NPV and IRR for each project b. Assuming the projects are independent, which one(s) would you recommend? c. If the projects are mutually exclusive, which would you recommend? d. Notice that the projects have the same cash flow timing pattern. Why is there a conflict between NPV and IRR