RECEIVED in Collabora Office: Calculate Redemption from an Investment and Discount
Use Collabora RECEIVED with an explicit day-count basis, reproduce the documented maturity amount, and explain why discounting divides rather than adds interest.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer: =RECEIVED(DATE(1999;2;15);DATE(1999;5;15);1000;5.75%;2) has documented result approximately 1014.420266. It calculates the amount received at maturity from the investment and the specified discount.
Syntax and input scale
=RECEIVED(Settlement; Maturity; Investment; Discount [; Basis])
Settlement is the purchase date, Maturity is the expiry date, Investment is the purchase amount, and Discount is the discount percentage. These four arguments are required. Basis is optional and defaults to zero.
| Basis | Documented convention |
|---|---|
| 0 or omitted | US NASD, twelve 30-day months |
| 1 | Actual days in months and actual days in the year |
| 2 | Actual days in months, 360-day year |
| 3 | Actual days in months, 365-day year |
| 4 | European method, twelve 30-day months |
Use genuine date values or DATE formulas. The examples below use explicit bases and ordinary dates so the date and year conventions remain visible. A day-count basis is part of the calculation model, not a display preference.
Enter 5.75% as 5.75% or 0.0575, not 5.75. Investment is an amount, and the returned value is an amount in the same currency units. The function does not choose a currency or convert exchange rates.
Example: independently reproduce the vendor amount
Enter the two dates in A2:B2 with DATE formulas. Put 1000 in C2, 5.75% in D2, and 2 in E2. In F2 enter:
=RECEIVED(A2;B2;C2;D2;E2)
There are 89 actual days between February 15 and May 15, 1999. Under the example’s actual/360 basis, the independent arithmetic is:
=C2/(1-D2*(B2-A2)/360)
It gives approximately 1014.420265862645, agreeing with the documented rounded 1014.420266. The denominator is approximately 0.985784722222.
The difference between maturity amount and investment is approximately 14.420265863. It is not the entire maturity receipt; keep the principal amount and difference separate when labeling a report.
Example: a half-year discount with exact arithmetic
For settlement 2026-01-15, maturity 2026-07-15, investment 980, discount 4%, and basis 0, the regular 30/360 fraction is 180/360=0.5.
=RECEIVED(DATE(2026;1;15);DATE(2026;7;15);980;4%;0)
The independent expectation is 980/(1−0.04×0.5)=1000. The gain is 20. This simple control makes the role of the discount denominator easy to audit.
Advanced comparison: discounting is not adding interest
For that half-year example, adding 4% annual interest directly to the purchase amount would give =980*(1+4%*0.5), or 999.6. RECEIVED’s discount model gives 1000 because the discount is measured against the received amount rather than simply added as interest on the invested amount.
The 0.4 difference is a denominator effect, not a rounding error. Choose the function according to the rate’s meaning instead of treating every quoted percentage as interchangeable.
Advanced application: recover the implied discount
Using investment 980, received amount 1000, and year fraction 0.5, the independent inverse check is:
=(1-980/1000)/0.5
The result is 0.04, or 4%. Keep this check beside the forward calculation to expose mismatched amount scales or time conventions.
For the source’s 89-day example, substitute the actual/360 fraction 89/360 and retain the unrounded received amount. Rounding the maturity amount first may cause the reconstructed rate to differ slightly.
Denominator limits and troubleshooting
In the independent discount model, 1−Discount×year_fraction must remain positive for the ordinary positive-amount interpretation used here. As it approaches zero, the received amount grows rapidly; at zero, the division is undefined. This mathematical limitation does not assign a tested native error code to every invalid input.
Check positive investment, date order, percentage scale, and Basis. If the amount is unexpectedly huge, inspect the denominator before rounding or hiding the result with an error fallback.
The dedicated section does not enumerate all native error codes, coercion rules, or month-end basis adjustments. The examples use valid ordinary dates and do not model coupons, taxes, fees, or irregular cash flows. ROUND is suitable for a separately specified reporting precision, while the unrounded result should remain available for an audit.
Availability and verification
The exact function is documented in Collabora Office 26.04 desktop help, retrieved and reviewed on October 17, 2026. This establishes a documentation scope, not the first release that introduced the function or the last version in which it works; those versions and any retirement date remain unestablished. Collabora Online and mobile support are not inferred from desktop help, nor is behavior in another spreadsheet product.
The examples are documentation-based expectations with independent calculations. They have not been executed in Collabora Office. No application screenshot or native error/coercion certification is implied. Formulas use English function names and semicolon argument separators.
References
- Collabora Office 26.04: RECEIVED (checked October 17, 2026).
- Editorial testing standards.