Microsoft Office Tutorials and References
In Depth Information
YIELDMAT
YIELDMAT
Based on a security that pays interest at maturity, YIELDMAT returns the annual yield.
=YIELDMAT(settlement,maturity,issue,rate,pr,basis)
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.
SETTLEMENT
The security’s maturity date—when the security expires.
MATURITY
The issue date of the security.
ISSUE
The interest rate of the security.
RATE
The price of the security.
PR
The day count basis to use.
BASIS
Figure 6.43
YIELDMAT returns the
annual yield based on
a security that pays
interest at maturity.
Search JabSto ::




Custom Search