 Welcome to episode number four, the Bogleheads Life Stages podcast. Bogleheads are investors who follow John Bogle's investing philosophy for attaining financial independence. Today's episode features Jim Richmond, designer of the flexible retirement planner. This recording was made on March 24th, 2021. Nothing in this video should be construed as personalized investment advice. Well, you know, what about retirement? What about, you know, how much do I need to have saved? And I started looking around and I put the, I wanted something that had implemented variable withdrawal. I was looking for a calculator online that had just some sort of decision rule. I had read some recent paper, there's I think Goyton, Jonathan Goyton had had written about how to kind of, you can get a slightly higher withdrawal rate with a good probability of success if you have some decision rule in the withdrawal process that adjusts the withdrawal based on how well the plan is going. So if you have a bad sequence of returns, you could maybe cut back spending a little bit. And if you allow that in the model, you end up with a higher withdrawal rate supported for a given probability success or given success rate for the retirement plan. So anyhow, I couldn't find that calculator. So I decided to put this one together and I initially just did it on a whim, but I posted it to the web and did get some some positive feedback about it. And after six months or a year, I decided to turn it into a business and and have done it. Okay, so right now you should be seeing or within a few minutes seconds, you'll be seeing the main page for the flexible retirement planner. This is what you get if you hit new plan up in the top left, it resets all the inputs to their defaults. Let me see if I can. And the inputs to the plan should be relatively straightforward, current age, retirement age, life expectancy. For this demo, I'm going to start out, we'll assume the retirees 40 years old. They are the person using the planner and the retirement age 65 and the life expectancy 95 will say 3% for inflation, we'll leave it at the default. These income tax income tax and investment tax rates should include state tax and federal tax any local income tax if it's if it's all if it's paid. And then for portfolio value, we're going to say that there's currently a $300,000 $300,000 tax deferred portfolio. By the way, this min IRA 401k withdrawal age trips people up sometimes I'm actually in the next release going to move that into settings just because it gets in the way. Basically, that's the minimum penalty free IRA 401k withdrawal age. So most people never need to touch that. And that's part of why I'm going to move it to settings. So just so you don't get tripped up on that. And then I'm going to say that this for this plan, this person, this 40 year old is going to put $15,000 away every year in their tax deferred annual savings. And then the other inputs we have investing styles and I'll just leave it at the default when these are sort of canned portfolios that have given this investment mix. I strongly suggest folks take a look at the Simba's back to testing spreadsheet. That's a great a great resource for figuring out for your own portfolio. What's what's a good, you know, what's what's a good return and standard deviation to use. But you could use these can ones at least to get started. By the way, I guess I should do the standard disclaimer. I'm not a financial planner and I'm not an investment expert. So nothing I say should be interpreted as investing advice or financial planning advice. I do know about the tool and I'm happy to answer questions about, of course, how to model things that you'd like to model in your financial plan. But I can't provide any kind of help or advice on on the financial planning side. Next, we come down to retirement income. And in this case, we'll say that that there's going to be a $25,000. Retire annual retirement income, let's say it's a couple, a couple and they're both the same age and they're going to start at age 67. Earning that withdrawing from that Social Security or taking that Social Security income. Retirement spending is $50,000. And the spending policy is again that decision rule that I talked about. And I'll get into the details of this later, but we'll leave it at the default for now. And then we'll hit run. And so what we see with this set of inputs, we have a fairly robust plan on the left. You see the graph, which the purplish bars are the tax deferred portfolio. The blue bars are the taxable portfolio. And the reason that we're seeing this change over from tax deferred to taxable is that RMDs are kicking in automatically at age 72. And so that's that's why we're seeing the tax deferred portfolio decreasing. On the right hand side, we can see the probability of success is 99%. We run 10,000 paths through the retirement. So basically that's going to draw 10,000 different unique random sequences of return. And based on those sequences of return that we draw one for each year of the retirement plan, there we're going to have a varying result. And so in this case, we ran 10,000 paths through the plan. And we had probably between 50 and 100 failures to get a 99% probability of success. And the average spending shortfall is 16%. And that's really just a metric. I think it was Masha Malewski had some research that was basically wanting to try to quantify when the plans fail in a Monte Carlo simulation, how bad is it? Is there a way to tell plans that fail earlier versus plans that fail later? And spending shortfall tries to do that so that if you had two different retirement plans with two different sets of inputs and they were both showing a 90% probability of success, one still may be more robust than another if it turns out that the failures happened earlier in the plan for one compared to the other. And that's what's average spending shortfall. It says just looking only at the failures, how much of the spending that was intended to happen in that plan got a chance to happen before the portfolio ran out of money. And so with this 16%, that means 85 on average, even with the failed plans, they made it 85% of the way through the retirement before the portfolio ran out of money. And again, we're only talking about 50 or so failures here, given the 99% probability of success. But for those 50 failures, even they made it about 85% of the way through retirement. That's what the spending shortfall is telling you. The other thing I want to talk about here, the initial portfolio value. The other values are median values. So portfolio value at retirement is 1.5 million median ending portfolio value 2.5. And so the way those medians are pulled, we do 10,000 simulation paths and we sort the results. So we have basically 10,000 ending portfolio values to deal with. How do we display that most effective, sort of easily to understand approach is to show the median. And that would be sort all 10,000 results in a table and then choose the result at row 5,000. That's how we would pull a median out of that. So again, 10,000 results, sort them in ascending order and then pull the middle one, the 5,000 one. And that's what we see here. Just to give it a little further on that, if we click this checkbox that shows the portfolio value bands, notice that we see the lines here are showing the lower and upper band. And that's the 10% and 90% percentile bands. And we can see that 7 looks like about 800,000 is the bottom 10% value and about 7 million is the top 10% value for the 90th percentile value. So the bottom value is actually, again, and if you think of that sorted table with 10,000 ending portfolio values, the median is the 5,000th, the bottom 10% is actually the 1,000th row and then the top 10% is the 9,000th row in that table, again, sorted in ascending order. So that gives you an idea of the variation that we have. The simulation is not producing one result and says, hey, here's your answer, you were done. It's actually producing a large amount of output. And the job is to try to consolidate it into something that's understandable. And the other thing I wanted to draw your attention to is this percentage of expenses funded. We've got the flexible spending policy selected. That's the one with the decision rule. But because this is such a robust plan, we're actually funding between 97 and 113% of expenses. So we're not having to cut back our spending much more than just a few percent here on average in the retirement plan. The other thing that I wanna bring to your attention is the detailed view table. This is a year-by-year table that allows you to see the result. Oh, by the way, the results both in the summary view and in the detailed view table are all shown in present value dollars. So the planner takes inflation into account and all of these amounts are adjusted for inflation as we go through the plan, but they're shown in present value non-inflated dollars. So the ending portfolio value will be a much greater amount in nominal dollars, but it will have spending power of 2.5 million in today's dollars. And the detailed view is the same way. So all of the results in the table and the simplest way to kinda grasp this I think for many people is that the new investments and the retirement spending are actually adjusting for inflation. So they will increase every year in nominal amount, but notice in the table, they show as being flat. And that's because they're exactly keeping up with inflation. And because we're showing this in present value dollars, those amounts stay stable, stay steady from year to year because they're exactly keeping up with inflation. If an amount is growing greater than the rate of inflation, it will increase from year to year in this table. And if the amount is growing less than the value of inflation, it will decrease. So we can see here at the retirement year at age 65, we see the cash flow situation starts to change. We go from putting 15,000 a year into our deferred account to now at age 65, we start planning to take $50,000 out of we need 50,000 of spending. And so you'll notice here the total withdrawal is actually 625, which is because the planet's grossing that up in order to account for income taxes that are gonna be due on that tax deferred withdrawal. The other thing I wanna bring your attention to is on the right hand, the right most column is the probability of success and the number of failures in parentheses. So the probability of success is a cumulative number as you go from row to row or year to year. And then the number of failures in per end are the number of times out of 10,000 that the simulation ran out of money in that particular year. So you'll see we start to pick up some failures starting at age 80 even, we have one. And so it still shows a hundred percent because out of 10,000, it's just a rounding error when you only have one failure out of 10,000. But you'll notice as we kind of go there, go down the list, we get more and more failures until we finally get enough 50, we probably need to get from 100 down to 99. I assume it's rounding down there. And so we're seeing the failures here from year to year just as an indication of kind of how things are going, what's happening. And also wanna show more details in this table you can see even more. Now this can get overwhelming pretty fast, but it's a lot of data. And basically one of the things that you can see here in this additional detailed table is that we start to look at age 72, we start pulling RMDs out. And you can kind of track what's going on with required minimum distributions from the tax deferred account. So we start with, and we've got the amount and the taxes and then how much available for expenses. It looks like we don't need to take any withdrawal out of the portfolio because of the RMD is greater than what we need. I believe, yeah, no additional withdrawal needed. Now this table can be a little overwhelming, but if that's not enough data for you, you could right click on any of the column headers and you can say show all columns, which will give you even more data. And the idea is that I'm just basically dumping all of the information that I have in the simulation. And if you right click on any cell, you can copy it to the clipboard or export the table and it'll paste right into Excel. I'm sorry, yeah, right click on this and this will paste into Excel. So you can then manipulate it and manage it a little bit easier. Okay, I wanna go back to the summary view. And let's say, because this plan is so robust, let's see what happens if we lower the retirement age, see if maybe we could retire at 60. Then we run it again. And now we notice this is we get a 93% probability of success, so that's not bad. But the stoplight is yellow, not green. And the reason for that is because it's just indicating that the percent of expenses funded varied because of the flexible spending policy down as low as 86%. So you might have had to take a 15% reduction in spending in some of the runs of this particular set of inputs in order to get that 93%. And we can configure that by going into settings to see if what the minimum amount or the maximum amount of spending cut we're willing to take. So the minimum default is 75%. So we're actually by default, the spending cut could be as big as 25%. And that's deployed gradually over the simulation as the portfolio is continuing to decline. Basically a really unlucky bad sequence of returns happens. The planner will knock back a couple of few percent off of spending every year until it gets down to 75% of the desired spending and then it won't knock back anymore after that. But we can adjust this and so let's set this to 90%. So that we're willing to be flexible but not that flexible is what we're saying here with this 90% minimum expenses to fund. So we're doing again, we're using that decision rule but we're only willing to cut back 10%. And let's see what that does. We had a 93% probability of success and then we had the spending getting cut down below 90. We've run it again. Now we've dropped the probability of success because we're not willing to be as flexible but we see that we're maintaining that 90%. So let's see if maybe if we up the retirement age by a year, does that get us to a 90? And I'm picking a 90% just as a random amount, people, everyone has to sort of choose what amount of success is adequate for them. But notice now, so we can kind of model that, all right, now we've got the green light because we've got a probability of success of 90% and we also are not having to cut back more than 10% in order to get that 90%. So that's just a general overview of the retirement flexible spending model. Now notice if we chose the stable spending and we were completely unwilling and unable to cut expenses, we wanted to exactly fund what we asked for until the portfolio runs out of money, what happens then. And notice we dropped back seven or so percent. So that flexibility got us a pretty decent boost in terms of the robustness of the plan. And that's what we're trying to model there. Okay, next I wanna move on to a feature called sensitivity analysis. And this is a feature that lets you take a look at varying the parameters of the plan in a way that saves you from having to make a change, hit run, make another change, hit run and try to make sense of all the different data. For instance, by default, this is set up to look at the portfolio return standard deviation as parameter one and the annual retirement spending as parameter two. And so we're gonna vary the return and this is a case where we're gonna have the portfolio return and standard deviation march in lockstep. So we're gonna have 3% return with 2% standard deviation all the way up to 12% return with 18% standard deviation. And then we're gonna have spending vary from 40 to 90,000. So then we'll see what this generates. So we're running the simulation actually about three or 400 times here. These are three or 400 times we run the simulation each of those times we use a different set of parameter one, parameter two inputs and you can see those up here. The right hand panel is showing you the results of one of those 300 simulation runs. And so we're at this top square but we could also select another square by clicking on and we see what were the parameter one and parameter two values. We had a return of 10 and a standard deviation of 14 for retirement spending of 50 and 93% probability of success. So we can get an idea here of what kind of return we need and what kind of spending we can support. And it looks like with this model where we can just about support 56, 57,000 or so if we want a 90 something probability maybe even up to 60 or 65 if the return if we assume a really high return. But the idea here is just to let you kind of explore variations in the inputs. Let's do this again only this time let's say we're wondering about what we should put down for the inflation rate and we're just, you know how careful do we have to be about figuring out what inflation to use. And so we maybe we'll put 1% as the minimum and 4% of the max. And then for the second parameter let's say we're wondering about income tax you know how much sensitivity do we have in our plan to changes in the income tax rate. And because we have so much in tax deferred this is gonna matter a lot because those tax deferred withdrawals are taxed at the income tax rate. Let's run this. And now we're seeing again those three or so hundred runs and getting an idea of if we vary these two parameters what does it look like? You can see on the X axis we've got the inflation rate increasing from 1% to 4% on the Y axis we've got the income tax rate increasing from 10% to 50%. And so we can just get an idea now now with one view and we can see what the results are with these varying inputs to get an idea of what how that is gonna work out. Great. And the last thing I wanna go cover on the planner is another feature that helps with the flexibility is the additional inputs. And so we get to additional inputs by clicking on the additional inputs button here. And in this case what I'm gonna do is let's just say that this plan is actually for a married couple and they're not the same age. So I'm gonna zero out this annual retirement income on the main input page. And instead I'm gonna put it in on the additional inputs page here in the bottom. And I'm gonna say starting at age 67 the older spouse is gonna start collecting their social security and they're gonna get 12,500 for their annual social security. And we're gonna say it's 100% taxable. And we'll say this is John's John's social security, we add row. And now we have John's spouse is Mary and Mary's two years younger than John. And she also wants to have her social security start at age 67, but because we're gonna key all of the ages in this plan off of the older spouse. So when John turns 69, Mary's gonna start collecting her social security. And so now we have social security for two. Notice that we've got it set up that it's automatically gonna track inflation and we have it at 100% taxable. And so now we go back to the main planner window. And if we run this again, we notice there's a slight drop in the probability of success because we had one of the spouses taking that social security two years later. We bumped the retirement age up. We can get it back up to over 90%. And again, I'm just using that. That's kind of for me, I like to see over 90, but everybody's gotta make their own rules about what works for them. The other thing you can model with this is if you wanna do one-time spending, maybe like you might have a missed income. And let's say that we wanna downsize our house and we're gonna plan to do that at age 80. And so we'll say, we'll have a one year cash flow. The start age and the end age will be the same at age 80. And then we'll say that we're gonna net, maybe this will be sell the house that's out in the country and move into an in-town apartment or condo. And doing that, we're gonna net $350,000. So that will be the amount of the cash flow. And let's say that we're gonna have to pay tax on that whole amount at the tax rate. Again, we could adjust this and put a net amount in here and say the taxable rate is zero. If that's easier, depending on how complicated the taxes are gonna be, maybe it wouldn't wanna, maybe this mortgage or this house sale wouldn't be taxed at our normal income tax rate. So we might wanna adjust that and just do the calculation kind of offline sort of and put the net amount in here. Either way could work. And we'll say sell downsize and we add a row. And so now we go back to the main planner page and we run again. And now we can see that we've got a much higher probability of success. We probably can support that 60 year retirement again. And we can see that this bump in the portfolio right at age 80 when the house sale kicks in when the downsizing kicks in. So that extra cash flow goes into the taxable portfolio and you can see it turned it into a much more robust plan. Another thing you might wanna try in here and we're getting down to the end. Let's say that starting at age 70, age 85, we wanna simulate higher expenses because of maybe some medical things. Now maybe we just wanna try this out and see what happens. It might not necessarily be what we're gonna plan for real but we could explore this with a say $20,000 expense. And let's say this is a medical expense and we don't even need to come in it. We put that in, we go back to the main plan and run it again. And notice we now are down a little bit on the probability of success. We're still increasing but not as quick of a rate again after the house sale kicks in. One last thing we could try here. If we just wanna, again, we're kind of playing around and we maybe wanna explore what happens if we just have really bad luck and we have a stock market crash at age 75. So 10 years in, the stock market does really badly. Now of course the simulation because it's running this a random return, random sequences of return 10,000 times we are going to get stock market crashes randomly dispersed through the whole simulation but we're gonna just force a crash at age 85 and we're gonna force it to be minus 25% with a standard deviation of zero. So it's definitely gonna happen. And so basically we're overriding the portfolio return to make sure that we get this crash to happen at age 75 and let's see what that does to our plan. Now we see we have the stock market crash at age 75 drops the portfolio down quite a bit. We kind of chug along for a bit then we have the house downsizing which brings us back up and now we're kind of doing okay for the last part of the retirement. So we did manage to work through that it appears at least based on this model. And so that's just to give you an overview of the kind of things that you can do with the retirement planner. And again, there's a lot of...