Treasury Bill Ladder Calculator Excel: Yield Optimization Dashboard for May 2026

Treasury bill ladder calculator excel - if you searched that, you are probably staring at a brokerage cash sweep paying less than the front end of the U.S. Treasury curve and wondering whether a self-built T-bill ladder would do better. The short answer in May 2026 is: probably yes, by a meaningful margin, and a properly built spreadsheet lets you see exactly how much. This post ships a free, premium-grade Excel calculator that prices a 12-rung monthly ladder against live Treasury rates, models reinvestment under different Fed paths, and benchmarks the ladder against CDs, money market funds, savings accounts, I-bonds, and short corporate bond indices.

The template is designed to look like a paid product on first open: cover page, KPI tile dashboard, embedded charts, conditional-formatted screener, scenario heatmap, rolling strategy playbook, methodology, and glossary across eleven sheets. Drop it on any analyst's desk and it should not feel like a free download.

Why the May 2026 setup matters for cash investors

The Federal Reserve has held the federal funds target steady through Q1 and into Q2 2026 after the cutting cycle that began in late 2024. The 3-month T-bill is currently trading around 4.28%, the 1-year around 4.05%, and the 10-year just above 4.30% - a flat-to-slightly-positive curve that rewards staying short while still paying you to extend out a year. Money market funds yield roughly the same as 3-month bills before fees, and high-yield savings accounts have crept down toward 4.20%. The arithmetic favors a ladder for any cash you can leave invested for 12 months or more.

A T-bill ladder also addresses three structural headaches that single-instrument cash plans do not:

1. Rolling liquidity. One rung matures every month, so you always have cash within 30 days without selling anything in the secondary market.
2. Reinvestment averaging. When yields drift, your blended yield drifts with them gradually instead of resetting all at once.
3. State tax exemption. Treasury interest is exempt from state and local income tax. For a California or New York resident in the top bracket, that exemption is worth roughly 50-100 basis points of yield versus a same-yield CD.

The T-bill ladder is rarely the highest pre-tax yield on this list - but after state tax for a top-bracket resident, it usually beats CDs and savings, and unlike I-bonds it does not lock principal.

Treasury bill ladder calculator excel: what the template models

The calculator implements a 12-rung monthly ladder by default: 1, 2, 3, 4, 6, 9, 12, 15, 18, 21, 24, and 36 months. Edit the Inputs sheet to change the rung count, longest maturity, weights, or reinvestment target and the entire workbook reprices.

For each rung the model computes:

• Yield at the closest Treasury constant-maturity tenor available via MarketXLS (TreasuryRate3M, TreasuryRate1Y, TreasuryRate5Y, TreasuryRate10Y).
• Discount price per $1,000 face using the standard money-market approximation Price = 1000 / (1 + yield x months / 12).
• Face value purchased from the rung's capital allocation.
• Maturity date using EDATE(TODAY(), months) so the calendar follows whenever you open the file.
• Cash at maturity equal to the face value (zero-coupon bills repay par).

The Dashboard rolls these up into a six-tile KPI row showing weighted average yield, projected annual interest income, weighted average maturity, rung count, the next maturity in months, and a liquidity score. A second row of tiles displays capital deployed, the curve slope (10Y - 1Y), the after-tax yield at your federal rate, and the real yield versus 5-year breakeven inflation.

How the ladder works mechanically

Pick the simplest version first - a 12-month equal-weight ladder. Total capital is $120,000 in the default sample. Divide it into 12 equal slices of $10,000. Buy a 1-month, 2-month, 3-month, 4-month, 6-month, 9-month, 12-month, 15-month, 18-month, 21-month, 24-month, and 36-month Treasury at $10,000 of capital each.

Now wait 30 days. The 1-month rung matures and returns its $10,000 face value. Reinvest it at the longest tenor you target - in the rolling 12-month structure, that means buying a fresh 12-month T-bill. After one month, your ladder still spans roughly the same maturity range but every rung is one month shorter. After 12 months of doing this, every original rung has matured and been replaced. You now hold a continuously rolling ladder where one rung matures every month indefinitely.

The trade-off is that you give up some yield versus locking in a single 24-month or 36-month note. In return you get monthly liquidity, dollar-cost-averaging across the curve, and an automatic mechanism that captures rate increases as they happen.

Building the ladder with MarketXLS formulas in Excel

Every yield in the live template is a formula, not a static number. The base rates come from MarketXLS macroeconomic functions that read the Federal Reserve H.15 release every business day:

=TreasuryRate3M()              -> 3-month U.S. Treasury rate
=TreasuryRate1Y()              -> 1-year U.S. Treasury rate
=TreasuryRate5Y()              -> 5-year U.S. Treasury rate
=TreasuryRate10Y()             -> 10-year U.S. Treasury rate
=TreasuryInflationProtectedSecurities5Y()  -> 5-year TIPS yield
=TreasuryInflationProtectedSecurities10Y() -> 10-year TIPS yield
=BondYieldAAA()                -> Moody's AAA corporate yield
=BondYieldBAA()                -> Moody's BAA corporate yield
=CorporateBondIndexAA()        -> ICE BofA AA corporate index
=CorporateBondIndexBBB()       -> ICE BofA BBB corporate index

For the ETF wrappers used in the comparison sheet:

=QM_Last("BIL")                -> Last price of the SPDR 1-3 Month T-Bill ETF
=DividendYield("SGOV")         -> Distribution yield of the iShares 0-3 Month T-Bill ETF
=DividendYield("SHV")          -> Distribution yield of the iShares Short Treasury Bond ETF

For each rung, the workbook chooses the closest available tenor. A 6-month rung uses =TreasuryRate1Y() as a stand-in (the published CMT series we have access to does not include a separate 6-month series - for production trading, replace with the broker-quoted yield at trade time).

The discount price approximation:

=1000 / (1 + yield * months / 12)

is correct to the basis point for the educational purpose of the calculator and matches the order-entry price most retail brokers display. For very short bills (under 6 months) the published bank discount yield differs slightly from the bond-equivalent yield used here; the gap is typically a fraction of a basis point.

Reading the Dashboard

The Dashboard sheet is what someone sees on the first open of the file. It is laid out so you can answer four questions in the time it takes to scroll once:

1. What yield am I getting? The Wt Avg Yield tile collapses the whole ladder into one number.
2. How much income does that produce? The Projected Income tile multiplies your capital by that yield.
3. How long is my money tied up? The Wt Avg Maturity and Liquidity Score tiles answer this.
4. How does it stack up against alternatives? The Curve 1Y vs 10Y, After-Tax Yield, and Real Yield tiles let you compare apples to apples.

Below the tiles, the Ladder Rung Screener is a conditionally formatted table of every rung in the ladder. Yield cells are color-scaled red-amber-green, capital allocation columns get data bars, and months-to-maturity uses a 3-arrow icon set to flag short, medium, and long rungs. Two embedded charts visualize yield by rung and capital allocated by rung.

Yield curve sheet

The Yield Curve sheet pulls live rates for every Treasury tenor MarketXLS exposes: 3-month, 1-year, 5-year, and 10-year, plus the 5-year and 10-year TIPS yields and AAA/BAA corporate references. Use the curve shape to make a tactical call:

• Normal upward curve (10Y > 1Y by more than 50 basis points). Extending the longest rung from 12 months to 24 months earns extra carry. The historical average term premium is around 50-100 basis points.
• Flat curve (10Y - 1Y between 0 and 50 basis points). The current setup as of May 2026. Stay with a 12-month structure - extra duration is not paying enough to justify the lockup.
• Inverted curve (10Y < 1Y). Stay short. Money market funds and 4-week bills are paying you more than 12-month bills. The Rolling Strategy sheet explicitly handles this case with a "Curve inverts" play.

Ladder Schedule sheet

The Ladder Schedule sheet shows every rung with its purchase price, face value, yield, maturity date, and cash inflow at maturity. The maturity dates use EDATE(TODAY(), months) so they always show the calendar from today forward. A bar chart at the bottom displays the cash inflow calendar, which is the most useful single visualization for matching rung maturities to known expenses (quarterly tax payments, annual insurance premiums, college tuition).

A common refinement: replace the equal weighting with a "bullet" structure that concentrates capital around a known cash-need date. For example, if you need $30,000 for tuition in 9 months, weight the 6-month, 9-month, and 12-month rungs at 25% each and spread the remaining 25% across the other nine rungs. The Inputs sheet supports per-rung weights for exactly this use case.

Scenario Analysis sheet

The Scenario Analysis sheet projects what your blended ladder yield looks like under seven Fed rate paths over years 1, 2, and 3. Year 1 is fixed (every rung locked at purchase). Years 2 and 3 reflect the chosen path as rungs roll into new yields.

Two takeaways jump out. First, the ladder protects against rate cuts better than a single 3-month bill because rungs further out the curve lock today's higher yield for longer. Second, the ladder gives up some upside if rates rise quickly because only one rung per month rolls into the new higher yield. This convexity profile - smooth on the downside, gradual on the upside - is exactly what most savers want for a cash bucket.

Rolling Strategy sheet

The Rolling Strategy sheet enumerates ten common reinvestment situations and what to do in each. The default rule is simple: when a rung matures, reinvest at the longest tenor in your ladder. That preserves the rolling structure indefinitely.

The sheet also handles edge cases: what to do when the curve inverts (stay short), when the Fed cuts unexpectedly (lock the 12-month yield before further cuts price in), when the Fed hikes unexpectedly (stay short and re-roll into higher yields). These are starter rules; tune them to your tax calendar and risk tolerance. The point of writing them down is to remove discretion in moments when the news cycle tempts you to do something dumb.

Comparison sheet

The Comparison sheet places the T-bill ladder side by side with ten cash alternatives across yield, liquidity, tax treatment, insurance, minimum, and notes columns. The yield column is conditionally formatted as a heatmap so you can spot the relative attractiveness at a glance.

Three points worth highlighting:

1. Pre-tax yield is misleading. A 12-month CD at 4.55% is taxed at federal + state. A T-bill ladder at 4.18% is taxed at federal only. For a top-bracket California resident, the after-tax yields are nearly identical - and the ladder gives you monthly liquidity that the CD does not.
2. Money market funds are not FDIC-insured. Treasury MMFs (SGOV, BIL) hold the same instruments as your ladder but in a fund wrapper. They are protected by SIPC at the brokerage level but not by FDIC at the bank level. For most people the distinction does not matter; for someone managing operating cash for a small business with FDIC requirements, it does.
3. I-bonds have annual purchase caps. $10,000 per person per year through TreasuryDirect, plus $5,000 in tax refund. Useful as part of a diversified cash position but not as the whole cash position.

Methodology and limitations

The Methodology sheet explains every calculation in plain English: yield source, discount price approximation, weighted average yield, after-tax yield, real yield, liquidity score, rolling rule. The Limitations section calls out four things you should know:

1. Yields are point-in-time. Bills bought on different days settle at different prices.
2. The discount price formula approximates - actual broker-quoted prices differ by 1-3 cents per $1,000.
3. The model assumes hold-to-maturity. Selling before maturity in the secondary market introduces price risk if yields rise.
4. Tax treatment varies by state, account type (taxable vs IRA), and AMT status. Consult a tax advisor.

None of these break the calculator for educational purposes. They matter when you cross from "should I do this" to "let me place the trade" and want to confirm the broker's number matches your model.

What's inside the template (sheet-by-sheet walkthrough)

Eleven sheets, each tab-color-coded:

1. Cover - branded title, subtitle, version, data-as-of date, table of contents.
2. How To Use - six-step tutorial covering inputs, dashboard reading, yield curve interpretation, maturity calendar, scenarios, and rolling strategy.
3. Inputs - yellow input cells for total capital, rung count, longest maturity, reinvestment toggle, federal and state tax rates, plus dropdowns for Fed path assumption, ladder style, and reinvestment target. Per-rung weights are also editable.
4. Dashboard - 10 KPI tiles, two embedded charts (yield by rung, capital allocated by rung), conditionally formatted rung screener.
5. Yield Curve - live Treasury rates from 3-month to 10-year, TIPS reference yields, AAA/BAA corporate references, curve chart.
6. Ladder Schedule - every rung's purchase price, face value, yield, maturity date, and cash inflow with a cash-inflow bar chart.
7. Scenario Analysis - seven Fed rate paths from -100 bps cuts to +100 bps hikes with year 1, 2, 3 yield and 3-year blended yield.
8. Rolling Strategy - ten reinvestment situations and the recommended play for each.
9. Comparison - 11 cash vehicles compared on yield, liquidity, tax, insurance, min, and notes.
10. Methodology - the math behind every calculation.
11. Glossary & Disclaimer - 22 term definitions and the standard educational notice.

Every sheet has a footer with the MarketXLS attribution and a "MarketXLS Functions Used" box listing the exact formulas that power the sheet.

Download the templates

Both files are free, designed to be presentation-ready, and built to last beyond the May 2026 snapshot.

Download the templates:

• - Pre-filled with current data; every cell shows the MarketXLS formula that would produce it as a comment.
• - Live-updating formulas; rates refresh via MarketXLS whenever you open the file.

The Sample is the right choice if you want to inspect the model before installing MarketXLS. The Template is the production version - install MarketXLS, open the workbook, watch the rates update, and start customizing.

How a T-bill ladder fits into a broader cash plan

Most people who reach for a calculator like this are not running their entire net worth in Treasuries. They are managing a cash bucket - the slice of liquid assets that sits between checking and equities. A reasonable framework:

• Operating cash (0-3 months of expenses): high-yield savings or a money market fund. Same-day liquidity matters more than yield.
• Bridge cash (3-12 months of expenses): a T-bill ladder with monthly maturities. Earns the curve, returns cash on a calendar.
• Reserve cash (12+ months of expenses): extend the ladder out to 24-36 months, or layer in I-bonds for inflation protection.

The Comparison sheet in the template helps you allocate across these buckets. The Scenario Analysis sheet helps you think about the duration risk you take on by extending the ladder.

For a portfolio-management view of cash within a broader allocation, see the MarketXLS Portfolio Management features - the same workbook can hold cash, equities, options, and fixed income in one place.

Frequently Asked Questions

Q: How is a Treasury bill ladder different from a CD ladder?

A: Mechanically very similar - both stagger maturities to provide rolling liquidity. The differences are tax treatment (Treasury interest is state-tax-exempt; CD interest is fully taxed), credit (Treasuries are direct U.S. government obligations; CDs depend on FDIC insurance up to $250k per bank), and liquidity (Treasuries trade in the secondary market every business day; breaking a CD typically costs 3-6 months of interest). For taxable accounts in high-tax states, the after-tax yield on T-bills usually beats CDs of the same tenor.

Q: What is the minimum to start a T-bill ladder?

A: TreasuryDirect sells T-bills in $100 increments, so technically $1,200 will fund a 12-rung ladder at $100 per rung. Most brokers (Fidelity, Schwab, Vanguard) offer T-bills in $1,000 increments through their bond desks. A practical floor for the 12-rung structure is $12,000 to $15,000. The template's default sample uses $120,000 to make the dollar-amounts clearer; the math is identical at any scale.

Q: How often do I need to manage the ladder?

A: Once a month, when the next rung matures. The Rolling Strategy sheet describes the default reinvestment rule: buy a fresh longest-tenor rung. The trade itself takes about 5 minutes through any retail broker. Most people set a calendar reminder for the day after each maturity.

Q: Can I build a Treasury bill ladder inside an IRA?

A: Yes. Most retail brokers let you trade T-bills in IRAs through the same bond desk used for taxable accounts. The state tax exemption is moot inside an IRA (everything grows tax-deferred or tax-free), so the calculus shifts: pre-tax yield is what matters, and the comparison sheet's CDs and corporate bonds become more attractive on an apples-to-apples basis.

Q: What happens to my ladder if rates change suddenly?

A: Each rung locks its yield at purchase, so existing rungs are unaffected. Reinvestments after the move happen at the new prevailing yield. The Scenario Analysis sheet quantifies this for ±25, ±50, ±75, and ±100 basis-point paths. The headline finding: a 12-rung ladder smooths rate moves substantially compared to a single bond - the blended yield in year 2 captures only about half of any rate move because only half the rungs have rolled.

Q: Do I have to use MarketXLS to use this template?

A: The Sample version works without MarketXLS - all values are pre-filled from May 5, 2026 reference data, and every cell carries a comment showing the MarketXLS formula that would produce it. The Template version uses live formulas and requires MarketXLS to refresh rates. You can still open the Template version without MarketXLS - the formulas show as text errors, but the structure, formatting, and methodology are intact.

Q: How do I customize the ladder for a different time horizon?

A: Open the Inputs sheet. Change "Longest Maturity (months)" to 24 or 36 for a longer ladder. Adjust the Months column on each rung row to redistribute. The Dashboard, Ladder Schedule, Scenario Analysis, and Rolling Strategy sheets all reference the Inputs sheet, so the entire workbook recalculates with one change.

The Bottom Line

A Treasury bill ladder turns the question "where do I park cash" from a one-time decision into a repeating monthly discipline. The yield is rarely the highest on the cash menu, but the combination of state-tax exemption, monthly liquidity, U.S. government backing, and reinvestment averaging makes it the most defensive option for sums above what FDIC insurance covers in a single bank.

The calculator above turns every calculation into a transparent, editable spreadsheet you can audit cell-by-cell. The dashboard answers the four questions a saver actually cares about (what yield, what income, how long locked, versus what alternatives) in the time it takes to open the file.

Build it. Tune it. Roll it monthly. Or use it as a check on whatever your current cash plan is doing.

For deeper Treasury, fixed-income, and macro modeling in Excel, see MarketXLS for fixed income or book a demo to see the full library of macroeconomic and yield-curve functions in action.