Syntax :

=YIELDMAT( settlement, maturity, issue, rate, pr, [basis] )

Parameters :

• settlement – The day on which the security is supposed to be settled (i.e. the date that the coupon is buy).
• maturity – The date on which the security will reach maturity (i.e. the date that the coupon expires).
  The date on which the securities was issued is referred to as its issuance date.
• rate – The interest rate on the security on the day it was issued.
• pr – The price of the bond per $100 of face value.
• [basis] – An optional integer input specifying the security’s financial day count base. Values that might be used include:

• Basis	Day Count Basis
  0 (or omitted)	US (NASD) 30/360
  1	actual/actual
  2	actual/360
  3	actual/365
  4	European 30/360