JPSem

I got P(success)=0.2866 (0.70x.85x.80x.75... something like that)

Remember, p(Success) is the product of SUCCESS probabilities, the question gives us failure probabilities.

I multiply P(success) by CF final (10 million), I get 2,866,000. Then I enter this as my CF5, enter -1million as Cf0, and calculate NPV at the given rate (18% I think)

I use the CF function, not the PV, FV function.