ACCRINTM in Zoho Sheet: Syntax and Worked Examples

ACCRINTM calculates accrued interest for a security that pays its interest at maturity. With principal 10,000, annual rate 6%, issue January 15, 2026 and endpoint April 15, 2026, basis 0 gives independent expected accrued interest 150.

The result is an interest amount in the principal’s currency. It does not include return of the principal and is not a price quoted per 100. The complete examples here have not been executed in an authored Zoho workbook.

=ACCRINTM(issue; settlement; rate; par; [basis])

Issue is the start date, rate is annual nominal interest and par is principal. The argument named settlement is described as the maturity date by the official ACCRINTM reference. The examples in this guide use it explicitly as the ending/maturity date of the accrual interval, avoiding a claim about a separate unprovided maturity date.

Basis defaults to 0: US/NASD 30/360. Zoho also lists 1 actual/actual, 2 actual/360, 3 actual/365 and 4 European 30/360. Rate 6% is entered as 0.06 or 6%, not 6.

The article’s static example table mistakenly prints seven-argument ACCRINT formulas. That is a different function. The existing public financial demonstration contains correctly labeled five-argument ACCRINTM formulas, consistent with the signature above. Do not add first-interest-date or frequency arguments from the copied table.

Enter =ACCRINTM(A2;B2;C2;D2;E2). The equivalent self-contained formula is:

=ACCRINTM(DATE(2026;1;15);DATE(2026;4;15);0.06;10000;0)

The independent 30/360 day count is 90, so accrued interest is 10000×0.06×90/360 = 150. If principal is returned at that endpoint, the mathematical principal-plus-interest amount is 10,150. ACCRINTM itself calculates only the interest in this example.

Changing the endpoint to July 15, 2026 gives 10000×0.06×180/360 = 300. Changing it to January 15, 2027 gives 600. These are simple proportional accrual calculations, not repeated compounding of interim interest payments.

Keep issue January 15, 2026, endpoint April 15, 2026, rate 6% and principal 10,000, but change the final argument to 3:

=ACCRINTM(DATE(2026;1;15);DATE(2026;4;15);0.06;10000;3)

There are 90 actual days in that interval. The independent result becomes 600×90/365 = 147.9452054795. Although the numerator happens to be 90 under both chosen bases, the denominator changes from 360 to 365. A basis is part of the financial convention, not merely a display preference.

For principal 25,000 and rate 4%, using the same dates with basis 0 gives 25000×0.04×90/360 = 250. This illustrates scaling by the actual principal: there is no automatic per-100 normalization in the worked model.

The public financial workbook, on its ACCRINTM tab, shows issue February 1, 2018, endpoint December 13, 2018, rate 7.8, principal 1,000 and basis 0. Its formula label is =ACCRINTM(A2;B2;C2;D2;E2), and its displayed result is 6,760.

Independently, the 30/360 interval is 312 days: 1000×7.8×312/360 = 6760. The unusually high rate is retained only to identify the vendor’s example, not as a suggested input. The complete demonstration resolves the static article’s copied function-name/signature error and corroborates proportional interest over the two dates. It does not certify all endpoints or every basis algorithm.

Zoho explicitly documents #NUM! for a negative par or rate, a basis outside 0–4, or issue after the ending date. These are documentation-based error expectations; this guide did not execute those failures. Equality of dates, zero principal/rate, fractional basis values and text coercion are not established by the negative/after rules.

The worked dates are mid-month and use basis 0 or 3. Month-end conventions, basis-1 periods spanning leap years and other unusual schedules need separate verification. An accrued-interest amount does not by itself identify a market price or an annual investment yield.

PRICEMAT uses a different contract to price an interest-at-maturity security. DATE constructs unambiguous dates, and YEARFRAC explains day-count fractions.

Official help and the existing public demonstration were checked on October 18, 2026. New examples are independent mathematical expectations; no authored Zoho application or engine test was run. The rolling pages do not establish the first release, mobile/import parity, retirement or deprecation history. This is function education rather than a recommendation for a security or transaction.