Microsoft Office Tutorials and References
In Depth Information
Based on a security that pays interest at maturity, YIELDMAT returns the annual yield.
The YIELDMAT function returns the yield annually for a security that pays interest at maturity. It
can be found only if the Analysis Toolpak is installed. It must be turned on using the Add-Ins
command from the Tools menu. The example in Figure 6.43 shows the settlement date of the
security is 11/15/1999 and the maturity date is 6/9/2009. The issue date of the security is
6/18/1999. The rate is 5.8% and the securities price per $100 face value is $98 and the basis is
30/360(4). This means that the annual interest for the security result is 9.30%.
The security’s settlement date. This is the date after the issue date when
the security is traded to the buyer.
The security’s maturity date—when the security expires.
The issue date of the security.
The interest rate of the security.
The price of the security.
The day count basis to use.
YIELDMAT returns the
annual yield based on
a security that pays
interest at maturity.