Manuals/calci/accrintm

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

• 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 I} Security's issue 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 Settle} Security's settlement date should  be after issue 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 R} Security annual coupon rate.
• 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 Par} Security par value.
• 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 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}}

• $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

Spreadsheet

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

• =ACCRINTM(A1,A2,A3,A4,A5)

5490.41095890411

• =ACCRINTM("3/7/2012","7/13/2013",10,10000,4)

135000

• =ACCRINTM("3/7/2012","7/13/2013",10,10000,5)

NAN