ACCRINTM in WPS Spreadsheet: Interest Accrued to a Single Maturity Payment

=ACCRINTM(issue,maturity,rate,par,basis)

issue is the issue date; maturity is the final payment date; rate is the annual rate; par is the face value; and basis selects the day-count convention. The source describes an omitted par default, but this guide supplies all five arguments, eliminating dependence on omission behavior. There is no coupon frequency or separate settlement argument in this signature.

In B2 enter =ACCRINTM(A2,A3,A4,A5,A6). There are 181 elapsed calendar days, calculated independently by date subtraction. The lesson gives par*rate*A/D, where A is accrued days and D the annual denominator. Thus 10000*0.06*181/365 gives 297.534246575343. Displaying two decimals gives 297.53, without changing the stored calculation.

For a separate total-payment cell, =A5+B2 gives 10297.5342465753 if B2 contains the interest formula. Adding principal is a separate operation, not part of ACCRINTM’s return value.

Change only A6 to 2, actual/360. The day count remains 181 but the expected interest becomes 10000*0.06*181/360, or 301.666666666667. The difference is about 4.132420091324. This comparison shows why an explicit basis matters even with identical dates and rates.

The examples use a single positive face amount and rate, with maturity after issue. There is no negative-payment sign convention here: the output is a positive interest amount. The calculation is simple accrual under the selected basis, not compounding across periodic coupons.

The WPS lesson explicitly documents #NUM! for zero rate or face value and basis outside 0–4. Its other error notes refer to settlement and first-interest, names absent from its own signature. This guide does not silently translate those statements into a complete native error contract. Supply valid DATE-generated issue/maturity values, positive rate and par, and maturity after issue; verify exact error behavior in the intended client for invalid cases.

The lesson’s date-origin prose is inconsistent, so use DATE rather than constructing serial numbers from that prose. This guide does not establish negative-rate support, all argument-coercion rules, or multi-year actual/actual calculations. For periodic coupon interest, use the separately documented ACCRINT function rather than inventing a frequency argument here.

Enter dates with DATE(year,month,day) or references to genuine date cells, rather than locale-dependent text. Rates are annual decimals: enter 6% or 0.06, not 6. Use the same currency throughout; these functions do not convert currencies.

The official basis table lists 0 (or omitted) as US NASD 30/360, 1 as actual/actual, 2 as actual/360, 3 as actual/365, and 4 as European 30/360. The examples specify basis explicitly. The names alone do not define every February, month-end or multi-year adjustment; this guide does not generalize its controls to those edge cases.

The official WPS Academy ACCRINTM lesson labels its applicable edition WPS Office For Windows Personal (个人版). The lesson and relevant formula/table illustrations were reviewed on October 19, 2026. This establishes a Chinese first-party documented scope, not English-global, Linux, macOS, mobile or all-edition availability. The numeric build, introduction release and last supported version are not established. The lesson does not identify the function as deprecated.

Examples above are independent mathematical expectations under the stated assumptions. They were not executed in WPS, and no current application screenshot or runtime precision guarantee is supplied. Documentation images establish the written contract, not a new native test. English function tokens and comma separators follow the source; verify localized entry and workbook interchange in the intended client.

• DATE: Construct unambiguous date inputs.
• DAYS: Count elapsed calendar days.