Accounting 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

 

  1. A) If the appropriate discount rate is 12%, rank the two projects.
  2. B) Which project is preferred if you rank by IRR?
  3. D) Should you use NPV or IRR to choose between the two projects? Give a brief discussion