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.

How do you calculate the maturity value of a treasury bill? ›

As a simple example, say you want to buy a $1,000 Treasury bill with 180 days to maturity, yielding 1.5%. 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.

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 you calculate rate of return percentage? ›

You can calculate the rate of return on your investment by comparing the difference between its current value and its initial value, and then dividing the result by its initial value. Multiplying the result of that rate of return formula by 100 will net you your rate of return as a percentage.

How do you earn a return on a T-bill? ›

You buy bills at a discount — a price below par — and profit from the difference at the end of the term. While T-bills don't pay interest like other Treasurys, the difference between your discounted price and the par value is essentially the "interest" earned.

What is the percentage of the T-bill? ›

Basic Info. 3 Month Treasury Bill Rate is at 5.26%, compared to 5.26% the previous market day and 5.26% last year. This is higher than the long term average of 4.19%.

What is the T-bill ladder strategy? ›

A T-Bill ladder is a strategy that involves sequentially purchasing investment-grade T-Bills that mature at different times in the near future. This latter point is where T-Bill ladders differ from the bond ladder strategy, which focuses on purchasing bank certificates of deposits (CDs) or bonds with longer maturities.

What happens when a T-bill matures? ›

When the bill matures, you are paid its face value. You can hold a bill until it matures or sell it before it matures.

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.

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 does T-bill interest work? ›

Bills are sold at a discount. The discount rate is determined at auction. Bills pay interest only at maturity. The interest is equal to the face value minus the purchase price.

How do you calculate the price of a T-bill? ›

Price = Face value (1 – (discount rate x time)/360)

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 do you calculate the time rate of return? ›

Time-weighted rate of return is a method to calculate an investment's underlying return by eliminating the effect of contributions or withdrawals made. The formula for time-weighted rate of return is: TWRR = (1 + R1) * (1 + R2) * ... (1 + Rn) - 1, where R is the simple return for each time period (R = (Ve - Vb) / Vb).

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

Formula: Simple Interest (SI) = Principal (P) x Rate (R) x Time (T) / 100.

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.

What is the formula for return on interest rate? ›

You may calculate the return on investment using the formula: ROI = Net Profit / Cost of the investment * 100 If you are an investor, the ROI shows you the profitability of your investments. If you invest your money in mutual funds, the return on investment shows you the gain from your mutual fund schemes.

Top Articles
Latest Posts
Article information

Author: Geoffrey Lueilwitz

Last Updated:

Views: 5973

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.