Buzz
Both COUPDAYSNC and IPMT functions in Excel are numerical functions that support calculations in the financial field. While COUPDAYSNC function returns the number of days from the settlement date to the next coupon date, IPMT function helps you compute aspects related to investments, assets, and interest rates.
- See more: Financial Functions
COUPDAYSNC Function
Both functions are applicable across Office versions 2013, 2010, 2007, and 2003.
How to Use COUPDAYSNC Function in Excel
Download and install Excel 2013 version
Syntax: COUPDAYSNC(settlement, maturity, frequency, [basis])
Where:
- Settlement: Securities settlement date (The date securities are sold to the buyer after issuance)
- Maturity: Securities maturity date (The date securities expire)
- Frequency: Number of times interest is paid per year
+ Frequency = 1: Annual payment
+ Frequency = 2: Semi-annual payment
+ Frequency = 4: Quarterly payment
- Basis: Date Count Basis
+ Basis = 0 or omitted: US (NASD) 30/360
+ Basis = 1: Actual/actual
+ Basis = 2: Actual/360
+ Basis = 3: Actual/365
+ Basis = 4: European 30/360
Consider an Example:
Given the spreadsheet below, the values entered correspond to the parameters of the function in Excel
Calculate the number of days from the settlement date to the next coupon date. Enter the formula in cell C10=COUPDAYSNC(C6,C7,C8,C9). The result is as shown in the image below.
Now you know how to use the COUPDAYSNC function in Excel to calculate the number of days from the settlement date to the next coupon date. You can apply this to calculate on your real data. Additionally, you can explore how to use the IPMT function in Excel.
