SheetFX
≡
<< Go back to all functions

COUPDAYBS

The COUPDAYBS function in Google Sheets is used to calculate the number of days from the first coupon, or interest payment, until the settlement date.

Function Syntax and Parameters

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

Parameters:

  • settlement: The settlement date of the security.
  • maturity: The maturity date of the security.
  • frequency: The number of coupon payments per year.
  • day_count_convention: [Optional] The day count convention to use for calculating the number of days.

Use Cases and Scenarios

  1. Bond Valuation: Calculate the number of days between the purchase date and the maturity date of a bond.
  2. Interest Accrual: Determine the number of days for interest accrual between coupon payments.
  3. Amortization Schedule: Calculate the number of days for each coupon payment in an amortization schedule.

Related Functions

  • COUPDAYS: Calculates the number of days in the coupon period that contains 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.
  • COUPNUM: Calculates the number of coupons payable between the settlement date and maturity date.
  • COUPPCD: Calculates the previous coupon date before the settlement date.

Note: This function belongs to the Financial category.

Please note that video and related articles information was not available for the COUPDAYBS function.