ACCRINT

Summary

ACCRINT calculates interest from either issue or the previous coupon date up to settlement, depending on calc_method.

Date inputs are spreadsheet serial dates; settlement must be after issue.
rate is the annual coupon rate as a decimal (for example, 0.06 for 6%), and par is principal amount; both must be positive.
frequency must be 1 (annual), 2 (semiannual), or 4 (quarterly).
basis codes: 0=US(NASD)30/360, 1=Actual/Actual, 2=Actual/360, 3=Actual/365, 4=European30/360.
calc_method: non-zero accrues from issue; 0 accrues from the previous coupon date.
Return value is in the same currency units as par and is positive for valid positive inputs.

Accrue from issue date (default calc_method)

Grid

Cell	Value
No inputs on Sheet1.

Formula

Result

Not evaluated yet.

Expected

Accrue from previous coupon (calc_method = 0)

Grid

Cell	Value
No inputs on Sheet1.

Formula

Result

Not evaluated yet.

Expected

calc_method=0 accrues from the previous coupon date; any non-zero value accrues from issue.

Invalid basis, non-positive rate/par, unsupported frequency, or settlement <= issue return #NUM!.

Category

Financial

Signature

ACCRINT(arg1: Number, arg2: Number, arg3: Number, arg4: Number, arg5: Number, arg6: Number, arg7: Number, arg8…: Number)

Arity

min 6, max variadic

Arguments

arg1