A systematic withdrawal plan refers to monthly withdrawals from an appreciating fund, especially to provide retirement income. This study proposes a stochastic algorithm that outputs the initial amount required to sustain a systematic withdrawal plan for a target duration with a 90% safety margin, given an initial monthly withdrawal amount. The systematic withdrawal plan is based on the S&P 500. Initially, a deterministic function modeling a systematic withdrawal plan was created. This study showed that the monthly growth rate of the S&P 500 is normally distributed with a mean of 0.6933% per month and a standard deviation of 4.0266% per month. By randomly sampling monthly growth rate values from the distribution, stochastic simulations were run to identify the distribution of the fund’s longevity. The Kolmogorov–Smirnov test suggested that the simulated values of the fund’s longevity were log-normally distributed. Initially, the algorithm uses the deterministic function to find the 50% safety margin value for the initial fund requirement. Then, the algorithm uses stochastic simulations to find the log-normal longevity distribution. The 90th percentile value of the log-normal longevity distribution is substituted into the deterministic function to calculate the 90% safety margin value for the initial fund requirement of a systematic withdrawal plan.
References
[1]
Shah, T. and Baser, N. (2022) Global Mutual Fund Market: The Turn of the Month Effect and Investment Strategy. Journal of Asset Management, 23, 466-476. https://doi.org/10.1057/s41260-022-00282-0
[2]
Sodini, P. and Viceira, L.M. (2020) The Value of Diversification: Diversification is the Only Free Lunch in Finance. Harvard University. https://scholar.harvard.edu/files/lviceira/files/ap7_annual_report-ps_and_lv-2020-01-29.pdf
[3]
Macrotrends (2024) U.S. Inflation Rate 1960-2024. Macrotrends. https://www.macrotrends.net/global-metrics/countries/USA/united-states/inflation-rate-cpi
[4]
Investing.com (2024) S&P 500 Index Historical Data. https://www.investing.com/indices/us-spx-500-historical-data
[5]
Bristol University (2024) SPSS—Exploring Normality (Practical). https://www.bristol.ac.uk/cmm/media/research/ba-teaching-ebooks/pdf/Normality%20-%20Practical.pdf
[6]
Feng, C., Wang, H., Lu, N., Chen, T., He, H., Lu, Y. and Tu, X.M. (2014) Log-Transformation and Its Implications for Data Analysis. Shanghai Archives of Psychiatry, 26, 105-109. https://doi.org/10.3969/j.issn.1002-0829.2014.02.009
[7]
StatProofBook (2024) Proof: Cumulative Distribution Function of the Log-Normal Distribution. https://statproofbook.github.io/P/lognorm-cdf.html
[8]
The Global Economy (2021) Stock Price Volatility—Country Rankings. https://www.theglobaleconomy.com/rankings/Stock_price_volatility/
[9]
Sullivan, J.H., Warkentin, M. and Wallace, L. (2021) So Many Ways for Assessing Outliers: What Really Works and Does It Matter? Journal of Business Research, 132, 530-543. https://doi.org/10.1016/j.jbusres.2021.03.066