ACCRINT

  • Updated

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.