Excel - Understanding TBILLYIELD Function for Treasury Bonds

Buzz

Ngày cập nhật gần nhất: 15/4/2026

Content

TBILLYIELD Function in Excel

How to Use TBILLYIELD Function in Excel - Illustrated Examples

Excel hosts a variety of computational functions to aid users in their tasks... Among these, TBILLYIELD stands out as a widely used function for calculating profits on Treasury bonds. For a deeper understanding of this function, refer to the following article.

TBILLYIELD Function in Excel

How to Use TBILLYIELD Function in Excel - Illustrated Examples

Syntax: =TBILLYIELD(settlement, maturity, pr)

Where:

- Settlement: Mandatory. It denotes the bond's settlement date, which typically occurs one day after the bond issue date when the Treasury bond is traded to the buyer.
- Maturity: Mandatory. It signifies the maturity date of the Treasury bond.

- Pr:

Purpose: Returns the profit for Treasury bonds.

Example: Consider the following data table:

Calculate the profit for Treasury bonds (TBILLYIELD). Given the settlement date (Settlement), maturity date (Maturity), and the price of the Treasury bond calculated on a $100 face value (PR).

Apply the TBILLYIELD function. The formula for cell E4 is: = TBILLYIELD(B4,C4,D4). The result is:

Copy the formula for the remaining cells:

This article introduces you to the TBILLYIELD function, helping you calculate profits for Treasury bonds. Wishing you effective use of the TBILLYIELD function in your work.

Mytour's content is for customer care and travel encouragement only, and we are not responsible.

For errors or inappropriate content, please contact us at: [email protected]