Documentation/Calc Functions/TBILLYIELD

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


Function name:

TBILLYIELD

Category:

Financial Analysis

Summary:

Calculates the yield of a treasury bill.

Syntax:

TBILLYIELD(Settlement; Maturity; Price)

Returns:

Arguments:

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.

Additional details:

Examples:

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.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: