Originally Posted by Sunset
Attached is the spreadsheet in case anyone wants to play with it, changing
the factor or the growth numbers.
Many thanks to target2019 for the formulas.
Thanks for your modifications.
Last evening I came across an older xls spreadsheet that was created by Peter Ponzo, aka Gummy. His ss randomizes returns for 40 years, and you can modify several inputs.
He also added some modifications that I requested at the time, to account for additional factors. This included continuing to invest new money for a given number of years.
You can alter many more factors than with a straight line prediction of the future. I can't vouch for the correctness or appropriateness of this spread sheet for anyone's situation. It does contain and use his macros. I have saved it as a .xlsm file. Unfortunately, that can't be uploaded here. It is available through my gdrive, here is the link
. It has been scanned with Malwarebytes and Mcafee.
Download the file and check with your antivirus to be safe. If/when you open it with Excel, if you get macro warning and don't want to proceed, then by all means, stop there.