I am trying to learn how to use XIRR following tutorials.I think I'm overlooking something with this dataset problem when using Google Sheets to calculate XIRR. Can someone be kind enough to explain what's wrong? enter image description here

1 Answer 1


You don't have a large enough positive transaction to balance the negative ones. For example deposits recorded as negative cash flows should be balanced against a positive balance (or positive withdrawal).

E.g. 3 deposits: £10, £11, £12 and final balance £35 would be listed as


Another example here: https://money.stackexchange.com/a/58278/11768

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .