Difference between revisions of "Manuals/calci/accrintm"
Jump to navigation
Jump to search
| Line 51: | Line 51: | ||
|- | |- | ||
! 1 | ! 1 | ||
| − | | 3/1/2008 | + | | 3/1/2008 |
|- | |- | ||
! 2 | ! 2 | ||
| − | | 8/15/2008 | + | | 8/15/2008 |
|- | |- | ||
! 3 | ! 3 | ||
| − | | 12 | + | | 12 |
|- | |- | ||
! 4 | ! 4 | ||
| − | | 1000 | + | | 1000 |
|- | |- | ||
! 5 | ! 5 | ||
| − | | 3 | + | | 3 |
|} | |} | ||
Revision as of 23:52, 26 February 2014
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.
- 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.
Security's settlement date should be after issue date.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 |
| A | B | |
|---|---|---|
| 1 | 3/1/2008 | |
| 2 | 8/15/2008 | |
| 3 | 12 | |
| 4 | 1000 | |
| 5 | 3 |
=ACCRINTM("3/1/2008","8/15/2008",12,1000,3)
5490.41095890411
=