TBILLYIELD function

TBILLYIELD (SettlementDate, MaturityDate, IssuePrice) TBILLYIELD (SettlementDate; MaturityDate; IssuePrice)

SettlementDate

Temporal Temporal

The settlement (purchase) date of the US Treasury bill.

MaturityDate

Temporal Temporal

The maturity (redemption) date of the US Treasury bill.

IssuePrice

Number Number

The issue price per $100 of face value of the US Treasury bill.

Returns

Number Number

The yield for a US Treasury bill.

Returns the yield for a US Treasury bill, given its price. Use TBILLPRICE to perform the reverse calculation.

Example

TBILLYIELD ( DATE (2010, 3, 15), DATE (2010, 9, 15), 97.50)

TBILLYIELD ( DATE (2010; 3; 15); DATE (2010; 9; 15); 97,50)

Returns a yield of roughly 5.02% for a Treasury bill purchased on March 15, 2010, maturing on September 15, 2010, at a price of $97.50 per $100 face value.