{"id":1811,"date":"2018-07-04T17:46:41","date_gmt":"2018-07-04T17:46:41","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=1811"},"modified":"2023-11-02T20:03:30","modified_gmt":"2023-11-02T20:03:30","slug":"coupnum","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/functions\/coupnum\/","title":{"rendered":"COUPNUM function"},"content":{"rendered":"\n
COUPNUM is an Excel function that calculates the number of coupon payments between the settlement date and the maturity date of a security.<\/p>\n\n\n\n
COUPNUM(settlement, maturity, frequency, [basis])<\/strong><\/p>\n\n\n\n You can use the COUPNUM function to determine the number of coupon payments for a bond or other fixed-income security. Here’s how to use it with some examples.<\/p>\n\n\n\n Example 1:<\/strong> Calculate the number of coupon payments for a semi-annual bond.<\/p>\n\n\n\n In this case, the function will return 2, as there are two semi-annual coupon payments between January 1, 2023, and December 31, 2023.<\/p>\n\n\n\n Example 2:<\/strong> Calculate the number of quarterly coupon payments for a bond with a custom day count basis.<\/p>\n\n\n\n Here, the function returns 2.25 because there are 2 full coupon payments plus a partial coupon payment (0.25) between March 1, 2023, and September 30, 2023, using the 30\/360 day count basis.<\/p>\n\n\n\n Example 3:<\/strong> Determine the number of annual coupon payments for a bond without specifying the day count basis.<\/p>\n\n\n\n The function will return 5 because there are five annual coupon payments between June 15, 2023, and June 15, 2028.<\/p>\n","protected":false},"excerpt":{"rendered":" COUPNUM is an Excel function that calculates the number of coupon payments between the settlement date and the maturity date of a security….<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[180],"yoast_head":"\nArguments<\/h2>\n\n\n\n
settlement:<\/strong><\/td> The settlement date of the security.<\/td><\/tr> maturity:<\/strong><\/td> The maturity date of the security.<\/td><\/tr> frequency:<\/strong><\/td> The number of coupon payments per year. For example, for semi-annual payments, use 2.<\/td><\/tr> [basis]:<\/strong><\/td> (Optional) An optional argument that specifies the day count basis to be used for calculating the number of days between dates. If omitted, Excel uses the default method.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n How to use<\/h2>\n\n\n\n
=COUPNUM(\"1\/1\/2023\", \"12\/31\/2023\", 2)<\/code><\/pre>\n\n\n\n
=COUPNUM(\"3\/1\/2023\", \"9\/30\/2023\", 4, 1)<\/code><\/pre>\n\n\n\n
=COUPNUM(\"6\/15\/2023\", \"6\/15\/2028\", 1)<\/code><\/pre>\n\n\n\n