Report this item to Etsy

TSP Calculator & Military Retirement Planner Spreadsheet | BRS vs High-3 Pension, TSP Projection, Match Pacing | Excel and Sheets

Low in stock, only 1 left

Price:$29.00

Loading
Includes Etsy Purchase Protection

You can only make an offer when buying a single item

Highlights

  • Digital download
  • Digital file type(s): 1 File

Two retirement systems, two multipliers, one TSP — and a match you can accidentally throw away. This planner puts your whole military retirement picture on one dashboard: pension under BOTH systems, your TSP projected to retirement, and a pacing tracker that makes sure you never lose match money by maxing out too early.

Built by a Navy veteran. Every number shows its math.

YOUR PENSION, BOTH WAYS, SIDE BY SIDE:
• Enter years of service and your high-3 average pay — the sheet computes Legacy (2.5% per year) and BRS (2.0% per year) monthly and annual pensions next to each other, with the dollar difference spelled out
• COLA projection shows your pension at retirement, +10, +20, and +30 years
• Sample from the sheet: 20 years, $5,800 high-3 → Legacy $2,900/mo vs BRS $2,320/mo — a $580/mo difference you'd never see on a single-system calculator

YOUR TSP, PROJECTED HONESTLY:
• Year-by-year projection of balance, your contributions, the match, and growth at your assumed return
• Roth vs Traditional split estimated and shown separately
• Same sample continued: $86,000 today, $14,800/yr going in, 7% return, 6 years → $234,932 at retirement

NEVER LOSE THE MATCH:
• The BRS match is paid per pay period — max your TSP in November and the match stops with your contributions. This tracker paces you: enter your annual goal and it calculates the exact per-pay-period amount to finish on the LAST period, not before
• Early-max warning in plain English if your current pace hits the IRS limit too soon, plus a shortfall warning if you're behind
• Match calculator: enter basic pay and your contribution % — it shows the 1% automatic, the matching dollars, and flags you if you're contributing under 5% and leaving match money on the table

CURRENT NUMBERS, BUILT IN:
• 2026 IRS limits verified (elective deferral $24,500; catch-up $8,000; ages 60–63 $11,250) — and every limit is an editable yellow cell, so you update it each January in seconds

YOU RECEIVE: 1 Excel workbook (.xlsx) with 6 tabs — Start Here, Dashboard, Retirement Pay Estimator, TSP Projector, Contribution Tracker & Match Pacing, Settings. Works in Microsoft Excel, Google Sheets, and LibreOffice. Yellow cells are the only inputs; everything else calculates itself. A complete fictional sample is included so you can see it working — replace it with your own numbers.

SCOPE: Built for regular active-duty retirements under Legacy/High-3 and BRS. It does not model Reserve/Guard point-based retirements, disability retirement, or CSB/REDUX.

IMPORTANT: This is a planning and education tool. All figures are estimates based on the numbers and assumptions you enter — not financial, tax, or legal advice, and not affiliated with the TSP, DFAS, or the Department of Defense. Verify pay, limits, and rates at tsp.gov and dfas.mil before making decisions.

Digital download only — no physical item will be shipped.

© 2026 VetFlipsCo — All rights reserved.

This product is licensed for personal use only. You may use it for yourself and keep backup copies for your own use. You may not resell, redistribute, share, give away, rebrand, or claim this workbook — or any modified version of it — as your own product, and you may not upload it to any sharing, resale, or file-hosting site. If you received this file from anywhere other than the VetFlipsCo shop on Etsy, it is an unauthorized copy. Buyers who purchase from VetFlipsCo receive updated versions when rates, limits, or rules change.

ALSO AVAILABLE IN THIS SHOP — THE MILITARY TRANSITION BUNDLE: This workbook is one of four in the Military Transition Bundle (VA Claim Tracker, TSP Retirement Planner, PCS Move Planner and Tap Checklist). Get all four for $89 instead of $116 bought separately: https://www.etsy.com/listing/4619429884/military-transition-bundle-va-claim

Instant Download

Your files will be available to download once payment is confirmed.  Here's how.

Instant download items don’t accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.

Etsy Purchase Protection
Shop confidently on Etsy knowing if something goes wrong with an order, we've got your back for all eligible purchases — see program terms