Syntax :

=INTRATE( settlement, maturity, investment, redemption, [basis] )

Parameters :

The following parameters are :

• Settlement – The settlement date of the security (i.e. the date that the coupon is purchased).

• Maturity – The maturity date of the security (i.e. the date that the coupon expires).

• Investment – The amount initially invested in the security.

• Redemption – The amount that will be received at maturity.

• Basis – An optional input indicating the day count basis to be utilised in the computation.

• Possible values of [basis] and their meanings are: