Forum Discussion
How to Account for Inflation
scrail2004ā "Thus, my balance will be worth less, adjusted for inflation, than it is today. Does that make more sense?"
Well, yes. But on the other hand, common sense would have told you that much.
If I might offer an observation, I think a more useful spreadsheet (to the extent you want something that might help in planning or budgeting) would make visible--i.e., in columns dedicated to them--those "assumptions about growth rate, monthly distributions, Roth conversions, taxes, and medicare expense" rather than hiding them behind whatever it was you did to come up with the column B numbers.
The real spreadsheet I have, on which I based my first example for you, is actually something I use to project income and expenses in my retirement years. (I retired 23 years ago (am now in my early 80s.) Both my wife and I have (non-Roth) IRAs, from which we get the Required Minimum Distributions; we both get Social Security payments; occasional, minimal outside income; then we have our various living expenses. Each of these has a column in a spreadsheet; the spreadsheet has one row per year, going into the future; I have assumptions about Cost of living increases (AKA inflation), assumptions about investment growth, in the IRAs, assumptions about annual SocSec changes, etc. That spreadsheet has proven very useful in helping us know how much we need to tighten our belts, or whether or not we can afford a nice vacation trip......
I also have another workbook into which I enter (download) data from banks and credit cards, to track in detail AC:TUAL income and expenses by category.
So it's not clear to me where this spreadsheet you're creating fits into the bigger picture of your own financial planning, but there you have some possible things to consider.
True! Common sense did tell me that. But I want to graph the projected value of the IRA against an inflation projection, based on which I will adjust my distributions to maintain an inflation-adjusted target balance for my heirs. That was how this whole workbook started for me. Of course, it got more and more complicated as I delved into it.
You and I think very much alike. Below are the column headers of the worksheet I am working on. I've included most of the items you mention - IRA projected growth, distributions, conversions, taxes, etc. It calculates my taxes based each income source and projected changes in the Fed and CA tax brackets and deductions, Medicare premiums based on those brackets (and projections), and Social Security based on a growth projection.
The final column gives me my "net net income" - post-tax, post Medicare premium...the money on which we will actually live (and hopefully travel).
Going forward, I'll adjust the next year's distributions based on market performance to maintain the targeted inflation-adjusted IRA/Roth IRA balance.
PS - I also track expenses by category. :-)
- mathetesNov 22, 2025Silver Contributor
Here's a Federal tax calculator I've created, mostly for fun....it's accurate up through the most recent tax tables.
- scrail2004Nov 22, 2025Brass Contributor
Great! I'll study it. It'll be good to double-check my calculations.