Calculations Shown In Excel file

Your firm is considering two projects with the following cash flows:

Discount rate: 12%

Project A: -$500 , $167, $180, $160, $ 100, $100

Project B: -500 , $200, $250, $170, $25, $ 30

A) If the appropriate discount rate is 12%, rank the two projects.

B) Which project is preferred if you rank by IRR?

D) Should you use NPV or IRR to choose between the two projects? Give a brief discussion