Project A

YEAR 0 1 2 3 4

Expected CFs ($) -1,000,000 50,000 200,000 600,000 1,000,000

Project B

YEAR 0 1 2 3 4

Expected CFs ($) -900,000 650,000 650,000 550,000300,000

Find the: Payback period, Discounted payback period, NPV, IRR, and Profitability Index.

My answers:

Project A B Rank A Rank B

PBP 3.15 1.38 2 1

Did PBP 3.98 1.79 2 1

NPV $612,847 $596,206 1 2

IRR 35.93%55.07% 2 1

PI 1.61 1.66 2 1

Can somebody show me where I am going wrong? Thank you