RECEIVED function
RECEIVED returns how much you collect at maturity on a short-term security that was fully invested and bought at a given discount rate. Dates are best passed with DATE or cell references.
Example
Read it as a sentence: find the amount received at maturity for a 1000 security bought January 1, 2024 and maturing July 1, 2024 at a 5% discount rate, using basis 0, which gives 1025.64102564103.
Syntax
RECEIVED(settlement, maturity, investment, discount, [basis])
Arguments in [square brackets] are optional.
-
settlement(required) - Date the security is bought (after issue, before maturity).
-
maturity(required) - Date the security expires and is repaid.
-
investment(required) - Amount paid.
-
discount(required) - Annual discount rate.
-
basis(optional) - Day-count convention: 0 or omitted = US 30/360, 1 = actual/actual, 2 = actual/360, 3 = actual/365, 4 = European 30/360.
Returns: Amount received at maturity of a fully invested security.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=RECEIVED(DATE(2024,2,15),DATE(2024,8,15),1000000,0.0575,0) | 1029601.03 | Typical |
=RECEIVED(DATE(2024,2,15),DATE(2024,8,15),1000000,0.0575) | 1029601.03 | Basis omitted |
=RECEIVED(DATE(2024,2,15),DATE(2024,8,15),1000000,0.0575,0) | 1029601.03 | Basis 0 |
=RECEIVED(DATE(2024,2,15),DATE(2024,8,15),1000000,0.0575,1) | 1029434.514 | Basis 1 |
=RECEIVED(DATE(2024,2,15),DATE(2024,8,15),1000000,0.0575,2) | 1029939.777 | Basis 2 |
=RECEIVED(DATE(2024,2,15),DATE(2024,8,15),1000000,0.0575,3) | 1029517.537 | Basis 3 |
=RECEIVED(DATE(2024,2,15),DATE(2024,2,15),1000000,0.0575,0) | #NUM! | Settlement = maturity |
=RECEIVED(DATE(2024,8,15),DATE(2024,2,15),1000000,0.0575,0) | #NUM! | Settlement after maturity |
Watch out for
- Pass dates with DATE() or cell references; text dates can misbehave and invalid dates return #VALUE!.
Where it works
- Excel
- RECEIVED is in every version of Excel from 2007 on.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Financial functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .