How to Calculate the Percentage Return of a T-Bill | The Motley Fool (2024)

Since treasuries have become significantly more attractive over the past 18 months, it's important to know how to calculate the percentage return of a Treasury bill. You should also know how to compare them effectively against other types of securities.

Here, we'll go step-by-step through the Treasury bill calculations.

How to Calculate the Percentage Return of a T-Bill | The Motley Fool (1)

Image source: The Motley Fool

What is a Treasury bill?

What is a Treasury bill?

A Treasury bill is a short-term government bond with a maturity of less than one year. Treasury bills, or T-bills, pay no interest but are sold at a discount to face value. For example, a bill with a redemption value of $1,000 might sell for $985 at auction.

Bonds

Bonds are debt securities that entitle the holder to receive interest payments.

You won't receive ongoing interest payments, but at maturity, you will receive an amount reflecting a certain investment return. Unlike stocks, T-bill investments are backed by the full faith and credit of the United States government.

Step 1: Calculating T-Bill yield

Step 1: Calculate the Treasury bill's yield

First, gather some key information about the bill you're trying to analyze. This includes:

  • The bill's purchase price
  • The bill's purchase date
  • The bill's maturity date

For ease of calculation, the bill's par value is expressed as 100 in the annualized yield calculation, and the bill's purchase price is expressed as a number less than 100 to reflect the implied discount.

To calculate yield, subtract the bill's purchase price from its face value and then divide the result by the bill's purchase price. Finally, multiply your answer by 100 to convert it to a percentage. The image below provides a visual of this formula.

How to Calculate the Percentage Return of a T-Bill | The Motley Fool (2)

Image source: The Motley Fool

Step 2: Annualize the T-Bill's yield

Step 2: Annualize the Treasury bill's yield

After you've found the Treasury bill's yield, multiply it by 365 and divide the result by the bill's days to maturity. The result will provide an annualized yield that will allow you to compare bills and other securities more easily.

Step 3: An Example

Step 3: Run an example

Say you were evaluating a Treasury bill with a 26-week maturity and a price of $97.

First, to calculate the bond's yield, you'd subtract 97 from 100 and divide by 97. From there, you'd multiply by 100 to arrive at a yield of 3.09%.

To annualize the bill's yield, multiply 3.09% by 365, and then divide the result by 182 (the bill's number of days to maturity) to arrive at an annualized yield of 6.2%.

This may seem like an unrealistic yield, but since interest rates have risen in 2023, Treasury bill rates have begun to approach 6% for the first time in many years.

Related investing topics

The bottom line on T-bill returns

T-bills have only recently come back into focus after over a decade of minuscule returns. Today, they can make up a meaningful part of your portfolio, particularly if you're approaching or in retirement.

In 2023, it's key to understand how to calculate and annualize T-bill returns so you're able to make informed decisions for your portfolio. Take an active part in analyzing potential investments to create a financial plan that works for you.

The Motley Fool has a disclosure policy.

How to Calculate the Percentage Return of a T-Bill | The Motley Fool (2024)

FAQs

How do you calculate percentage return on a Treasury bill? ›

To calculate yield, subtract the bill's purchase price from its face value and then divide the result by the bill's purchase price. Finally, multiply your answer by 100 to convert it to a percentage.

How to calculate interest rate on T-bills? ›

Face Value Redemption and Interest Rate

For example, suppose an investor purchases a 52-week T-bill with a face value of $1,000. The investor paid $975 upfront. The discount spread is $25. After the investor receives the $1,000 at the end of the 52 weeks, the interest rate earned is 2.56% (25 / 975 = 0.0256).

What is the rate of return on the T-bill? ›

Related Bonds - Domicile
NamePrice ChangeYield
U.S. 1 Month Treasury Bill0.0055.365%
U.S. 3 Month Treasury Bill-0.0055.391%
U.S. 6 Month Treasury Bill0.0005.385%
U.S. 2 Year Treasury Note0.0015.004%
5 more rows

What is one downside to investing in treasuries? ›

But while they are lauded for their security and reliability, potential drawbacks such as interest rate risk, low returns and inflation risk must be carefully considered. If you're interested in investing in Treasury bonds or have other questions about your portfolio, consider speaking with a financial advisor.

How can I calculate my rate of return? ›

Key Takeaways. Return on investment (ROI) is an approximate measure of an investment's profitability. ROI is calculated by subtracting the initial cost of the investment from its final value, then dividing this new number by the cost of the investment, and finally, multiplying it by 100.

How to calculate the average return for Treasury bills and the average annual inflation rate? ›

The average inflation rate and return of Treasury bills can be calculated as: Average Treasury Bill Return = + T n ) / n , where: Ta is the average Treasury bill return.

How is interest calculated on a 6 month T-bill? ›

The only interest paid will be when the bill matures. At that time, you are given the full face value. T-bills are zero-coupon bonds usually sold at a discount, and the difference between the purchase price and the par amount is your accrued interest.

What is the interest rate on T-bills for 6 months? ›

6 Month Treasury Rate is at 5.40%, compared to 5.39% the previous market day and 4.98% last year. This is higher than the long term average of 2.83%. The 6 Month Treasury Bill Rate is the yield received for investing in a US government issued treasury security that has a maturity of 6 months.

What is the tbillprice formula in Excel? ›

The TBILLPRICE function in Excel is used to calculate the price of a Treasury bill or T-bill. Its syntax is as follows: TBILLPRICE(settlement, maturity, discount) - settlement: The date on which the T-bill is purchased. - maturity: The date on which the T-bill matures. - discount: The discount rate of the T-bill.

Are T bill returns guaranteed? ›

Because the primary characteristic of T-Bills is that they offer a guaranteed return of principal, they typically function as the safe portion of an investment portfolio.

Is the T bill rate the risk free rate? ›

Most often, either the current Treasury bill, or T-bill, rate or long-term government bond yield are used as the risk-free rate. T-bills are considered nearly free of default risk because they are fully backed by the U.S. government.

What are current 3 month T bill rates? ›

U.S. 3 Month Treasury US3M:Tradeweb
  • Yield Open5.43%
  • Yield Day High5.49%
  • Yield Day Low5.394%
  • Yield Prev Close5.404%
  • Price5.255.
  • Price Change-0.005.
  • Price Change %-0.0951%
  • Price Prev Close5.26.

Can you lose money on T-bills? ›

There is virtually zero risk that you will lose principal by investing in T-bonds. There is a risk that you could have earned better money elsewhere.

Why would anyone bother investing in Treasury bills? ›

Treasury securities are considered the safest and most liquid investment. This makes Treasuries the perfect collateral for borrowing money.

Do you pay capital gains on Treasury bills? ›

Are Treasury bills taxed as capital gains? Normally no. However, if you buy a T-bill in the secondary market and then achieve a profit, you may be liable for capital gains depending on your exact purchase price.

How much do you make on a 3 month T-bill? ›

3 Month Treasury Bill Rate is at 5.26%, compared to 5.25% the previous market day and 4.97% last year. This is higher than the long term average of 4.19%. The 3 Month Treasury Bill Rate is the yield received for investing in a government issued treasury security that has a maturity of 3 months.

How much do you make on a 4 week Treasury bill? ›

4 Week Treasury Bill Rate is at 5.28%, compared to 5.28% the previous market day and 3.63% last year. This is higher than the long term average of 1.41%. The 4 Week Treasury Bill Rate is the yield received for investing in a US government issued treasury bill that has a maturity of 4 weeks.

What is the difference between interest rate and yield on treasury bills? ›

Key Takeaways. Yield is the annual net profit that an investor earns on an investment. The interest rate is the percentage charged by a lender for a loan. The yield on new investments in debt of any kind reflects interest rates at the time they are issued.

Is the 3 month Treasury bill rate annualized? ›

Yes t-bill rates are annualized. T-bills are zero coupon bonds and all of the interest is therefore paid at maturity.

Top Articles
Latest Posts
Article information

Author: Geoffrey Lueilwitz

Last Updated:

Views: 6177

Rating: 5 / 5 (80 voted)

Reviews: 87% of readers found this page helpful

Author information

Name: Geoffrey Lueilwitz

Birthday: 1997-03-23

Address: 74183 Thomas Course, Port Micheal, OK 55446-1529

Phone: +13408645881558

Job: Global Representative

Hobby: Sailing, Vehicle restoration, Rowing, Ghost hunting, Scrapbooking, Rugby, Board sports

Introduction: My name is Geoffrey Lueilwitz, I am a zealous, encouraging, sparkling, enchanting, graceful, faithful, nice person who loves writing and wants to share my knowledge and understanding with you.