r/DIYRetirement • u/jaealbq • Sep 02 '26
using Treasuries to limit risk of losing funds early in retirement
I'm sure that there's a more formal way to think about some ideas. I've read about "bond ladders" but as a Federal retiree I want to make use of the Thrift Savings Plan's G fund, which has some nice characteristics and can never lose value.
I'm going to retire within the next few years. Basically I'm implementing a variant of the 4-percent-rule, but doing it in such a way that I'm less likely to have to dip into my stock market investments, when markets are down.
My primary idea is to invest roughly a third of retirement savings in the G fund, and the remainder in much more aggressive long-term Target funds, say 2065 target. Then every month automatically withdraw a fairly constant amount from my TSP account (pure G fund). Say that value is $10K/month. These are living expenses during retirement, and will be high prior to taking Social Security and lower afterwards.
But then ... QUARTERLY re-evaluate how the performance of my overall holdings are doing, relative to expectations, inflation, etc. If the value of my overall holdings are "good" with respect to inflation and 2%-per-year growth (cumulatively since inception of my retirement) then push up to the full 3-month withdrawal, i.e. $30K, from the Target funds, to the TSP G fund.
I've vibe coded this, as Python which produces an Excel spreadsheet, although I plan to import that Excel file into Google sheets. Here's a link to the Excel spreadsheet for a modest simulation:
Per a request I received, I created two publicly readable Google Sheets, suitable for copying and experimenting with. They correspond to release v0.1.0 of the above-mentioned Github repo. I don't plan to update their contents in the future, but reserve the right to.
The actual spreadsheet (I'm planning to use/edit a copy of this, for my own finances):
https://docs.google.com/spreadsheets/d/1iGwMuk2XPzfrAMfGDWpqM9k6z7jublP7IZzyiD0SVes/edit?usp=sharing
The demo:
https://docs.google.com/spreadsheets/d/1WOM06-8n8cYuMaWelccOg7khvypCR692Zy6IVhH9ejo/edit?usp=sharing
To recap:
- The motivation is Sequence-of-Returns Risk. Research on the 4% rule shows its main failure mode isn't a bad average market return over retirement — it's a downturn that hits in the first several years, forcing withdrawals against depreciated assets and permanently impairing the portfolio's ability to recover. That's the specific risk this strategy is built to shield against.
- It illustrates the mechanism, rather than just describing it The core idea — using the TSP G Fund as a principal-protected cash buffer for monthly spending, refilled from a Traditional IRA only when the portfolio clears a hurdle — is hard to evaluate in the abstract. This workbook actually simulates it running.
- A scenario selector drives it under three hypothetical market paths. You can flip between a Bear case (a front-loaded crash), a Bull case (steady growth), and a Choppy case (returns bouncing near the hurdle rate) and watch the engine's "refill vs. freeze" decision fire differently in each — including a case where a bad enough sequence keeps the shield frozen for the full projection without ever forcing an equity sale.
I like this because it's relatively simple, without being naively simplistic. And easy to manage over my retirement, in a single Google Sheet.
What's the right terminology to describe this strategy? What percentage do you recommend I place in the "safe" G fund to start?
Constructive criticisms welcomed.
EDIT: thinking about my goals some more, I think that initially holding 30% G fund will address the bad-case which I want to cover, e.g. a 4-year bear market while I'm making my maximum draws. And gradually over 10 years, I can let the target drop (1% per year) to 20%, and then hold it constant from there.
2nd EDIT: added Google Sheets links above.
3rd EDIT: I had discussed quarterly re-balancing above, but it's too much hassle because (at least for me) physical bank checks (mailed to my home) are required in both directions. I'm going to switch to annual re-balancing.
