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.