RECEIVED Function

Returns the amount received at maturity for a discount security.

Category

Financial

Available in

All versions, Microsoft 365

Returns

An amount at maturity

Want to practice RECEIVED in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

Overview

RECEIVED answers: if I invest this much at this discount rate, what do I get back at maturity?

It's investment ÷ (1 − discount × days ÷ year length).

Syntax

=RECEIVED(settlement, maturity, investment, discount, [basis])

Arguments

ArgumentRequired?What it does
settlementYesThe date the buyer takes ownership (after the issue date).
maturityYesThe date the security is repaid.
investmentYesThe amount invested.
discountYesThe security's discount rate.
basisNoDay count: 0 or omitted = US 30/360, 1 = actual/actual, 2 = actual/360, 3 = actual/365, 4 = European 30/360.

Examples

Example 1 — Maturity value of a note

Northstar invests $250,000 in a note discounted at 4.75%, 3/15/2026 to 9/15/2026 (actual/360).

B6fx=RECEIVED(B1,B2,B3,B4,B5)
AB
1Settlement3/15/2026
2Maturity9/15/2026
3Investment$250,000
4Discount rate4.75%
5Basis2
6Received$256,220.46

Common mistakes

  • #VALUE! or #NUM!. A date isn't a real date, settlement is on or after maturity, or frequency isn't 1, 2 or 4.

Notes

  • Enter dates with DATE or as cells holding real dates. Text dates like "3/15/2026" typed straight into the formula can be misread on computers with other regional settings.
  • Related functions: INTRATE, PRICEDISC, DISC.
Kyle Stott

Author

Kyle Stott

Certified Microsoft Excel Expert

Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.