ACCRINT

Accrued interest of a security

Description

Returns the accrued interest of a security with periodic payments.

Function signature

ACCRINT(datestart: String, datefirstpayment: String, dateend: String, rate: Number, redemption: Number, frequency: Number, basis: String = us_nasd) => Number

Parameter

Description

Date start

The date the security was initially issued.

Date first payment

The first date interest will be paid.

Date end

The security's settlement date.

Rate

The annualized rate of interest.

Redemption

The redemption amount per 100 face value, or par.

Frequency

Yearly interest/coupon payments count (1, 2, or 4).

basis

Method to use for counting days per month/year:

  • `us_nasd` (default): 30-day month, 360-day year, i.e. US (NASD).

  • `actual`: Actual number of days per month/year.

  • `actual_360`: 360 day year, actual number of days per month.

  • `actual_365`: 365 day year, actual number of days per month. This means leap years are not taken into account.

  • `european`: Like `us_nasd`, but for months that are not 30 days long, European standards are used.

Examples

startDate = "2000-01-01T13:06:15+03:00"
firstDate = "2009-01-22T13:06:15+03:00"
endDate = "2010-01-22T13:06:15+03:00"

Formula

Return value

ACCRINT(startDate, firstDate, endDate, 0.8, 200, 2)

1609.33333333

ACCRINT(startDate, firstDate, endDate, 0.8, 200, 2, "us_nasd")

1609.33333333

ACCRINT(startDate, firstDate, endDate, 0.8, 200, 2, "actual_365")

1610.52054795