Difference between revisions of "Manuals/calci/accrintm"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
'''ACCCRINTM'''(I, Settle,R,Par,basis) | '''ACCCRINTM'''(I, Settle,R,Par,basis) | ||
| − | <math>I</math> Security's issue date. | + | *<math>I</math> Security's issue date. |
| − | <math>Settle</math> Security's settlement date should be after issue date. | + | *<math>Settle</math> Security's settlement date should be after issue date. |
| − | <math>R</math> Security annual coupon rate. | + | *<math>R</math> Security annual coupon rate. |
| − | <math>Par</math> Security par value | + | *<math>Par</math> Security par value. |
| − | <math>basis></math> Type of day count basis. | + | *<math>basis></math> Type of day count basis. |
| − | |||
| − | |||
| + | ==Description== | ||
This function returns the accumulated interest for a security that pays interest at maturity. | This function returns the accumulated interest for a security that pays interest at maturity. | ||
| − | |||
| − | |||
Issue, Basis, Settlement be integers. | Issue, Basis, Settlement be integers. | ||
| − | |||
ACCRINTM shows the error value when R less-than or equal to 0 or if Par less-than or equal to 0, basis<0 or basis>4 and I date greathearted or equal to settle date, | ACCRINTM shows the error value when R less-than or equal to 0 or if Par less-than or equal to 0, basis<0 or basis>4 and I date greathearted or equal to settle date, | ||
| Line 22: | Line 18: | ||
where, | where, | ||
| − | '''M''' - number of days counted from issue date to | + | '''M''' - number of days counted from issue date to maturity date. |
'''D''' - Annual Year Basis. | '''D''' - Annual Year Basis. | ||
Revision as of 03:20, 26 February 2014
ACCCRINTM(I, Settle,R,Par,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.
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 R less-than or equal to 0 or if Par less-than or equal to 0, basis<0 or basis>4 and I date greathearted or equal to settle date,
Formula:-
ACCRINTM=Par χ Rate χ(M /D)
where,
M - number of days counted from issue date to maturity date.
D - Annual Year Basis.
ACCRINTM
Lets see an example in (Column2,Row2)
=ACCRINTM(B2,B3,B4,B5,B6)
where
B2=3/1/2008
B3=8/15/2008
B4=12%
B5=1000
B6=3
ACCRINTM returns 54.6667.
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 3/1/2008 | |||
| Row2 | 8/15/2008 | 54.666667 | ||
| Row3 | 12% | |||
| Row4 | 1000 | |||
| Row5 | 3 | |||
| Row6 |