COUPNUM()

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

Definition. This function determines the number of interest payments (coupon dates) the new owner is facing after buying a fixed-interest security with regular coupon dates.

Arguments

  • 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 ...

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.