Calculates the accrued interest of a security that pays periodic interest.
Sample Usage
ACCRINT(C2,C3,C4,C5,C6,C7)
Syntax
ACCRINT(issue, first_interest, settlement, rate, par, frequency, [basis])
- issue - The date the security was initially issued.
- first_interest - The first interest date of the security.
- settlement - The date of maturity.
- rate - The annualized rate of interest.
- par - The par value of the security.
- frequency - The number of interest payments per year.
- basis - [OPTIONAL] The method of calculating years.
- 0 or omitted: US 30/360 day count. This mode calculates based on 30 day months and 360 day years with end-of-month date adjustment according to US NASD standards.
- 1: Actual/actual. This mode calculates based on the actual number of days between the specified dates, and the actual number of days in the intervening years.
- 2: Actual/360. This mode calculates based on the actual number of days between the specified dates, and 360 day years.
- 3: Actual/365. This mode calculates based on the actual number of days between the specified dates, and 365 day years.
- 4: European 30/360. This mode calculates based on 30 day months and 360 day years with end-of-month date adjustment according to European standards.
Examples
ACCRINT(C2,C3,C4,C5,C6,C7) returns the accrued interest for a treasury bond.
Notes
- To specify the issue and first_interest, you can use the DATE function. For example, use DATE(2020,2,3) for the 3rd day of January, 2020.