This portfolio backtesting tool allows you to construct one or more portfolios based on the selected asset class level allocations in order to analyze and backtest portfolio returns, risk characteristics, drawdowns, and rolling returns. You can compare up to three different portfolios against the selected benchmark, and you can also specify any periodic contribution or withdrawal cashflows and the preferred portfolio rebalancing strategy.
You can also use the portfolio backtesting tool to build and compare portfolios based on specific mutual funds, ETFs, and stocks.
Asset Class | Allocation |
---|---|
US Stock Market | 40.00% |
Cash | 5.00% |
Total US Bond Market | 10.00% |
REIT | 40.00% |
Gold | 5.00% |
Save portfolio » |
Asset Class | Allocation |
---|---|
US Stock Market | 35.00% |
Cash | 5.00% |
Total US Bond Market | 20.00% |
REIT | 35.00% |
Gold | 5.00% |
Save portfolio » |
Asset Class | Allocation |
---|---|
US Stock Market | 20.00% |
Cash | 10.00% |
Total US Bond Market | 40.00% |
REIT | 20.00% |
Gold | 10.00% |
Save portfolio » |
Portfolio | Initial Balance | Final Balance | CAGR | Stdev | Best Year | Worst Year | Max. Drawdown | Sharpe Ratio | Sortino Ratio | Market Correlation |
---|---|---|---|---|---|---|---|---|---|---|
Portfolio 1 | $10,000 | $78,066 | 8.57% | 12.01% | 28.25% | -28.81% | -47.49% | 0.55 | 0.77 | 0.84 |
Portfolio 2 | $10,000 | $71,552 | 8.19% | 10.55% | 25.29% | -24.60% | -41.80% | 0.57 | 0.82 | 0.84 |
Portfolio 3 | $10,000 | $51,798 | 6.80% | 6.59% | 17.52% | -12.15% | -22.81% | 0.67 | 0.98 | 0.76 |
SPDR S&P 500 ETF Trust | $10,000 | $85,299 | 8.95% | 14.39% | 38.05% | -36.81% | -50.80% | 0.50 | 0.73 | 0.99 |
Name | Total Return | Annualized Return | Annualized Standard Deviation | ||||||
---|---|---|---|---|---|---|---|---|---|
3 Month | Year To Date | 1 year | 3 year | 5 year | 10 year | Full | 3 year | 5 year | |
Portfolio 1 | -8.08% | -4.56% | -4.56% | 5.04% | 6.47% | 10.77% | 8.57% | 8.89% | 8.78% |
Portfolio 2 | -6.91% | -4.00% | -4.00% | 4.69% | 5.96% | 9.86% | 8.19% | 7.87% | 7.82% |
Portfolio 3 | -3.07% | -2.33% | -2.33% | 3.77% | 4.24% | 6.96% | 6.80% | 5.01% | 5.15% |
SPDR S&P 500 ETF Trust | -13.52% | -4.56% | -4.56% | 9.17% | 8.37% | 13.01% | 8.95% | 10.86% | 10.91% |
Trailing return and volatility are as of last full calendar month ending December 2018 |
Year | Inflation | Portfolio 1 | Portfolio 2 | Portfolio 3 | SPDR S&P 500 ETF Trust | US Stock Market | Cash | Total US Bond Market | REIT | Gold | ||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Return | Balance | Return | Balance | Return | Balance | Return | Balance | |||||||
1994 | 2.67% | -3.59% | $9,641 | -3.43% | $9,657 | -2.57% | $9,743 | 0.40% | $10,040 | -0.17% | 4.20% | -2.66% | -8.40% | -2.17% |
1995 | 2.54% | 21.32% | $11,696 | 20.74% | $11,660 | 17.52% | $11,450 | 38.05% | $13,860 | 35.79% | 5.71% | 18.18% | 12.13% | 0.98% |
1996 | 3.32% | 22.31% | $14,305 | 19.93% | $13,983 | 12.45% | $12,876 | 22.49% | $16,977 | 20.96% | 5.17% | 3.58% | 33.84% | -4.59% |
1997 | 1.70% | 20.04% | $17,172 | 18.50% | $16,570 | 12.11% | $14,435 | 33.48% | $22,660 | 30.99% | 5.22% | 9.44% | 18.77% | -21.41% |
1998 | 1.61% | 3.84% | $17,832 | 4.35% | $17,291 | 5.23% | $15,191 | 28.69% | $29,161 | 23.26% | 4.97% | 8.58% | -16.32% | -0.83% |
1999 | 2.68% | 8.11% | $19,279 | 7.05% | $18,510 | 4.21% | $15,831 | 20.39% | $35,107 | 23.81% | 4.77% | -0.76% | -4.04% | 0.85% |
2000 | 3.39% | 7.48% | $20,720 | 7.83% | $19,959 | 7.77% | $17,060 | -9.73% | $31,691 | -10.57% | 5.99% | 11.39% | 26.35% | -5.44% |
2001 | 1.55% | 1.62% | $21,056 | 2.39% | $20,437 | 4.09% | $17,759 | -11.75% | $27,966 | -10.97% | 3.70% | 8.43% | 12.35% | 0.75% |
2002 | 2.38% | -4.70% | $20,067 | -3.01% | $19,822 | 2.58% | $18,217 | -21.59% | $21,929 | -20.96% | 1.65% | 8.26% | 3.75% | 25.57% |
2003 | 1.88% | 28.25% | $25,736 | 25.29% | $24,835 | 17.08% | $21,330 | 28.18% | $28,108 | 31.35% | 1.04% | 3.97% | 35.66% | 19.89% |
2004 | 3.26% | 18.03% | $30,376 | 16.29% | $28,882 | 10.95% | $23,665 | 10.70% | $31,116 | 12.52% | 1.32% | 4.24% | 30.76% | 4.65% |
2005 | 3.42% | 8.43% | $32,938 | 7.78% | $31,128 | 6.62% | $25,232 | 4.83% | $32,618 | 5.98% | 3.14% | 2.40% | 11.89% | 17.76% |
2006 | 2.54% | 22.03% | $40,193 | 19.93% | $37,331 | 14.56% | $28,906 | 15.85% | $37,787 | 15.51% | 4.82% | 4.27% | 35.07% | 22.55% |
2007 | 4.08% | -1.95% | $39,411 | -0.70% | $37,068 | 4.08% | $30,084 | 5.14% | $39,728 | 5.49% | 4.56% | 6.92% | -16.46% | 30.45% |
2008 | 0.09% | -28.81% | $28,059 | -24.60% | $27,951 | -12.15% | $26,429 | -36.81% | $25,105 | -37.04% | 1.53% | 5.05% | -37.05% | 4.92% |
2009 | 2.72% | 25.11% | $35,105 | 22.79% | $34,321 | 16.45% | $30,776 | 26.36% | $31,724 | 28.70% | 0.16% | 5.93% | 29.58% | 24.03% |
2010 | 1.50% | 20.27% | $42,221 | 18.64% | $40,720 | 14.59% | $35,265 | 15.06% | $36,501 | 17.09% | 0.14% | 6.42% | 28.30% | 29.27% |
2011 | 2.96% | 5.01% | $44,336 | 5.29% | $42,875 | 5.87% | $37,336 | 1.89% | $37,190 | 0.96% | 0.07% | 7.56% | 8.47% | 9.57% |
2012 | 1.74% | 14.25% | $50,654 | 12.97% | $48,434 | 9.04% | $40,712 | 15.99% | $43,137 | 16.25% | 0.08% | 4.05% | 17.53% | 6.60% |
2013 | 1.50% | 12.62% | $57,048 | 10.61% | $53,575 | 3.40% | $42,096 | 32.31% | $57,073 | 33.35% | 0.05% | -2.26% | 2.31% | -28.33% |
2014 | 0.76% | 17.49% | $67,027 | 15.94% | $62,115 | 10.60% | $46,558 | 13.46% | $64,756 | 12.43% | 0.03% | 5.76% | 30.13% | -2.19% |
2015 | 0.73% | 0.50% | $67,365 | 0.41% | $62,368 | -0.44% | $46,353 | 1.25% | $65,567 | 0.29% | 0.05% | 0.30% | 2.22% | -10.67% |
2016 | 2.07% | 9.02% | $73,438 | 8.22% | $67,496 | 6.01% | $49,138 | 12.00% | $73,436 | 12.53% | 0.30% | 2.50% | 8.34% | 8.03% |
2017 | 2.11% | 11.38% | $81,796 | 10.43% | $74,537 | 7.93% | $53,032 | 21.70% | $89,372 | 21.05% | 0.88% | 3.45% | 4.83% | 12.81% |
2018 | 1.91% | -4.56% | $78,066 | -4.00% | $71,552 | -2.33% | $51,798 | -4.56% | $85,299 | -5.26% | 1.90% | -0.13% | -6.11% | -1.94% |
Metric | Portfolio 1 | Portfolio 2 | Portfolio 3 | SPDR S&P 500 ETF Trust |
---|---|---|---|---|
Arithmetic Mean (monthly) | 0.75% | 0.71% | 0.57% | 0.80% |
Arithmetic Mean (annualized) | 9.36% | 8.80% | 7.03% | 10.09% |
Geometric Mean (monthly) | 0.69% | 0.66% | 0.55% | 0.72% |
Geometric Mean (annualized) | 8.57% | 8.19% | 6.80% | 8.95% |
Standard Deviation (monthly) | 3.47% | 3.05% | 1.90% | 4.15% |
Standard Deviation (annualized) | 12.01% | 10.55% | 6.59% | 14.39% |
Downside Deviation (monthly) | 2.38% | 2.07% | 1.23% | 2.79% |
Maximum Drawdown | -47.49% | -41.80% | -22.81% | -50.80% |
Stock Market Correlation | 0.84 | 0.84 | 0.76 | 0.99 |
Beta(*) | 0.68 | 0.60 | 0.34 | 1.00 |
Alpha (annualized) | 2.38% | 2.70% | 3.55% | 0.00% |
R2 | 67.23% | 66.30% | 54.70% | 100.00% |
Sharpe Ratio | 0.55 | 0.57 | 0.67 | 0.50 |
Sortino Ratio | 0.77 | 0.82 | 0.98 | 0.73 |
Treynor Ratio (%) | 9.60 | 10.14 | 13.00 | 7.24 |
Calmar Ratio | 0.56 | 0.60 | 0.74 | 0.68 |
Active Return | -0.39% | -0.76% | -2.15% | N/A |
Tracking Error | 8.24% | 8.44% | 10.50% | N/A |
Information Ratio | -0.05 | -0.09 | -0.20 | N/A |
Skewness | -1.14 | -1.16 | -1.24 | -0.66 |
Excess Kurtosis | 6.18 | 6.18 | 6.95 | 1.20 |
Historical Value-at-Risk (5%) | -4.58% | -3.95% | -2.29% | -6.95% |
Analytical Value-at-Risk (5%) | -4.96% | -4.30% | -2.56% | -6.03% |
Conditional Value-at-Risk (5%) | -8.20% | -7.10% | -4.11% | -9.47% |
Upside Capture Ratio (%) | 72.79 | 64.66 | 40.69 | 100.00 |
Downside Capture Ratio (%) | 65.29 | 55.67 | 26.84 | 100.00 |
Safe Withdrawal Rate | 8.49% | 8.21% | 7.11% | 9.40% |
Perpetual Withdrawal Rate | 5.86% | 5.53% | 4.31% | 6.20% |
Positive Periods | 201 out of 300 (67.00%) | 201 out of 300 (67.00%) | 206 out of 300 (68.67%) | 194 out of 300 (64.67%) |
Gain/Loss Ratio | 0.88 | 0.92 | 1.01 | 0.89 |
* SPDR S&P 500 ETF Trust is used as the benchmark for calculations. Value-at-risk metrics are based on monthly values. |
Stress Period | Start | End | Portfolio 1 | Portfolio 2 | Portfolio 3 | SPDR S&P 500 ETF Trust |
---|---|---|---|---|---|---|
Asian Crisis | Jul 1997 | Jan 1998 | -2.67% | -2.25% | -1.34% | -5.18% |
Russian Debt Default | Jul 1998 | Oct 1998 | -13.48% | -11.62% | -6.55% | -15.28% |
Dotcom Crash | Mar 2000 | Oct 2002 | -11.27% | -9.21% | -4.25% | -44.71% |
Subprime Crisis | Nov 2007 | Mar 2009 | -47.37% | -41.80% | -22.81% | -50.80% |
Rank | Start | End | Length | Recovery By | Recovery Time | Underwater Period | Drawdown |
---|---|---|---|---|---|---|---|
1 | Jun 2007 | Feb 2009 | 1 year 9 months | Jan 2011 | 1 year 11 months | 3 years 8 months | -47.49% |
2 | Apr 1998 | Aug 1998 | 5 months | Apr 1999 | 8 months | 1 year 1 month | -14.00% |
3 | Jun 2011 | Sep 2011 | 4 months | Jan 2012 | 4 months | 8 months | -13.28% |
4 | Apr 2002 | Sep 2002 | 6 months | May 2003 | 8 months | 1 year 2 months | -11.27% |
5 | Sep 2018 | Dec 2018 | 4 months | -9.04% | |||
6 | Feb 1994 | Nov 1994 | 10 months | May 1995 | 6 months | 1 year 4 months | -8.77% |
7 | Apr 2004 | Apr 2004 | 1 month | Sep 2004 | 5 months | 6 months | -7.60% |
8 | Sep 2000 | Mar 2001 | 7 months | Jun 2001 | 3 months | 10 months | -6.96% |
9 | Jul 2001 | Oct 2001 | 4 months | Mar 2002 | 5 months | 9 months | -6.78% |
10 | Apr 2015 | Sep 2015 | 6 months | Mar 2016 | 6 months | 1 year | -6.77% |
Worst 10 drawdowns included above |
Rank | Start | End | Length | Recovery By | Recovery Time | Underwater Period | Drawdown |
---|---|---|---|---|---|---|---|
1 | Nov 2007 | Feb 2009 | 1 year 4 months | Oct 2010 | 1 year 8 months | 3 years | -41.80% |
2 | Apr 1998 | Aug 1998 | 5 months | Apr 1999 | 8 months | 1 year 1 month | -11.86% |
3 | Jun 2011 | Sep 2011 | 4 months | Jan 2012 | 4 months | 8 months | -11.29% |
4 | Apr 2002 | Oct 2002 | 7 months | May 2003 | 7 months | 1 year 2 months | -9.21% |
5 | Feb 1994 | Nov 1994 | 10 months | May 1995 | 6 months | 1 year 4 months | -8.18% |
6 | Sep 2018 | Dec 2018 | 4 months | -7.82% | |||
7 | Jun 2007 | Jul 2007 | 2 months | Oct 2007 | 3 months | 5 months | -7.31% |
8 | Apr 2004 | Apr 2004 | 1 month | Sep 2004 | 5 months | 6 months | -7.01% |
9 | Apr 2015 | Aug 2015 | 5 months | Mar 2016 | 7 months | 1 year | -6.09% |
10 | Feb 2001 | Mar 2001 | 2 months | Jun 2001 | 3 months | 5 months | -5.65% |
Worst 10 drawdowns included above |
Rank | Start | End | Length | Recovery By | Recovery Time | Underwater Period | Drawdown |
---|---|---|---|---|---|---|---|
1 | Nov 2007 | Feb 2009 | 1 year 4 months | Dec 2009 | 10 months | 2 years 2 months | -22.81% |
2 | Jul 1998 | Aug 1998 | 2 months | Dec 1998 | 4 months | 6 months | -6.55% |
3 | Feb 1994 | Nov 1994 | 10 months | Apr 1995 | 5 months | 1 year 3 months | -5.73% |
4 | Apr 2004 | Apr 2004 | 1 month | Sep 2004 | 5 months | 6 months | -5.37% |
5 | Jun 2011 | Sep 2011 | 4 months | Jan 2012 | 4 months | 8 months | -5.20% |
6 | Aug 2016 | Nov 2016 | 4 months | Jul 2017 | 8 months | 1 year | -5.10% |
7 | Feb 2015 | Aug 2015 | 7 months | Mar 2016 | 7 months | 1 year 2 months | -4.80% |
8 | Jun 2002 | Oct 2002 | 5 months | Apr 2003 | 6 months | 11 months | -4.25% |
9 | May 2013 | Jun 2013 | 2 months | Feb 2014 | 8 months | 10 months | -4.17% |
10 | Jun 2007 | Jul 2007 | 2 months | Sep 2007 | 2 months | 4 months | -4.02% |
Worst 10 drawdowns included above |
Rank | Start | End | Length | Recovery By | Recovery Time | Underwater Period | Drawdown |
---|---|---|---|---|---|---|---|
1 | Nov 2007 | Feb 2009 | 1 year 4 months | Mar 2012 | 3 years 1 month | 4 years 5 months | -50.80% |
2 | Sep 2000 | Sep 2002 | 2 years 1 month | Nov 2006 | 4 years 2 months | 6 years 3 months | -44.71% |
3 | Jul 1998 | Aug 1998 | 2 months | Nov 1998 | 3 months | 5 months | -15.28% |
4 | Oct 2018 | Dec 2018 | 3 months | -13.52% | |||
5 | Aug 2015 | Sep 2015 | 2 months | May 2016 | 8 months | 10 months | -8.48% |
6 | Feb 1994 | Mar 1994 | 2 months | Aug 1994 | 5 months | 7 months | -6.98% |
7 | Apr 2012 | May 2012 | 2 months | Aug 2012 | 3 months | 5 months | -6.63% |
8 | Jan 2000 | Feb 2000 | 2 months | Mar 2000 | 1 month | 3 months | -6.43% |
9 | Feb 2018 | Mar 2018 | 2 months | Jul 2018 | 4 months | 6 months | -6.28% |
10 | Jul 1999 | Sep 1999 | 3 months | Oct 1999 | 1 month | 4 months | -5.76% |
Worst 10 drawdowns included above |
Name | CAGR | Stdev | Best Year | Worst Year | Max Drawdown | Sharpe Ratio | Sortino Ratio | Market Correlation |
---|---|---|---|---|---|---|---|---|
US Stock Market | 8.94% | 14.79% | 35.79% | -37.04% | -50.89% | 0.49 | 0.70 | 1.00 |
Cash | 2.44% | 0.62% | 5.99% | 0.03% | 0.00% | N/A | N/A | 0.01 |
Total US Bond Market | 4.90% | 3.56% | 18.18% | -2.66% | -5.01% | 0.69 | 1.11 | -0.00 |
REIT | 8.87% | 19.17% | 35.66% | -37.05% | -68.28% | 0.42 | 0.60 | 0.57 |
Gold | 4.60% | 15.68% | 30.45% | -28.33% | -42.91% | 0.21 | 0.33 | 0.01 |
Name | Total Return | Annualized Return | ||||
---|---|---|---|---|---|---|
3 Month | Year To Date | 1 year | 3 year | 5 year | 10 year | |
US Stock Market | -14.28% | -5.26% | -5.26% | 8.88% | 7.79% | 13.13% |
Cash | 0.57% | 1.90% | 1.90% | 1.02% | 0.63% | 0.36% |
Total US Bond Market | 1.59% | -0.13% | -0.13% | 1.93% | 2.35% | 3.31% |
REIT | -6.49% | -6.11% | -6.11% | 2.16% | 7.24% | 11.89% |
Gold | 7.53% | -1.94% | -1.94% | 6.12% | 0.87% | 3.43% |
Trailing returns as of last calendar month ending December 2018 |
Name | US Stock Market | Cash | Total US Bond Market | REIT | Gold | Portfolio 1 | Portfolio 2 | Portfolio 3 | SPDR S&P 500 ETF Trust |
---|---|---|---|---|---|---|---|---|---|
US Stock Market | 1.00 | 0.01 | -0.00 | 0.57 | 0.01 | 0.84 | 0.84 | 0.76 | 0.99 |
Cash | 0.01 | 1.00 | 0.14 | -0.02 | -0.04 | -0.00 | 0.00 | 0.03 | 0.02 |
Total US Bond Market | -0.00 | 0.14 | 1.00 | 0.18 | 0.26 | 0.17 | 0.21 | 0.39 | 0.02 |
REIT | 0.57 | -0.02 | 0.18 | 1.00 | 0.11 | 0.91 | 0.91 | 0.87 | 0.54 |
Gold | 0.01 | -0.04 | 0.26 | 0.11 | 1.00 | 0.16 | 0.18 | 0.37 | -0.01 |
Name | Portfolio 1 | Portfolio 2 | Portfolio 3 |
---|---|---|---|
US Stock Market | $31,732 | $26,708 | $13,058 |
Cash | $723 | $689 | $1,154 |
Total US Bond Market | $3,443 | $6,592 | $11,162 |
REIT | $29,796 | $25,297 | $12,627 |
Gold | $2,372 | $2,267 | $3,797 |
Return attribution decomposes portfolio gains into its constituent parts and identifies the contribution to returns by each of the assets. |
Name | Portfolio 1 | Portfolio 2 | Portfolio 3 |
---|---|---|---|
US Stock Market | 41.01% | 40.39% | 33.52% |
Cash | -0.00% | 0.00% | 0.02% |
Total US Bond Market | 0.49% | 1.37% | 8.28% |
REIT | 57.49% | 56.96% | 49.45% |
Gold | 1.01% | 1.28% | 8.73% |
Risk attribution decomposes portfolio risk into its constituent parts and identifies the contribution to overall volatility by each of the assets. |
Roll Period | Portfolio 1 | Portfolio 2 | Portfolio 3 | SPDR S&P 500 ETF Trust | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
Average | High | Low | Average | High | Low | Average | High | Low | Average | High | Low | |
1 year | 10.11% | 60.52% | -41.10% | 9.47% | 52.62% | -36.20% | 7.47% | 31.66% | -21.01% | 11.16% | 53.27% | -43.44% |
3 years | 9.52% | 28.48% | -13.87% | 9.04% | 25.65% | -11.25% | 7.39% | 17.88% | -3.19% | 9.56% | 32.35% | -16.28% |
5 years | 9.07% | 21.92% | -3.60% | 8.68% | 19.66% | -2.32% | 7.29% | 13.02% | 1.71% | 8.35% | 28.45% | -6.67% |
7 years | 8.79% | 17.01% | 0.80% | 8.47% | 15.36% | 1.59% | 7.32% | 10.31% | 4.07% | 6.99% | 18.07% | -3.91% |
10 years | 8.49% | 12.33% | 2.42% | 8.24% | 11.59% | 3.00% | 7.32% | 9.31% | 4.69% | 6.25% | 14.17% | -3.45% |
15 years | 8.46% | 9.99% | 5.42% | 8.21% | 9.37% | 5.62% | 7.31% | 8.12% | 5.92% | 6.17% | 10.40% | 3.67% |