Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic.
ฟังก์ชันนี้ทำงานใน Google Sheets เหมือนกับใน Excel — ไวยากรณ์และอาร์กิวเมนต์เดียวกัน
XIRR(values, dates, [guess])XIRR calculates the annual internal rate of return for an investment with irregular payment dates. It is more flexible than the IRR function because it accounts for specific dates associated with each cash flow.
=XIRR({-1000, 300, 800}, {"2023-01-01", "2023-06-01", "2024-01-01"})ผลลัพธ์: 0.1088
Calculates the annual return for an initial investment of 1000 followed by two irregular repayments.
This usually happens if the cash flows do not contain at least one positive and one negative value, or if the calculation fails to converge.