Syntax. COUPNCD(Settlement,Maturity,Frequency,Basis)

Definition. This function determines the date of the first coupon interest payment after a fixed-interest security with regular coupon dates has changed ownership.


  • Settlement (required) The date when the ownership of the security changes.

  • Maturity (required) The date when the repayment of the loan certified by the security takes place.

  • Frequency (required) Because it is quite common to have fixed-interest securities with several interest dates per year, the required argument Frequency supplies the dates-per-year number. Allowed values are: 1 = annual; 2 = biannual; 4 = quarterly.

  • Basis (optional) The method you want to use for determining the days in the year according to Table 15-2 ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.