$4,000 each year for the next si rates positive cash flows of $4,500 each year for the Project A has an initial investment of $11,000, and generates positive cash flows o years. Project B has an initial investment of $17,000, and gene next six years. Assume the discount rate is 13%. 5 6 NPV Enter the NPV function. Be sure to properly 7 Project A Project 8 Using the NPV criteria answer these questions Project selected if A and B are mutually exclusive Project(s) selected if A and B are indpendent: 10 12 IRR 13 Project A Project B 14 -..............1 Enter the IRR function. 16 Using IRR for your decision, which project would you select if A and B are mutually exclusive: Using the IRR criteria 17 18 Would your answer change if the two projects are independent instead of mutually exclusive? 19 Would your answer change if the two projects are independent instead of mutually exclusive? 19 20 21 Project C was added to the potential capital budgeting list at the last minute as a mutually exclusive alternative to a Project B. C has an initial investment of $17,000, and generates positive cash flow of $37,500 in year six; note years 23 1 through 5 have NO CASH FLOws. Assume the discount rate is 13%. 24 25 26 NPV 27 Project B Project C $0.00 Enter the NPV function. Be sure to properly account for the initial cost! The value in 29 Using the NPV criteria answer these questions Project selected if B and C are mutually exclusive: IRR Project B Project C 0961 1 Enter the IRR function. Yellow cell will fil automatically 35 Using the IRR criteria. Project selected if B and C are mutually exclusive: 36 37 Because Projects B and C are mutually exclusive, would you recommend that Project B or Project C be added to the 9capital budget for this year? Explain your answer here