Syntax :

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

Parameters : 

• The following parameter are:

settlement –

• The ministry’s settling date (i.e. the date that the coupon is purchased).

maturity –

• The ministry’s maturation date (i.e. the date that the coupon expires).

investment –

• The initial sum invested in a security.

discount –

• The security’s discount rate.

[basis] –

• An optional input that specifies the day count basis for the computation.