Yield of Treasury bill
Yield = yldtbill(Settle, Maturity, Face, Price)
Settlement date. Enter as serial date number or date string. Settle must be earlier than Maturity.
Maturity date. Enter as serial date number or date string.
Redemption (par, face) value.
Price of the Treasury bill.
The settlement date of a Treasury bill is February 10, 2000, the maturity date is August 6, 2000, the par value is $1000, and the price is $981.36. Using this data
Yield = yldtbill('2/10/2000', '8/6/2000', 1000, 981.36)
Yield = 0.0384 (or 3.84%)