Asset Allocation Rebalancing Worksheet

Most investors set a target allocation once and never touch it again. The result: portfolios drift silently toward higher risk, and the correction comes at the worst possible time—during a drawdown. A 60/40 portfolio can drift to approximately 65/35 after a single year in which stocks return 15% and bonds return 3%. Vanguard research shows that systematic rebalancing reduces portfolio volatility by 0.5–1.5 percentage points annualized with minimal drag on long-term returns. The practical antidote is a written worksheet—a forcing function that turns vague intentions into specific trades.

TL;DR: A rebalancing worksheet converts your target allocation into a step-by-step calculation: current weights → drift measurement → trade list. Using ±5 percentage point tolerance bands with quarterly monitoring captures most of the benefit while minimizing unnecessary trading.

What Drift Actually Costs You (And Why Worksheets Fix It)

Drift is the gap between where your portfolio is and where it should be. It happens automatically because different asset classes earn different returns. Stocks have returned approximately 10.3% annualized since 1926, while intermediate-term government bonds have returned approximately 5.3% (Ibbotson/Morningstar SBBI data). That return gap compounds into meaningful allocation shifts within months.

The point is: drift isn't a bug—it's the inevitable consequence of owning assets with different expected returns. A worksheet forces you to measure it instead of guessing.

Target drift → Risk mismatch → Behavioral reaction → Panic selling → Permanent loss

Without a worksheet, most investors discover their allocation has drifted only after a sharp drawdown makes the mismatch painful. During the 2020 COVID crash, a 60/40 portfolio drifted to roughly 50/50 as the S&P 500 fell 34% in 23 trading days. Investors who rebalanced back to 60/40 near the trough recovered to pre-crash levels approximately 6 weeks earlier than those who didn't.

The Worksheet (Step-by-Step Calculation)

Here's a rebalancing worksheet for a $100,000 portfolio with a 60/40 target. The inputs use realistic drift after a strong equity year.

Step 1: Record current values and weights.

Step 2: Apply your tolerance bands.

The consensus from Vanguard and Daryanani's research: use ±5 percentage point absolute bands for major asset classes. For smaller allocations (below 10% of the portfolio), use ±25% of the target weight instead—a 10% target triggers at 7.5% or 12.5%.

In this example, no single asset class has breached the ±5pp band (the largest drift is +4.5pp on U.S. Stocks). No trades required this quarter. The worksheet just saved you from unnecessary trading.

Step 3: When a band does break, calculate the trade.

Suppose U.S. Stocks drift to $51,500 (51.5%)—breaching the 50% upper band. The trade calculation:

• Target value: $100,000 × 45% = $45,000
• Current value: $51,500
• Required sale: $51,500 − $45,000 = $6,500
• Direct proceeds to: U.S. Bonds (most underweight)

Why this matters: you rebalance to the target, not just back inside the band. Rebalancing only to the edge creates more frequent, smaller trades that increase costs without improving risk-adjusted returns.

Cash-Flow Rebalancing (The Tax-Smart First Move)

Before selling anything in a taxable account, check whether incoming cash flow can do the work. Dividends, interest, new contributions, and required withdrawals are free rebalancing tools (no capital gains triggered).

The rule: when new cash exceeds 1% of total portfolio value per quarter, direct it entirely to underweight asset classes. You buy 100 shares of your underweight bond ETF with this quarter's dividend reinvestment, and you've closed half the drift gap without a single taxable sale.

The point is: selling overweight positions is the last step, not the first. Cash flow first → New contributions second → Selling last.

When you do sell in a taxable account, use specific-identification tax lot accounting. Sell lots with the highest cost basis first (to minimize realized gains), and never sell positions held less than 366 days unless the rebalancing need is urgent. Short-term gains are taxed as ordinary income at rates up to 37%, while long-term rates top out at 20%—that spread matters.

(Watch for the wash-sale rule: if you sell at a loss and buy a substantially identical security within 30 days, the IRS disallows the loss under IRC Section 1091.)

When Rebalancing Adds the Most Value (And When It Doesn't)

The 2008–2009 financial crisis was the textbook case. A 60/40 portfolio drifted to approximately 42/58 by March 2009 as the S&P 500 fell from 1,565 to 677. Investors who rebalanced back to 60/40 at the trough captured approximately 26% more equity upside over the subsequent 12-month recovery (the S&P 500 rose 68% from March 2009 to March 2010).

The practical point: rebalancing is a contrarian mechanism that forces you to buy cheap and sell expensive—systematically, without requiring conviction.

But 2022 showed the limitation. When stocks fell approximately 25% and bonds fell approximately 13% simultaneously, a 60/40 portfolio only drifted to about 58/42. Both asset classes declined together (correlations spiked above 0.5), so there was little drift to correct. Rebalancing adds the most value when cross-asset correlations stay below 0.3—which is most of the time, but not during correlated drawdowns.

The durable lesson: rebalancing is not a return enhancer. It's a risk management tool that keeps your portfolio aligned with your actual risk tolerance. Daryanani's research found threshold-based rebalancing improved risk-adjusted returns by approximately 0.25% per year versus calendar-only methods—meaningful, but modest.

Choosing Your Method (Calendar vs. Threshold vs. Hybrid)

A survey from the Journal of Financial Planning found 58% of advisors rebalance quarterly, 26% annually, and 16% use threshold-only. The research favors a hybrid: monitor quarterly, trade only when a ±5pp band is breached. Vanguard found that annual monitoring with 5% threshold bands produced risk-adjusted results within 0.03% of daily-monitored thresholds. More frequent checking adds complexity without meaningful improvement.

Rebalancing Worksheet Checklist

Essential (high ROI):

• Write down your target allocation with specific percentages for each asset class
• Set ±5pp tolerance bands (or ±25% of target for allocations under 10%)
• Schedule quarterly portfolio reviews on your calendar
• Calculate drift in percentage points before deciding whether to trade

High-impact (tax and cost efficiency):

• Direct new contributions and dividends to underweight classes first
• Use specific-lot identification when selling in taxable accounts
• Hold positions at least 366 days before selling to qualify for long-term capital gains rates
• Set a minimum trade size of $1,000 or 1% of portfolio (whichever is greater)

Optional (good for taxable accounts):

• Pair rebalancing trades with tax-loss harvesting opportunities
• Track rebalancing costs per event (target below 0.5% of amount traded)

Your Next Step

Open your brokerage account today and record your current allocation in a spreadsheet with four columns: Asset Class, Target %, Current %, Drift (pp). If any position has drifted more than 5 percentage points, calculate the dollar trade needed to return to target—and check whether upcoming contributions can close the gap before you sell. That single worksheet is the difference between a portfolio that manages you and one you actually manage.