Difference between revisions of "Manuals/calci/accrintm"
Jump to navigation
Jump to search
| Line 12: | Line 12: | ||
*ACCRINTM shows the error value when: | *ACCRINTM shows the error value when: | ||
R less-than or equal to 0 | R less-than or equal to 0 | ||
| − | + | Par less-than or equal to 0 | |
basis<0 or basis>4 | basis<0 or basis>4 | ||
I date greathearted or equal to settle date, | I date greathearted or equal to settle date, | ||
| − | <math>ACCRINTM = Par * Rate * | + | <math>ACCRINTM = Par * Rate *\frac{M}{D}</math> |
*<math>M</math> number of days counted from issue date to maturity date. | *<math>M</math> number of days counted from issue date to maturity date. | ||
*<math>D</math> Annual Year Basis. | *<math>D</math> Annual Year Basis. | ||
Revision as of 23:33, 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 Par less-than or equal to 0 basis<0 or basis>4 I date greathearted 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
=ACCRINTM(3/1/2008,8/15/2008,12,1000,3) 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 |