The question is shown below. Of the three options which answer is correct?

You are given the following incremental cash flow table: Year: 0 123 4 5 CF 500 150 150 150 150 150 You are using the IRR function in Excel to compute the IROR. For the resulting value, you get #NUM! what is the most likely cause of the error? O Half the cash flows must be of the opposite sign) negative O All the cash flows must be negative O There must be at least one negative value in the cash flow