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

RECEIVED solves for the maturity amount of a discounted investment using Investment/(1-Discount*t). Here t comes from the release’s GetYearDiff helper. The discount is applied relative to the maturity amount, so this is not simply Investment multiplied by 1+Discount*t. Release implementation.

RECEIVED(Settlement;Maturity;Investment;Discount[;Basis])

• Settlement, Maturity: use valid dates with Settlement<Maturity for the intended model.
• Investment: positive amount paid initially. Discount: positive annual discount rate as a decimal.
• 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=950, Discount=0.05 and a Basis-0 half-year from January 1 to July 1, 2024, the divisor is 0.975. The maturity amount is approximately 974.358974358974. The difference from Investment is approximately 24.358974358974.

For a full Basis-0 year with the same Investment and Discount, the result is 1000. This directly checks that a 5% discount on the maturity amount 1000 produces an initial amount of 950.

Rearranging gives Investment=Received*(1-Discount*t). RECEIVED and PRICEDISC use the same GetYearDiff helper, so this amount identity is consistent when dates, basis and discount match. It does not require treating Discount as an investment-based return.

For February 29 to March 31, 2024, Basis 0 uses 31/360 and gives approximately 954.107964848654. Basis 4 uses 32/360 and gives approximately 954.241071428571. Preserve those release-specific endpoint rules when reconciling a worksheet; a generic one-month fraction would describe a different calculation.

Validate 1-Discount*t>0 before using the conventional positive-redemption model. The wrapper explicitly checks positive Investment and Discount but does not independently impose increasing dates or a positive denominator. The guide’s ordinary examples do satisfy those conditions. Invalid, equal-date, reversed-date and zero-denominator calls were not executed.

The function has no intermediate cash-flow or compounding argument. Keep rate units and dates explicit, and distinguish the returned maturity amount from a profit or annualized return. It is an arithmetic model of the supplied assumptions rather than a validation of an investment arrangement.

PRICEDISC, INTRATE, DISC.

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