INTRATE 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.

INTRATE annualizes the simple gain relative to the initial investment. It returns (Redemption/Investment-1)/t, using GetYearDiff for the selected date basis. There is no intermediate compounding or coupon schedule in this formula. Release implementation.

INTRATE(Settlement;Maturity;Investment;Redemption[;Basis])

• Settlement, Maturity: dates with Settlement<Maturity.
• Investment, Redemption: positive amounts in matching units.
• Basis is optional and defaults to 0: 0 US 30/360, 1 actual/actual, 2 actual/360, 3 actual/365, or 4 European 30/360. These labels do not guarantee identical endpoint adjustments across every function in this release; the helper used here is identified below.

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. Enter DATE expressions directly rather than locale-dependent date text.

For Investment=95 and Redemption=100 from January 1 to July 1, 2024, Basis 0 uses t=0.5. The total return is 5/95, and annualizing gives approximately 0.105263157895, or 10.5263157895%.

The same amounts with Basis 2 use 182/360 and give approximately 0.104106419896. This is not a compound annual growth rate: the formula divides the holding-period return by a year fraction rather than taking a fractional power.

The underlying amount relation is Redemption=Investment*(1+INTRATE*t). For an exact half-year and Investment=95, a rate of 2/19 recovers Redemption=100. This is a simple-interest identity for the stated timing.

GetYearDiff divides its computed day difference by the start year’s selected year length. For February 29 to March 31, 2024 it uses 31/360 under Basis 0 and 32/360 under Basis 4, giving approximately 0.611205432937 and 0.592105263158. These source/native results must not be replaced with a generic 30-day assumption. DISC uses a different helper at these endpoints.

The source checks positive Investment and Redemption and increasing dates. It does not make Redemption>Investment a universal input requirement, although the native examples here use positive gains. Invalid-domain cases were not executed.

This arithmetic does not include cash flows between settlement and maturity, fees or tax effects. Use dates and a basis consistent with the intended calculation. Do not label the result as a coupon-bond yield or substitute it for an iterative cash-flow return merely because both are displayed as percentages.

DISC, RECEIVED, YEARFRAC.

• Function-specific release implementation
• GetYearDiff date helper
• GetDiffDate date helper
• Optional basis conversion and validation

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.