Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic.
この関数は Google スプレッドシートでも 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.