TBillEq

Syntax

TBillEq(Settlement, Maturity, Discount)

Parameters

Settlement. The treasury bill's settlement date.

Maturity. Maturity date for the treasury bill.

Discount. Discount for a treasury bill.

NOTE. To determine the parameter, specify either the parameter value or the cell address where it is located.

Description

It returns the bond-equivalent yield for a treasury bill.

Comments

The Settlement parameter value should be less or equal to the Maturity parameter value

The function is calculated according to the following formula:

,

where:

Example

Formula Result Description
=TBillEq("01.01.2007", "01.09.2008", 0.05) 0,06

The bond-equivalent yield on the treasury bill based on the following terms:

  • The settlement date is 01.01.2007.

  • The maturity date is 01.09.2008.

  • The discount is 0.05.
=TBillEq(A0, B0, C0) 0,81

The bond-equivalent yield on the treasury bill based on the following terms:

  • The calculation date is specified in the A0 cell, value is 01.01.2007.

  • The maturity date is specified in the B0 cell, value is 01.10.2007.

  • The discount is specified in the C0 cell, value is 0.5.

See also:

Function Wizard │ Financial Functions │ TBillPrice │ TBillYield