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
| Row | A | B | C |
|---|---|---|---|
| 6 | Input | Second input | Third input |
| 7 | 46023 | 46204 | 46053 |
| 8 | 46023 | 46204 | 46083 |
| 9 | 46023 | 46204 | 46113 |
Record 1
=ACCRINT(A7,B7,C7,0.06,1000,2,0)Illustrative output5
See the inputs and instructions for all 3 examplesSyntax
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 |