monthly, annual).

Payments are expressed as negative values and income as positive values.

Amounts can vary, but intervals need to be the same.

Excel PV function

The first value is negative, since it represents an outflow.

A better guess will prevent this error.

Excel NPV function