SheetFX
≡
<< Go back to all functions

TBILLYIELD

The TBILLYIELD function in Google Sheets is a powerful tool to calculate the yield of a US Treasury Bill based on price. This function is particularly useful for financial analysis and investment decision-making. Dive into our comprehensive guide to learn how to use TBILLYIELD effectively.

Function Syntax and Parameters

Syntax: TBILLYIELD(settlement, maturity, price)

Parameters:

  • settlement: The settlement date of the Treasury Bill.
  • maturity: The maturity date of the Treasury Bill.
  • price: The price at which the Treasury Bill is sold.

Step-by-Step Tutorial

  1. Using TBILLYIELD to calculate yield:
    • Example: =TBILLYIELD("1/1/2023", "7/1/2023", 98.5)
    • Result: The function will calculate the yield of the Treasury Bill based on the provided settlement date, maturity date, and price.

Use Cases and Scenarios

  1. Investment Analysis: Calculate the yield of a US Treasury Bill to evaluate its potential return.
  2. Financial Planning: Determine the profitability of investing in Treasury Bills.
  3. Bond Valuation: Evaluate the attractiveness of Treasury Bills in comparison to other fixed-income securities.

Related Functions

  • T-Bill Equivalent Yield (TEY): Calculate the equivalent yield of a Treasury Bill to compare it with other fixed-income securities.
  • YIELD: Calculate the yield of a security that pays periodic interest.

Related Articles