ETF Rebalancing Calculator

Manage US stocks, Korean stocks, and ETFs in one place and auto-rebalance to your target allocation

Real-time US & KR stock prices
Auto buy/sell calculation
Cloud sync supported

Optimizing Your Assets with a Portfolio Calculator

The Complete Expert Guide

📊 Reading time: 14 min🎯 Last updated: 2025.01⚡ Ready for practical use

🎯 Key Summary

  • Portfolio optimization is the science of maximizing returns for a given level of risk
  • Portfolios on the efficient frontier are the optimal choice
  • Different strategies are needed depending on age and goals
  • Global diversification can reduce risk by more than 30%

Deep Dive: Portfolio Theory

A Complete Understanding of Modern Portfolio Theory (MPT)

Modern Portfolio Theory (MPT), published by Harry Markowitz in 1952, completely transformed the paradigm of investing. The core insight of this theory is that "the correlation between assets matters more than the risk of any individual asset."

Core Formulas of MPT

Portfolio Expected Return:

E(Rp) = Σ wi × E(Ri)

Portfolio Variance (Risk):

σ²p = Σ Σ wi × wj × σi × σj × ρij

• wi, wj = weights of assets i, j

• E(Ri) = expected return of asset i

• σi, σj = standard deviations of assets i, j

• ρij = correlation coefficient of assets i, j

What this formula means is simple. By combining assets with low (ideally negative) correlation, the overall portfolio risk becomes smaller than the sum of individual asset risks. This is the diversification effect often called the "Free Lunch" of investing.

Asset CombinationCorrelation CoefficientRisk Reduction EffectExample
Perfect Positive Correlation+1.00%Apple + Microsoft
Weak Positive Correlation+0.515%Stocks + Real Estate
Uncorrelated030%Stocks + Commodities
Weak Negative Correlation-0.340%Stocks + Bonds
Perfect Negative Correlation-1.0100%Theoretical Ideal

The Efficient Market Hypothesis and Its Limitations

Eugene Fama's Efficient Market Hypothesis (EMH) argues that "since all information is immediately reflected in prices, it is impossible to beat the market." However, several anomalies are observed in reality.

Where EMH Holds

  • ✓ Most active funds underperform the index
  • ✓ Information is quickly reflected in prices
  • ✓ Short-term price prediction is very difficult
  • ✓ Transaction costs and taxes erode returns

Limitations of EMH

  • ✗ Bubbles and crashes occur repeatedly
  • ✗ Value stocks outperform growth stocks long-term
  • ✗ Momentum effects are consistently observed
  • ✗ Superstar investors like Warren Buffett exist

Practical Application Tips

Don't believe in the efficient market hypothesis 100%, but don't ignore it 100% either. A "core-satellite strategy" — where 70–80% is in index funds (core) and 20–30% uses active strategies (satellite) — is the wise choice.

Portfolio Construction from a Behavioral Finance Perspective

Behavioral finance, pioneered by Daniel Kahneman and Richard Thaler, studies how irrational human behavior affects investing. When constructing a portfolio, watch out for the following psychological biases.

Loss Aversion

Losses feel twice as painful as equivalent gains

Solution

Use systematic rebalancing to remove emotion

Confirmation Bias

Accepting only information that supports your beliefs

Solution

Actively consider opposing viewpoints

Overconfidence

Overestimating your own abilities

Solution

Stay humble and diversify

Herding

Tendency to follow the crowd

Solution

Think independently and take a long-term view

Recency Bias

Placing too much weight on recent events

Solution

Make decisions based on long-term data

Portfolio Calculator Master Class

Using the portfolio calculator correctly lets you apply Nobel Prize-winning economic theory in practice. Let's master everything step by step, from basic to advanced features.

Mastering the Basic Features

1. Entering Assets and Analyzing Current Portfolio

Enter the ETFs you currently hold and their quantities, and the calculator instantly analyzes your current portfolio based on real-time prices.

Input Example:
ETFQtyPriceValueWeight
VOO50$450$22,50045%
QQQ30$400$12,00024%
AGG100$105$10,50021%
VNQ60$85$5,10010%
Total$50,100100%

2. Setting Target Weights and Analyzing the Gap

Set your desired target weights and the calculator automatically computes the gap from your current allocation, then suggests the required buy/sell quantities.

Current vs. Target
VOO45% → 40%
QQQ24% → 30%
AGG21% → 25%
VNQ10% → 5%
Required Action
VOOSell 6 shares
QQQBuy 8 shares
AGGBuy 19 shares
VNQSell 30 shares

Interpreting Risk Metrics

Standard Deviation (σ)

The most fundamental indicator of volatility

Low<10%
Medium10-20%
High>20%

💡 Annual basis; divide by √252 for daily

Beta (β)

Indicator of sensitivity relative to the market

β < 1Defensive
β = 1Market-neutral
β > 1Aggressive

💡 Typically measured relative to the S&P 500

Sharpe Ratio

The key indicator of risk-adjusted returns

<1.0Poor
1.0-2.0Acceptable
>2.0Excellent

💡 (Return - Risk-Free Rate) / Standard Deviation

📊 Additional Risk Metrics

Max Drawdown

Maximum decline from peak; target within -20%

VaR (Value at Risk)

Maximum loss at 95% confidence level; within 5% of assets

Sortino Ratio

Considers only downside risk; more precise than Sharpe

Information Ratio

Excess return over benchmark / tracking error

Utilizing the Correlation Matrix

The correlation matrix is central to portfolio construction. Let's analyze the correlations among actual ETFs.

ETFVOOQQQAGGGLDVNQEEM
VOO1.000.88-0.150.020.750.68
QQQ0.881.00-0.20-0.050.650.72
AGG-0.15-0.201.000.25-0.10-0.18
GLD0.02-0.050.251.000.080.15
VNQ0.750.65-0.100.081.000.55
EEM0.680.72-0.180.150.551.00

Interpretation Guide:

Negative correlation (good)
Low correlation (acceptable)
High correlation (caution)

Portfolio Strategies by Age / Situation

The optimal portfolio varies by life stage and personal circumstances. Let's look at specific strategies and ETF recommendations for each age group.

20s: Aggressive Growth Strategy

Key Principles

  • • Investment horizon: 40+ years
  • • Risk tolerance: Very high
  • • Goal: Maximum asset growth
  • • Stock weight: 80–100%

Recommended Portfolio

QQQ (NASDAQ)30%
VTI (Total Market)25%
VXUS (International)20%
VWO (Emerging)15%
ARKK (Innovation)10%

💡 Special tip for your 20s: Time is your greatest asset. Don't fear short-term volatility — invest consistently. Build a system that automatically invests 20–30% of your paycheck.

30s: Balanced Growth

Key Principles

  • • Investment horizon: 30–35 years
  • • Risk tolerance: High
  • • Goal: Balance between growth and stability
  • • Stock weight: 70–80%

Recommended Portfolio

VOO (S&P 500)35%
QQQ (Tech)20%
VXUS (International)15%
BND (Bonds)20%
VNQ (REITs)10%

💡 Special tip for your 30s: Since this is a time of building a family, make sure to secure an adequate emergency fund before investing. Manage children's education costs in a separate account and actively use retirement accounts (IRP, pension savings).

40s: Stable Accumulation

Key Principles

  • • Investment horizon: 20–25 years
  • • Risk tolerance: Moderate
  • • Goal: Asset preservation and moderate growth
  • • Stock weight: 60–70%

Recommended Portfolio

VTI (Total Market)30%
SCHD (Dividend)20%
VXUS (International)10%
AGG (Bonds)25%
VNQ (REITs)10%
GLD (Gold)5%

💡 Special tip for your 40s: This is when your income peaks. Actively apply tax-reduction strategies, increase dividend income to improve cash flow, and run retirement simulations regularly.

50s+: Retirement Preparation

Key Principles

  • • Investment horizon: 10–15 years
  • • Risk tolerance: Low
  • • Goal: Capital preservation and income
  • • Stock weight: 40–50%

Recommended Portfolio

VYM (High Dividend)20%
DVY (Dividend Select)15%
BND (Total Bond)30%
VTEB (Municipal Bond)15%
O (Monthly Dividend REIT)10%
GLD (Gold)5%
Cash5%

💡 Special tip for your 50s+: Minimize sequence-of-returns risk (early retirement losses). Keep 3–5 years of living expenses in safe assets, and prepare so that dividends and interest income can cover your living expenses.

Portfolios for Special Situations

🎓 Preparing for Children's Education Costs

  • • Target horizon: 10–18 years
  • • Early: Stocks 70% / Bonds 30%
  • • Mid: Stocks 50% / Bonds 50%
  • • Late: Stocks 20% / Bonds 80%

🏠 Home Purchase Fund

  • • Target horizon: 3–5 years
  • • Short-term bonds: 40%
  • • Stable dividend stocks: 30%
  • • Cash/MMF: 30%

💼 Early Retirement (FIRE)

  • • Savings rate: 50–70%
  • • Stocks: 75% (index-focused)
  • • Bonds: 20%
  • • REITs: 5%

🏥 Medical Expense Reserves

  • • Utilize HSA account
  • • Healthcare sector: 20%
  • • Stable bonds: 50%
  • • Dividend stocks: 30%

Global Diversification Strategies

Overcoming home bias and diversifying globally can reduce risk while expanding return opportunities. Let's explore how to construct a global portfolio.

Optimal Allocation by Region

Market Cap-Weighted Allocation

United States60%
Developed Markets (ex-US)25%
Emerging Markets15%

GDP-Weighted Allocation

United States40%
Developed Markets30%
Emerging Markets30%

💡 For most investors, market cap-weighting is appropriate. GDP-weighting has a higher emerging market share, which leads to greater volatility.

Global ETF Selection Guide

RegionETFCostFeatureRating
GlobalVT0.08%9,000 global holdings⭐⭐⭐⭐⭐
USVTI0.03%US total market⭐⭐⭐⭐⭐
VOO0.03%S&P 500⭐⭐⭐⭐⭐
DevelopedVXUS0.08%All ex-US⭐⭐⭐⭐
VEA0.05%Developed markets only⭐⭐⭐⭐
EmergingVWO0.08%All emerging markets⭐⭐⭐⭐
EEM0.68%High liquidity⭐⭐⭐
EuropeVGK0.09%European developed markets⭐⭐⭐
AsiaVPL0.09%Asian developed markets⭐⭐⭐

Currency Hedging Considerations

With Currency Hedge

  • ✓ Eliminates exchange rate risk
  • ✓ Predictable returns
  • ✗ Additional costs (1–2% per year)
  • ✗ Unfavorable when USD strengthens

Without Currency Hedge

  • ✓ Additional gains when USD strengthens
  • ✓ Lower costs
  • ✗ Exchange rate risk
  • ✗ Increased short-term volatility

💡 Recommendation: For long-term investing (10+ years), no currency hedge; for short-term investing (3 years or less), hedging is advantageous.

Practical Portfolio Rebalancing

Rebalancing is the core of portfolio management. Through real examples, let's explore when and how to rebalance.

Optimal Rebalancing Timing

✅ Recommended Timing

  • • Target weight deviates by ±5%
  • • Quarterly regular review
  • • On large cash inflows
  • • When reinvesting dividends

⚠️ Proceed with Caution

  • • Right after a sharp market move
  • • When making emotional decisions
  • • Reacting to short-term news
  • • Without considering taxes

❌ Timing to Avoid

  • • Readjusting within 1 month
  • • Minor differences (±2%)
  • • Transaction costs exceed gains
  • • Year-end tax season

Practical Rebalancing Example

Scenario: Q3 2024 Rebalancing

Initial investment $100,000 → Current value $125,000 (25% gain)

AssetTargetCurrentDiffAdjustment
Stocks (VOO)60%68%+8%-$10,000
Bonds (AGG)30%24%-6%+$7,500
REITs (VNQ)10%8%-2%+$2,500

Execution Plan

  1. 1. Sell 22 shares of VOO (worth $10,000)
  2. 2. Buy 71 shares of AGG (worth $7,500)
  3. 3. Buy 29 shares of VNQ (worth $2,500)
  4. 4. Total transaction cost: approx. $30 (0.024%)

Performance Measurement and Benchmarking

Accurately measuring portfolio performance and comparing it against an appropriate benchmark is essential for improving your investment strategy.

Key Performance Indicators

Return Metrics

Time-Weighted Return (TWR)

Pure performance excluding cash flow effects

Money-Weighted Return (MWR)

The return actually experienced by the investor

CAGR

Compound Annual Growth Rate

Risk-Adjusted Metrics

Sharpe Ratio

Excess return per unit of risk

Sortino Ratio

Return relative to downside risk

Calmar Ratio

Return relative to maximum drawdown

Choosing an Appropriate Benchmark

Portfolio TypeRecommended BenchmarkAlternative
US Stock-FocusedS&P 500Russell 3000
Global StocksMSCI ACWIFTSE Global All Cap
Balanced Portfolio60/40 CustomTarget Date Fund
Conservative Portfolio40/60 CustomAGG + Inflation
Aggressive PortfolioNASDAQ 100Russell Growth

Frequently Asked Questions and Answers

Q1. How many ETFs should a portfolio consist of?

Generally, 4–8 is appropriate. Too few means insufficient diversification; too many makes management complex. Ideally, 3–4 core assets and 2–3 satellite assets.

Q2. Can I mix individual stocks and ETFs?

Yes, you can. However, it is best to build the core (70–80%) with ETFs and limit individual stocks to the satellite (20–30%).

Q3. Should I follow the portfolio calculator results 100%?

No. The calculator only provides guidelines. Adjust based on your personal situation and market outlook.

Q4. How often should I review my portfolio?

Monthly check-ins, a detailed quarterly analysis, and 1–4 rebalancings per year are appropriate. Checking too frequently can actually be harmful.

Q5. Should I change my portfolio when the market crashes?

On the contrary, this is precisely the time to stick to your principles. A crash is an opportunity to buy low through rebalancing.

Q6. What is the difference between portfolio optimization and rebalancing?

Optimization is about setting target weights; rebalancing is about maintaining those targets.

Q7. Can I trust backtesting results?

They are useful as a reference, but the past does not guarantee the future. Test a variety of scenarios.

Q8. How do I manage currency risk?

For long-term investing, consider no currency hedge; for short-term or retirement funds, consider partial hedging.

Q9. How should I construct a portfolio with tax efficiency in mind?

Place assets with high dividends/interest in tax-advantaged accounts (ISA, IRP), and keep growth stocks in regular brokerage accounts.

Q10. Should I include AI or thematic ETFs?

Limit them to no more than 10% of the total. Thematic investing has high volatility and uncertain long-term performance.

Q11. Do I need bond ETFs?

They are essential from your 30s onward. Increase their weight as you age to secure stability.

Q12. Isn't investing in emerging markets risky?

On their own, yes — but limiting them to 10–20% of the portfolio helps improve overall returns.

Q13. Is it a failure if my portfolio underperforms its benchmark?

No. If you achieved stable returns with lower volatility, that is a success. You need to look at risk-adjusted returns.

Q14. Which is better — a robo-advisor or self-management?

A robo-advisor is better for beginners or those with little time; self-management is better if you want to save on costs.

Q15. Do I need portfolio insurance (hedging)?

It is worth considering starting 5 years before retirement. Partial hedging is possible with put options or VIX ETFs.