TBILLEQ

Formulas / TBILLEQ
Calculate the bond-equivalent yield for a Treasury bill.
TBILLEQ(settlement, maturity, discount)
  • Settlement - required
  • Maturity - required
  • Discount - required

Examples

  • =TBILLEQ(C5,C6,C7)

    The TBILLEQ function can be used to calculate the yield of a bond, given the price, face value and coupon rate. In this example, the bond has a face value of $1,000 (C6), a coupon rate of 3.25% (C7) and a price of $988.13 (C5). To calculate the yield, use the preceding formula. The function returns a yield of 2.53%, with percentage number format applied.

  • =TBILLEQ(C5,C6,C7)

    The TBILLEQ function can also be used to calculate the price of a bond given the face value, coupon rate and yield. In this example, the bond has a face value of $1,000 (C6), a coupon rate of 3.25% (C7) and a yield of 2.53% (C5). To calculate the price of the bond, use the preceding formula. The function returns a price of $988.13.

  • =TBILLEQ(C5,C6,C7)

    The TBILLEQ function can also be used to calculate the coupon rate of a bond given the face value, price and yield. In this example, the bond has a face value of $1,000 (C6), a price of $988.13 (C5) and a yield of 2.53% (C7). To calculate the coupon rate, use the preceding formula. The function returns a coupon rate of 3.25%.

Summary

The TBILLEQ function calculates the bond-equivalent yield of a Treasury note with a settlement date of February 1, 2016, a maturity date of January 30, 2017 and a discount of 3.5%. It requires three arguments: settlement, maturity, and discount.

  • The TBILLEQ function calculates the bond-equivalent yield for a Treasury bill, returning a yield as a percentage. It requires two arguments: a settlement date and a maturity date.
  • Both the settlement date and the maturity date must be provided for the TBILLEQ function to work correctly.
  • An optional third argument (discount) can be provided.


Frequently Asked Questions

What is the TBILLEQ function?
The TBILLEQ function is a financial function used in Sourcetable that calculates the bond-equivalent yield for a Treasury note.
What does the TBILLEQ function calculate?
The TBILLEQ function calculates the bond-equivalent yield for a Treasury note.
How do I use the TBILLEQ function?
The TBILLEQ function is used in Sourcetable. It is typically used to calculate the bond-equivalent yield of a Treasury note. The syntax for the function is as follows:
  • TBILLEQ(settlement, maturity, discount)
  • Settlement - the security's settlement date.
  • Maturity - the security's maturity date.
  • Discount - the security's discount rate.
What are the advantages of using the TBILLEQ function?
The TBILLEQ function is a useful tool in calculating the bond-equivalent yield of a Treasury note. This function enables users to quickly and accurately calculate the yield of a Treasury note without having to manually calculate it. Additionally, this function can also be used to compare yields of different Treasury notes.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV