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.

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 the rate of return on a T-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.

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

Stats
Last Value5.25%
Last UpdatedMay 20 2024, 16:24 EDT
Next ReleaseMay 21 2024, 16:15 EDT
Long Term Average4.19%
Average Growth Rate115.2%
1 more row

What is one downside to investing in treasuries? ›

Cons of Investing in Treasury Bonds

Interest rate risk: As interest rates ascend, the value of existing bonds with lower interest rates tends to diminish, potentially leading to capital losses if the bonds are sold prior to maturity.

What is the T-bill calculator in Excel? ›

The TBILLYIELD Function[1] is categorized under Excel FINANCIAL functions. It will calculate the yield on a Treasury bill. In financial analysis, TBILLYIELD can be useful in calculating the yield on a Treasury bill when we are given the start date, end date, and price.

What is an example of rate of return calculation? ›

What is a Rate of Return?
  • (($15 + $1 – $10) / $10) x 100 = 60% ...
  • 10 shares x ($1 annual dividend x 2) = $20 in dividends from 10 shares. ...
  • 10 shares x $25 = $250 (Gain from selling 10 shares) ...
  • 10 shares x $20 = $200 (Cost of purchasing 10 shares) ...
  • = (($250 + $20 – $200) / $200) x 100 = 35%

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.

What is the return on the 6 month T bill? ›

6 Month Treasury Rate is at 5.43%, compared to 5.41% the previous market day and 5.36% last year. This is higher than the long term average of 2.84%. 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.

Are T-bills a good investment at this time? ›

Are Treasury bills a good investment? Ultimately, whether Treasury bills are a good fit for your portfolio depends on your risk tolerance, time horizon and financial goals. T-bills are known to be low-risk short-term investments when held to maturity since the U.S. government guarantees them.

Can you lose money on T-bills? ›

Treasury bonds, notes, and bills have no default risk since the U.S. government guarantees them. Investors will receive the bond's face value if they hold it to maturity. However, if sold before maturity, your gain or loss depends on the difference between the initial price and what you sold the Treasury for.

Why would anyone bother investing in Treasury bills? ›

A Treasury bill, or T-bill, is a short-term debt obligation backed by the U.S. Treasury Department. It's one of the safest places you can save your cash, as it's backed by the full faith and credit of the government. T-bills are auctioned off at a discount and then redeemed at maturity for the full amount.

Is a CD better than a treasury bill? ›

Choosing between a CD and Treasuries depends on how long of a term you want. For terms of one to six months, as well as 10 years, rates are close enough that Treasuries are the better pick. For terms of one to five years, CDs are currently paying more, and it's a large enough difference to give them the edge.

What is the T calculator? ›

t-statistic Calculator. Use the t-statistic calculator (t-value calculator or t test statistic calculator) to compute the t-value of a given dataset using its sample mean, population mean, standard deviation and sample size.

How do you use the T formula in Excel? ›

(i) Microsoft Excel

You need to write the function in cell B2 as =T(A2) and press enter. Since the function tests and confirms whether the value is text or not it shall return the text string as is because “Microsoft Excel” is text.

What is the current 1 year T-bill rate? ›

Basic Info. 1 Year Treasury Rate is at 5.16%, compared to 5.14% the previous market day and 5.06% last year.

What is the average monthly T-bill rate? ›

1 Month Treasury Rate is at 5.49%, compared to 5.50% the previous market day and 5.58% last year. This is higher than the long term average of 1.46%.

What is the T-bill investment rate? ›

Treasury securities
This WeekMonth Ago
182-day T-bill auction avg disc rate5.1655.155
One-Year MTA5.1535.114
Two-Year Treasury Constant Maturity4.844.97
Five-Year Treasury Constant Maturity4.494.69
4 more rows

What is the current 2 year T-bill rate? ›

2 Year Treasury Rate is at 4.97%, compared to 4.96% the previous market day and 4.04% last year.

Top Articles
Latest Posts
Article information

Author: Barbera Armstrong

Last Updated:

Views: 6194

Rating: 4.9 / 5 (59 voted)

Reviews: 90% of readers found this page helpful

Author information

Name: Barbera Armstrong

Birthday: 1992-09-12

Address: Suite 993 99852 Daugherty Causeway, Ritchiehaven, VT 49630

Phone: +5026838435397

Job: National Engineer

Hobby: Listening to music, Board games, Photography, Ice skating, LARPing, Kite flying, Rugby

Introduction: My name is Barbera Armstrong, I am a lovely, delightful, cooperative, funny, enchanting, vivacious, tender person who loves writing and wants to share my knowledge and understanding with you.