INTRATE Function (Calligra Sheets)

• Introduced: Original introduction release not established; the inspected release is not an introduction date.
• Available: Registered in Calligra Sheets 26.08.2, verified from first-party released source retrieved on October 18, 2026.
• Retired or deprecated: Neither is established by the inspected sources. The function remains registered; retirement and deprecation are different claims.
• Evidence: Selected formulas were executed in the Calligra Sheets 25.04.2 GUI on October 18, 2026. The native-results section lists those observations separately from independent arithmetic and source analysis. 26.08.2 was source-checked only.
• Entry style: English function names, semicolon argument separators and decimal points. Use DATE constructors instead of ambiguous date text. Optional-argument brackets shown in syntax are not entered literally.

=INTRATE(settlement; maturity; investment; redemption[; basis])

Four or five arguments are accepted. Unlike DISC, the rate denominator is the initial investment, not the redemption amount. Unlike a periodic cash-flow function, INTRATE has no payment frequency or intervening cash-flow argument.

On a fresh worksheet put =DATE(2025;1;1) in B1, =DATE(2025;7;1) in B2, 950 in B3, 1000 in B4 and 0 in B5. Label the cells settlement, maturity, investment, redemption and basis.

1. Enter =INTRATE(B1;B2;B3;B4;B5) in B7.
2. Expect 0.105263157895; percentage formatting shows approximately 10.5263%.
3. The holding-period gain is 1000−950 = 50.
4. The holding-period return is 50/950 = 0.0526315789474. For the 180/360 default fraction in this example, annualize by dividing by 0.5.

Do not mistake the 10.5263% annual rate for a 100-unit cash profit. The actual gain in this example is 50. The annualization describes a quote convention applied to the half-year holding period.

=INTRATE(DATE(2025;1;1);DATE(2025;7;1);950;1000;3) is independently expected to return 0.1061355045071, about 10.6135504507%. This uses 181 actual days and the calculation (50/950) × 365/181.

The first row shows scale invariance: multiplying both cash amounts by ten does not change the rate. It changes the gain in currency from 50 to 500.

For this function, basis 0 defaults to the financial helper’s simplified US 30/360 method; 1 counts actual days divided by the number of days in the settlement year; 2 uses actual/360; 3 uses actual/365; 4 uses a simplified European 30/360 calculation.

The 0/4 helpers are not full end-of-month normalization algorithms. Basis 0 has a special February-start adjustment; basis 4 is simply 30 times the month difference plus the day difference. Basis 1 uses the settlement year’s 365/366 denominator even across a year boundary. Do not infer full market-convention correctness from the labels. These helpers also differ from the shared YEARFRAC implementation used by DISC. See released date helpers.

The same purchase/redemption ratio can produce different annual figures. With the main basis-0 half-year model, simple investment return is 10.5263157895%. A redemption-base discount quote would be (50/1000)/0.5 = 10%. A hypothetical compounded annual rate formed by repeating the half-year gross return is (1000/950)^2−1, approximately 10.8033240997%.

INTRATE returns the first of these, not all three. The compound calculation assumes the same return can be earned again over another equal half-year interval; INTRATE makes no such reinvestment promise. Name each column clearly if a comparison sheet includes several conventions.

For reconciliation, retain settlement, maturity, basis, investment, redemption and the unannualized gain. A rate alone can obscure whether a discrepancy came from cash values, date convention or annualization. This is especially important when comparing an actual/365 quote with a 30/360 quote near month ends.

The source returns its internal errorVALUE when its day count is nonpositive, the year denominator is nonpositive, investment is zero, or basis is outside 0–4. The native 25.04.2 tests displayed #VALUE! for equal ordinary dates and zero investment; other invalid-input cases were source-checked only.

The explicit checks do not reject every negative investment or redemption. A returned number for an economically unsuitable sign pattern is not evidence that the transaction is modeled sensibly. Use a positive initial investment and a redemption amount appropriate to your intended example, then investigate negative gains separately.

The date helpers’ February and month-end simplifications also mean date validation cannot be reduced to “the formula returned a number”. Use ordered valid dates, whole-number basis inputs and explicit DATE constructors. Text coercion, regional date parsing and invalid-input display require native checks.

The Financial module registers COM.SUN.STAR.SHEET.ADDIN.ANALYSIS.GETINTRATE as an alternate name for INTRATE. It invokes the same implementation. An alias registration does not establish a workbook import/export guarantee, identical error behavior in other products or availability in every packaged build.

• DATE creates the two date inputs.
• YEARFRAC is a separate implementation; do not assume identical helper behavior.
• POWER supports the separate hypothetical compound-return comparison.
• KDE INTRATE handbook documents the function interface.
• Released function implementation provides the actual validation and calculation rules.

These formulas were recalculated in Calligra Sheets 25.04.2 from a prepared ODS workbook and saved by the application. The table records the native-saved results. Other scenarios remain independent expectations or source analysis unless listed here.

Screenshot: Native Calligra Sheets 25.04.2. Selected cell B2 evaluates =INTRATE(DATE(2025;1;1);DATE(2025;7;1);950;1000) and displays 0.1052631579. Column B contains application results; column C contains the corresponding formula text.

These observations cover only the listed cases in 25.04.2. They do not establish execution in 26.08.2, another locale, general workbook compatibility or the economic validity of unsuitable inputs.