A new update for the retirement simulator Version 8.0 has been posted to the website. See link below for new version
Version 8.0 Rev D Public Version
|Added Countif to count number of lives that match EOL for more accurate probability. Old method overestimate success by a small amount.|
|Cleaned up formating and some updates to the simdata page|
|Added status update on progress with run time in seconds|
Version 9.0 Rev D Private Beta
Version 9.0 is in Private Beta and may not be available on the public download page. Version 9.0 includes additional features such as the Retirement Saving Histogram and includes an option for wage growth above inflation. It also includes a warning before running with an estimate time as well as much improved VBA code.
We also made some significant updates to version 9.0 of the simulation tool including speed improvement of 40% over Version 8.0. If you have already received the link to Version 9.0, that link should still work. Contact us if you need a new link.
If you have not Subscribed to the website, Subscribe below now and we will send you the link to the Private Beta version.
Sign Up Today!
Revisions for Version 9.0
|Added wage growth in options|
|Adjust annual savings for inflation and wage growth|
|Adjust income need for wage growth (already had inflation), assume wage increase allow some income inflations based on savings rate|
|Added probability of success initial savings would meet 4% SWR|
|Added Initial Warning for simulation run time|
|Added simulation progress status|
|Changed sheet over to Reference Names and updated VBA|
|Improved simulation data sheet with general cleanup|
|Improved speed of simulation macro|
40% Improvement, 10,000 life times reduced to 81.9 seconds from 136.9 seconds running on a Surface 3 Pro.
|Added countif to count number of lives that match EOL for more accurate probability. Old method overestimate success by a small amount. Adjusted for number of runs vs. fixed to 1000|