Zoho Sheet RECEIVED Function: Maturity Amounts from Discount Rates

RECEIVED(settlement; maturity; purchase_value; discount_rate; [basis])

settlement is the purchase date, maturity is the date the security matures, purchase_value is the amount invested and discount_rate is the annual discount rate. Enter 8% or 0.08 for eight percent. There is no frequency argument in the documented signature.

The optional basis defaults to 0. Zoho documents 0 as US NASD 30/360, 1 as actual days with an actual-length year, 2 as actual days/360, 3 as actual days/365 and 4 as European 30/360. Those are distinct conventions. This guide uses explicit 3 for reproducible actual-day examples; omitting the final argument would change the requested convention.

Construct dates with DATE(year;month;day) rather than ambiguous text. The Zoho DATE reference documents that construction. The examples use semicolons as shown in Zoho’s help; the actual editor’s locale and accepted separators should be checked before importing formulas.

The official RECEIVED reference was retrieved October 15, 2026. It documents the rolling web service but does not establish the first release or last functioning version. Both historical endpoints remain unknown, and mobile/offline parity is not certified by the web entry.

Expected numbers below are independent simple-interest or discount-model calculations from fully specified inputs, not captured native Zoho output. The source lists syntax, argument meanings, day-count options and sample results, but its embedded example input cells are not visible in the retrieved text. Those hidden datasets are not reconstructed or claimed as executed tests. The ordinary positive, forward-date examples do not resolve every boundary or coercion behavior.

Put Settlement, Maturity, Purchase and Discount in A1:D1 and Basis in E1. Enter =DATE(2026;4;1) in A2, =DATE(2026;7;1) in B2, 9800 in C2, 8% in D2 and 3 in E2.

In F2 enter =RECEIVED(A2;B2;C2;D2;E2). The independent maturity-value expectation is 9999.4409034999. The actual holding interval is 91 days.

A separate discount-model control is =C2/(1-D2*(B2-A2)/365). The denominator is independently 0.9800547945. The increase from the initial purchase is approximately 199.4409034999.

Keep the monetary unit consistent across the purchase and output columns. Percentage formatting belongs on the discount input, while the returned amount normally uses a number or monetary format. Applying a currency symbol does not perform currency conversion.

For the same dates, eight-percent discount and basis 3, enter purchase amounts 1000, 5000 and 9800 in H2:H4. Use =RECEIVED($A$2;$B$2;H2;$D$2;$E$2) in I2 and fill down.

Independent outputs are 1020.3511126020, 5101.7555630102 and 9999.4409034999. The common factor is approximately 1.0203511126. Doubling the purchase amount doubles the modeled maturity amount because the rate and time fraction remain fixed.

The anchored references are intentional. A filled formula that shifts the dates or rate is no longer a scale-only test. Inspect copied formulas when a sensitivity table stops following the expected proportional pattern.

Applying a simple interest add-on to the purchase instead gives =C2*(1+D2*(B2-A2)/365), independently 9995.4630136986. That differs from the RECEIVED control because the discount fraction is measured against maturity value rather than purchase value.

The difference is not a mere percentage-format issue. In the discount model, purchase equals maturity multiplied by one minus the period discount fraction. Solving that relationship requires division by the retained fraction, rather than multiplication by one plus it.

Using the unrounded F2 result, enter =F2*(1-D2*(B2-A2)/365) in G2. Its independent target is the original 9800. The difference =G2-C2 has mathematical target zero.

This is a useful reverse check for an imported worksheet. Retain the actual discount rate, date interval and basis in labeled cells; replacing any one of them in only the reverse formula breaks the comparison. Small floating-point residuals should be distinguished from a material input mismatch.

For an illustrative full 365-day interval with basis 3 and purchase 1000, discount rates 5%, 20% and 50% yield independent amounts 1052.6315789474, 1250 and 2000. The denominator decreases as the rate rises.

At a period discount fraction of one the mathematical denominator is zero. Beyond one, the elementary expression turns negative. These are model warnings, not established native Zoho output or error claims. The guide’s worked formulas stay in the positive-denominator region rather than silently treating all rate/time combinations as sensible securities.

Zoho’s dedicated list documents #NUM! for purchase_value or discount_rate below zero, basis outside 0–4, and settlement after maturity. It also includes a frequency restriction mentioning 1, 2 and 4, although the syntax has no frequency parameter. That unrelated row is not adopted as a RECEIVED argument rule here.

The wording does not explicitly exclude zero purchase, zero discount or equal dates. Exact endpoint behavior, fractional basis conversion and the singular denominator error were not native-tested. Shared name/type/reference errors are available in the help but do not establish every malformed-date case.

If a result differs from a simple-interest worksheet, first check which amount is the rate denominator. Then check elapsed days, annualization convention and percent entry. These fictional examples describe spreadsheet arithmetic and omit fees, taxes, credit risk and other investment considerations.