ACCRINT
Returns the accrued interest for a security that pays periodic interest
Syntax
ACCRINT(issue, first_interest, settlement, rate, par, frequency, [basis], [calc_method])
Parameters
- issue: Required. The security's issue date
- first_interest: Required. The security's first interest date
- settlement: Required. The security's settlement date
- rate: Required. The security's annual coupon rate
- par: Required. The security's par value
- frequency: Required. The number of coupon payments per year (1=annual, 2=semi-annual, 4=quarterly)
- basis: Optional. The type of day count basis to use (0=US 30/360, 1=Actual/actual, 2=Actual/360, 3=Actual/365, 4=European 30/360)
- calc_method: Optional. 0=from issue date, 1=from first interest date (default)
Example
=ACCRINT("01/01/2024", "07/01/2024", "04/01/2024", 0.10, 1000, 2, 0)