The COUPNUM function in Google Sheets calculates the number of coupons, or interest payments, between the settlement date and the maturity date of the investment.
Parameters
settlement: The date on which the security was purchased.maturity: The date on which the security will mature.frequency: The number of coupon payments per year.[day_count_convention]: [Optional] The day count convention to use for calculating coupon payments. The default value is0(actual/actual).
Step-by-Step Tutorial
- Using
COUPNUMto calculate the number of coupons:- Example:
=COUPNUM(DATE(2022, 1, 1), DATE(2025, 1, 1), 2) - Result: The number of coupons between the settlement date of January 1, 2022, and the maturity date of January 1, 2025, with a frequency of 2 coupon payments per year.
- Example:
Use Cases and Scenarios
- Bond Investment: Determine the total number of interest payments for a bond.
- Fixed Income Analysis: Calculate the number of coupon payments for a fixed income security.
- Financial Planning: Estimate the number of coupon payments for a projected investment.
Related Functions
COUPDAYS: Calculates the number of days in the coupon period that contains the settlement date.COUPDAYSBS: Calculates the number of days from the beginning of the coupon period to the settlement date.COUPDAYSNC: Calculates the number of days from the settlement date to the next coupon date.COUPNCD: Calculates the next coupon date after the settlement date.COUPPCD: Calculates the previous coupon date before the settlement date.