April 28, 2021 – Welcome back to another installment of the Safe Withdrawal Rate Series. In the previous installment, Part 44, I went through a number of general tax planning ideas, and I promised another post to introduce an Excel Sheet, I created to help me with my tax planning. There were numerous reader requests a long time ago when I ran the withdrawal strategy case studies (2017-2018) to publish not just the Safe Withdrawal Rate calculations but also the tax planning Excel Sheet. Well, I never published those Excel sheets because a) they were custom-tailored to those particular case studies, b) they potentially included personal information of the case study volunteers and c) they were created “for my eyes only” so I couldn’t really publish them without a massive effort to explain and document what exactly I’m doing there.
But now (with a three-year delay!) I’ve finally come around to creating something from scratch I feel comfortable publishing for a broader audience. It’s not a Google Sheet, but an MS Excel Sheet, more on that later. It’s probably still not a universally applicable tool. And most importantly, it’s a tool that still requires a lot of Excel Spreadsheet mastery. It will not spit out “the” optimal tax strategy, it will only help me (and maybe you) find that optimal tax strategy. A lot of handiwork is still necessary! Much more handiwork than with Safe Withdrawal Sheet (and even that is already a handful!).
So, I like to go through a simple case study to show how this sheet works and showcase how you can “hack” your withdrawal tax optimization strategy in that one specific case. Even aside from tax optimization, the sheet helps me gauge what’s the average effective tax rate throughout retirement, to help me figure out how much of a gross-up I have to apply to translate a net-of-tax retirement budget into a pre-tax withdrawal percentage.
I can’t foresee what exact tax challenges you might face, but with my tool, I would have been able to handle what came across my desk so far, both in my personal finances and the case studies I’ve done so far.
So, let’s take a look…