Introduction
This Treasury bill ladder calculator estimates how a T‑bill ladder might perform over a chosen time period. It focuses on a practical question: if you keep maturing bills fully invested using an auto‑roll style approach, how does your estimated blended annualized yield compare with a scenario where some proceeds sit as idle cash earning a lower rate?
The calculator is designed for planning and education. You supply the yields you want to assume for common bill terms (4, 8, 13, 26, and 52 weeks), choose how many rungs to include, and set a planning horizon in months. The output is a plain‑English summary you can copy.
What is a Treasury bill ladder?
A Treasury bill (T‑bill) ladder is a cash‑management strategy where you split a lump sum across multiple short‑term U.S. Treasury bills with staggered maturities. Instead of buying one bill and waiting for it to mature, you create several “rungs” so that some portion of your money comes due regularly.
- Safety focus: T‑bills are backed by the U.S. government (credit risk is generally considered very low).
- Liquidity planning: staggered maturities can provide predictable access to cash.
- Yield seeking: you may earn more than leaving funds in a low‑yield bank account or sweep vehicle.
A ladder can be useful when you want a balance between earning a Treasury yield and keeping a schedule of upcoming maturities. Some people use ladders as an alternative to holding a large cash balance in a checking account; others use them to stage cash for a known future expense (for example, a home down payment or quarterly tax payments). The best structure depends on how often you want liquidity and how comfortable you are reinvesting at future rates.
How to use the calculator
- Enter your Total Investment (the amount you want to allocate across the ladder today).
- Choose the Number of Ladder Rungs (2 to 5). The calculator uses the first N terms from this set: 4‑week, 8‑week, 13‑week, 26‑week, 52‑week.
- Set your Planning Horizon in months (for example, 12 months for a one‑year plan).
- Enter your assumed annual yields for each term. These are inputs (not live market data).
- Enter an Idle Cash Yield to represent what uninvested proceeds might earn between purchases.
- Click Calculate Ladder Performance. The results area will show estimated interest and blended APYs for: (a) staying invested via auto‑roll and (b) a simplified “manual” scenario that includes idle‑cash days.
Tip: if you are not sure what to enter for yields, you can start with a single flat assumption (for example, 5.00% for all terms) and then adjust each term to reflect a curve (shorter bills lower or higher than longer bills). The goal is not to predict the market perfectly; it is to understand how ladder structure and idle time can change your estimated outcome.
Formula and calculation approach (what the tool is doing)
The calculator uses a straightforward interest approximation based on your annual yield inputs. For each rung, it:
- Splits the total investment evenly across the selected number of rungs.
- Steps forward in time in increments equal to the rung’s term (in days).
- For each step, estimates interest using simple day‑count prorating.
Estimated interest for a period ≈ allocation × (annualRate) × (daysInvested / 365)
It then converts total interest over your horizon into a blended annualized percentage (APY‑style annualization):
(interest / principal) × (365 / horizonDays).
This is an annualized estimate to help compare scenarios on a consistent basis.
Note: real T‑bill pricing is typically quoted on a discount basis and uses specific day‑count conventions. This calculator intentionally uses a simplified approach so you can compare scenarios quickly.
Worked example (with numbers you can sanity‑check)
Suppose you invest $50,000 for 12 months and choose 4 rungs. The calculator splits the principal into roughly $12,500 per rung. If you enter yields of 4.80% (4‑week), 4.90% (8‑week), 5.00% (13‑week), and 5.10% (26‑week), the model estimates interest each time a rung completes a term and “rolls” again.
A quick back‑of‑the‑envelope check: if the blended annual rate were about 5.0% and you stayed invested for a full year, simple interest would be roughly $50,000 × 0.05 ≈ $2,500 before taxes. Your calculator result may differ because (a) each rung uses its own rate, (b) the horizon is converted to days using an average month length, and (c) the manual scenario credits some days at the idle yield.
If you set Idle Cash Yield to 1.50%, the “manual” scenario will typically show lower total interest than the auto‑roll scenario. The difference is the estimated opportunity cost of leaving proceeds uninvested during the leftover days at the end of a term.
Assumptions and limitations
- User‑supplied yields: the tool does not fetch live auction or secondary‑market rates.
- Constant rates: it assumes the same annual yield applies each time a rung rolls.
- Simplified interest math: it uses a 365‑day year and prorates by days invested; it does not model exact discount pricing.
- Even allocation: each rung receives an equal share of the total investment; real ladders may use uneven sizing.
- Taxes and fees excluded: results are pre‑tax and ignore bid/ask spreads, commissions, and account‑specific costs.
- Execution realities: settlement timing, auction schedules, and minimum purchase increments are not modeled.
- Not advice: this is an educational estimate, not investment, tax, or legal advice.
Practical context: auto‑roll vs manual reinvestment
Many investors use a ladder to keep cash productive while still having regular access to maturities. In practice, the biggest drag on returns often isn’t the quoted Treasury yield—it’s the time your money spends not earning it. If proceeds sit in a sweep account for days or weeks before you place the next order, your realized return can fall.
This page’s calculator models that idea with an Idle Cash Yield. In the “manual” scenario, when a rung’s term extends beyond the remaining horizon, the model treats the leftover days as idle time earning the idle yield. In the “auto‑roll” scenario, the calculation assumes the allocation remains invested whenever possible.
Input tips (to get more realistic results)
- Use yields from a consistent source (for example, recent auction results or broker quotes) and keep the units consistent (annual percent).
- Set idle cash yield to what your cash actually earns (HYSA, money market fund, or sweep). If you set it too low, the auto‑roll advantage may look larger than your real experience.
- Choose a horizon that matches your plan. A very short horizon may not allow longer rungs to cycle, which changes the blend.
- If you want a conservative estimate, consider using slightly lower yields than today’s quotes to reflect reinvestment risk. If you want a stress test, try a scenario where short‑term yields drop and the idle yield rises.
Interpreting the results
The results are presented as a short summary with two blended APYs and two total interest estimates. Use the comparison to answer practical questions such as:
- Is the estimated incremental interest worth the operational effort of managing maturities?
- How sensitive is the outcome to the idle cash yield (your “do nothing” alternative)?
- Does adding more rungs meaningfully change the blended yield for your horizon?
Remember what “blended APY” means here: it is an annualized way to compare interest earned over your chosen horizon. It is not a guaranteed yield, and it is not the same as a bank APY with compounding. It is a consistent yardstick for comparing two simplified scenarios using the same assumptions.
Additional considerations (execution and recordkeeping)
If you implement a ladder outside this calculator, keep a simple record of purchase dates, maturity dates, and amounts. Many people use calendar reminders for auction schedules and settlement dates. If you buy through a broker, confirm how cash is handled at maturity and whether reinvestment can be automated.
Tax treatment can also matter. Treasury interest is generally subject to federal income tax and often exempt from state and local income tax, but your situation may differ. This calculator does not model taxes.
Common questions (quick clarifications)
Does a ladder guarantee a higher return than a single bill? Not necessarily. A ladder is mainly a liquidity and reinvestment structure. If yields are higher on one specific term, concentrating in that term could produce a higher estimated yield, but you would give up the regular maturity schedule.
Why do longer rungs sometimes look “underused” in a short horizon? If your horizon is shorter than a rung’s term, the model can only invest for the days that fit inside the horizon. The remaining days are treated as idle time in the manual scenario, which can reduce the blended result.
What should I use for the planning horizon? Use the time window you care about for comparing strategies. For example, if you are deciding how to manage cash for the next 6 months, set the horizon to 6 months even if you might keep the ladder going longer.
Deeper explanation: how ladder choices affect cash flow
A ladder is not only about yield; it is also about timing. With more rungs, you typically get more frequent maturities, which can reduce the chance that you need to sell something early or hold too much idle cash. With fewer rungs, you may have longer gaps between maturities, which can be fine if you do not need frequent liquidity.
In this calculator, rung terms are fixed to common bill tenors: 4, 8, 13, 26, and 52 weeks. When you choose 2 rungs, the model uses 4‑week and 8‑week. When you choose 3 rungs, it uses 4‑week, 8‑week, and 13‑week, and so on. This mirrors a common approach where you build from short to longer bills as you add rungs.
Understanding the “idle cash” concept in the model
The manual scenario in this tool is intentionally simple: it assumes that if a term would extend beyond your remaining horizon, the leftover days are treated as idle time earning the idle yield. This is a way to represent friction such as waiting for an auction date, delaying a reinvestment decision, or keeping cash available because your horizon is ending.
If you want the manual scenario to look closer to an always‑reinvest approach, set the idle yield closer to your bill yields. If you want to model a low‑yield sweep account, set idle yield lower. The difference between the two scenarios is a simplified estimate of the value of staying invested.
How to compare scenarios responsibly
Use the calculator as a comparison tool rather than a promise. If you change only one input at a time, you can see which assumptions matter most. For example, try keeping all bill yields the same and vary only the idle yield; then keep idle yield fixed and vary the number of rungs. This helps you separate the effect of ladder structure from the effect of your cash alternative.
Also consider that real‑world reinvestment rates can change. A ladder reduces the risk of locking everything into one rate at one point in time, but it also means you will be reinvesting portions of your money at whatever rates exist in the future. That reinvestment risk is not “good” or “bad” by itself; it is simply part of how ladders work.
Plain-language summary of what you get from a ladder
- Regular maturities: a schedule of cash coming due without selling early.
- Rate diversification over time: you buy at multiple points, not all at once.
- Operational simplicity (with auto‑roll): fewer decisions and fewer idle days, depending on your platform.
- Tradeoff: you may not always capture the single highest-yielding term if the curve is steep.
Reminder about inputs
The yields you enter should be annual percentages (for example, enter 5.25 for 5.25%). If you are looking at Treasury bill quotes that use a discount rate or bond equivalent yield, convert them to a consistent annual yield before comparing. This calculator does not perform quote conversions; it assumes your inputs are already comparable.
Mini-game: Roll Runner
Steer maturities into reinvestment windows and keep idle cash from leaking yield.
Pointer/touch: move + tap to roll. Keyboard: ←/→ to change lane, Space/Enter to roll.