Name
YIELDDISC
Synopsis
You can use YIELDDISC (an Analysis ToolPak function) to determine the interest earned (yield) on a discounted security. This function can only be used with a security that pays interest on a set schedule, such as monthly or annually.
To Calculate
=YIELDDISC(Settlement
,Maturity
,PR
,Redemption
,Basis
)
The Basis
argument is the only optional
argument. All other arguments must have values.
Example
Figure 12-28 illustrates how YIELDDISC can be used to determine the yield of a discounted security.
Get Excel 2000 in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.