CLEC Investment & WealthCLEC Investment & Wealth Database
CLEC Investment & WealthCLEC Investment & Wealth Database
Homepage
Important Materials
Presentations
2023
2023-2024 Files
The Truth About Insurance: Buying Insurance Is Always a Loss. The More Insurance You Buy, the Poorer You Become! Do Not Buy Insurance: Casual Investment Talk, CLEC Investment Channel, Post Date: December 02, 202000049 Short: Questions from Taiwanese investors: Are 00662's internal expenses a problem? Tax issues with sub-brokerage and overseas brokers. CLEC Investment and Finance Channel, September 29, 2023November 27, 2023 Recalculation: The Very Different Fates of Buying and Renting After Thirty Years, Second Edition00004 Special Topic: Systemic Risks You Must Know About Securities-Backed Lending! Know the Risks; Understand the Risks; Control the Risks!2x and 3x LeverageBeta CalculationDo Not Open an Account with an Overseas Broker; Do Not Use Sub-BrokerageCan I Contribute to a Traditional IRA After Maxing Out My 401(k)?If You Still Have to Ask About Asset Allocation for Stock Pledging, You Should Not Pledge or You Could Go Bankrupt!My U.S. Brokerage Is Charles SchwabWhy We Recommend Investing in the Nasdaq-100 Index Fund Instead of the S&P 500Cash is like air: it may not generate profit, but it can keep you alive! Rev 1.1Which account is more tax-efficient for cash in money market funds and leveraged funds?Smart Rebalancing MethodQuestions About Asset AllocationThere Must Be a Limit to Human PessimismSimple Investing Method: Buy a Home or Rent and InvestSafe Asset Allocation for Retirees With No Income Who Use Pledged Stock Loans and Have Already Borrowed a Large Amount! rev. 2.0Asset Allocation When You Have Pledged Stock, Whether Retired or Not, and Whether You Borrow for Expenses or NotLeveraged Funds, Cash, and QQQ/SPY Portfolios: Risk and Return monte_carlo_sim_cagrUnited States and Taiwan: Retirement Asset Allocation for Living by Withdrawing From Assets, Without Pledging, Across Different Funding Levels!Who Can Use Stock Pledging, Who Can Use Leveraged Funds, and Understanding Their RisksWho Can Use Stock Pledging and Leveraged Funds: Understanding the Risks, rev 1.0Asset Allocation Article Information SummaryIf Your Funds Are Not Enough, You Have Not Started Pledging, You Have Not Watched the Videos Carefully, and You Have Not Studied the Excel File, Do Not Ask Pledging Questions!Stock-Collateral Loan Questions: Reply rev 1.0Asset Allocation for People Still Some Time Away from Retirement rev1.0Asset Allocation for People Still Some Time Away from Retirement rev2.000662 and QQQ Performance Question
2024
2025
2025 Files
2026
2026 Files
Hundred-Million Investment Life Lecture
X (Twitter)
Presentations2023-2024 Files

Leveraged Funds, Cash, and QQQ/SPY Portfolios: Risk and Return monte_carlo_sim_cagr

Leveraged Funds, Cash, and QQQ/SPY Portfolios: Risk and Return monte_carlo_sim_cagr

Leveraged Funds, Cash, and QQQ/SPY Portfolios: Risk and Return monte_carlo_sim_cagr cover
Number: P-042
Published: Not specified
Pages: 6
Source filename: 槓桿基金、現金 QQQ SPY資產組合 風險與回報monte_carlo_sim_cagr.PDF
Original PDF: Open PDF

Related Materials

  • Previous presentation: Asset Allocation When You Have Pledged Stock, Whether Retired or Not, and Whether You Borrow for Expenses or Not
  • Next presentation: United States and Taiwan: Retirement Asset Allocation for Living by Withdrawing From Assets, Without Pledging, Across Different Funding Levels!

Document Text

Analysis of Monte Carlo Simulation Results for Asset Classes and Portfolios

Preface

Past history is only one path within a random process. Monte Carlo simulation is a useful tool for studying the possible outcomes of many paths for a random event.

The simulation sample begins at the start of 2008 because it is limited by the launch date of the 2x leveraged fund QLD. It ends at the end of 2022, rather than the end of 2023, to avoid overly optimistic results.

The focus below is compound annual growth rate (CAGR) and maximum drawdown (MDD), without inflation adjustment. The long-term risk of investing is a CAGR that is too low. If performance is poor or even trails long-term inflation, real purchasing power shrinks and social class can slide toward poverty. Short-term risk comes from excessive MDD. A large drawdown can damage confidence and lead investors to sell, creating permanent loss. If cash flow depends on invested assets, a decline creates psychological pressure; if securities-backed borrowing is used, a large decline may also cause forced liquidation.

This article organizes Portfolio Visualizer simulation results and presents them as box charts for easier comparison. The bottom and top of each box are the first quartile (Q1) and third quartile (Q3), and the middle line is the median. The lower and upper whiskers mark the 10th and 90th percentiles. Intuitively, the five points from bottom to top represent the outcomes of the unluckiest investor, a less lucky investor, an ordinary investor, a lucky investor, and the luckiest investor.

Box charts are useful for comparing assets and holding periods, but they do not show the full probability distribution of simulation results. Still, they help reveal features such as interquartile range (IQR), which reflects variability. Whether the median is centered in the box and whether the whiskers are balanced also indicates whether the distribution is skewed.

Finally, Monte Carlo simulation cannot know every future outcome. It only shows many possible future paths, so the exact value at each box-chart point is not the key issue. The key is comparing asset classes or combinations and different holding periods. Because simulation output is strongly affected by the original sample distribution, we first compare SPY historical data with simulation results to assess reliability.

Figure 1-1: Yahoo Finance line chart comparing SPY and TLT total return from 2008 to 2023, with SPY far outpacing TLT.

SPY vs TLT vs CASH. First, look at JPMorgan's 1950-2020 historical data. The light-green stock-market return distributions for rolling 5-year, 10-year, and 20-year periods are basically covered by the SPY CAGR box chart and whiskers in Figure 1(a). Therefore, using data from the start of 2008 to the end of 2022 as simulation input is broadly useful and has reference value.

For CASH, the most distinctive feature is that MDD is always zero regardless of holding period. Compared with the uncertainty of potential stock-market declines, this explains why many people prefer holding cash instead of investing. But risk-averse investors holding large cash positions often ignore the unbearable long-term risk of low CAGR. Avoiding short-term risk also means giving up returns and indirectly pushing oneself toward poverty.

For SPY, once the holding period exceeds 15 years, even the worst 10% of simulated CAGR outcomes remain positive. The variability of outcomes narrows as the holding period lengthens: the best outcomes gradually come down, and the worst outcomes gradually move up.

This shows that investing is fair over long periods. The gap between the luckiest and unluckiest investors can become small enough to satisfy most people. SPY's MDD can become larger as the holding period increases, but investors are rewarded for bearing that decline. Over a 25-year SPY holding period, a bad market may produce MDD over -60%, yet CAGR can still be around 4%. A decline alone is never a reason to sell stocks.

The surprising result is TLT. Even over 25 years, the long-term Treasury fund can still produce negative returns. Its CAGR median is only around 4%, and its MDD distribution is wider and lower than SPY's, meaning larger possible losses. TLT exposes holders to both long-term and short-term risks without corresponding returns, so it is not an ideal investment.

Figure 2-1: J.P. Morgan bar chart of the range of stock, bond, and 50/50 portfolio total returns over 1-, 5-, 10-, and 20-year rolling periods (1950-2020). Figure 2-2: Monte Carlo box charts of CAGR and maximum drawdown for SPY, TLT, and cash across 5- to 25-year holding periods.

SPY vs QQQ vs QLD. Here we compare SPY, QQQ, and the daily 2x leveraged ETF QLD. If someone believes in long-term market growth, should they go all in on leveraged ETFs?

In Figure 2, QQQ's CAGR boxes sit above SPY's, showing higher returns, but QQQ's MDD boxes are slightly lower, showing deeper drawdowns. Both are diversified and avoid idiosyncratic risk, but SPY's additional 400 stocks provide somewhat better downside protection, while removing those 400 stocks improves CAGR. QQQ's boxes are only slightly longer than SPY's, meaning luck affects QQQ only slightly more than SPY. Even the unluckiest long-term QQQ investor does better on average than an SPY investor.

QLD's five-year CAGR upper box edge reaches an extreme 58%, attracting many investors, but its five-year lower whisker is also an extreme -16%, which repels others. QLD's CAGR box width is roughly twice QQQ's. Leverage raises median return but also raises variability. Lucky investors who buy near lows can earn very high average annual returns, while unlucky investors who buy at bubble peaks may still fail to earn positive returns after 20 years. QLD's MDD can reach about -98% over a 25-year period. If that happens early, recovery may be possible; if late, it can be extremely painful.

If single-year returns are independent random variables, then by the central limit theorem, long-term average geometric annual returns are log-normally distributed. Daily 2x leverage magnifies volatility and the standard deviation of average annual returns, increasing skewness. High skew means a few paths have very high returns, while most paths are far below them, similar to lottery payoff distributions.

Figure 3-1: Monte Carlo box charts of CAGR and maximum drawdown for SPY, QQQ, and 2x-leveraged QLD across 5- to 25-year holding periods. Figure 3-2: Probability density function chart comparing log-normal outcome distributions for volatility sigma=0.5 and sigma=1.

QQQ vs Case 1 vs 50/50. The real function of leveraged ETFs is to complement cash: cash reduces QLD's severe MDD, while QLD offsets cash drag and weak CAGR. Suppose an investor must keep cash for emergency reserves or collateral borrowing. If the same proportion is invested in a 2x leveraged ETF and the leveraged ETF and cash are rebalanced back to 1:1 every year, the cash drag problem can be reduced.

The red box chart in Figure 3 is QQQ:QLD:CASH = 60:20:20. Its expected beta is equivalent to 100% QQQ. CAGR box width is almost the same as 100% QQQ and slightly higher overall, suggesting slightly better average annual return. But MDD inherits some QLD characteristics and is slightly deeper. After daily market moves, QQQ:QLD:CASH weights drift. When QLD rises, its weight increases, increasing future drawdown risk until rebalancing removes the problem.

If cash is increased further, the limit under this rule is QLD:CASH = 50:50. CAGR remains almost as wide as 100% QQQ and slightly higher, while MDD becomes less variable and somewhat smaller than 100% QQQ. This appears to offer lower short-term risk and better long-term return. But one must ask why such a high cash ratio is needed. High cash can create behavioral errors: chasing after rises, trying to bottom-fish after declines, failing to rebalance after deeper declines, or incorrectly taking profits or stop-losses because of leveraged ETF volatility. Even with discipline, high cash and high leveraged ETF positions require rebalancing, which creates transaction costs and possibly capital gains tax. For pledged borrowing, lenders may not accept leveraged ETFs as collateral, while cash and unlevered index funds usually create less concern.

Figure 4-1: Monte Carlo box charts of CAGR and maximum drawdown for QQQ, QQQ:QLD:CASH=60:20:20, and QLD:CASH=50:50 across 5- to 25-year holding periods.

QQQ vs beta 1.2 vs 60/40. The Kelly formula tells gamblers how much to bet to maximize long-term average return when expected return, risk-free rate, and standard deviation are known. Past research applying this principle to the S&P 500 suggested an allocation of 117%, meaning all-in was not enough; borrowing an extra 17% of principal would produce the expected optimal average annual return. Borrowing, however, has interest costs and requires collateral or good credit. Can the same effect be achieved another way?

The red CAGR boxes in Figure 4 use QQQ:QLD:CASH = 60:30:10, with expected volatility at 120% of QQQ. The median CAGR is about 2% higher than QQQ's. For holding periods above ten years, the lower whisker is almost aligned with QQQ's, while the upper whisker and upper box edge are higher. This suggests that using cash and 2x leveraged funds to raise volatility can improve upside without lowering expected minimum average annual return. There is no free lunch, however: MDD boxes are lower than QQQ's, so the price of higher return is larger drawdown.

The prior section's effect of reducing MDD by raising cash also appears here. At 120% expected volatility, maximizing cash leads to QLD:CASH = 60:40. The yellow CAGR box is roughly similar to the red box, while the yellow MDD box sits higher, meaning higher cash lowers maximum drawdown without reducing return.

A preliminary conclusion: leveraged funds are powerful tools. They can be combined with unlevered index funds and cash to adjust leverage without the complexity of borrowing or derivatives. If unlevered index funds are steak, cash and leveraged funds are seasoning. Properly used, they improve the meal, but no one orders only the seasoning.

Figure 5-1: Monte Carlo box charts of CAGR and maximum drawdown for QQQ, QQQ:QLD:CASH=60:30:10, and QLD:CASH=60:40 across 5- to 25-year holding periods.

QQQ vs 60/40 vs 60/40(TLT). TLT is not always negatively correlated with stocks, but because it has low long-term correlation with stocks, it is popular in traditional stock-bond allocations. What happens if TLT replaces cash?

In the CAGR box chart, the yellow box again shows a familiar effect: its lower whisker aligns with or exceeds QQQ's lower whisker, while the upper whisker and upper box edge are higher. Replacing cash with TLT slightly improves expected minimum average annual return and raises expected maximum average annual return. But again there is no free lunch. The cost is higher MDD: yellow MDD boxes are lower than blue and red. Whether comparing QQQ to SPY, 120% volatility portfolios to QQQ, or TLT replacing cash, higher CAGR comes with larger MDD. Higher return means higher volatility; this is a beta effect, not alpha.

Returning to the steak analogy, replacing salt, or cash, with seasoned salt, TLT, may make the flavor better, but not everyone can accept it.

Conclusion: this article first shows the risks of cash, TLT, and QLD used alone, such as low growth, low returns, or high variability that makes outcomes depend heavily on luck. But when these asset types are combined in appropriate ratios, interesting characteristics appear. Still, investment cannot be driven by the rearview mirror. The variables needed by the Kelly formula are unknown, so the optimal leverage level cannot truly be known. Monte Carlo simulation is objective, but it uses data from a limited period. Black swan events are often not visible in the historical sample.

Investing has many possibilities, and adding leveraged funds creates even more. This article offers a perspective and background knowledge. In investing, the greatest danger is not decline itself, but ignorance: taking large risks without knowing it, or not understanding the cost of refusing to take risk.

Once an asset allocation exists, rebalancing is needed. Rebalancing does not have to be only periodic and mechanical; tactical methods are possible. But those more complex operations are harder to simulate and are beyond this article's scope.

Peta Hung, 2024.10.19

Figure 6-1: Monte Carlo box charts of CAGR and maximum drawdown for QQQ, QLD:CASH=60:40, and QLD:TLT=60:40 across 5- to 25-year holding periods.

Asset Allocation When You Have Pledged Stock, Whether Retired or Not, and Whether You Borrow for Expenses or Not

Asset Allocation When You Have Pledged Stock, Whether Retired or Not, and Whether You Borrow for Expenses or Not

United States and Taiwan: Retirement Asset Allocation for Living by Withdrawing From Assets, Without Pledging, Across Different Funding Levels!

United States and Taiwan: Retirement Asset Allocation for Living by Withdrawing From Assets, Without Pledging, Across Different Funding Levels!

Table of Contents

Related MaterialsDocument TextAnalysis of Monte Carlo Simulation Results for Asset Classes and Portfolios