On May 10th, I’ll be presenting my work on Roth conversions at Financialexpertsnetwork.com.
I’ll be working through one of my spreadsheets during the presentation. It can be downloaded here: http://www.edwardfmcquarrie.com/wp-content/uploads/2022/05/Roth-conversion-worksheet-for-financial-experts-webinar.xlsx
A similar worksheet was the focus of this Bogleheads forum: https://www.bogleheads.org/forum/viewtopic.php?f=10&t=358688. In that forum I work through quite a number of permutations.
where can i find the webinar that walks through this spreadsheet?
It’s at financialexpertsnetwork.com, financial advisors, past webinars (late May)
Where can I find this chart updated for Q1 2023 sourced to you? https://www.cnbc.com/2023/01/07/2022-was-the-worst-ever-year-for-us-bonds-how-to-position-for-2023.html
Thank you very much.
Hi Kevin: I haven’t updated the chart with 2023 data as yet. Bonds bounced a bit in the first quarter; whether they will plumb new lows in 2023 remains to be seen. FWIW, I track TLT or VGLT for long bonds, BND for total bond, and VCIT for intermediate Treasuries. Any of the ETF charting sites on the web should allow you to perform your own update on the chart.
I have not had a chance to look at your spreadsheet. So, is that the tool that’s used to run scenarios or is there software that analyzes Roth conversions using the factors that you discuss in your article that appeared in the Journal of Financial Planning ?
Hi: No software, that’s not my skill set or interest. Rather, the spreadsheet lets the reader of the JFP article play with alternate assumptions, and probe the tables in the article.
Does the spreadsheet link still work ? Nothing happened when I click on it ? Thanks!
Browsers can be finicky: try this one instead: https://github.com/emcquarrie/Roth-conversion-spreadsheets