writer
6,694
edits
Changes
Jump to navigation
Jump to search
Created page with "<div style="font-size:30px">'''ACCCRINTM(I, Settle,R,Par,basis)'''</div><br/> *<math>I</math> Security's issue date. *<math>Settle</math> Security's settlement date should ..."
<div style="font-size:30px">'''ACCCRINTM(I, Settle,R,Par,basis)'''</div><br/>
*<math>I</math> Security's issue date.
*<math>Settle</math> Security's settlement date should be after issue date.
*<math>R</math> Security annual coupon rate.
*<math>Par</math> Security par value.
*<math>basis></math> 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.
:<math>ACCRINTM = Par * Rate *\frac{M}{D}</math>
*<math>M</math> number of days counted from issue date to maturity date.
*<math>D</math> Annual Year Basis.
==Example==
{| class="wikitable"
|+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
==Related Videos==
{{#ev:youtube|wkvOBTuJEuw|280|center|ACCRINTM}}
==See Also==
*[[Manuals/calci/ACCRINT| ACCRINT]]
*[[Manuals/calci/DATE| DATE]]
==Refernces==
*[http://www.excelfunctions.net/Excel-Accrintm-Function.html Accrued interest]
*<math>I</math> Security's issue date.
*<math>Settle</math> Security's settlement date should be after issue date.
*<math>R</math> Security annual coupon rate.
*<math>Par</math> Security par value.
*<math>basis></math> 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.
:<math>ACCRINTM = Par * Rate *\frac{M}{D}</math>
*<math>M</math> number of days counted from issue date to maturity date.
*<math>D</math> Annual Year Basis.
==Example==
{| class="wikitable"
|+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
==Related Videos==
{{#ev:youtube|wkvOBTuJEuw|280|center|ACCRINTM}}
==See Also==
*[[Manuals/calci/ACCRINT| ACCRINT]]
*[[Manuals/calci/DATE| DATE]]
==Refernces==
*[http://www.excelfunctions.net/Excel-Accrintm-Function.html Accrued interest]