I. Intro
The COUPNCD function calculates the next coupon or interest payment date after the settlement date.
II. About the function
- Formula: =COUPNCD(settlement,maturity,frequency,[basis])
- Parameters:
- settlement (required): The settlement date of the security (the date after the issue date when the buyer takes ownership of the security).
- maturity (required): The maturity date or end date of the security (the date when the security can be redeemed at face or par value).
- frequency (required): The number of interest or coupon payments per year (1, 2, or 4).
- basis (optional): The method used to calculate the number of days in a year. See COUPDAYSNC for more details.
- Example: =COUPNCD("2010-2-1","2019-12-31",4,0)
III. Steps
Use the COUPNCD function
- Select a cell and enter =COUPNCD.
- Enter the parameters in the cell. For example: =COUPNCD(B1,B2,B3,B4).
- Press Enter to display the result, which is 03/31/2010 in this example.
250px|700px|reset
Delete the COUPNCD function
Select the cell with the COUPNCD function, and press Delete.