XIRR Function (OpenOffice Calc)

• Introduced: First release not established; documented by OpenOffice.org 3.3.
• Supported in: Apache OpenOffice 4.1.16; this is a verified release, not a final supported version.
• Scope: Desktop Calc, English function names and semicolon-separated formulas.
• Checked: October 14, 2026. Eight ordinary reference formulas were recalculated from generated ODF in 4.1.16 on Linux x86-64, Build 9816. Source and independent arithmetic were checked.

XIRR seeks an annualized rate that makes a dated cash-flow sum zero. Each exponent uses the actual difference from the first date divided by 365, including intervals spanning leap days. This timing model differs from the equal-period model in IRR. Release implementation.

=XIRR(Values;Dates[;Guess])

• Values: numeric cash-flow range with payments and receipts carrying opposite signs.
• Dates: equally sized numeric-date range, paired with Values row by row.
• Guess: optional starting rate, default 0.1; the release rejects a starting guess at or below −1.
• Supply at least two matched entries and verify the date serial origin.

Enter the values in the stated cells. G contains numeric date serials with the December 30, 1899 origin. A dash marks an unused cell, not a zero to enter.

IRR treats successive numeric entries as equal periods; XIRR uses their actual paired dates. Keep the timing models distinct.

The native column contains saved 4.1.16 results; independent references use high-precision arithmetic and the stated source rules. Values are shown to twelve decimal places where needed. The range examples use the numeric setup above.

Using F10:F14 and G10:G14 gives approximately 0.272768799283, or 27.2768799283% annually. The actual offsets from January 1, 2024 are 0, 182, 366, 547 and 731 days. Those are not four equal annual periods, so the result differs from IRR on the same amounts.

For J10:J11 paired with the first two dates, −1000 becomes 1100 after 182 days. The annualized result is 1.1^(365/182)-1, approximately 0.210633821537. A ten-percent return over that interval is not itself a ten-percent annual rate.

Check a candidate r with XNPV(r;F10:F14;G10:G14). Independently, sum each value divided by (1+r)^((date-first_date)/365). This residual check tests the exact fixed-365 model rather than a YEARFRAC convention chosen separately.

The default, 0.05 and 0.2 guesses converge to the same root for the ordinary F schedule. That agreement is useful for this input but does not prove uniqueness for arbitrary cash flows. Keep dates and amounts paired when sorting; sorting only one range changes the problem.

The function checks that the ranges have equal counts of at least two and validates the initial guess. Its Newton calculation allows up to fifty iterations, with rate-change and residual criteria. A result should still be checked against the original dated cash flows, especially when the sequence changes sign repeatedly.

The native examples use numeric values and dates in chronological order. Text dates, mismatched ranges, blank entries, unsuccessful searches and invalid guesses were not executed. A date displayed in a familiar format can still be text; confirm that it is a numeric date serial before using it.

XNPV, IRR, NPV.

• Function-specific release implementation
• lcl_sca_XirrResult calculation
• lcl_sca_XirrResult_Deriv1 calculation

The generated ODF produced the informational load warning “Not all attributes could be read.” The sheet was hard-recalculated and saved separately. All eight ordinary function identities, inputs and results were reconciled; a stale SUM cache changed from 999999 to 3 and an uncached SUM returned 7. This establishes the stated examples, not every workbook style or invalid input. Other explanatory identities are independent calculations. The authoring-tool XLSX was not executed in OpenOffice, and its preview values are not the native results reported here.