Difference between revisions of "Manuals/calci/ACCRINTM"
Jump to navigation
Jump to search
| Line 6: | Line 6: | ||
*<math>ParValue</math> Security par value. | *<math>ParValue</math> Security par value. | ||
*<math>Basis</math> Type of day count basis. | *<math>Basis</math> Type of day count basis. | ||
| + | **ACCRINTM(),returns the accrued interest for a security that pays interest at maturity. | ||
==Description== | ==Description== | ||
Revision as of 16:48, 27 July 2018
ACCRINTM (Issue,Settlement,Rate,ParValue,Basis)
- Security's issue date.
- Security's settlement date should be after issue date.
- Security annual coupon rate.
- Security par value.
- Type of day count basis.
- ACCRINTM(),returns the accrued interest for a security that pays interest at maturity.
Security's issue date.
Security's settlement date should be after issue date.
Security annual coupon rate.
Security par value.
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.
- number of days counted from issue date to maturity date.
- Annual Year Basis.
number of days counted from issue date to maturity date.
Annual Year Basis.Example
| 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
Related Videos
See Also
Refernces