ACCRINTM (PQL - xl)

This function calculates the accrued interest at maturity for a security that pays periodic interest

  • Library: PQL \ Spreadsheet \ Financial
  • Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module

Syntax

ACCRINTM(issue, settlement, rate, OPTIONAL par, OPTIONAL basis)

Function Arguments

Name

Description

Type

Optional

issue

Date that the security is issued

StringOrNumber

settlement

Maturity date for security

StringOrNumber

rate

Annual interest rate for the security

Number

par

Par value for the security; if omitted, the calculation uses a value of $1,000

Number

Y

basis

Integer representing the basis for day count

Number

Y

Comments

This function is the same as the Microsoft Excel 'ACCRINTM' function - using the same inputs, logic and outputs.