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? ›

For instance, for a 26-week Treasury bill priced at 99, you'd start by taking 100-99 = 1 and then dividing 1 by 99 to get 0.010101. Then, multiply that number by 365 and divide by 26 x 7 or 182 days. The net result is 0.02025, or 2.025%.

How to calculate rate of return on 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? ›

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

How do I calculate my bill rate? ›

You can calculate the bill rate in four steps:
  1. Determine your annual salary.
  2. Estimate the capacity of your employees.
  3. Estimate the multiplier.
  4. Apply the bill rate formula: bill rate = (annual salary / capacity) × multiplier.
Apr 3, 2024

What is the formula for effective return rate? ›

The formula for EAR is: EAR = (1 + i/n)^n - 1 where i is the stated interest rate as a decimal and n is the number of interest payments per year. The stated interest rate is typically given as a percentage so remember to divide that percentage by 100 to get the decimal version.

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

6 Month Treasury Rate is at 5.41%, compared to 5.41% the previous market day and 5.13% 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.

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 unique about the T bill return? ›

T-bills pay a fixed rate of interest, which can provide a stable income. However, if interest rates rise, existing T-bills fall out of favor since their return is less than the market. T-bills have interest rate risk, which means there is a risk that existing bondholders might lose out on higher rates in the future.

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 much does a $10,000 treasury bill cost? ›

They are sold at a discount to face value, and the difference between the discounted price and face value is your return on investment. For example, if you buy a 12-week T-bill with a face value of $10,000 for $9,800, the difference of $200 is your return for holding the security for 12 weeks.

Are T-bills still a good investment? ›

The biggest downside of investing in T-bills is that you're going to get a lower rate of return compared to other investments, such as certificates of deposit, money market funds, corporate bonds or stocks. If you're looking to make some serious gains in your portfolio, T-bills aren't going to cut it.

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 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.

How do you calculate the discount rate on a treasury bill? ›

Assume, for example, that an investor purchases a $10,000 Treasury bill at a $300 discount from par value (a price of $9,700), and that the security matures in 120 days. In this case, the discount yield is ($300 discount)[/$10,000 par value] * 360/120 days to maturity, or a 9% dividend yield.

What is the 6 month T-bill rate? ›

Basic Info

6 Month Treasury Bill Rate is at 5.17%, compared to 5.17% the previous market day and 4.93% last year.

How do you calculate the rate of return on a bond? ›

The calculation of the rate of return is the interest plus appreciation, divided by original bond price – expressed as a percentage. The rate of return after one year is therefore 25% ($5000 plus $20,000, divided by $100,000, multiplied by 100).

References

Top Articles
Latest Posts
Article information

Author: Barbera Armstrong

Last Updated:

Views: 6045

Rating: 4.9 / 5 (79 voted)

Reviews: 86% 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.