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.
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
- Bond Valuation: Calculate the number of days between the purchase date and the maturity date of a bond.
- Interest Accrual: Determine the number of days for interest accrual between coupon payments.
- 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.