Microsoft Office Tutorials and References
In Depth Information
Syntax
Note
The ACCRINTM function calculates accrued interest for zero-
coupon bonds, as shown in row 18 in Figure 13.25 .
Figure 13.25.
Figure 13.25. As the original buyer of the bond, you owe the accrued interest
As the original buyer of the bond, you owe the accrued interest
to the issuer.
to the issuer.
If issueis greater than or equal to settlement, ACCRINT returns a #NUM! er-
ror.
Figure 13.25 demonstrates how the accrued interest changes when the gap
between the issue date and settlement date extends.
Search JabSto ::




Custom Search