Google Sheets TBILLYIELD Function: Syntax, Examples & Tips

settlement:
The date on which the investment is purchased or the security is settled. This must be a valid date.

maturity:
The date on which the investment matures or the security expires. This must also be a valid date and should be later than the settlement date.

price:
The price of the investment expressed as a percentage of the face value. This is typically a numeric value representing the price at which the investment is bought.

What is a TBILLYIELD?

The TBILLYIELD function in Google Sheets is a financial formula used to calculate the yield of a Treasury bill (T-bill) based on its face value, purchase price, and the number of days until maturity. This function is particularly useful for investors and financial analysts who want to assess the return on investment for T-bills, which are short-term government securities.

In simpler terms, TBILLYIELD helps you determine how much profit you can expect to earn from a T-bill investment, expressed as an annualized percentage.

A Practical Example

Imagine you are analyzing a T-bill investment with the following details:

• Face Value: $10,000
• Purchase Price: $9,800
• Days to Maturity: 30

You want to calculate the yield of this T-bill to understand its profitability.

TBILLYIELD Formula

To achieve this, you would use the TBILLYIELD function as follows:

=TBILLYIELD(settlement, maturity, rate, pr)

In this formula:

• settlement is the date when the T-bill is purchased.
• maturity is the date when the T-bill matures.
• rate is the annualized discount rate of the T-bill.
• pr is the purchase price of the T-bill.

For our example, assuming the T-bill matures in 30 days, the formula would look like this:

=TBILLYIELD(TODAY(), TODAY() + 30, 0, 9800)

Result of the Formula

When you apply the TBILLYIELD formula, it will return the yield of the T-bill as a percentage. For instance, if the yield calculated is 3.00%, it indicates that the annualized return on the investment is 3.00%.

Why Use TBILLYIELD?

TBILLYIELD is beneficial because it provides a straightforward way to evaluate the profitability of T-bill investments. It helps investors make informed decisions by comparing the yields of different T-bills or other investment options. Additionally, it allows for quick calculations without the need for complex financial modeling.

Key Takeaways:

• TBILLYIELD: A financial function that calculates the yield of a Treasury bill based on its face value, purchase price, and days to maturity.
• Investment Analysis: Useful for assessing the profitability of T-bill investments and comparing them with other investment opportunities.
• Simplicity: Provides a quick and easy way to calculate yields without complex formulas or models.
• Common Use Cases: Ideal for investors, financial analysts, and anyone involved in government securities trading.

TBILLYIELD is an essential function for anyone working with T-bills, providing a powerful way to enhance investment analysis and decision-making capabilities.

Happy investing!