ACCRINTM Function (LibreOffice Calc)
The ACCRINTM function returns the accrued interest for a security that pays interest only at maturity. It supports multiple day-count conventions and is essential for zero-coupon bond valuation and financial modeling.
Compatibility
▾| Excel | ✔ |
| Gnumeric | ✔ |
| Google_sheets | ✔ |
| Libreoffice | ✔ |
| Numbers | ✔ |
| Onlyoffice | ✔ |
| Openoffice | ✔ |
| Wps | ✔ |
| Zoho | ✔ |
What the ACCRINTM Function Does ▾
- Computes accrued interest from issue date to maturity date
- Designed for zero-coupon securities
- Supports multiple day-count basis systems
- Works with real dates, serial numbers, and DATEVALUE
It is designed to be precise, finance‑grade, and Excel‑compatible.
Syntax ▾
ACCRINTM(issue; settlement; rate; par; [basis])
Arguments
-
issue:
The date the security was issued. -
settlement:
The maturity date (when interest is paid). -
rate:
Annual interest rate (e.g., 0.05 for 5%). -
par:
Par (face) value of the security. -
basis (optional):
Day-count convention:
| basis | Day-count convention |
|---|---|
| 0 | US 30/360 |
| 1 | Actual/Actual |
| 2 | Actual/360 |
| 3 | Actual/365 |
| 4 | European 30/360 |
Basic Examples ▾
Accrued interest on a zero-coupon bond
=ACCRINTM("2024-01-01"; "2024-12-31"; 0.06; 1000)
Using Actual/Actual
=ACCRINTM(A1; A2; 0.05; 1000; 1)
Using text dates
=ACCRINTM(DATEVALUE(A1); DATEVALUE(A2); Rate; Par)
Advanced Examples ▾
Zero-coupon interest with Actual/360 (money market)
=ACCRINTM(A1; A2; 0.045; 100000; 2)
Zero-coupon interest from imported CSV timestamps
=ACCRINTM(DATEVALUE(LEFT(A1;10)); DATEVALUE(LEFT(A2;10)); Rate; Par)
Zero-coupon interest from Excel serial dates stored as text
=ACCRINTM(DATE(1899;12;30)+VALUE(A1); DATE(1899;12;30)+VALUE(A2); Rate; Par)
Calculate the maturity value (par + accrued interest)
=Par + ACCRINTM(Issue; Maturity; Rate; Par)
Calculate discount yield from accrued interest
=ACCRINTM(A1; A2; Rate; Par) / Par
Edge Cases and Behavior Details ▾
ACCRINTM returns a numeric value (currency)
Accepts:
- Real dates
- Serial numbers
- DATEVALUE outputs
Invalid text → Err:502
Behavior details
- Issue < Settlement must hold
- Basis must be 0–4
- Time components ignored
- Uses standard day-count math
ACCRINTM of an error → error propagates
Common Errors and Fixes ▾
Err:502 — Invalid argument
Cause:
- Dates not recognized
- Basis outside 0–4
Fix:
- Wrap dates with DATEVALUE
- Validate basis
Err:504 — Invalid date sequence
Cause:
- Settlement before issue
Fix:
- Correct date order
Wrong accrued interest
Cause:
- Wrong basis
- Incorrect rate or par
Fix:
- Verify day-count convention
- Confirm rate and par values
Best Practices ▾
- Use Actual/Actual (basis 1) for most zero-coupon bonds
- Use Actual/360 for money-market instruments
- Normalize text dates with DATEVALUE
- Validate date order carefully
- Use ACCRINT for coupon-paying bonds
ACCRINTM is your zero‑coupon accrued‑interest engine — essential for discount bond valuation, accounting, and professional financial modeling.
Related Patterns and Alternatives ▾
- Use ACCRINT for coupon-paying bonds
- Use YEARFRAC for fractional year calculations
- Use PRICE and YIELD for bond valuation
- Use DATEVALUE for text conversion
By mastering ACCRINTM and its companion functions, you can build powerful, accurate, and fully professional financial models in LibreOffice Calc.