Calculates the yield of a treasury bill.
TBILLYIELD(Settlement; Maturity; Price)
Settlement is the date of purchase of the security.
Maturity is the date on which the security matures (expires).
Price is the price (purchase price) of the treasury bill per 100 currency units of par value.
Settlement date: March 31 1999, maturity date: June 1 1999, price: 98.45 currency units.
The yield of the treasury bill is worked out as follows:
=TBILLYIELD("1999-03-31";"1999-06-01"; 98.45) returns 0.091417 or 9.1417 per cent.