Forum

Update (12/31/2022):

It seems that new users have trouble registering for the forum. The confirmation email never shows up. I’ve decided to phase out this forum and transition over to a new forum plugin. The new location is here:

https://earlyretirementnow.com/forum-3/

Policies – please read!

  • Everyone can read posts, but to start a new topic or add a reply you’d need to register. To create an ID, please verify your email address. You will get a link at that email address and you can then pick a password.
  • Be courteous to others. Treat others like you like to be treated. Discuss the issues. No ad-hominem attacks!
  • It’s OK to include external links if they are relevant. But please avoid spamming! Please no affiliate links.
  • Before starting a new topic, please check if that question/topic has been discussed before already and add to that discussion instead of starting a new topic.
  • If you’ve written a cool blog post that you want to share with others please post this in the “Self-Promo” category only!
  • Please read the usual Disclaimers and the Privacy Policy!
  • The forum policies may be amended in the future!
Notifications
Clear all

SWR Toolbox formulas

2 Posts
2 Users
2 Reactions
5,307 Views
Posts: 5
 jt17
Topic starter
(@jt17)
Active Member
Joined: 5 years ago
[#157]

I was using the excellent SWR Toolbox 2.0 workbook and, somewhat by accident, came across two things I would not have expected:

1. In the Parameters, setting "Project Future Real Returns" values to 0% (or near-0%) still yields low-ish failure probabilities and 2-4% failsafe SWRs. How could this be?

2. There does seem to be some formula dependence between the "Portfolio Today" in the Cash Flow Assist tab and the SWR/Failure Rate calcs on the first tab. Why would this be the case? Shouldn't SWRs be dependent only on the Parameters entered, and independent of portfolio amount?

Thanks much


1 Reply
Posts: 349
(@earlyretirementnowcom)
Member
Joined: 10 years ago

Thanks! Both great questions!

  1. All SWRs are still calculated with historical return data. The "project future returns" merely attached some "made up" returns at the end of the simulation of some of the cohorts. Say, you run a 60-year horizon simulation and the 1965 cohort uses actual data 1965-2020 and then the "made up" data 2021-2025. That would have a tiny impact on the SWR. Sequence Risk implies that the later returns during the last few years of the retirement have essentially no impact on the SWR
  2. The cash flows are entered in $. The SWR in %. If you have a $2,000 future Social Security payment starting 20 years into your retirement, then that will raise your sustainable retirement budget. But the % impact differs depending on your portfolio size. In % terms, it makes a difference if a fixed $2000 future income is spread over a $1m or $5m portfolio.

Reply
Share: