Name
TBILLPRICE
Synopsis
You can use TBILLPRICE (an Analysis ToolPak function) to determine the value of a Treasury Bill for each $100 of the face value.
To Calculate
=TBILLPRICE(Settlement
,Maturity
,Discount
)
All arguments must have values for this function.
-
Discount
A numeric value that represents the discount rate for the Treasury Bill. For example, if the Treasury Bill has a discount rate of 4.5% the value of this argument is
0.045
.
Example
Figure 12-24 illustrates how you can use TBILLPRICE to determine the face value or cost of a Treasury Bill.
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.