Hi Bill! I am up late reading because I can’t put down your new book! I am learning so much and appreciate all of your examples. Is there a tool or formula where we can add inputs to create a synthetic CWR template for our personal plan so we can monitor against our actual CWR? Such a powerful tool! Thanks again for all of your hard work.    D.

 

Dear Deb,

Thanks for your note. I am glad you are enjoying the book.

As it happens, I have nearly completed a “Synthetic CWR Creator” using an Excel spreadsheet, which I plan to post to this website the week of August 11. It will allow you to “play with” several variables, including planning horizon, account taxability, asset allocation, starting account balance, legacy, and first-year withdrawals. It’s based on constant, unvarying investment rates of return and inflation, which is not completely realistic, but it is how the Synthetic CWR is constructed. We don’t want any bull or bear markets in the Curve, just a smooth graph during retirement. It also has a chart you can use to track your actual CWR performance against the synthetic CWR, year by year.

Please let me know how you like it.

Best regards,

Bill Bengen