Menu

ACCRINT Function (LibreOffice Calc)

Financial Advanced LibreOffice Calc Introduced in LibreOffice 3.0
finance bonds accrued-interest coupons day-count valuation

The ACCRINT function returns the accrued interest for a security that pays periodic interest. It supports multiple day-count conventions and is essential for bond valuation, portfolio accounting, and financial modeling.

Compatibility

â–¾

What the ACCRINT Function Does â–¾

  • Computes accrued interest from issue date to settlement date
  • Supports coupon frequencies: annual, semiannual, quarterly
  • Supports multiple day-count basis systems
  • Handles regular coupon schedules
  • Works with real dates, serial numbers, and DATEVALUE

It is designed to be finance‑grade, precise, and fully compatible with Excel.

Syntax â–¾ 

ACCRINT(issue; first_interest; settlement; rate; par; frequency; [basis])

Arguments

  • issue:
    The date the security was issued.

  • first_interest:
    The first coupon payment date.

  • settlement:
    The date the security is traded to the buyer.

  • rate:
    Annual coupon rate (e.g., 0.05 for 5%).

  • par:
    Par (face) value of the security.

  • frequency:
    Number of coupon payments per year:

    • 1 = annual
    • 2 = semiannual
    • 4 = quarterly

  • 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 semiannual bond

=ACCRINT("2024-01-01"; "2024-07-01"; "2024-03-15"; 0.06; 1000; 2)

Accrued interest using Actual/Actual

=ACCRINT(A1; A2; A3; 0.05; 1000; 2; 1)

Accrued interest from text dates

=ACCRINT(DATEVALUE(A1); DATEVALUE(A2); DATEVALUE(A3); 0.04; 1000; 2)

Advanced Examples â–¾

Accrued interest for quarterly coupons

=ACCRINT("2024-01-01"; "2024-04-01"; "2024-02-15"; 0.08; 1000; 4)

Accrued interest from imported CSV timestamps

=ACCRINT(DATEVALUE(LEFT(A1;10)); DATEVALUE(LEFT(A2;10)); DATEVALUE(LEFT(A3;10)); Rate; Par; Frequency)

Accrued interest from Excel serial dates stored as text

=ACCRINT(DATE(1899;12;30)+VALUE(A1); DATE(1899;12;30)+VALUE(A2); DATE(1899;12;30)+VALUE(A3); Rate; Par; Frequency)

Accrued interest with Actual/360 (money market)

=ACCRINT(A1; A2; A3; 0.045; 100000; 2; 2)

Accrued interest with European 30/360

=ACCRINT(A1; A2; A3; 0.05; 1000; 2; 4)

Calculate clean price from dirty price

=DirtyPrice - ACCRINT(Issue; FirstInt; Settlement; Rate; Par; Freq)

Calculate accrued interest per 100 face value

=ACCRINT(A1; A2; A3; Rate; 100; Frequency)

Edge Cases and Behavior Details â–¾

ACCRINT returns a numeric value (currency)

Accepts:

  • Real dates
  • Serial numbers
  • DATEVALUE outputs

Invalid text → Err:502

Behavior details

  • Issue < FirstInterest < Settlement must hold
  • Frequency must be 1, 2, or 4
  • Basis must be 0–4
  • Time components ignored
  • Uses standard coupon‑period math

ACCRINT of an error → error propagates

Common Errors and Fixes â–¾

Err:502 — Invalid argument

Cause:

  • Dates not recognized
  • Frequency not 1, 2, or 4
  • Basis outside 0–4

Fix:

  • Wrap dates with DATEVALUE
  • Validate frequency and basis

Err:504 — Invalid date sequence

Cause:

  • Settlement before issue
  • FirstInterest before issue

Fix:

  • Correct date order

Wrong accrued interest

Cause:

  • Wrong basis
  • Wrong frequency
  • Incorrect first coupon date

Fix:

  • Verify coupon schedule
  • Use correct day-count convention

Best Practices â–¾

  • Use Actual/Actual (basis 1) for most bond calculations
  • Use Actual/360 for money‑market instruments
  • Use 30/360 for corporate bonds
  • Normalize text dates with DATEVALUE
  • Validate coupon schedules carefully
  • Use ACCRINTM for zero‑coupon bonds
ACCRINT is your periodic‑coupon accrued‑interest engine — essential for bond valuation, portfolio accounting, and professional‑grade financial modeling.

Related Patterns and Alternatives â–¾

  • Use ACCRINTM for zero‑coupon bonds
  • Use COUPDAYS, COUPNUM, COUPPCD, COUPNCD for coupon schedule analysis
  • Use PRICE and YIELD for bond valuation
  • Use YEARFRAC for fractional year calculations
  • Use DATEVALUE for text conversion

By mastering ACCRINT and its companion functions, you can build powerful, accurate, and fully professional financial models in LibreOffice Calc.

Related Functions

Copyright 2026. All rights reserved.