Accrint

Syntax

Accrint(Issue, FirstInterest, Settlement, Rate[, NominalCost[, Frequency[, Basis])

Parameters

Issue. The security's issue date.

FirstInterest. The first payment date on securities.

Settlement. The security's maturity date.

Rate. Annual interest rate for coupons on securities. Parameter value must be greater than zero.

NominalCost. Face value of securities. Parameter value must be greater than zero.

Frequency. The number of coupon payments per year. The parameter may take the following values:

Basis. The day calculation method used. It is set in the range from 0 to 4:

Optional parameter.

NOTE. To determine the parameter, it is available to specify either the parameter value or the cell address where it is located.

Description

It returns an accrued interest for securities with periodic interest payments.

Comments

The Issue parameter value must be less than the Settlement parameter value.

Example

Formula Result Description
=Accrint("11.01.2008", "11.02.2008", "11.03.2008", 0.1, 1000, 2, 0) 16,6667 Accumulated percentage derived from securities based on the following terms:
  • The security's issue date is 15.10.2008.

  • The first payment date on securities is 11.02.2008.

  • The security's maturity date is 11.03.2008.

  • The annual interest rate is 0.1%.

  • The face value is 1000.

  • The number of payments for coupons in a year is 2 (semi-annual payments).

  • The day calculation method - American.

=Accrint(A1, A2, A3, 0,124, 100, 4, 3) 9,2656 Accumulated percentage derived from securities based on the following terms:
  • Securities issue date is specified in the cell A1, value is 01.01.2007.

  • The first payment date on securities is specified in the cell A2, value is 01.03.2007.

  • The security's maturity date is specified in the cell A3, value is 01.10.2007.

  • The annual interest rate is 12.4%.

  • The face value is 100.

  • The number of payments for coupons in a year is 4, quarterly payments.

  • The day calculation method is actual/365 days.

See also:

Function WizardFinancial Functions