This is the heart of the leveraged indexing
strategy. What will a leveraged index
investment do over fifteen years? The
first tab is standard 10% growth, the
second tab is random returns. This model
has some annotation.
http://www.indexroll.com/15-year-model.xls
In 20 years, a leveraged index investment
might be worth 50x its original value,
or it might be worth nothing. We run
1000 4x leveraged investments for 20
years and see what happens. The first
sheet gives averages and standard deviations.
Our investment doubles every 5 years,
on average. Copy the results from the
first sheet to the second sheet and sort
them to find out the percentile rankings.
http://www.indexroll.com/20-year-leverage.xls
The index may be more volatile than
you think. Here are the 30-day, 60-day,
90-day, 120-day, 180-day, 360-day, and
720-day returns for SPY from 1993 to
2007. Then we do a little more analysis
on the 30-day returns to find the "fat
tails". For 35% of the months observed,
the index was down, and for 7.6% of the
months, it was down more than 5%.
http://www.indexroll.com/index-analysis.xls
Simple chart that calculates the average
return and standard deviation of the
SPY index over a one to seven year holding
period and makes two standard deviation
wide bands. For example, the index held
for 7 years will return +95% with a 40%
standard deviation, meaning your returns
will be somewhere between +15% and +174%.
That's a wide range.
http://www.indexroll.com/stdev-calc.xls
This is a model that backtests a dollar
cost averaging reinvestment strategy
from 1993 to 2007. We purchase 6000 shares
of SPY at a very high level of leverage
and then buy $100 worth of shares every
month using debt. The fund returns $18.26
for every $1 invested in 1993, as compared
to $4.06 for the index.
http://www.indexroll.com/leveraged-index-test.xls
This is some neat research. Using leverage
allows you to actually remove a source
of volatility from your returns - the
volatility caused by having varying amounts
of capital invested every month. Here
we test two strategies - one in which
the amount of debt is constant over the
life of the investment, and one where
the amount invested is constant and the
debt varies. Its a random model so you
have to run it a few times to see the
conclusions - that fixed investment strategies
have lower volatility.
http://www.indexroll.com/fixed-investment.xls |