Showing posts with label finance calculation. Show all posts
Showing posts with label finance calculation. Show all posts

Friday, December 27, 2019

How to calculate US 500 Index from 1999 to 2013?

Dec. 27, 2019

退休后如何投资?这是每个人迟早都会面临的问题。传统的模式是60%股票,40%债券, 第一年支取4%,逐年随通胀率增加。这个模式越来越行不通了。其主要原因是,股票与债券已经失去了过去的对冲作用。从前,股票涨, 债券跌。反之亦然。但是现在,两者趋于同步。再者,债券的收益率太低。十年的联邦债券收益率低于2%。

有人提出新的模式,即股票80%,债券20%。问题还是没有解决。如果在退休的最初几年,股市下跌,而你还要提现,你的资金可能支撑不了二十年。众所周知,美国股市2000年开始下跌,经过十三年,直到2013年才超过1999年的水平。如果有人刚好在1999年退休,恐怕股票账户里的钱,到2013就提光了,从而错过了近几年股市的大涨。

Fact? Let me do some homework and show step by step how to solve the problem. 

I like to look into the argument: 
US stock from 2000 to 2013, it takes 13 years to go up more than 1999. 

I like to look into US index for each year from 1999 to 2013, table is copied from wiki page

 Year   change    Total 
          in index   Annual
                        Return
                        Including
                        Dividends
199919.53%21.04%$47.4428.56%18.21%18.93%17.88%17.25%
2000−10.14%−9.10%$43.1218.33%17.46%16.02%15.68%15.34%
2001−13.04%−11.89%$37.9910.70%12.94%13.74%15.24%13.78%
2002−23.37%−22.10%$29.60−0.59%9.34%11.48%12.71%12.98%
200326.38%28.68%$38.09−0.57%11.07%12.22%12.98%13.84%
20048.99%10.88%$42.23−2.30%12.07%10.94%13.22%13.54%
20053.00%4.91%$44.300.54%9.07%11.52%11.94%12.48%
200613.62%15.79%$51.306.19%8.42%10.64%11.80%13.37%
20073.53%5.49%$54.1212.83%5.91%10.49%11.82%12.73%
2008−38.49%−37.00%$34.09−2.19%−1.38%6.46%8.43%9.77%
200923.45%26.46%$43.110.42%−0.95%8.04%8.21%10.54%
201012.78%15.06%$49.612.29%1.41%6.76%9.14%9.94%
2011-0.00%2.11%$50.65−0.25%2.92%5.45%7.81%9.28%
201213.41%16.00%$58.761.66%7.10%4.47%8.22%9.71%
201329.60%32.39%$77.7917.94%7.40%4.68%9.22%10.26%
I will write Excel script to come out the result.

Follow up


Dec. 28, 2019 2:42 PM
It is important skill to learn and then I can quickly calculate the return of S & P 500 index.


I  have over $10,000 us dollars in my 401K account. I should put 60% S & P 500 index, 40% bond, so that in 2002, $6000 S & P 500 index will lose 40% value, $3600 dollars, so I could have sell $1000 bond to purchase equity. So those $1000 dollars will go up to $1260 at the end of 2003, the equity value is $7200, the bond value is $3000. So it is time to think about to sell $1200 equity to purchase bond.

1999
2000 first dip, buy low (10% loss - rebalance)
2001 second dip, buy low (13.14% loss - rebalance)
2002 third dip, buy low (23.37% loss - rebalancne)
2003 bull market, sell those purchase completed in 2000 to 2002.
2004
2005
2006
2007
2008
2009
2010
2011
2012
2013

Every year S & P 500 index has dividend around 2%, so 14 years total return is (1 + 0.02)^14 = 1.3194.

As a long term investor, it is not difficult to figure out that those over $10,000 401 K investment in early 2000, I should have generated at least over 30% dividend, and also market value goes up at least 46%; and also if I have learned how to rebalance the portfolio, then I will buy low and sell high. Those recession from 2001 to 2002 is great time for me to time the market to purchase and sell in 2003 bull market. 2003 I will have 26% profit for additional purchase.