Excel Function : COUPNUM
Category
Financial
Description
Returns the number of coupons payable between the settlement date and maturity date
Microsoft Excel Reference Page
https://support.office.com/en-us/article/COUPNUM-function-a90af57b-de53-4969-9c99-dd6139db2522
Syntax and Description of the COUPNUM Excel Function
The syntax for the COUPNUM function in Microsoft Excel is: COUPNUM(settlement, maturity, rate, pr, [basis]) Parameters or Arguments settlement The settlement date of the security. maturity The maturity date of the security. rate The coupon rate. pr The price per $100 face value. basis Optional. The type of day counting method to use. Basis Day-counting method 0 or omitted US (NASD) 30/360 1 Actual/actual 2 Actual/360 3 Actual/365 4 European 30/360 Notes:
About COUPNUM Excel Function
COUPNUM(settlement, maturity, frequency, [basis]) The COUPNUM function returns the number of coupons to be paid between the settlement and maturity dates.
