ExcelFlux

ACCRINT function

the accrued interest for a security that pays periodic interest.

Financial · Guided Excel example

Where can you use it?

Budgeting, treasury and finance teams. When reviewing a scenario with cash flows, payment periods and rate assumptions, compare the input and output units in the example.

Scenario in the workbook

Accrue interest at a 6% coupon on 1,000 face value using the 30/360 basis.

A worked example from the workbook

RowABC
6InputSecond inputThird input
7460234620446053
8460234620446083
9460234620446113
Record 1
=ACCRINT(A7,B7,C7,0.06,1000,2,0)

Illustrative output5

See the inputs and instructions for all 3 examples

Syntax

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

Worked examples

Accrue interest at a 6% coupon on 1,000 face value using the 30/360 basis.

Column F provides expressions as text. Satisfy the stated requirements, then paste into an empty Excel cell and compare with column G. The result was not verified in desktop Excel here.

Row A B C
6 Input Second input Third input
7 46023 46204 46053
8 46023 46204 46083
9 46023 46204 46113
Trial Expression Sample output
Record 1 =ACCRINT(A7,B7,C7,0.06,1000,2,0) 5
Record 2 =ACCRINT(A8,B8,C8,0.06,1000,2,0) 10
Record 3 =ACCRINT(A9,B9,C9,0.06,1000,2,0) 15
Microsoft Excel reference