Microsoft Office Tutorials and References
In Depth Information
The TBILLYIELD function returns the yield for a T-bill.
to Calculate Accrued Interest
If you are the original buyer of a bond and you buy that bond after the
issue date, the bond will have earned some accrued interest during that gap.
As the original buyer of the bond, you generally pay this interest back to
the issuer when you take possession of the bond. This basically simplifies
accounting for the issuer, which can issue identical payments at the next
coupon date without having to worry about dozens of different settlement
The ACCRINT function calculates this accrued interest.
ACCRINT oor ACCINTM
ACCINTM to Calculate Accrued Interest
The ACCRINT function returns the accrued interest for a security that pays
periodic interest. This function takes the following arguments:
issue — This is the security ’ s issue date.
first_interest — This is the security ’ s first interest date.
settlement — This is the security ’ s settlement date. The security
settlement date is the date after the issue date when the security is
traded to the buyer. The ACCRINT function calculates the interest
that would have been earned between the issue date and the settlement
rate — This is the security ’ s annual coupon rate.
par — This is the security ’ s par value. If you omit par, ACCRINT
frequency — This is the number of coupon payments per year.
basis — This is the type of day count basis to use. You use 0 for U.S.