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 to Calculate the Percentage Return of a T-Bill | The Motley Fool? ›

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 return on the Treasury bills? ›

Basic Info. 3 Month Treasury Bill Rate is at 5.26%, compared to 5.26% the previous market day and 5.16% 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 will I 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 4.32% 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 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.

Is 1 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. They are discount instruments and you will receive face value at maturity which includes the interest.

How to calculate T-bill returns? ›

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 percentage return on a 1 year treasury bill? ›

1 Year Treasury Rate is at 5.22%, compared to 5.21% the previous market day and 5.22% last year. This is higher than the long term average of 2.95%. The 1 Year Treasury Rate is the yield received for investing in a US government issued treasury security that has a maturity of 1 year.

How much does a $1000 T-bill cost? ›

To calculate the price, take 180 days and multiply by 1.5 to get 270. Then, divide by 360 to get 0.75, and subtract 100 minus 0.75. The answer is 99.25. Because you're buying a $1,000 Treasury bill instead of one for $100, multiply 99.25 by 10 to get the final price of $992.50.

Why don't people invest in the treasury bill? ›

Taxes: Treasury bills are exempt from state and local taxes but still subject to federal income taxes. That makes them less attractive holdings for taxable accounts. Investors in higher tax brackets might want to consider short-term municipal securities instead.

How do T-bills work for dummies? ›

They are issued at a discount to their face value and pay no interest until maturity, at which point the investor receives the full face value of the bill. For example you can currently buy a 3 month T-bill expiring June 10th this year for $98.85 and on June 10th the U.S Government pays you $100.

What is the Treasury bill discount rate? ›

The difference between the face value of the T-bill and the amount that an investor pays is called the discount rate or discount yield, which is calculated as a percentage.

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.

Which three arguments are needed to use the tbillyield function? ›

The arguments required for the TBILLYIELD function are settlement date, maturity date, and price. The settlement date is the date that the Treasury bill is purchased, the maturity date is the date when the Treasury bill matures, and the price is the price of the Treasury bill.

How to calculate Treasury bill interest rate? ›

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 happens when T-bill matures? ›

Upon maturity of the T-bills, when will I receive the principal amount? On maturity, the principal amount will be credited to your respective account by the end of the day, typically after 6pm. For cash applications: The principal amount will be credited to your designated Direct Crediting Service bank account.

How much will I make on a 1 month Treasury bill? ›

1 Month Treasury Rate is at 5.48%, compared to 5.50% the previous market day and 5.28% last year. This is higher than the long term average of 1.46%. The 1 Month Treasury Rate is the yield received for investing in a US government issued treasury bill that has a maturity of 1 month.

How much does a $1000 T bill cost? ›

To calculate the price, take 180 days and multiply by 1.5 to get 270. Then, divide by 360 to get 0.75, and subtract 100 minus 0.75. The answer is 99.25. Because you're buying a $1,000 Treasury bill instead of one for $100, multiply 99.25 by 10 to get the final price of $992.50.

What is the 3 month T bill rate? ›

U.S. 3 Month Treasury US3M:Tradeweb
  • Yield Open5.423%
  • Yield Day High5.443%
  • Yield Day Low5.391%
  • Yield Prev Close5.399%
  • Price5.2525.
  • Price Change-0.0025.
  • Price Change %-0.0476%
  • Price Prev Close5.255.

What is the 6 month treasury bill rate? ›

Basic Info

6 Month Treasury Rate is at 5.42%, compared to 5.43% the previous market day and 5.46% last year.

How much interest do you get from Treasury bills? ›

Learn What They Are and How to Buy. The shortest-term U.S. debt security, T-Bills differ from Treasury notes and bonds. They do not pay interest and are sold at a discount rate.

Top Articles
Latest Posts
Article information

Author: Dean Jakubowski Ret

Last Updated:

Views: 6226

Rating: 5 / 5 (50 voted)

Reviews: 89% of readers found this page helpful

Author information

Name: Dean Jakubowski Ret

Birthday: 1996-05-10

Address: Apt. 425 4346 Santiago Islands, Shariside, AK 38830-1874

Phone: +96313309894162

Job: Legacy Sales Designer

Hobby: Baseball, Wood carving, Candle making, Jigsaw puzzles, Lacemaking, Parkour, Drawing

Introduction: My name is Dean Jakubowski Ret, I am a enthusiastic, friendly, homely, handsome, zealous, brainy, elegant person who loves writing and wants to share my knowledge and understanding with you.