Name
TBILLYIELD
Synopsis
You can use TBILLYIELD (an Analysis ToolPak function) to determine the interest earned (yield) on a Treasury Bill.
To Calculate
=TBILLYIELD(Settlement
,Maturity
,PR
)
All arguments must have values for this function.
Example
Figure 12-24 illustrates how you can use TBILLYIELD
to determine the yield (actual interest earned) for a Treasury Bill.
If you notice, the function uses the results of TBILLPRICE as the
value for the PR
argument.
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.