Microsoft Office Tutorials and References
In Depth Information
Based on a yield that
pays periodic interest,
this function returns
the yield of the security.
results with cell
For a discounted security, YIELDDISC returns the annual yield.
The YIELDDISC function returns the annual yield of a discounted security. The YIELDDISC function
is found only if the Analysis Toolpak is installed. It must be turned on using the Add-Ins command
from the Tools menu. As you’ll see in Figure 6.42, the settlement date of the security is 11/15/1999
and the maturity date is 2/9/2000. The security’s price per $100 face value is $98 and the basis is
30/360(4). This produces an annual yield of 8.75%.
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 price of the security.
The redemption value of the security per $100 face value.
The day count basis to use.
For a discounted
returns the annual