XIRR function
Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic
Syntax
XIRR(values, dates, [guess])Square brackets indicate optional arguments.
Arguments
| Argument | Required | Meaning |
|---|---|---|
| values | Yes | A series of cash flows that corresponds to a schedule of payments in dates. The first payment is optional and corresponds to a cost or payment that occurs at the beginning of the investment. If the first value is a cost or payment, it must be a negative value. All succeeding payments are discounted based on a 365-day year. The series of values must contain at least one positive and one negative value.A1:A4 |
| dates | Yes | A schedule of payment dates that corresponds to the cash flow payments. Dates may occur in any order.B1:B4 |
| guess | No | A number that you guess is close to the result of XIRR.0.1 |
Try XIRR
Annualise two dated cash flows
=XIRR(A2:A3,B2:B3)These dates are exactly 365 days apart, so receiving 1100 after paying 1000 gives an annual rate of 10%. XIRR uses actual date spacing and a 365-day year.
Inspect the current formula
Read its written arguments or observe actual operation values in a separate local calculation. This action neither applies a draft nor grades an answer.
Read the formula, one argument at a time
Explore the written function calls and their inputs. The calculation result belongs to the complete formula.
XIRR · top-level call
=XIRR(A2:A3,B2:B3)1 / 2 · values
A series of cash flows that corresponds to a schedule of payments in dates. The first payment is optional and corresponds to a cost or payment that occurs at the beginning of the investment. If the first value is a cost or payment, it must be a negative value. All succeeding payments are discounted based on a 365-day year. The series of values must contain at least one positive and one negative value.
XIRR reference ↗Follow the cells behind a result
Read explicit local references and helper formulas using a separate calculation. Your draft stays in this field; the worksheet and practice checks do not change.
The worksheet runs locally. Published checks apply to the supplied example only. Native Excel and Google Sheets compatibility remain unverified.
Practice a complete task
Reference and compatibility
Univer 1.0.4 / Apache-2.0. Calculation checks cover the supplied examples only. The browser worksheet does not implement every Excel feature, external service or connected data type.