TBILLYIELD function

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

SettlementDate

Number or { Number }

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

MaturityDate

Number or { Number }

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

IssuePrice

Number or { Number }

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

Returns

Number or { Number }

The yield for a US Treasury bill.

Returns the yield for a US Treasury bill.

Example

TBILLYIELD(DATE(2008, 1, 1), DATE(2008, 5, 1), 97.31)TBILLYIELD(DATE(2008; 1; 1); DATE(2008; 5; 1); 97,31)

Returns a yield of roughly 8.3% for a US Treasury bill with a settlement date of January 1, 2008, a maturity date of May 1, 2008 and an issue price of $97.31, per $100 face value.

Partly derived from the OpenOffice.org documentation, licensed under the Apache License 2.0.