The Excel COUPDAYBS function is a function that returns the number of days from the start of a coupon period to its settlement date. You can use the COUPDAYBS function on versions of Office 2013, Office
How to use the COUPDAYBS function in Excel, example
Instructions on how to use the COUPDAYBS function in Excel – Illustrative example
Syntax: COUPDAYBS(settlement, maturity, frequency, [basis])
Where:
– Settlement: Securities settlement date (Is the date the securities are sold to buyers after issuance)
– Maturity: The expiration date of the security (Is the date the security expires)
– Frequency: Number of annual interest payments
+ Frequency = 1: Pay one year at a time
+ Frequency = 2: Semi-annual payment
+ Frequency = 4: Quarterly billing
– Basis: Day counting facility
+ Basis = 0 or omitt: US (NASD) 30/360
+ Basis = 1: Fact/fact
+ Basis = 2: Actual/360
+ Basis = 3: Actual/365
+ Basis = 4: Europe 30/360
Consider Example:
For the lower worksheet, the values entered correspond to the parameters of the function in Excel
Calculate the number of days from the beginning of the coupon period to the settlement date. Enter the formula in cell C10=COUPDAYBS(C6,C7,C8,C9). We get the result as shown below.
Above, I have shown you how to use the COUPDAYBS function in Excel to calculate the number of days from the start of the coupon period to its settlement date. This allows you to apply calculations to your actual figures on a spreadsheet.
https://thuthuat.taimienphi.vn/ham-coupdaybs-trong-excel-2742n.aspx
You want to learn the EFFECT function to use in work, so please refer to the previous article of Software to learn about