{"id":1821,"date":"2018-07-04T17:51:58","date_gmt":"2018-07-04T17:51:58","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=1821"},"modified":"2023-11-02T20:06:19","modified_gmt":"2023-11-02T20:06:19","slug":"coupncd","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/functions\/coupncd\/","title":{"rendered":"COUPNCD function"},"content":{"rendered":"\n
COUPNCD function returns the next interest payment date after the specified settlement date for a security that pays periodic interest. It’s a useful tool for financial analysis, especially in bond and fixed-income investments.<\/p>\n\n\n\n
COUPNCD(settlement, maturity, frequency, [basis])<\/strong><\/p>\n\n\n\n The COUPNCD function helps you find the next interest payment date for a security. Here’s how to use it:<\/p>\n\n\n\n Suppose you have the following data:<\/p>\n\n\n\n settlement date:<\/strong> 2023-04-15 You can use the COUPNCD function as follows:<\/p>\n\n\n\n This will return the next interest payment date, which is “2023-10-31” in this case.<\/p>\n\n\n\n Remember that you can also use the optional Let’s look at a few more examples:<\/p>\n\n\n\n This example calculates the next interest payment date with quarterly payments and the “Actual\/Actual” day-count basis. The result is “2023-10-31.”<\/p>\n\n\n\n Here, we find the next interest payment date for an annual payment schedule with the “European 30\/360” day-count basis. The result is “2024-06-30.”<\/p>\n\n\n\n The COUPNCD function is a valuable tool for investors, financial analysts, and anyone working with fixed-income securities. It helps you determine the next interest payment date, which is crucial for assessing the cash flows and making investment decisions.<\/p>\n\n\n\n If you encounter unfamiliar terms or need more details on specific arguments, you can refer to financial resources or websites that provide in-depth explanations of bond calculations and financial terminology.<\/p>\n","protected":false},"excerpt":{"rendered":" COUPNCD function returns the next interest payment date after the specified settlement date for a security that pays periodic interest. It’s a useful…<\/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 date when the security was purchased.<\/td><\/tr> maturity<\/strong><\/td> The date when the security matures.<\/td><\/tr> frequency<\/strong><\/td> The number of times interest is paid per year.<\/td><\/tr> [basis]<\/strong><\/td> (Optional) An optional argument specifying the day-count basis to use. If omitted, it defaults to 0 (or “US (NASD) 30\/360”).<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n How to Use<\/h2>\n\n\n\n
maturity date:<\/strong> 2025-12-31
interest frequency:<\/strong> 2 (semi-annual payments)<\/p>\n\n\n\n=COUPNCD(\"2023-04-15\", \"2025-12-31\", 2)<\/code><\/pre>\n\n\n\n
[basis]<\/code> argument if you need to specify a different day-count basis.<\/p>\n\n\n\n
Examples<\/h2>\n\n\n\n
=COUPNCD(\"2023-07-15\", \"2024-12-31\", 4, 1)<\/code><\/pre>\n\n\n\n
=COUPNCD(\"2023-09-30\", \"2025-06-30\", 1, 3)<\/code><\/pre>\n\n\n\n
Additional Information<\/h2>\n\n\n\n