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

Financial

AMORLINC

Last updated 9 months ago

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`

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.