ACCRINT

Name

ACCRINT -- 

Synopsis

ACCRINT(issue,first_interest,settlement,rate,par,frequency[,basis])

Description

ACCRINT calculates the accrued interest for a security that pays periodic interest. The rate is the annual rate of the security and par is the par value of the security. basis is the type of day counting system you want to use:

0 US 30/360

1 actual days/actual days

2 actual days/360

3 actual days/365

4 European 30/360

If @basis is omitted, US 30/360 is applied. If issue date or settlement date is not valid, ACCRINT returns NUM! error. If @rate or @par is zero or negative, ACCRINT returns #NUM! error. If @basis < 0 or @basis > 4, ACCRINT returns #NUM! error. If issue date is after maturity date or they are the same, ACCRINT returns #NUM! error.

Examples

See also

ACCRINTM