Google Sheets-funktion

XIRR

Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic.

Skapa en formel med AI Samma funktion i Excel

Den här funktionen fungerar likadant i Google Kalkylark som i Excel — samma syntax och argument.

Syntax

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.

Argument

valuesobligatorisktA series of cash flows that corresponds to a schedule of payments in dates.
datesobligatorisktA schedule of payment dates that corresponds to the cash flow payments.
guessvalfrittAn optional estimate of what the result of XIRR will be; defaults to 0.1 (10%).

Exempel

=XIRR({-1000, 300, 800}, {"2023-01-01", "2023-06-01", "2024-01-01"})

Resultat: 0.1088

Calculates the annual return for an initial investment of 1000 followed by two irregular repayments.

Vanliga frågor

Why does XIRR return a #NUM! error?

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.

Relaterade funktioner

IRR NPV XNPV