The Excel RECEIVED function calculates the amount received at maturity for a fully invested security. The security's settlement date (i.e. the date that the coupon is purchased). The security's maturity date (i.e. the date that the coupon expires). The initial amount invested into the security.