Backtest Portfolio Asset Allocation

This portfolio backtesting tool allows you to construct one or more portfolios based on the selected mutual funds, ETFs, and stocks. You can analyze and backtest portfolio returns, risk characteristics, style exposures, and drawdowns. The results cover both returns and fund fundamentals based portfolio style analysis along with risk and return decomposition by each portfolio asset. 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.

The related asset class level portfolio modeling tool allows you to analyze and compare asset class level portfolios with a longer time horizon starting from 1972.

$ .00
$ .00
%
%
%
%
$ .00
%
%
Portfolio Assets 
Asset 1
%
%
%
Asset 2
%
%
%
Asset 3
%
%
%
Asset 4
%
%
%
Asset 5
%
%
%
Asset 6
%
%
%
Asset 7
%
%
%
Asset 8
%
%
%
Asset 9
%
%
%
Asset 10
%
%
%
Total
%
%
%

Portfolio Analysis Results (Jan 2007 - Dec 2020)

Portfolio Allocations

SPDR Dow Jones Industrial Avrg ETF Tr
Ticker Name Allocation
DIA SPDR Dow Jones Industrial Avrg ETF Tr 100.00%
Save portfolio »
Vanguard Dividend Appreciation ETF
Ticker Name Allocation
VIG Vanguard Dividend Appreciation ETF 100.00%
Save portfolio »

Portfolio Returns

Portfolio performance statistics
PortfolioInitial BalanceFinal BalanceCAGRStdevBest YearWorst YearMax. DrawdownSharpe RatioSortino RatioUS Mkt Correlation
SPDR Dow Jones Industrial Avrg ETF Tr$10,000$34,381 9.22% 15.00%29.64%-32.16%-47.05% 0.610.900.97
Vanguard Dividend Appreciation ETF$10,000$35,109 9.39% 13.52%29.62%-26.69%-41.11% 0.670.990.96
   

Trailing Returns

Trailing Returns
NameAnnualized ReturnAnnualized Volatility
3 Month1 year3 year5 year10 yearFull3 year5 year
SPDR Dow Jones Industrial Avrg ETF Tr10.70%9.61%9.67%14.48%12.78%9.22%18.88%15.67%
Vanguard Dividend Appreciation ETF10.25%15.40%13.57%14.92%12.70%9.39%16.28%13.25%
Trailing annualized return and volatility are for full months ending in December 2020 excluding portfolio cashflows.
Notes on results:
  • Past performance is no guarantee of future results, which may vary. All use is subject to terms of service.
  • Investing involves risk, including possible loss of principal. The value of the investments and the income derived from them may fluctuate over time.
  • All portfolio returns presented are hypothetical and backtested. Hypothetical returns do not reflect trading costs, transaction fees, or taxes.
  • The results are based on information from a variety of sources we consider reliable, but we do not represent that the information is accurate or complete.
  • The results do not constitute investment advice or recommendation, are provided solely for informational purposes, and are not an offer to buy or sell any securities.
  • The results are based on the total return of assets and assume that all received dividends and distributions are reinvested.
  • CAGR = Compound Annual Growth Rate
  • Stdev = Annualized standard deviation of monthly returns
  • Sharpe and Sortino ratios are calculated and annualized from monthly excess returns over risk free rate (3-month treasury bill)
  • Stock market correlation is based on the correlation of monthly returns
  • Drawdown analysis is calculated based on monthly returns excluding cashflows
  • The results assume annual rebalancing of portfolio assets to match the specified allocation
Annual returns for the configured portfolios
YearInflationSPDR Dow Jones Industrial Avrg ETF TrVanguard Dividend Appreciation ETFSPDR Dow Jones Industrial Avrg ETF Tr (DIA)Vanguard Dividend Appreciation ETF (VIG)
ReturnBalanceReturnBalance
20074.08%8.79%$10,8795.63%$10,5638.79%5.63%
20080.09%-32.16%$7,381-26.69%$7,744-32.16%-26.69%
20092.72%22.75%$9,05919.57%$9,26022.75%19.57%
20101.50%14.01%$10,32914.74%$10,62414.01%14.74%
20112.96%8.06%$11,1616.16%$11,2798.06%6.16%
20121.74%9.94%$12,27111.65%$12,5939.94%11.65%
20131.50%29.64%$15,90728.87%$16,22829.64%28.87%
20140.76%9.82%$17,46910.08%$17,8639.82%10.08%
20150.73%0.10%$17,487-1.95%$17,5150.10%-1.95%
20162.07%16.37%$20,35111.97%$19,61216.37%11.97%
20172.11%28.08%$26,06522.22%$23,97028.08%22.22%
20181.91%-3.74%$25,090-2.08%$23,472-3.74%-2.08%
20192.29%25.02%$31,36729.62%$30,42425.02%29.62%
20201.36%9.61%$34,38115.40%$35,1099.61%15.40%
Monthly returns for the configured portfolios
YearMonthSPDR Dow Jones Industrial Avrg ETF TrVanguard Dividend Appreciation ETFSPDR Dow Jones Industrial Avrg ETF Tr (DIA)Vanguard Dividend Appreciation ETF (VIG)
ReturnBalanceReturnBalance
200711.54%$10,1541.56%$10,1561.54%1.56%
20072-2.66%$9,883-1.74%$9,980-2.66%-1.74%
200730.99%$9,9810.28%$10,0080.99%0.28%
200745.82%$10,5624.44%$10,4525.82%4.44%
200754.57%$11,0452.48%$10,7114.57%2.48%
20076-1.41%$10,889-1.60%$10,540-1.41%-1.60%
20077-1.40%$10,737-2.52%$10,274-1.40%-2.52%
200781.15%$10,8602.30%$10,5101.15%2.30%
200794.31%$11,3283.43%$10,8704.31%3.43%
2007100.14%$11,344-0.33%$10,8350.14%-0.33%
200711-3.17%$10,985-2.03%$10,615-3.17%-2.03%
200712-0.96%$10,879-0.49%$10,563-0.96%-0.49%
20081-4.83%$10,353-5.27%$10,006-4.83%-5.27%
20082-2.19%$10,127-1.55%$9,851-2.19%-1.55%
20083-0.26%$10,1012.03%$10,051-0.26%2.03%
200844.86%$10,5922.57%$10,3094.86%2.57%
20085-1.36%$10,4480.33%$10,343-1.36%0.33%
20086-9.87%$9,416-7.86%$9,530-9.87%-7.86%
200870.39%$9,4531.06%$9,6310.39%1.06%
200881.75%$9,6192.08%$9,8311.75%2.08%
20089-5.87%$9,055-6.72%$9,171-5.87%-6.72%
200810-13.56%$7,827-14.11%$7,877-13.56%-14.11%
200811-5.16%$7,423-2.55%$7,676-5.16%-2.55%
200812-0.57%$7,3810.88%$7,744-0.57%0.88%
20091-8.34%$6,765-7.62%$7,154-8.34%-7.62%
20092-11.20%$6,007-10.52%$6,401-11.20%-10.52%
200937.44%$6,4547.03%$6,8517.44%7.03%
200947.86%$6,9617.29%$7,3517.86%7.29%
200954.87%$7,3004.95%$7,7144.87%4.95%
20096-0.53%$7,2620.49%$7,752-0.53%0.49%
200978.44%$7,8746.56%$8,2618.44%6.56%
200984.05%$8,1932.41%$8,4604.05%2.41%
200992.33%$8,3843.15%$8,7272.33%3.15%
2009100.06%$8,389-0.43%$8,6890.06%-0.43%
2009117.07%$8,9825.79%$9,1937.07%5.79%
2009120.86%$9,0590.73%$9,2600.86%0.73%
20101-3.38%$8,753-2.30%$9,046-3.38%-2.30%
201023.00%$9,0152.42%$9,2653.00%2.42%
201035.34%$9,4974.62%$9,6945.34%4.62%
201041.46%$9,6352.17%$9,9041.46%2.17%
20105-7.49%$8,913-7.24%$9,187-7.49%-7.24%
20106-3.51%$8,600-4.34%$8,789-3.51%-4.34%
201077.23%$9,2226.38%$9,3507.23%6.38%
20108-3.94%$8,859-3.44%$9,028-3.94%-3.44%
201097.89%$9,5588.31%$9,7787.89%8.31%
2010103.24%$9,8672.83%$10,0553.24%2.83%
201011-0.71%$9,7980.30%$10,085-0.71%0.30%
2010125.42%$10,3295.34%$10,6245.42%5.34%
201112.69%$10,6071.43%$10,7762.69%1.43%
201123.24%$10,9513.41%$11,1433.24%3.41%
201130.90%$11,0501.06%$11,2610.90%1.06%
201144.18%$11,5113.49%$11,6554.18%3.49%
20115-1.66%$11,321-1.27%$11,507-1.66%-1.27%
20116-1.16%$11,189-0.77%$11,418-1.16%-0.77%
20117-2.09%$10,955-3.46%$11,022-2.09%-3.46%
20118-3.90%$10,527-3.20%$10,670-3.90%-3.20%
20119-5.88%$9,908-6.26%$10,002-5.88%-6.26%
2011109.73%$10,8729.60%$10,9629.73%9.60%
2011110.96%$10,9761.87%$11,1670.96%1.87%
2011121.69%$11,1611.00%$11,2791.69%1.00%
201213.60%$11,5632.60%$11,5723.60%2.60%
201222.82%$11,8892.76%$11,8922.82%2.76%
201232.14%$12,1432.09%$12,1402.14%2.09%
201240.11%$12,157-0.34%$12,0990.11%-0.34%
20125-5.82%$11,449-4.37%$11,570-5.82%-4.37%
201264.02%$11,9092.18%$11,8224.02%2.18%
201271.13%$12,0441.96%$12,0541.13%1.96%
201281.18%$12,1861.90%$12,2831.18%1.90%
201292.63%$12,5081.87%$12,5132.63%1.87%
201210-2.44%$12,203-1.26%$12,355-2.44%-1.26%
201211-0.13%$12,1871.44%$12,534-0.13%1.44%
2012120.68%$12,2710.47%$12,5930.68%0.47%
201316.11%$13,0205.93%$13,3396.11%5.93%
201321.61%$13,2301.16%$13,4931.61%1.16%
201333.81%$13,7343.38%$13,9503.81%3.38%
201341.96%$14,0031.67%$14,1841.96%1.67%
201352.37%$14,3341.15%$14,3472.37%1.15%
20136-1.49%$14,121-1.51%$14,130-1.49%-1.51%
201374.37%$14,7395.41%$14,8954.37%5.41%
20138-4.27%$14,109-3.57%$14,363-4.27%-3.57%
201392.33%$14,4383.97%$14,9332.33%3.97%
2013102.95%$14,8654.17%$15,5562.95%4.17%
2013113.69%$15,4132.32%$15,9163.69%2.32%
2013123.21%$15,9071.96%$16,2283.21%1.96%
20141-5.19%$15,081-5.01%$15,415-5.19%-5.01%
201424.28%$15,7274.90%$16,1704.28%4.90%
201430.92%$15,8720.79%$16,2980.92%0.79%
201440.82%$16,0021.01%$16,4630.82%1.01%
201451.15%$16,1861.61%$16,7271.15%1.61%
201460.77%$16,3111.49%$16,9750.77%1.49%
20147-1.44%$16,075-3.31%$16,414-1.44%-3.31%
201483.57%$16,6493.65%$17,0123.57%3.65%
20149-0.24%$16,609-1.00%$16,842-0.24%-1.00%
2014102.08%$16,9542.65%$17,2882.08%2.65%
2014112.94%$17,4533.22%$17,8442.94%3.22%
2014120.09%$17,4690.11%$17,8630.09%0.11%
20151-3.53%$16,852-3.38%$17,260-3.53%-3.38%
201525.97%$17,8575.59%$18,2245.97%5.59%
20153-1.82%$17,531-2.27%$17,811-1.82%-2.27%
201540.40%$17,602-0.21%$17,7730.40%-0.21%
201551.31%$17,8320.96%$17,9441.31%0.96%
20156-2.12%$17,454-2.54%$17,489-2.12%-2.54%
201570.58%$17,5562.16%$17,8670.58%2.16%
20158-6.20%$16,468-5.87%$16,819-6.20%-5.87%
20159-1.35%$16,246-1.84%$16,510-1.35%-1.84%
2015108.58%$17,6396.74%$17,6238.58%6.74%
2015110.74%$17,7700.27%$17,6700.74%0.27%
201512-1.59%$17,487-0.87%$17,515-1.59%-0.87%
20161-5.48%$16,529-2.29%$17,114-5.48%-2.29%
201620.73%$16,6511.13%$17,3080.73%1.13%
201637.31%$17,8686.28%$18,3957.31%6.28%
201640.61%$17,977-0.33%$18,3330.61%-0.33%
201650.38%$18,0460.95%$18,5080.38%0.95%
201660.96%$18,2192.37%$18,9470.96%2.37%
201672.94%$18,7552.29%$19,3822.94%2.29%
201680.25%$18,8020.01%$19,3840.25%0.01%
20169-0.44%$18,720-0.97%$19,195-0.44%-0.97%
201610-0.78%$18,574-1.93%$18,825-0.78%-1.93%
2016115.95%$19,6782.98%$19,3855.95%2.98%
2016123.42%$20,3511.17%$19,6123.42%1.17%
201710.53%$20,4581.76%$19,9570.53%1.76%
201725.14%$21,5094.33%$20,8215.14%4.33%
20173-0.59%$21,381-0.07%$20,806-0.59%-0.07%
201741.42%$21,6841.72%$21,1641.42%1.72%
201750.73%$21,8431.57%$21,4980.73%1.57%
201761.73%$22,2210.28%$21,5571.73%0.28%
201772.67%$22,8150.73%$21,7152.67%0.73%
201780.62%$22,956-0.36%$21,6360.62%-0.36%
201792.17%$23,4542.38%$22,1512.17%2.38%
2017104.46%$24,5012.10%$22,6164.46%2.10%
2017114.19%$25,5294.48%$23,6304.19%4.48%
2017122.10%$26,0651.44%$23,9702.10%1.44%
201815.74%$27,5625.02%$25,1735.74%5.02%
20182-4.05%$26,444-4.03%$24,158-4.05%-4.03%
20183-3.34%$25,561-1.35%$23,833-3.34%-1.35%
201840.11%$25,589-0.93%$23,6110.11%-0.93%
201851.38%$25,9421.77%$24,0291.38%1.77%
20186-0.44%$25,8270.30%$24,101-0.44%0.30%
201874.85%$27,0784.68%$25,2304.85%4.68%
201882.45%$27,7412.80%$25,9372.45%2.80%
201891.96%$28,2851.68%$26,3731.96%1.68%
201810-4.94%$26,888-6.36%$24,696-4.94%-6.36%
2018111.96%$27,4154.14%$25,7181.96%4.14%
201812-8.48%$25,090-8.73%$23,472-8.48%-8.73%
201917.33%$26,9306.32%$24,9557.33%6.32%
201923.94%$27,9914.58%$26,0983.94%4.58%
201930.15%$28,0341.14%$26,3960.15%1.14%
201942.63%$28,7723.72%$27,3782.63%3.72%
20195-6.38%$26,937-4.63%$26,109-6.38%-4.63%
201967.36%$28,9196.63%$27,8407.36%6.63%
201971.09%$29,2332.23%$28,4621.09%2.23%
20198-1.38%$28,8300.59%$28,628-1.38%0.59%
201992.16%$29,4521.45%$29,0432.16%1.45%
2019100.55%$29,6130.03%$29,0500.55%0.03%
2019114.06%$30,8162.45%$29,7624.06%2.45%
2019121.79%$31,3672.22%$30,4241.79%2.22%
20201-0.89%$31,0860.57%$30,597-0.89%0.57%
20202-9.61%$28,098-8.34%$28,045-9.61%-8.34%
20203-13.61%$24,274-9.62%$25,348-13.61%-9.62%
2020411.00%$26,9459.88%$27,85111.00%9.88%
202054.76%$28,2263.60%$28,8544.76%3.60%
202061.70%$28,7070.08%$28,8781.70%0.08%
202072.59%$29,4514.98%$30,3152.59%4.98%
202087.77%$31,7406.16%$32,1837.77%6.16%
20209-2.15%$31,058-1.05%$31,846-2.15%-1.05%
202010-4.44%$29,678-2.27%$31,123-4.44%-2.27%
20201112.16%$33,28510.04%$34,24712.16%10.04%
2020123.29%$34,3812.52%$35,1093.29%2.52%

Returns Based Style Analysis

Returns Based Style Analysis
Style CategorySPDR Dow Jones Industrial Avrg ETF TrVanguard Dividend Appreciation ETF
Large-cap Value57.34%45.11%
Large-cap Growth35.82%40.68%
Mid-cap Value0.00%0.00%
Mid-cap Growth0.00%0.00%
Small-cap Value0.00%0.00%
Small-cap Growth0.00%0.00%
Global ex-US Developed Markets0.00%0.00%
Emerging Markets0.00%0.00%
Corporate Bonds0.00%0.00%
Long-Term Treasuries0.00%1.76%
Intermediate-Term Treasuries0.41%12.46%
Short-Term Treasuries6.43%0.00%
R Squared95.02%94.72%
Style analysis is based on monthly returns from January 2007 to December 2020 and uses total portfolio return with monthly rebalancing. Returns based style analysis aims to explain the portfolio returns based on asset class exposures, it does not identify the actual portfolio holdings.

Holdings Based Style Analysis for SPDR Dow Jones Industrial Avrg ETF Tr

Holdings Based Style Analysis for SPDR Dow Jones Industrial Avrg ETF Tr
TickerNameCategoryWeightYieldFeesP/EReturn ContributionRisk Contribution
DIASPDR Dow Jones Industrial Avrg ETF TrLarge Value100.00%1.57%0.16%21.17$24,381100.00%

Asset Allocation

Equity Market Capitalization

Equity Sectors

Holdings Based Style Analysis for Vanguard Dividend Appreciation ETF

Holdings Based Style Analysis for Vanguard Dividend Appreciation ETF
TickerNameCategoryWeightYieldFeesP/EReturn ContributionRisk Contribution
VIGVanguard Dividend Appreciation ETFLarge Blend100.00%1.48%0.06%24.90$25,109100.00%

Asset Allocation

Equity Market Capitalization

Equity Sectors

Fund fundamentals data as of 09/27/2021. (c) 2021 Morningstar. All Rights Reserved. The fund fundamentals information contained herein: (1) is proprietary to Morningstar and/or its content providers; (2) may not be copied or distributed; and (3) is not warranted to be accurate, complete or timely. Neither Morningstar nor its content providers are responsible for any damages or losses arising from any use of this information.

Portfolio return and risk metrics
MetricSPDR Dow Jones Industrial Avrg ETF TrVanguard Dividend Appreciation ETF
Arithmetic Mean (monthly)0.83%0.83%
Arithmetic Mean (annualized)10.45%10.39%
Geometric Mean (monthly)0.74%0.75%
Geometric Mean (annualized)9.22%9.39%
Volatility (monthly)4.33%3.90%
Volatility (annualized)15.00%13.52%
Downside Deviation (monthly)2.88%2.62%
Max. Drawdown-47.05%-41.11%
US Market Correlation0.970.96
Beta(*)0.900.81
Alpha (annualized)0.57%1.45%
R293.25%93.04%
Sharpe Ratio0.610.67
Sortino Ratio0.900.99
Treynor Ratio (%)10.1611.21
Calmar Ratio0.430.79
Active Return-0.36%-0.20%
Tracking Error4.24%4.73%
Information Ratio-0.08-0.04
Skewness-0.57-0.69
Excess Kurtosis1.201.41
Historical Value-at-Risk (5%)-6.31%-6.59%
Analytical Value-at-Risk (5%)-6.29%-5.59%
Conditional Value-at-Risk (5%)-9.84%-8.97%
Upside Capture Ratio (%)90.1182.29
Downside Capture Ratio (%)89.2878.16
Safe Withdrawal Rate9.15%9.19%
Perpetual Withdrawal Rate6.76%6.90%
Positive Periods111 out of 168 (66.07%)113 out of 168 (67.26%)
Gain/Loss Ratio0.850.85
* US stock market is used as the benchmark for calculations. Value-at-risk metrics are based on monthly values.

Drawdowns for Historical Market Stress Periods

Drawdowns for Historical Market Stress Periods
Stress PeriodStartEndSPDR Dow Jones Industrial Avrg ETF TrVanguard Dividend Appreciation ETF
Subprime CrisisNov 2007Mar 2009-47.05%-40.92%
COVID-19 StartJan 2020Mar 2020-22.61%-17.16%

Drawdowns for SPDR Dow Jones Industrial Avrg ETF Tr

Drawdowns for SPDR Dow Jones Industrial Avrg ETF Tr (worst 10)
RankStartEndLengthRecovery ByRecovery TimeUnderwater PeriodDrawdown
1Nov 2007Feb 20091 year 4 monthsApr 20112 years 2 months3 years 6 months-47.05%
2Jan 2020Mar 20203 monthsAug 20205 months8 months-22.61%
3May 2011Sep 20115 monthsJan 20124 months9 months-13.93%
4Oct 2018Dec 20183 monthsApr 20194 months7 months-11.29%
5Mar 2015Sep 20157 monthsMar 20166 months1 year 1 month-9.02%
6Feb 2018Mar 20182 monthsAug 20185 months7 months-7.26%
7Sep 2020Oct 20202 monthsNov 20201 month3 months-6.50%
8May 2019May 20191 monthJun 20191 month2 months-6.38%
9May 2012May 20121 monthAug 20123 months4 months-5.82%
10Jan 2014Jan 20141 monthApr 20143 months4 months-5.19%
Worst 10 drawdowns included above

Drawdowns for Vanguard Dividend Appreciation ETF

Drawdowns for Vanguard Dividend Appreciation ETF (worst 10)
RankStartEndLengthRecovery ByRecovery TimeUnderwater PeriodDrawdown
1Oct 2007Feb 20091 year 5 monthsFeb 20112 years3 years 5 months-41.11%
2Feb 2020Mar 20202 monthsAug 20205 months7 months-17.16%
3May 2011Sep 20115 monthsFeb 20125 months10 months-14.18%
4Oct 2018Dec 20183 monthsMar 20193 months6 months-11.00%
5Mar 2015Sep 20157 monthsMar 20166 months1 year 1 month-9.41%
6Feb 2018Apr 20183 monthsJul 20183 months6 months-6.20%
7Jan 2014Jan 20141 monthMar 20142 months3 months-5.01%
8Apr 2012May 20122 monthsAug 20123 months5 months-4.70%
9May 2019May 20191 monthJun 20191 month2 months-4.63%
10Jun 2007Jul 20072 monthsSep 20072 months4 months-4.08%
Worst 10 drawdowns included above

Portfolio Assets

Performance statistics for portfolio components
TickerNameCAGRStdevBest YearWorst YearMax. DrawdownSharpe RatioSortino RatioUS Mkt Correlation
DIASPDR Dow Jones Industrial Avrg ETF Tr9.22%15.00%29.64%-32.16%-47.05%0.610.900.97
VIGVanguard Dividend Appreciation ETF9.39%13.52%29.62%-26.69%-41.11%0.670.990.96

Monthly Correlations

Correlations for the portfolio assets
TickerNameDIAVIGSPDR Dow Jones Industrial Avrg ETF TrVanguard Dividend Appreciation ETF
DIASPDR Dow Jones Industrial Avrg ETF Tr1.000.971.000.97
VIGVanguard Dividend Appreciation ETF0.971.000.971.00

Portfolio Return Decomposition

Portfolio return decomposition
TickerNameSPDR Dow Jones Industrial Avrg ETF TrVanguard Dividend Appreciation ETF
DIASPDR Dow Jones Industrial Avrg ETF Tr$24,381
VIGVanguard Dividend Appreciation ETF$25,109

Portfolio Risk Decomposition

Portfolio risk decomposition
TickerNameSPDR Dow Jones Industrial Avrg ETF TrVanguard Dividend Appreciation ETF
DIASPDR Dow Jones Industrial Avrg ETF Tr100.00%
VIGVanguard Dividend Appreciation ETF100.00%

Annual Asset Returns

Rolling returns summary
Roll PeriodSPDR Dow Jones Industrial Avrg ETF TrVanguard Dividend Appreciation ETF
AverageHighLowAverageHighLow
1 year9.37%50.08%-40.68%9.40%44.75%-35.02%
3 years10.99%25.55%-7.56%10.55%22.93%-5.88%
5 years11.32%21.23%0.72%10.85%20.36%1.55%
7 years11.46%16.17%5.61%11.06%15.27%6.14%
10 years11.32%16.64%7.06%10.79%15.09%6.97%