Functions
RECEIVED
Amount received at maturity
Try it
When to use it
When should I use RECEIVED?
Use RECEIVED to calculate the amount received at maturity for a fully invested security — ideal for evaluating discount instruments like T-bills or certificates of deposit held to maturity.
Used in
Syntax
RECEIVED(settlement, maturity, investment, discount, [basis])Examples
=RECEIVED(DATE(2010,2,1),DATE(2019,12,31),1000,0.05) // => 1983.4710743801654
=RECEIVED(DATE(2010,2,1),DATE(2019,12,31),1000,0.05,4) // => 1982.9248141007986