ExcelFlux

ACCRINTM function

the accrued interest for a security that pays interest at maturity.

Financial

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

Find accrued interest on a security that pays at maturity using Actual/365.

A worked example from the workbook

RowAB
6InputCash flow
74602346388
84602346205
94602346113
Record 1
=ACCRINTM(A7,B7,0.05,1000,3)

Expected result50

See the inputs and instructions for all 3 examples

Syntax

ACCRINTM(issue, settlement, rate, par, [basis])

Copyable formulas

English Excel · en-US
=ACCRINTM(A7,B7,0.05,1000,3)
Turkish Excel · tr-TR
=GERÇEKFAİZV(A7;B7;0,05;1000;3)

Worked examples

Find accrued interest on a security that pays at maturity using Actual/365.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A B
6 Input Cash flow
7 46023 46388
8 46023 46205
9 46023 46113
Case Formula Expected result
Record 1 =ACCRINTM(A7,B7,0.05,1000,3) 50
Record 2 =ACCRINTM(A8,B8,0.05,1000,3) 24.93150685
Record 3 =ACCRINTM(A9,B9,0.05,1000,3) 12.32876712
Microsoft Excel reference