SheetFX
≡
<< Go back to all functions

COUPNUM

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.

Function Syntax and Parameters

Syntax: COUPNUM(settlement, maturity, frequency, [day_count_convention])

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 is 0 (actual/actual).

Step-by-Step Tutorial

  1. Using COUPNUM to 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.

Use Cases and Scenarios

  1. Bond Investment: Determine the total number of interest payments for a bond.
  2. Fixed Income Analysis: Calculate the number of coupon payments for a fixed income security.
  3. 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.

Related Articles