TBILLEQ
TBILLEQ ( settlement , maturity , discount )
Description: Computes the bond-equivalent yield for a U.S. Treasury bill.
Arguments:
Name |
Type |
Description |
---|---|---|
settlement |
number |
The Treasury bill's settlement date. Any time information in the date is ignored. |
maturity |
number |
The Treasury bill's maturity date. Any time information in the date is ignored. |
discount |
number |
The Treasury bill's discount rate. |
Return Type and Value: number – The bond-equivalent yield for a U.S. Treasury bill.
However, if
settlement or maturity is out of range for the current date base value,
#NUM!
is returned.settlement > maturity,
#NUM!
is returned.maturity is more than one year after settlement,
#NUM!
is returned.discount ≤ 0,
#NUM!
is returned.
example: