Apple Numbers ACCRINT: Accrued interest from the issue date

=ACCRINT(issue, first, settle, annual-rate, par, frequency, days-basis)

Apple specifies first and settle after issue and a strictly positive annual-rate. Frequency is 1, 2 or 4 payments per year. The optional final days-basis defaults to 0. Omitting par means leaving its position empty, with its comma preserved; Apple then assumes 1000. There is no eighth calc_method argument in this documented signature. Apple ACCRINT help, version 15.4.

Basis choices are 0 NASD 30/360, 1 actual/actual, 2 actual/360, 3 actual/365 and 4 European 30/360. Use explicit basis and par when first checking a formula. A coupon rate of 10% is 0.10, not 10.

In a fresh table enter:

Enter =ACCRINT(B2,B3,B4,B5,B6,B7,B8) in B10. The documented and independently reproduced reference is 38.0555555555556. The complete equivalent is:

=ACCRINT(DATE(2008,12,14),DATE(2009,7,1),DATE(2009,5,1),0.10,1000,2,0)

Using DATE removes the ambiguity of the date strings in the printed example. Under the stated 30/360 convention, these ordinary dates span 360 + (5-12)*30 + (1-14) = 137 days. Independent arithmetic gives 1000*0.10*137/360 = 38.0555555555556. This reproduces Apple’s documented result without executing Numbers.

Change only B4 to =DATE(2009,9,15). Apple’s second example returns approximately 75.2777777777778, matching 1000*0.10*271/360 with a 271-day issue-to-settlement count.

The July 1 first coupon lies between issue and this new settlement. Nevertheless, Apple’s stated purpose remains total accrued interest since issue. This amount should not be assumed to equal an accrued-interest adjustment on a real trade, which may concern only the current coupon period and contractual settlement rules.

If you need elapsed days in the current coupon period, COUPDAYBS asks a different question. Do not try to change ACCRINT’s scope by appending an undocumented argument copied from another application.

The documented empty-position form for the first example is:

=ACCRINT(DATE(2008,12,14),DATE(2009,7,1),DATE(2009,5,1),0.10,,2,0)

It retains the par slot and has the same reference amount because the default is 1000. Deleting the slot as well as its value would shift later arguments into the wrong positions. Explicit 1000 is clearer when sharing a formula with someone unfamiliar with optional placeholders.

For a simpler independent case, issue January 1, 2025, first coupon July 1, settlement April 1, annual rate 0.06, par 1000, frequency 2 and basis 0 give 15: 1000*0.06*90/360. Doubling par to 2000 gives 30. Frequency does not mean that a 6% annual coupon should be entered as 3%; keep the documented annual rate in that argument.

For the same January-to-April 2025 example, basis 3 uses the 90 actual days and a 365-day year. The independent amount is 60*90/365, approximately 14.7945205479452. That differs from the 30/360 amount even though both day counts happen to be 90 here.

These calculations establish the specified cases. They do not establish every month-end, February, leap-year or irregular-coupon boundary. A basis label alone is not a substitute for checking those rules when they materially affect a real security.

Check chronological order, positive annual-rate, supported frequency and the intended basis. The cited Apple page gives constraints but does not provide an exact spreadsheet error-code table, so this guide does not promise a particular error label for every invalid input. Zero-rate behavior is not inferred from a requirement that rate be greater than zero.

Currency display depends on Language & Region settings; a currency symbol is formatting rather than a separate conversion. ACCRINTM is for interest paid at maturity and is not an alias for this periodic-interest function.

Checked October 18, 2026 against Apple Formulas and Functions Help 15.4. The published examples and independent arithmetic are separate from native execution: no Numbers workbook or screenshot was produced. The reference is shared iWork help; first introduction, older-version coverage and parity across individual clients are not established. These are calculation examples, not investment advice.