Manuals/calci/accrintm

ACCCRINTM(I, Settle,R,Par,basis)

• $I$ Security's issue date.
• $Settle$ Security's settlement date should  be after issue date.
• $R$ Security annual coupon rate.
• $Par$ Security par value.
• $basis>$ Type of day count basis.

Description

• This function returns the accumulated interest for a security that pays interest at maturity.
• Issue, Basis, Settlement be integers.
• ACCRINTM shows the error value when:

1.R less-than or equal to 0
2.Par less-than or equal to 0
3.basis < 0 or basis > 4
4.I date greater-than or equal to settle date.

Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle ACCRINTM = Par * Rate *\frac{M}{D}}

• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle M} number of days counted from issue date to maturity date.
• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle D} Annual Year Basis.

Example

=ACCRINTM("3/1/2008","8/15/2008",12,1000,3) 5490.41095890411 =

	A
1	3/1/2008
2	8/15/2008
3	12%
4	1000
5	3

Spreadsheet

	A	B
1
2
3
4
5

=ACCRINTM("3/1/2008","8/15/2008",12,1000,3) 5490.41095890411 =