How Much of Your Retirement Money Actually Has to Be Safe? We Built the Sheet

We open a blank spreadsheet and build one, cell by cell, to answer a single question: how much of your retirement money actually has to be safe? Four inputs you already know or can look up in ten minutes, eleven rows, and one number out. For the household we build here it comes to $181,056 against half a million dollars saved — thirty-six percent, not half and not all of it. Your number will be different, because three of the four inputs are yours. We call the number in cell B8 the Bedrock Number, and by the end of the video you will have your own. WHAT YOU'LL LEARN • How to define "essential spending" so the figure means something, and build it from the BLS Consumer Expenditure Survey • Why guaranteed income has two values — one before you claim and one after — and why the sheet needs both columns • The Medicare Part B double-count that catches people: $202.90 a month, counted once, never twice • What three years of delayed retirement credits actually does: 8% a year, and the arithmetic on it • Why the bridge years cost 62% of the whole Bedrock Number, and what that says about waiting • The same model run on a second household with a pension — 4% must be safe instead of 36% • Why "safe" has to mean two things at once, with CPI at 3.4% against a 2.8% COLA • How to run all of it on your own four numbers tonight ⏱️ CHAPTERS 00:00 – Introduction: Why percentage rules (60/40, 100 minus your age) fail. 00:35 – Setting up the Spreadsheet: The Bedrock Number (Cell B8). 01:33 – Step 1 (Row 3): Defining and calculating essential spending ($3,136/mo). 03:20 – Step 2 (Row 4): Guaranteed income and the Social Security delay calculation. 04:42 – The Medicare Part B Rule: How to avoid double-counting. 05:11 – Step 3 (Row 5): Calculating your income gap (Before vs. After claiming). 06:15 – Step 4 (Row 6): Setting bridge years vs. safe cushion years. 06:59 – The Math (Row 7 & 8): Calculating the final "Bedrock Number" ($181,056). 08:28 – Household Example 2: How pensions dramatically shrink the safe pile ($19,800). 09:25 – Analyzing the Bedrock Share: Safe money vs. Risk money. 10:05 – Inflation Caution: Protecting safe money with TIPS and I-Bonds. 10:53 – Summary: Finding your 4 personal inputs and setting your boundaries. ────────────────────────────────── 🎬 HOW THIS VIDEO WAS MADE ────────────────────────────────── The narrating voice is synthetic — generated with ElevenLabs, directed line by line rather than typed and accepted. Narration direction and audio: Ajit S. Research, script, sourcing and editing: A.R.Khole. Visuals: illustrations generated with OpenArt; the spreadsheet, the motion graphics and the source windows built in-house and rendered frame by frame. The model, the definitions and every calculation are ours. Every published figure is shown against the page it came from, and all of those pages are linked below. Please check them. All Source Documents : https://docs.google.com/document/d/1OuA0eHlbuixrtrJoWL50_V7nVuB9I0mhk1nWInvYj-U/edit?usp=sharing ⚠️ DISCLAIMER: Educational only — not financial, tax, legal or investment advice. This video teaches arithmetic and shows where the inputs are published; it does not recommend any security, fund, product or provider, and no figure in it is a suggestion about what you should hold. National averages are not your numbers. Figures are current as of the retrieval dates shown on screen and change over time. Always consult a qualified professional before acting. 🏃 MY OTHER CHANNEL — HEALTHY UNCLE JOHN Gentle exercise & wellbeing for folks 60+. Money is only half of retirement. 👉 https://youtube.com/@healthyunclejohn ❤️ Support the channel — become a member: https://www.youtube.com/channel/UCWugleQL2wqr5N1X4o8yyLw/join ────────────────────────────────── 📲 BUDGET PLANNER PRO ────────────────────────────────── Cell B3 is the one that decides everything else: what your life actually costs each month. Budget Planner Pro is a daily budget tracker plus seven retirement calculators that all read from your one situation. One payment, not a subscription. 👉 https://unclejohnfinancial.gumroad.com/l/BudgetPlannerPro 🎟️ Use code UNCLEJOHN30 for 30% OFF at checkout! #BedrockNumber #RetirementPlanning #RetirementIncome #SocialSecurity #UncleJohnFinancial