Thank you very much for posting these -- I've been making the rounds of brokerage sites but they're so busy trying not to scare people that their MC simulators aren't that useful to me.
You have to use Excel, because Google Sheets doesn't have the Data Table function used to construct this. You can download it at facpub.stjohns.edu/~moyr/MonteCarloRetire.xlsx
Hi Ronald - great video! Is there a way to have the end balance replications (I believe at year 30) displayed in the Google Sheet similar to how you displayed them in Excel in your video here Thank you!
Thank you very much for posting these -- I've been making the rounds of brokerage sites but they're so busy trying not to scare people that their MC simulators aren't that useful to me.
super cool can you share that google doc by chance?
You have to use Excel, because Google Sheets doesn't have the Data Table function used to construct this. You can download it at facpub.stjohns.edu/~moyr/MonteCarloRetire.xlsx
Hi Ronald - great video! Is there a way to have the end balance replications (I believe at year 30) displayed in the Google Sheet similar to how you displayed them in Excel in your video here
Thank you!