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 Large Cap | 45.00% |
Intermediate Term Treasury | 50.00% |
Cash | 5.00% |
Save portfolio » |
Asset Class | Allocation |
---|---|
US Large Cap | 60.00% |
Intermediate Term Treasury | 35.00% |
Cash | 5.00% |
Save portfolio » |
Asset Class | Allocation |
---|---|
US Large Cap | 75.00% |
Intermediate Term Treasury | 20.00% |
Cash | 5.00% |
Save portfolio » |
Portfolio | Initial Balance | Final Balance | CAGR | TWRR | MWRR | Stdev | Best Year | Worst Year | Max. Drawdown | Sharpe Ratio | Sortino Ratio | Market Correlation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
Conservative (45% Stocks) | $1,000,000 | $5,375,659 | 5.58% | 9.85% | 9.54% | 8.33% | 27.36% | -8.86% | -18.69% (-24.15%) | 0.39 | 0.59 | 0.91 |
Moderate (60% Stocks) | $1,000,000 | $5,798,409 | 5.83% | 10.12% | 9.83% | 10.15% | 29.91% | -13.75% | -26.18% (-31.13%) | 0.36 | 0.54 | 0.96 |
Growth (75% Stocks) | $1,000,000 | $6,130,190 | 6.02% | 10.31% | 10.06% | 12.17% | 32.46% | -18.65% | -33.34% (-37.81%) | 0.33 | 0.49 | 0.98 |
* The number in parentheses shows the calculated value taking into account the percentage based periodic withdrawals. |
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 | |
Conservative (45% Stocks) | 3.21% | -2.81% | -2.81% | -0.37% | 4.80% | 8.86% | 9.85% | 6.90% | 7.56% |
Moderate (60% Stocks) | 4.36% | -8.25% | -8.25% | -4.34% | 3.43% | 9.05% | 10.12% | 9.75% | 10.41% |
Growth (75% Stocks) | 5.70% | -13.70% | -13.70% | -8.33% | 1.93% | 9.15% | 10.31% | 12.97% | 13.50% |
Trailing return and volatility are as of last full calendar month ending December 2002 |
Year | Inflation | Conservative (45% Stocks) | Moderate (60% Stocks) | Growth (75% Stocks) | US Large Cap | Intermediate Term Treasury | Cash | ||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Return | Balance | Cashflow | Return | Balance | Cashflow | Return | Balance | Cashflow | |||||
1972 | 3.41% | 10.10% | $1,058,144 | -$40,749 | 12.53% | $1,081,548 | -$41,238 | 14.97% | $1,104,953 | -$41,726 | 18.95% | 2.72% | 4.13% |
1973 | 8.71% | -4.69% | $969,337 | -$39,664 | -7.78% | $958,571 | -$39,877 | -10.88% | $946,412 | -$40,061 | -16.18% | 4.47% | 7.17% |
1974 | 12.34% | -8.86% | $849,091 | -$35,136 | -13.75% | $794,576 | -$33,881 | -18.65% | $739,984 | -$32,597 | -26.93% | 5.70% | 8.14% |
1975 | 6.94% | 20.61% | $984,263 | -$37,974 | 25.05% | $954,962 | -$36,824 | 29.49% | $920,914 | -$35,493 | 36.95% | 7.36% | 6.09% |
1976 | 4.86% | 18.02% | $1,116,428 | -$42,203 | 19.58% | $1,097,553 | -$41,529 | 21.15% | $1,072,271 | -$40,609 | 24.18% | 13.75% | 5.19% |
1977 | 6.70% | -2.74% | $1,043,571 | -$41,983 | -4.08% | $1,011,880 | -$40,812 | -5.41% | $974,846 | -$39,421 | -7.84% | 1.04% | 5.34% |
1978 | 9.02% | 3.59% | $1,038,975 | -$41,320 | 4.30% | $1,014,317 | -$40,186 | 5.01% | $983,835 | -$38,831 | 5.87% | 1.15% | 7.45% |
1979 | 13.29% | 11.32% | $1,111,631 | -$43,270 | 13.23% | $1,103,812 | -$42,611 | 15.13% | $1,088,647 | -$41,688 | 18.05% | 5.35% | 10.49% |
1980 | 12.52% | 16.41% | $1,243,742 | -$46,296 | 20.77% | $1,281,193 | -$46,782 | 25.12% | $1,309,155 | -$46,939 | 31.92% | 2.88% | 12.15% |
1981 | 8.92% | 3.13% | $1,232,747 | -$48,165 | 0.93% | $1,242,871 | -$49,251 | -1.26% | $1,242,411 | -$49,954 | -5.21% | 9.41% | 15.29% |
1982 | 3.83% | 25.58% | $1,487,847 | -$51,377 | 24.05% | $1,481,856 | -$50,985 | 22.53% | $1,463,105 | -$50,153 | 20.97% | 31.13% | 11.45% |
1983 | 3.79% | 12.64% | $1,610,806 | -$63,020 | 15.06% | $1,638,652 | -$63,942 | 17.47% | $1,651,814 | -$64,295 | 21.29% | 5.22% | 9.03% |
1984 | 3.95% | 10.81% | $1,715,542 | -$64,034 | 9.49% | $1,724,403 | -$64,716 | 8.17% | $1,717,292 | -$64,806 | 6.21% | 15.01% | 10.17% |
1985 | 3.80% | 25.57% | $2,070,424 | -$74,916 | 26.92% | $2,103,452 | -$75,816 | 28.26% | $2,117,019 | -$76,015 | 31.23% | 22.24% | 7.88% |
1986 | 1.10% | 15.99% | $2,308,165 | -$89,990 | 16.44% | $2,353,949 | -$92,052 | 16.88% | $2,378,153 | -$93,276 | 18.06% | 15.10% | 6.28% |
1987 | 4.43% | 3.19% | $2,289,202 | -$97,571 | 3.66% | $2,345,301 | -$102,305 | 4.14% | $2,380,217 | -$106,183 | 4.71% | 1.55% | 5.93% |
1988 | 4.42% | 10.27% | $2,426,071 | -$95,096 | 11.91% | $2,522,597 | -$98,307 | 13.56% | $2,597,777 | -$100,664 | 16.22% | 5.26% | 6.80% |
1989 | 4.65% | 21.80% | $2,840,147 | -$106,558 | 24.33% | $3,014,407 | -$112,519 | 26.86% | $3,167,330 | -$117,645 | 31.36% | 14.52% | 8.61% |
1990 | 6.11% | 3.63% | $2,828,757 | -$110,031 | 1.71% | $2,946,756 | -$115,598 | -0.21% | $3,037,865 | -$120,219 | -3.32% | 9.46% | 7.89% |
1991 | 3.06% | 21.87% | $3,313,314 | -$122,057 | 24.01% | $3,512,079 | -$129,126 | 26.15% | $3,683,093 | -$135,158 | 30.22% | 15.97% | 5.71% |
1992 | 2.90% | 7.41% | $3,420,375 | -$131,607 | 7.36% | $3,623,765 | -$139,241 | 7.30% | $3,798,334 | -$145,748 | 7.42% | 7.78% | 3.57% |
1993 | 2.75% | 10.32% | $3,626,617 | -$142,088 | 10.09% | $3,834,231 | -$149,901 | 9.86% | $4,010,510 | -$156,456 | 9.89% | 11.43% | 3.05% |
1994 | 2.67% | -1.42% | $3,435,944 | -$138,889 | -0.60% | $3,663,058 | -$147,637 | 0.23% | $3,863,281 | -$155,258 | 1.18% | -4.33% | 4.20% |
1995 | 2.54% | 27.36% | $4,205,749 | -$153,934 | 29.91% | $4,573,542 | -$166,051 | 32.46% | $4,918,237 | -$177,175 | 37.45% | 20.44% | 5.71% |
1996 | 3.32% | 11.51% | $4,507,540 | -$170,722 | 14.66% | $5,039,919 | -$188,857 | 17.80% | $5,568,371 | -$206,537 | 22.88% | 1.92% | 5.17% |
1997 | 1.70% | 19.68% | $5,184,705 | -$193,776 | 23.31% | $5,973,112 | -$221,293 | 26.95% | $6,793,922 | -$249,611 | 33.19% | 8.96% | 5.22% |
1998 | 1.61% | 18.43% | $5,901,404 | -$219,311 | 21.13% | $6,953,901 | -$255,215 | 23.83% | $8,085,908 | -$293,191 | 28.62% | 10.61% | 4.97% |
1999 | 2.68% | 7.96% | $6,123,290 | -$236,145 | 11.65% | $7,461,881 | -$282,888 | 15.34% | $8,963,231 | -$334,319 | 21.07% | -3.52% | 4.77% |
2000 | 3.39% | 3.24% | $6,075,839 | -$242,160 | -0.22% | $7,155,690 | -$291,482 | -3.69% | $8,297,096 | -$345,787 | -9.06% | 14.03% | 5.99% |
2001 | 1.55% | -1.45% | $5,754,775 | -$232,400 | -4.39% | $6,575,674 | -$267,548 | -7.32% | $7,390,470 | -$303,087 | -12.02% | 7.55% | 3.70% |
2002 | 2.38% | -2.81% | $5,375,659 | -$218,150 | -8.25% | $5,798,409 | -$241,647 | -13.70% | $6,130,190 | -$263,024 | -22.15% | 14.15% | 1.65% |
Metric | Conservative (45% Stocks) | Moderate (60% Stocks) | Growth (75% Stocks) |
---|---|---|---|
Arithmetic Mean (monthly) | 0.81% | 0.85% | 0.88% |
Arithmetic Mean (annualized) | 10.22% | 10.68% | 11.12% |
Geometric Mean (monthly) | 0.79% | 0.81% | 0.82% |
Geometric Mean (annualized) | 9.85% | 10.12% | 10.31% |
Standard Deviation (monthly) | 2.41% | 2.93% | 3.51% |
Standard Deviation (annualized) | 8.33% | 10.15% | 12.17% |
Downside Deviation (monthly) | 1.30% | 1.69% | 2.12% |
Maximum Drawdown | -18.69% | -26.18% | -33.34% |
Stock Market Correlation | 0.91 | 0.96 | 0.98 |
Beta(*) | 0.47 | 0.60 | 0.74 |
Alpha (annualized) | 4.48% | 3.37% | 2.24% |
R2 | 82.18% | 91.99% | 96.00% |
Sharpe Ratio | 0.39 | 0.36 | 0.33 |
Sortino Ratio | 0.59 | 0.54 | 0.49 |
Treynor Ratio (%) | 6.95 | 6.08 | 5.52 |
Calmar Ratio | -0.04 | -0.21 | -0.27 |
Active Return | -0.61% | -0.34% | -0.14% |
Tracking Error | 9.26% | 7.00% | 4.86% |
Information Ratio | -0.07 | -0.05 | -0.03 |
Skewness | -0.08 | -0.25 | -0.33 |
Excess Kurtosis | 0.97 | 1.45 | 1.81 |
Historical Value-at-Risk (5%) | -3.22% | -3.77% | -4.87% |
Analytical Value-at-Risk (5%) | -3.14% | -3.97% | -4.89% |
Conditional Value-at-Risk (5%) | -4.30% | -5.58% | -7.04% |
Upside Capture Ratio (%) | 54.23 | 65.39 | 76.76 |
Downside Capture Ratio (%) | 37.80 | 53.67 | 69.32 |
Safe Withdrawal Rate | 4.56% | 4.63% | 4.65% |
Perpetual Withdrawal Rate | 4.51% | 4.74% | 4.91% |
Positive Periods | 236 out of 372 (63.44%) | 231 out of 372 (62.10%) | 227 out of 372 (61.02%) |
Gain/Loss Ratio | 1.39 | 1.29 | 1.23 |
* US stock market is used as the benchmark for calculations. Value-at-risk metrics are based on monthly values. |
Stress Period | Start | End | Conservative (45% Stocks) | Moderate (60% Stocks) | Growth (75% Stocks) |
---|---|---|---|---|---|
Oil Crisis | Oct 1973 | Mar 1974 | -5.74% | -7.58% | -9.51% |
Black Monday Period | Sep 1987 | Nov 1987 | -14.81% | -19.42% | -23.60% |
Asian Crisis | Jul 1997 | Jan 1998 | -3.25% | -3.93% | -4.57% |
Russian Debt Default | Jul 1998 | Oct 1998 | -5.74% | -8.53% | -11.22% |
Dotcom Crash | Mar 2000 | Oct 2002 | -9.28% | -20.26% | -30.41% |
Rank | Start | End | Length | Recovery By | Recovery Time | Underwater Period | Drawdown |
---|---|---|---|---|---|---|---|
1 | Jan 1973 | Sep 1974 | 1 year 9 months | May 1975 | 8 months | 2 years 5 months | -18.69% |
2 | Sep 1987 | Nov 1987 | 3 months | Jan 1989 | 1 year 2 months | 1 year 5 months | -14.81% |
3 | Sep 2000 | Sep 2002 | 2 years 1 month | -9.28% | |||
4 | Feb 1980 | Mar 1980 | 2 months | May 1980 | 2 months | 4 months | -7.16% |
5 | Apr 1981 | Sep 1981 | 6 months | Nov 1981 | 2 months | 8 months | -6.47% |
6 | Jul 1975 | Sep 1975 | 3 months | Dec 1975 | 3 months | 6 months | -6.44% |
7 | Jan 1977 | Feb 1978 | 1 year 2 months | Jul 1978 | 5 months | 1 year 7 months | -6.04% |
8 | Aug 1990 | Sep 1990 | 2 months | Dec 1990 | 3 months | 5 months | -5.95% |
9 | Feb 1994 | Jun 1994 | 5 months | Feb 1995 | 8 months | 1 year 1 month | -5.93% |
10 | Oct 1979 | Oct 1979 | 1 month | Jan 1980 | 3 months | 4 months | -5.76% |
Worst 10 drawdowns included above |
Rank | Start | End | Length | Recovery By | Recovery Time | Underwater Period | Drawdown |
---|---|---|---|---|---|---|---|
1 | Jan 1973 | Sep 1974 | 1 year 9 months | Jun 1975 | 9 months | 2 years 6 months | -26.18% |
2 | Sep 2000 | Sep 2002 | 2 years 1 month | -20.26% | |||
3 | Sep 1987 | Nov 1987 | 3 months | Apr 1989 | 1 year 5 months | 1 year 8 months | -19.42% |
4 | Jul 1998 | Aug 1998 | 2 months | Oct 1998 | 2 months | 4 months | -8.53% |
5 | Jan 1977 | Feb 1978 | 1 year 2 months | Jul 1978 | 5 months | 1 year 7 months | -8.42% |
6 | Jul 1975 | Sep 1975 | 3 months | Jan 1976 | 4 months | 7 months | -8.08% |
7 | Dec 1980 | Sep 1981 | 10 months | Nov 1981 | 2 months | 1 year | -8.03% |
8 | Aug 1990 | Sep 1990 | 2 months | Jan 1991 | 4 months | 6 months | -7.98% |
9 | Feb 1980 | Mar 1980 | 2 months | May 1980 | 2 months | 4 months | -7.70% |
10 | Sep 1978 | Oct 1978 | 2 months | Mar 1979 | 5 months | 7 months | -6.29% |
Worst 10 drawdowns included above |
Rank | Start | End | Length | Recovery By | Recovery Time | Underwater Period | Drawdown |
---|---|---|---|---|---|---|---|
1 | Jan 1973 | Sep 1974 | 1 year 9 months | Jan 1976 | 1 year 4 months | 3 years 1 month | -33.34% |
2 | Sep 2000 | Sep 2002 | 2 years 1 month | -30.41% | |||
3 | Sep 1987 | Nov 1987 | 3 months | Apr 1989 | 1 year 5 months | 1 year 8 months | -23.60% |
4 | Jul 1998 | Aug 1998 | 2 months | Nov 1998 | 3 months | 5 months | -11.22% |
5 | Jan 1977 | Feb 1978 | 1 year 2 months | Jul 1978 | 5 months | 1 year 7 months | -10.76% |
6 | Dec 1980 | Sep 1981 | 10 months | Aug 1982 | 11 months | 1 year 9 months | -10.12% |
7 | Jun 1990 | Sep 1990 | 4 months | Jan 1991 | 4 months | 8 months | -10.08% |
8 | Feb 1980 | Mar 1980 | 2 months | May 1980 | 2 months | 4 months | -8.22% |
9 | Sep 1978 | Oct 1978 | 2 months | Mar 1979 | 5 months | 7 months | -7.43% |
10 | Sep 1986 | Sep 1986 | 1 month | Jan 1987 | 4 months | 5 months | -6.70% |
Worst 10 drawdowns included above |
Name | CAGR | Stdev | Best Year | Worst Year | Max Drawdown | Sharpe Ratio | Sortino Ratio | Market Correlation |
---|---|---|---|---|---|---|---|---|
US Large Cap | 10.58% | 15.88% | 37.45% | -26.93% | -44.87% | 0.30 | 0.45 | 0.99 |
Intermediate Term Treasury | 8.73% | 6.39% | 31.13% | -4.33% | -10.70% | 0.33 | 0.50 | 0.16 |
Cash | 6.71% | 0.81% | 15.29% | 1.65% | 0.00% | N/A | N/A | -0.01 |
Name | Total Return | Annualized Return | ||||
---|---|---|---|---|---|---|
3 Month | Year To Date | 1 year | 3 year | 5 year | 10 year | |
US Large Cap | 8.39% | -22.15% | -22.15% | -14.60% | -0.61% | 9.27% |
Intermediate Term Treasury | 0.51% | 14.15% | 14.15% | 11.87% | 8.36% | 7.85% |
Cash | 0.35% | 1.65% | 1.65% | 3.76% | 4.21% | 4.44% |
Trailing returns as of last calendar month ending December 2002 |
Name | US Large Cap | Intermediate Term Treasury | Cash | Conservative (45% Stocks) | Moderate (60% Stocks) | Growth (75% Stocks) |
---|---|---|---|---|---|---|
US Large Cap | 1.00 | 0.17 | -0.01 | 0.92 | 0.97 | 0.99 |
Intermediate Term Treasury | 0.17 | 1.00 | 0.11 | 0.53 | 0.38 | 0.28 |
Cash | -0.01 | 0.11 | 1.00 | 0.04 | 0.02 | 0.01 |
Name | Conservative (45% Stocks) | Moderate (60% Stocks) | Growth (75% Stocks) |
---|---|---|---|
US Large Cap | $3,926,389 | $5,494,793 | $7,153,750 |
Intermediate Term Treasury | $3,588,504 | $2,725,617 | $1,677,836 |
Cash | $231,357 | $248,115 | $264,530 |
Return attribution decomposes portfolio gains into its constituent parts and identifies the contribution to returns by each of the assets. |
Name | Conservative (45% Stocks) | Moderate (60% Stocks) | Growth (75% Stocks) |
---|---|---|---|
US Large Cap | 79.46% | 91.52% | 97.11% |
Intermediate Term Treasury | 20.52% | 8.47% | 2.89% |
Cash | 0.02% | 0.01% | 0.00% |
Risk attribution decomposes portfolio risk into its constituent parts and identifies the contribution to overall volatility by each of the assets. |
Roll Period | Conservative (45% Stocks) | Moderate (60% Stocks) | Growth (75% Stocks) | ||||||
---|---|---|---|---|---|---|---|---|---|
Average | High | Low | Average | High | Low | Average | High | Low | |
1 year | 10.44% | 40.51% | -17.61% | 10.96% | 45.03% | -24.01% | 11.47% | 49.63% | -30.27% |
3 years | 11.00% | 23.23% | -1.48% | 11.63% | 25.74% | -4.34% | 12.22% | 28.23% | -8.33% |
5 years | 11.42% | 21.01% | 3.40% | 12.15% | 23.08% | 2.18% | 12.84% | 25.14% | 0.85% |
7 years | 11.63% | 18.02% | 4.38% | 12.38% | 18.84% | 3.98% | 13.09% | 19.93% | 3.41% |
10 years | 11.88% | 15.24% | 5.78% | 12.57% | 16.12% | 5.60% | 13.22% | 16.99% | 5.23% |
15 years | 12.05% | 14.53% | 9.17% | 12.75% | 15.79% | 9.13% | 13.41% | 17.03% | 9.02% |