What is the problem with the following IRR calculation using XIRR formula in Google Sheet (opens in new tab)

I opened an investment bank account in December,2024, then there are the following transactions date transaction type cashflow ($) 2025-01-01 DEPOSIT 10,000 2026-01-01 BUY STOCK -10,000 2026-02-01 SELL STOCK 13,000 2026-06-01 WITHDRAWAL -13,000 I used Google Sheet to calculate the result But the IRR result ended up as 0 Question: is the IRR result calculated by Google Sheet by using XIRR formula correct? If it is incorrect, there is probably some problem in the input data, how to fix the inpu...

Read the original article
Sign in to keep reading the full article.

Keyboard Shortcuts

Navigation

Next / previous post
j/k
Open post
oorEnter
Preview post
v

Post Actions

Love post
a
Like post
l
Dislike post
d
Undo reaction
u
Save / unsave
s

Recommendations

Add interest / feed
Enter
Not interested
x

Go to

Home
gh
Interests
gi
Feeds
gf
Likes
gl
History
gy
Changelog
gc
Settings
gs
Discover
gb
Search
/

General

Show this help
?
Submit feedback
!
Close modal / unfocus
Esc

Press ? anytime to show this help