ACCRINTM Function
Calculates accrued interest for a security that pays interest at maturity.
Syntax
Parameters
| Parameter | Description | Required |
|---|---|---|
| issue | Date the security was issued. | Required |
| settlement | Date the security matures or is sold. | Required |
| rate | Annual coupon rate. | Required |
| par | Par value of the security. | Required |
| basis | Day-count convention (0 = US 30/360, default). | Optional |
Basic Example
Accrued interest for a maturity-paying bond
=ACCRINTM(DATE(2024,1,1), DATE(2024,12,31), 0.06, 1000)Calculates accrued interest for a full year on a 6% bond with $1,000 par value.
Advanced Examples
Example 1: With actual/360 basis
Money market instrumentUse basis 2 for actual/360
=ACCRINTM(DATE(2024,1,1), DATE(2024,12,31), 0.06, 1000, 2)How ACCRINTM Works
ACCRINTM calculates the total interest accrued from issue to maturity. It is used for securities that pay all interest at maturity rather than periodically.
Important Notes & Limitations
Dates must be valid Excel dates.
Basis 0 is the most common convention for US bonds.
Par value is usually $1,000 or $100.
Common Errors & Fixes
#NUM! errorInvalid dates or basis.Fix: Verify dates and basis value.
#VALUE! errorDates are not recognized.Fix: Use DATE function or valid date serial numbers.
Download Practice File
ACCRINTM
accrintmPractice ACCRINTM with Real Data
Download a sample CSV file with pre-populated data and practice exercises for the ACCRINTM function. Works in both Excel and Google Sheets.
File format: CSV (comma-separated values) - opens in Excel, Google Sheets, and all spreadsheet apps