USE EXCEL AND SHOW EXCEL FUNCTIONS.

11. Calculating NPV [LO1] For the cash flows in the previous problem, what is th NPV at a discount rate of zero percent? What if the discount rate is 10 percent ie is 20 percent? If it is 30 percent? 12. NPV versus IRR [LO1, 5] Mahjong. Inc., has identified the following two mutually exclusive projects: Cash Flow (A) Cash Flow (B) Year 0 $43,000 | -$43,000 23,000 17,900 12,400 9,400 20-94 7,000 lerooo 13,800 |4,100 24,000, bo rt 4 26,0001b1 b 00 What is the IRR for each of these projects? Using the IRR decision rule, which project should the company accept? Is this decision necessarily correct? Which project will the company choose if it applies the NPV decision rule? B? At what discount rate would the company be indifferent between these two b. If the required return is 11 percent, what is the NPV for each of these projects? c. Over what range of discount rates would the company choose project A? Project projects? Explain