Treasury Bill Calculator & Ladder Planner
Compare T-bill quotes given as bank discount rates or prices per $100. Enter up to eight bills to see what each costs, when it matures, how its investment rate compares, and whether an earlier redemption covers a later purchase. The timeline uses your issue dates and terms, with a running cash balance for each day that money moves.
Plan a Treasury bill ladder
Compare quotes, see when cash comes back, and check which purchases a maturity can fund.
Starting cash and bill terms
Use the issue date as settlement. Enter terms from each quote or use the illustrative example.
Interest $172.85. Minimum starting cash $9,921.94.
Cash flow by settlement date
Bars compare cash paid for bills and face value received. The balance uses all transactions on that date.
- Purchases$9,921.94Maturities$0.00
Cash after event$78.06
- Purchases$4,905.21Maturities$5,000.00
Cash after event$172.85
- Purchases$0.00Maturities$5,000.00
Cash after event$5,172.85
- Purchases$0.00Maturities$5,000.00
Cash after event$10,172.85
Price and yield for each bill
Discount rates use face value and 360 days. Investment rates use price paid per $100 and the Treasury convention for the bill’s term.
| Bill | Maturity | Price per $100 | Purchase | Face value | Interest | Discount rate | Investment rate |
|---|---|---|---|---|---|---|---|
| 1 | 2026-12-17 | $99.688889 | $4,984.44 | $5,000.00 | $15.56 | 3.999999% | 4.068211% |
| 2 | 2027-02-18 | $98.750000 | $4,937.50 | $5,000.00 | $62.50 | 4.945055% | 5.077201% |
| 3 | 2027-06-17 | $98.104167 | $4,905.21 | $5,000.00 | $94.79 | 3.749999% | 3.875557% |
Export the ladder
How to use this calculator
- Enter Starting cash in dollars. The rolling ladder example includes a purchase on the date an earlier bill matures.
- Enter Issue date, Term in calendar days, and Face value in $100 increments for each bill. Use the issue date that appears on the quote or announcement.
- Choose Discount rate if a quote gives a bank discount percentage, or Price per $100 if the quote states a price. Enter the matching figure.
- Read Minimum starting cash and Additional cash needed. Inspect Cash flow by settlement date to see the date and size of a shortfall.
- Use Price and yield for each bill to compare the offers. Download ladder CSV for the dated schedule and calculation inputs.
The Formula
The mathematical logic powering this calculation is:
Let P be the price per $100 of face value, d the annual bank discount rate as a decimal, r the number of calendar days to maturity, and y the number of days in the year following the issue date. The planner uses 366 when that following year includes February 29 and 365 otherwise. For a February 29 issue it uses the following February 28 as the anniversary.
For a discount quote, P = 100(1 − d × r/360), rounded to six decimals. A quoted price can also be entered directly. The price-implied discount rate is (100 − P)/100 × 360/r. The investment rate i for a bill with r ≤ y/2 is (100 − P)/P × y/r. For a longer bill, i is the nonnegative solution of P × [1 + (r/y − 1/2)i] × (1 + i/2) = 100. These quoted rates use the price per $100 before the full purchase amount is rounded to cents.
The purchase amount is P × face value/100 rounded to cents, and maturity interest is face value minus the rounded purchase amount. The planner uses issue date as settlement and adds the entered term in calendar days. For each date it groups purchases and maturities, then adds redemptions and subtracts purchases from cash. Minimum starting cash is the greatest cumulative amount paid minus cumulative maturities at any event date, with a floor of zero. Additional cash needed is the excess of that requirement over entered starting cash.
Enter 1–8 bills, whole terms up to one year, face values of $100–$10 million in $100 increments, and starting cash up to $100 million. Quote entries accept 0%–20% discount rates or $1–$100 per $100, with as many as six decimal places. The tool uses illustrative or user-supplied quotes and assumes same-day maturity proceeds are available for purchases. Actual issue calendars and processing times come from your provider. Taxes, fees, cash interest, and early sale proceeds are outside these cash flows.Worked Example
If you input:
- Starting cash (USD): 10,000.00
- Bill 1: 2026-11-19, 28 days, $5,000 face value, 4% discount rate
- Bill 2: 2026-11-19, 91 days, $5,000 face value, $98.750000 per $100
- Bill 3: 2026-12-17, 182 days, $5,000 face value, 3.75% discount rate
Result:
The first two bills cost $4,984.44 and $4,937.50, so the opening purchase requires $9,921.94. On December 17, the first bill pays $5,000.00 and the third bill costs $4,905.21. The lowest balance is $78.06, so no additional cash is needed. Across the three bills, interest totals $172.85 and cash after the final maturity is $10,172.85.
Frequently Asked Questions
What is a Treasury bill discount rate?
It annualizes the price discount relative to face value using a 360-day year. The Treasury investment rate uses the price per $100 and the term-specific method in Appendix B.
How much cash do I need to start a T-bill ladder?
The minimum is the largest cumulative difference between purchases and preceding or same-day redemptions. If proceeds settle after a same-day purchase, you may need more cash than the planner reports.
How do I enter a bill quoted at par?
Choose Price per $100 and enter 100, or choose a zero discount rate. A par purchase costs its full face value and earns zero interest when redeemed at par.
Does adding a rung automatically reinvest proceeds?
Each rung represents a purchase you specify. To model reinvestment, enter the later purchase with the expected issue date, face amount, term and quote.
Where can I find a bill’s actual issue date and quote?
Use the Treasury auction announcement and results or the quote provided by your account. The workbook treats your entries as assumptions and calculates calendar dates without applying any holiday or auction schedule.
Why is the earned interest slightly different from the quoted yield calculation?
Treasury-style yields use the price per $100. A full purchase rounds to cents, and the difference between that payment and the face amount is the dollar interest shown in the cash schedule.
Similar Calculators
Bond Yield Calculator
Calculate a regular bond's yield or clean price, separate accrued interest, and compare actual repricing with duration and convexity across a dated payment schedule.
Certificate of Deposit Calculator
Compare CD offers with explicit APY or nominal rates. See maturity balances, interest growth, a savings-target solver and a downloadable comparison schedule.
Tax-Equivalent Yield Comparison Planner
Compare taxable and exempt income assumptions, annual fees and tax-equivalent yields. Find exact break-even tax rates and inspect after-tax income scenarios.
Emergency Fund Target Calculator
Emergency Fund Target for the exact fields in this tool, with clear inputs and an immediate result for planning or comparison.
