Navigation:  Formula Reference > Spreadsheet Formula Functions >

ACCRINT

Previous pageReturn to chapter overviewNext page

 

This function calculates the accrued interest for a security that pays periodic interest.

Syntax

ACCRINT(issue,first,settle,rate,par,frequency,basis)

Arguments

This function has these arguments:

Argument

Description

issue

Date that the security is issued

first

First date for calculating the interest for the security

settle

Settlement date for the security

rate

Annual interest rate for the security

par

[Optional] Par value for the security; if omitted, the calculation uses a value of $1,000

frequency

Frequency of payment, number of payments per year

basis

[Optional] Integer representing the basis for day count (Refer to Day Count Basis.)

Remarks

This function requires that the issue is less than the settlement (otherwise a #NUM! error is returned). If the rate or par is less than or equal to 0, then a #NUM! error is returned. If the frequency is a number other than 1, 2, or 4, then a #NUM! error is returned. If the basis is less than 0 or greater than 4, a #NUM! error is returned.

Data Types

Accepts numeric and DateTime object data. Returns numeric data.

Examples

ACCRINT(A1,A2,A3,B4,D9,E9,0)

ACCRINT(DATE(2003,1,1),DATE(2003,1,7),DATE(2005,1,7),0.5,1000,2) gives the result 1008.33333

 

See Also

ACCRINTM

INTRATE