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