CODEWITHSUNDEEP
google-sheetsxirr
krbabu
krbabu

Reputation: 51

Can someone see what is wrong with this XIRR() computation in Google Sheets? (I have sent a request to Google ...)

Please review https://docs.google.com/spreadsheets/d/1cWIAdWylD5Mx8zP5gFwkSVkAYLwXuFopoH_9mi2tGWg/edit#gid=0. It contains some dates and corresponding investment amounts. My goal is to have XIRR() compute the rate of return. While it is obvious that the result must be negative, the cell C1, with the formula XIRR(B3:B16,A3:A16), produces a huge positive number. Thanks in advance.

Upvotes: 0

Views: 783

Answers (1)

krbabu
krbabu

Reputation: 51

I just realized that I didn't provide a 3rd argument, rate_guess, in the original invocation of XIRR(). (Thanks to @player0 for prompting me). With rate_guess provided, the result is believable.

Upvotes: 0

Related Questions