WPS ACCRINTM is a financial function in WPS Spreadsheet for calculating accrued interest for a security that pays interest at maturity; this guide covers 3 core tasks, with 3 available without membership and 0 membership-related items.
At a Glance
| Metric | Value | Notes |
|---|---|---|
| Core tasks | 3 | Matches the number of rows in the How-to Index |
| Available without membership | 3 | Matches the number of Free rows in the How-to Index |
| Membership-related items | 0 | Matches the number of membership-related rows in the How-to Index |
| Membership limit | None for this function | You can use ACCRINTM directly in WPS Spreadsheet |
| Version limit | None listed | No extra version gate is listed in the current feature information |
About This Feature
Overview
ACCRINTM is a financial function in WPS Spreadsheet that calculates the accrued interest for a security that pays interest at maturity.
Core tasks include:
- Insert ACCRINTM from the Insert Function dialog.
- Type
=ACCRINTM(...)directly in a cell or in the formula bar. - Review the syntax and parameter details before confirming the formula.
The syntax shown for this function is ACCRINTM(issue, settlement, rate, par, [basis]).
Common use cases include bond interest estimation, financial modeling, and spreadsheet training. It helps users enter the function faster, verify parameter order, and check the formula structure before calculation.
System Requirements
| Item | Requirement |
|---|---|
| Operating system | A desktop Windows environment that can run WPS Office |
| App version | The latest version of WPS Office is recommended; no extra ACCRINTM version gate is listed here |
| Network | No mandatory network connection is required for local formula entry and calculation; internet access is needed for online help or software download |
| Other | WPS Office should already be installed, and you should be able to open a spreadsheet file for formula editing |
Download & Installation
Before using ACCRINTM, install WPS Office for Windows and open WPS Spreadsheet.
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Post-install check | Open WPS Office → open a spreadsheet file → go to the Formulas tab and confirm that you can use Insert Function or type formulas directly |
Source: WPS download page
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | WPS provides the ACCRINTM function for calculating accrued interest for a security that pays interest at maturity, with common entry paths including Insert Function, direct formula entry, and syntax review. | Excel provides the ACCRINTM function with the syntax ACCRINTM(issue, settlement, rate, par, [basis]) and documents date handling, basis values, and error conditions. | Google Sheets lists ACCRINTM as a financial function with the syntax ACCRINTM(issue, maturity, rate, [redemption], [day_count_convention]) for accrued-interest calculations. | Notion formulas support calculations inside database properties and formula expressions, but they are not spreadsheet-specific financial functions like ACCRINTM. | Adobe Acrobat supports calculated PDF form fields through predefined calculations, simplified field notation, and custom JavaScript, rather than spreadsheet financial functions. |
| Official Source | — | ACCRINTM function | Google Sheets function list | Intro to formulas; Formula syntax & functions | Manage form field properties |
Advantage: It supports both dialog-based insertion and direct worksheet entry for the same financial function.; It fits spreadsheet-based finance workflows where users need to enter, review, and reuse formulas in cells.
Overall Conclusion
If your work centers on spreadsheet-based accrued-interest calculations, WPS, Microsoft Excel, and Google Sheets all provide relevant function support. WPS is a practical fit when you want to insert the function from a dialog, type it directly in cells, and review syntax in the same spreadsheet workflow, while Notion and Adobe are better aligned with database formulas or PDF form calculations.
Use Cases
| No. | Scenario | Suitable users | Main need | How ACCRINTM helps |
|---|---|---|---|---|
| 1 | Bond interest estimation | Finance staff | Calculate accrued interest for a maturity-interest security quickly | Enter =ACCRINTM(...) in a target cell |
| 2 | Financial function training | Teachers and students | Understand the function structure while entering parameters | Use the Insert Function dialog to review parameters during entry |
| 3 | Formula review and troubleshooting | Spreadsheet analysts | Check parameter order when results look incorrect | Review the syntax ACCRINTM(issue, settlement, rate, par, [basis]) before recalculating |
| 4 | Reusable worksheet templates | Office users | Reuse the same formula structure across multiple cells | Enter the formula once, then copy or fill it into other cells |
| 5 | Fast formula entry in the formula bar | Experienced users | Avoid opening the dialog every time | Type the formula directly in the cell or formula bar and confirm with Enter |
Membership & Benefits
Free vs WPS Premium
| Capability | Free users | WPS Premium |
|---|---|---|
| Basic spreadsheet functions in WPS Spreadsheet | ✅ Available | ✅ Available |
| ACCRINTM entry and calculation | ✅ Available | ✅ Available |
| Advanced PDF editing and conversion tools | Some features are limited | More features are available |
| Cloud storage | 1GB | 20GB |
Source: WPS Office pricing page
Recommendations
| Usage scenario | Recommended plan | Why |
|---|---|---|
| You mainly use ACCRINTM and other basic spreadsheet functions | Free plan | The current feature information shows no membership restriction for this function |
| You also need more PDF tools, cloud storage, or broader office features | WPS Premium | A paid plan is more suitable for users who need more cross-module capabilities |
How to Subscribe
- WPS membership page: Subscribe now
Source: WPS Office pricing page