TBILLYIELD function
The TBILLYIELD function is one of the financial functions. It is used to calculate the yield of a Treasury bill.
Syntax
TBILLYIELD(settlement, maturity, pr)
The TBILLYIELD function has the following arguments:
| Argument | Description |
|---|---|
| settlement | The date when the Treasury bill is purchased. |
| maturity | The date when the Treasury bill expires. This date must be within one year of the settlement date. |
| pr | The purchase price of the Treasury bill, per $100 par value. |
Notes
Dates must be entered by using the DATE function.
How to apply the TBILLYIELD function.
Examples
The figure below displays the result returned by the TBILLYIELD function.
