You just retired and will live off your savings and investments. You have 2 portfolios to choose from: Portfolio A should have 8% vol and 6% geometric return Portfolio B should have 12% vol an 6.5% geometric return Which should lead to more wealth to pass to future generations?
-
-
I am most interested in the fact that you appear to be using Excel on an iPhone. Tell me you work in Finance... etc.
-
In this house we know how to party (note that I don’t have powerpoint, I’m not a b*nking an*lyst)pic.twitter.com/53DSTESkWA
- Show replies
New conversation -
-
-
I'm fine assuming lognormal returns as the generator, but because of the withdrawals, the distribution of the wealth for the investor wont be lognormal in 25 years.
-
We agree that without flows the 25% percentile is lower for B than for A after 25 years then. Do you think that adding fixed distributions is going to change that relationship? Why? It would be interesting to see an example.
End of conversation
New conversation -
-
-
You can also replace the .25 with RAND() and convert the annualized GEOMEAN and STDEV to daily periodicity, drag down a bunch of rows, and generate a parametrized sequence of returns. Do that across a bunch of columns and the ergodicity people yell at you for building a monte.
Thanks. Twitter will use this to make your timeline better. UndoUndo
-
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.