Complete "Lesson 15: Portfolio Overlap, Cash and Bonds" first to unlock this lesson.Go to previous lesson

In this sixteen-minute beginner lesson, learners build a spreadsheet to apply a predefined portfolio rebalancing rule using fictional Global Stock ETF, Bond ETF, and Cash holdings in a simulated account. Starting with a 60% stock, 30% bond, and 10% cash policy, learners calculate current weights, percentage-point drift, target dollar values, proposed trades, trading spreads, hypothetical taxes, whole-share quantities, and remaining cash. They practice applying a five-percentage-point threshold consistently, distinguishing a rebalancing trigger from a performance forecast, and documenting execution costs and rounding differences. The outcome is a reproducible spreadsheet and journal entry showing whether the written rule requires rebalancing or holding.

Why Rebalance and Why Write the Rule First

Portfolio rebalancing is the process of adjusting asset allocations toward predefined target weights. It is primarily a tool for maintaining a chosen risk exposure rather than maximizing returns. Assets change in value at different rates, causing their percentage weights to drift away from the original plan. Without a rule, learners may allow recent performance or emotion to determine whether to make adjustments. A written policy creates a consistent reference that can be applied before and after market changes. This lesson uses fictional Global Stock ETF, Bond ETF, and Cash in a simulated account.

Learner preparing a portfolio rebalancing spreadsheet
Figure 1. A written rule decides when a portfolio is rebalanced.

Our written policy specifies a target allocation of 60% Global Stock ETF, 30% Bond ETF, and 10% Cash. It also specifies that rebalancing occurs when any asset's current weight differs from its target by more than five percentage points. If all differences are five percentage points or less, the policy requires holding the existing allocation. The word more is important: a deviation of exactly five percentage points does not trigger the rule. The threshold should be stated before the market moves so it cannot be redefined to justify a preferred outcome.

Written investment policy showing three asset classes
Figure 2. The written policy: 60% stock ETF, 30% bond ETF, 10% cash.
Initial portfolio allocation among stocks bonds and cash
Figure 3. Starting allocation of the simulated $10,000.

Key points

  • Rebalancing returns a portfolio to the risk mix you chose; it is not a forecast or a way to boost returns.
  • Write the rule before the market moves: targets 60/30/10 and rebalance when any drift is more than 5 points.
  • Calendar rules act on dates; threshold rules act on drift.
The written policy
HoldingTarget weightStarting value
Global Stock ETF60%$6,000
Bond ETF30%$3,000
Cash10%$1,000
Total100%$10,000
Rule: rebalance when any weight is more than 5 percentage points from target; otherwise hold.

Different policies can use different approaches. A calendar rule triggers rebalancing at predefined intervals, such as a scheduled annual review. A threshold rule triggers when weight drift exceeds a specified tolerance. Some policies combine both methods. None guarantees higher returns or lower realized costs. For this educational exercise, we use the stated five-percentage-point threshold rule, and the scenario provides a hypothetical year-end observation. Rebalancing is not a forecast that an overweight asset will decline or an underweight asset will rise.

Calendar rebalancing compared with threshold rebalancing
Figure 4. Calendar rule versus threshold rule.

Calculate Current Weights and Identify the Threshold Trigger

Begin with the simulated $10,000 portfolio. At its starting point, Global Stock ETF holds $6,000, Bond ETF holds $3,000, and Cash holds $1,000. These values match the written targets of 60%, 30%, and 10%. After one hypothetical year, market movements and account activity leave Global Stock ETF valued at $8,100, Bond ETF at $3,060, and Cash at $840. The sum is exactly $12,000. Current weight is calculated by dividing each asset's value by the current total portfolio value, not by the original $10,000 balance.

Portfolio allocation drifting as asset values change
Figure 5. After a year the stock share has grown.

The current weights are $8,100 divided by $12,000, or 67.5% stocks; $3,060 divided by $12,000, or 25.5% bonds; and $840 divided by $12,000, or 7.0% cash. These percentages sum to exactly 100%. Calculate drift by subtracting each target weight from its corresponding current weight. Stock drift is positive 7.5 percentage points, bond drift is negative 4.5 points, and cash drift is negative 3.0 points. Positive drift means overweight relative to the policy, while negative drift means underweight.

Spreadsheet containing asset values and target weights
Figure 6. Values and target weights in the spreadsheet.
Current portfolio weights compared with target allocations
Figure 7. Current weights compared with target weights.

Key points

  • Current weight = value / total: 8,100 / 12,000 = 67.5%, 3,060 / 12,000 = 25.5%, 840 / 12,000 = 7.0%.
  • Drift = current weight - target weight: +7.5, -4.5, -3.0 points.
  • Stock drift 7.5 is more than 5, so the rule says rebalance. Exactly 5 would not trigger it.
Weights and drift after one year
HoldingValueWeightTargetDrift
Global Stock ETF$8,10067.5%60%+7.5
Bond ETF$3,06025.5%30%-4.5
Cash$8407.0%10%-3.0
Total$12,000100%100%
Drift from target (percentage points)
+7.5
Stock
-4.5
Bond
-3.0
Cash
Bars show the size of the drift; the threshold is 5 points.

The rule uses the absolute size of each deviation. Stocks have a 7.5-percentage-point absolute drift, bonds 4.5, and cash 3.0. Because stocks exceed the five-percentage-point threshold, the entire portfolio is scheduled for rebalancing. The other two assets do not individually breach the tolerance, but they still participate in restoring the overall target allocation. This is an important distinction: the threshold identifies when the portfolio-wide action is required, while the target weights determine the desired allocation after that action.

Threshold rule triggering a portfolio review
Figure 8. Drift beyond five points triggers the rule.

Calculate Target Values and Ideal Dollar Trades

Once the rule indicates rebalancing, calculate target dollar values using the current $12,000 portfolio total. Global Stock ETF's target is 60% multiplied by $12,000, equal to $7,200. Bond ETF's target is 30% multiplied by $12,000, equal to $3,600. Cash's target is 10% multiplied by $12,000, equal to $1,200. These three desired dollar amounts add to exactly $12,000. The calculations are based on the pre-trade, pre-cost total so the initial ideal adjustments can be inspected consistently.

Portfolio target dollar values calculated from percentages
Figure 9. Target dollars are total value times target weight.

The signed trade amount equals target value minus current value. For Global Stock ETF, $7,200 minus $8,100 equals negative $900, indicating a proposed sale of $900. For Bond ETF, $3,600 minus $3,060 equals positive $540, indicating a proposed purchase of $540. Cash requires an additional $360 to reach its target, because $1,200 minus $840 equals positive $360. Selling $900 of stocks and buying $540 of bonds leaves $360 to increase cash before accounting for any costs.

Selling stock and purchasing bonds to restore allocation
Figure 10. Sell the overweight stock, buy the underweight bonds.

Key points

  • Target value = total x target weight: $7,200, $3,600, $1,200.
  • Trade = target - current: stock -$900 (sell), bonds +$540 (buy), cash +$360.
  • Sanity check: -900 + 540 + 360 = 0.
Ideal trades
HoldingCurrentTargetTrade
Global Stock ETF$8,100$7,200-$900 (sell)
Bond ETF$3,060$3,600+$540 (buy)
Cash$840$1,200+$360
Net$0

A useful sanity check is that the frictionless target adjustments sum to zero. The adjustments are negative $900 for stocks, positive $540 for bonds, and positive $360 for cash. Their sum is exactly zero. This confirms that the planned allocation changes are internally balanced before taxes and trading frictions. However, the ideal target amounts are not guaranteed execution amounts. Share prices, whole-share restrictions, fees, and taxes can prevent the final portfolio from matching the original target dollar values exactly.

Account for Trading Spreads and Hypothetical Taxes

The exercise introduces a fictional trading spread cost of 0.10% of every traded dollar amount. The ideal rebalancing plan sells $900 of Global Stock ETF and buys $540 of Bond ETF. Their combined gross traded amount is $1,440. Multiplying $1,440 by 0.001 gives exactly $1.44 in spread costs. This amount is an invented arithmetic assumption rather than an actual broker quote. In real transactions, spreads can vary by asset, market conditions, order size, and execution timing.

Trading spread costs during portfolio rebalancing
Figure 11. Spread costs on traded dollars: $1.44.

The example also assumes an invented 15% tax on realized capital gains. The $900 stock sale is assigned a hypothetical cost basis of $700, so its realized gain is $200. Fifteen percent of $200 equals $30 of fictional tax. Adding the prescribed $1.44 spread cost produces $31.44 in total illustrated costs. These calculations are independent of actual taxation in any jurisdiction and exclude other possible fees. They demonstrate why an otherwise balanced set of proposed trades can reduce the account's total value.

Hypothetical realized gain and tax calculation
Figure 12. Realized gain $200 and invented tax $30.

Key points

  • Spread: (900 + 540) x 0.10% = $1.44.
  • Invented tax: gain 900 - 700 = $200, 15% = $30.
  • Total illustrative cost: $31.44. Tax is most of it.
Illustrative costs (invented rates)
ItemCalculationAmount
Spread(900 + 540) x 0.10%$1.44
Realized gain900 - 700$200
Tax at 15%200 x 15%$30.00
Total1.44 + 30$31.44
The rates are invented for practice and do not describe any real market or tax rule.

There is an important implementation distinction. The required $1.44 spread is calculated on the ideal $900 sale and $540 bond purchase before whole-share rounding. Later, the actual bond purchase will be only $520. If the stated 0.10% spread were recalculated strictly on executed traded amounts, the spread would instead be $1.42, and total cost would be $31.42. To preserve the exercise's specified $31.44 cost budget, the main worked reconciliation deducts that illustrative amount. A real spreadsheet should explicitly identify which trade amounts generate each cost and recompute costs after final execution quantities are known.

Round Trades to Whole Shares and Reconcile Cash

Convert the ideal dollar trades into share quantities using the fictional prices supplied for this lesson. Global Stock ETF has a price of $45. Selling $900 therefore means selling exactly 20 shares. Bond ETF has a price of $52. The desired $540 purchase corresponds to approximately 10.384615 shares, but the exercise assumes only whole shares may be traded. Round the purchase quantity down to 10 shares, costing exactly $520. The bond purchase is therefore $20 smaller than the ideal dollar adjustment.

Whole share rounding for ETF purchases
Figure 13. Whole shares: 10.38 bond shares rounds down to 10.

After these whole-share trades, the stock allocation is $8,100 minus $900, or $7,200. The bond allocation is $3,060 plus $520, or $3,580. Cash becomes $840 plus $900 sale proceeds minus $520 bond purchase, or $1,220 before costs. The original desired cash target was $1,200, so the whole-share rounding leaves $20 more cash than the frictionless target. This is not an arithmetic error; it is a consequence of being unable to purchase a fractional bond ETF share under the exercise's rules.

Cash residual after trades costs and share rounding
Figure 14. Cash left after trades, costs and rounding.

Key points

  • Stock: 900 / 45 = 20 shares. Bonds: 540 / 52 = 10.38, round down to 10 shares = $520.
  • Cash before costs: 840 + 900 - 520 = $1,220. After costs: $1,188.56.
  • New total $11,968.56: exactly $31.44 below $12,000.
Whole-share execution
HoldingIdeal tradePriceSharesExecuted
Global Stock ETF-$900$45-20-$900
Bond ETF+$540$5210 (10.38 rounded down)+$520
Result after costs
HoldingIdeal targetExecutedGap
Global Stock ETF$7,200$7,200$0
Bond ETF$3,600$3,580-$20
Cash$1,200$1,188.56-$11.44
Total$12,000$11,968.56-$31.44

Using the prescribed illustrative total cost of $31.44, deduct that amount from the $1,220 cash balance, leaving exactly $1,188.56. The resulting portfolio consists of $7,200 stocks, $3,580 bonds, and $1,188.56 cash, totaling $11,968.56. The reduction from the starting $12,000 equals the $31.44 cost budget. If the spreadsheet instead recomputes the spread on executed $900 and $520 trades, final cash is $1,188.58 and the total is $11,968.58. Both reconciliations are mathematically consistent when their respective cost assumptions are clearly labeled.

Build Spreadsheet Columns, Formulas, and Validation Checks

Create a spreadsheet with assets in column A, current dollar values in B, current weights in C, target weights in D, and signed percentage-point drift in E. Add a helper action column F, target dollar values in G, signed target trades in H, market prices in I, and signed whole-share quantities in J. Place Global Stock ETF in row 2, Bond ETF in row 3, Cash in row 4, and the portfolio total in B5. The helper action column allows the formulas to remain consistent while distinguishing a row-level threshold result from target and trade calculations.

Spreadsheet formulas calculating portfolio weights and drift
Figure 15. Formulas for weights and drift.

In C2, use =B2/B$5 to calculate the current stock weight, assuming B5 contains =SUM(B2:B4). In E2, use =C2-D2 for signed drift. In F2, use =IF(ABS(E2)>0.05,"Rebalance","Hold") to identify whether that asset breaches the threshold. In G2, use =D2*B$5 to calculate target value, and in H2 use =G2-B2 for the signed ideal trade amount. In J2, use =ROUNDDOWN(H2/I2,0) for signed whole-share quantity. Copy appropriate formulas down to the bond row, and calculate cash as the residual rather than trying to divide cash by an ETF share price.

Key points

  • Columns: Asset, Value, Weight, Target weight, Drift, Target value, Trade, Price, Shares.
  • Formulas: =B2/B$5, =C2-D2, =IF(ABS(E2)>0.05,"Rebalance","Hold"), =D2*B$5, =G2-B2, =ROUNDDOWN(H2/I2,0).
  • Check that weights sum to 100% and trades net to zero.
Spreadsheet columns and formulas
ColumnFieldFormula (row 2)
CWeight=B2/B$5
EDrift=C2-D2
FAction=IF(ABS(E2)>0.05,"Rebalance","Hold")
GTarget value=D2*B$5
HTrade=G2-B2
JShares=ROUNDDOWN(H2/I2,0)
B5 holds the total, =SUM(B2:B4).

For the portfolio-wide decision, evaluate whether the largest absolute drift among the three rows exceeds 0.05. Verify that current weights sum to 100%, target weights sum to 100%, and frictionless target-dollar adjustments sum to zero. The signed share quantities should show a 20-share stock sale and a 10-share bond purchase. Add separate actual-trade, fee, tax, and ending-cash fields or a supporting execution table to reconcile the final $11,968.56 value using the prescribed cost budget. Do not overwrite the original target calculations with executed amounts.

Spreadsheet validation of portfolio calculations
Figure 16. Sanity checks: weights sum to 100%, trades net to zero.

Compare Hold Decisions and New-Money Rebalancing

A rebalancing rule must also define when not to act. Consider a separate hypothetical observation using the same policy targets of 60%, 30%, and 10%. Suppose current weights are 63% stocks, 28% bonds, and 9% cash. Their drifts are positive 3, negative 2, and negative 1 percentage points, respectively. The largest absolute drift is 3 percentage points, which does not exceed the five-percentage-point threshold. Therefore, the written rule says hold rather than rebalance. A small drift is not automatically a reason to trade.

Portfolio holding steady within its rebalancing threshold
Figure 17. A hold decision: all drifts within five points.

New-money rebalancing is another educational technique. Instead of selling an overweight holding, new contributions can be directed toward underweight assets. This may reduce transaction costs or avoid realizing gains, depending on the circumstances. However, contributions increase the portfolio's total value and change its target dollar amounts, so the effect must be recalculated rather than assumed. If contributions are insufficient to restore the target weights, some drift may remain. The exact approach should follow a policy written in advance, including any instructions about contribution timing and cost considerations.

Using new contributions to adjust portfolio weights
Figure 18. New money can adjust weights without selling.

Key points

  • Hold example: 63%, 28%, 9% gives drifts +3, -2, -1. The largest is 3, which is not more than 5, so hold.
  • New money can rebalance without selling, but it changes the total, so recompute targets and re-test.
  • Record costs, but do not rewrite the rule after seeing prices; write any cost exception in advance.
A hold decision
HoldingWeightTargetDrift
Global Stock ETF63%60%+3
Bond ETF28%30%-2
Cash9%10%-1
Largest drift is 3 points, not more than 5: hold.
Two ways to restore weights
MethodWhat happensWatch for
Sell and buySell the overweight, buy the underweightSpread and taxes on realized gains
New moneyDirect contributions to the underweight holdingsThe total changes, so recompute targets and re-test the rule

Cost awareness matters, but it should not become an excuse for selectively ignoring the policy. If the written rule requires rebalancing, document the expected spread, taxes, whole-share limitations, and other material costs before implementing the simulated adjustment. If a learner wishes to use a cost-based exception, that exception belongs in the policy before future market outcomes are known. Larger costs may prompt a documented policy review, but a rule should not be silently rewritten simply because the current market environment makes the required action uncomfortable.

Comparing calendar and threshold policy decisions
Figure 19. Calendar and threshold policies compared.

Final Lab: Apply the Rule, Reconcile, and Journal

Your final checkpoint is to produce a complete simulated rebalancing spreadsheet for Global Stock ETF, Bond ETF, and Cash. Record the written 60%, 30%, and 10% targets and the rule to rebalance when any weight drifts more than five percentage points. Enter the current values of $8,100, $3,060, and $840, totaling $12,000. Calculate weights of 67.5%, 25.5%, and 7.0%, then drifts of positive 7.5, negative 4.5, and negative 3.0 percentage points. The stock drift activates the rebalancing rule.

Recording rebalancing decisions in a financial journal
Figure 20. Record the decision in your journal.
Cost-aware portfolio rebalancing checklist
Figure 21. A cost-aware rebalancing checklist.

Practice Lab: Apply a Five-Point Rebalancing Rule

Use one simulated portfolio containing fictional Global Stock ETF, Bond ETF, and Cash. The written policy targets 60%, 30%, and 10%, and requires rebalancing when any absolute allocation drift is greater than five percentage points; otherwise hold. Begin with current values of $8,100, $3,060, and $840. Calculate the $12,000 total, current weights, drifts, ideal target values, proposed trades, and whole-share quantities. Apply a hypothetical spread of 0.10% to the prescribed ideal trades and invented 15% tax to the stated realized gain. For the main reconciliation, use the specified $31.44 cost budget, while separately identifying the $31.42 alternative if spreading costs are recalculated on executed whole-share amounts. Preserve original values, formulas, and journal entries. No real-money transactions are involved.

  • Decision 1: A hypothetical portfolio originally targeted 60% Global Stock ETF, 30% Bond ETF, and 10% Cash. Its current values are $8,100 stocks, $3,060 bonds, and $840 cash, totaling $12,000. — Calculate current weights and drifts, then determine whether the policy's greater-than-five-percentage-point threshold requires rebalancing.
  • Decision 2: The current portfolio total is $12,000 with targets of 60% stocks, 30% bonds, and 10% cash, while current values are $8,100, $3,060, and $840. — Calculate target dollar values and the ideal signed changes required to restore the original target weights before costs.
  • Decision 3: Ideal trades are a $900 stock sale and $540 bond purchase. The exercise uses a 0.10% trading spread and a fictional 15% tax on a stock sale with $900 proceeds and $700 cost basis. — Calculate gross traded value, spread cost, realized gain, hypothetical tax, and the prescribed total cost.
  • Decision 4: Global Stock ETF trades at $45, Bond ETF at $52, and the ideal trades are a $900 sale and $540 purchase. Initial cash is $840, and the prescribed cost budget is $31.44. — Calculate whole-share trades and reconcile final stock, bond, cash, and portfolio values using the prescribed cost budget.
  • Decision 5: A separate observation under the same written policy has current weights of 63% Global Stock ETF, 28% Bond ETF, and 9% Cash. The rule activates only when absolute drift is greater than five percentage points. — Calculate each signed drift, determine whether to rebalance or hold, and describe the appropriate journal entry.

Answer key

Check your answers
DecisionAnswerHorizonReason
#1Weights are 67.5% stocks, 25.5% bonds, and 7.0% cash. Drifts are +7.5, -4.5, and -3.0 percentage points. The decision is REBALANCE because the stock allocation exceeds its target by more than five percentage points.Hypothetical year-end allocation reviewCurrent weights are asset values divided by $12,000, and the largest absolute drift of 7.5 percentage points exceeds the written five-point threshold.
#2Target values are $7,200 stocks, $3,600 bonds, and $1,200 cash. Ideal changes are sell $900 stocks, buy $540 bonds, and increase cash by $360; the three target changes sum to zero.Before simulated rebalancing tradesEach target equals its policy weight multiplied by $12,000, and target minus current gives -900, +540, and +360 dollars.
#3Gross traded value is $1,440, spread cost is $1.44, realized gain is $200, hypothetical tax is $30, and total illustrated cost is $31.44.Hypothetical rebalancing transactionThe calculations are 900 + 540 = 1,440; 1,440 × 0.001 = 1.44; 900 - 700 = 200; and 200 × 0.15 = 30.
#4Sell 20 stock shares for $900 and buy 10 whole bond shares for $520. Ending values are $7,200 stocks, $3,580 bonds, and $1,188.56 cash, totaling $11,968.56.After the hypothetical whole-share executionThe cash reconciliation is 840 + 900 - 520 - 31.44 = 1,188.56, and 7,200 + 3,580 + 1,188.56 = 11,968.56.
#5Drifts are +3, -2, and -1 percentage points, with maximum absolute drift of 3 points. The policy says HOLD. Record the date, weights, drifts, rule applied, and the decision not to trade.Separate hypothetical policy reviewAll three absolute deviations are at or below five percentage points, so none activates the predefined rebalancing threshold.

Calculate target values of $7,200 stocks, $3,600 bonds, and $1,200 cash. Record the ideal $900 stock sale and $540 bond purchase. Apply the invented 0.10% spread to the ideal $1,440 traded amount to obtain $1.44, and calculate $30 of hypothetical tax on a $200 realized gain. The prescribed total cost budget is $31.44. Convert the planned trades into whole shares: sell 20 stock shares at $45 and buy 10 bond shares at $52. The rounded bond trade costs $520 instead of the desired $540.

Key points

  • Journal the policy, date, values, weights, drift, result, trades, shares, costs and cash left.
  • Keep before and after snapshots, and keep targets, orders and costs in separate fields.
  • Educational only, with simulated money. Not investment advice.
Your rebalancing journal
FieldEntry
Policy60/30/10; rebalance if any drift is more than 5 points
Observed values$8,100 / $3,060 / $840 (total $12,000)
Weights and drift67.5 / 25.5 / 7.0; +7.5 / -4.5 / -3.0
DecisionRebalance (7.5 is more than 5)
Ideal tradesSell $900 stock, buy $540 bonds
ExecutedSell 20 stock shares, buy 10 bond shares ($520)
Costs$31.44 (spread $1.44, invented tax $30)
Cash left$1,188.56; total $11,968.56

Using the specified illustrative cost budget, reconcile the resulting $7,200 stock position, $3,580 bond position, and $1,188.56 remaining cash, totaling $11,968.56. Also demonstrate the hold case with 63%, 28%, and 9% weights, where maximum drift is only three percentage points. Save the original inputs, record the threshold decision, list the proposed and actual simulated trades, show estimated costs, and explain any remaining allocation differences. The learning objective is to apply a stated rule consistently while accounting transparently for costs and implementation constraints.

Learner completing a simulated rebalancing lesson
Figure 22. Apply the rule, count the costs, reconcile.

Worked example at a glance

Rebalance in a Spreadsheet: One Simulated $12,000 Portfolio
Written policy, drift and target tradesCosts, whole shares and spreadsheet formulas
Policy targets: Global Stock ETF 60%; Bond ETF 30%; Cash 10%Invented trading spread: 0.10% of traded dollar amount
Policy trigger: Rebalance if any absolute weight drift > 5 percentage points; otherwise holdIdeal gross traded amount: $900 + $540 = $1,440
Initial simulated portfolio: $10,000Spread on ideal trades: $1,440 × 0.001 = $1.44
Initial Global Stock ETF: $6,000 = 60%Invented gain-tax rate: 15%
Initial Bond ETF: $3,000 = 30%Stock sale proceeds: $900
Initial Cash: $1,000 = 10%Cost basis of sold shares: $700
Current Global Stock ETF: $8,100Realized gain: $900 - $700 = $200
Current Bond ETF: $3,060Hypothetical tax: $200 × 15% = $30
Current Cash: $840Total cost using ideal trades: $1.44 + $30 = $31.44
Current portfolio total: $8,100 + $3,060 + $840 = $12,000Global Stock ETF price: $45 per share
Current stock weight: $8,100 / $12,000 = 67.5%Stock shares to sell: $900 / $45 = 20 whole shares
Current bond weight: $3,060 / $12,000 = 25.5%Bond ETF price: $52 per share
Current cash weight: $840 / $12,000 = 7.0%Ideal bond share quantity: $540 / $52 = 10.384615... shares
Stock drift: 67.5% - 60% = +7.5 percentage pointsExecuted whole bond shares: 10 shares × $52 = $520
Bond drift: 25.5% - 30% = -4.5 percentage pointsUnspent desired bond allocation: $540 - $520 = $20
Cash drift: 7.0% - 10% = -3.0 percentage pointsActual post-trade stock value: $8,100 - $900 = $7,200
Threshold decision: REBALANCE: maximum absolute drift 7.5 > 5 pointsActual post-trade bond value: $3,060 + $520 = $3,580
Target stock value: $12,000 × 60% = $7,200Cash before costs: $840 + $900 - $520 = $1,220
Target bond value: $12,000 × 30% = $3,600Cash after illustrative $31.44 costs: $1,220 - $31.44 = $1,188.56
Target cash value: $12,000 × 10% = $1,200Post-cost total: $7,200 + $3,580 + $1,188.56 = $11,968.56
Ideal stock trade: $7,200 - $8,100 = -$900; sellIllustrative stock weight after costs: $7,200 / $11,968.56 ≈ 60.1576%
Ideal bond trade: $3,600 - $3,060 = +$540; buyIllustrative bond weight after costs: $3,580 / $11,968.56 ≈ 29.9117%
Ideal cash adjustment: $1,200 - $840 = +$360Illustrative cash weight after costs: $1,188.56 / $11,968.56 ≈ 9.9307%
Frictionless reconciliation: -$900 + $540 + $360 = $0Spreadsheet columns: A Asset; B Value; C Weight; D Target weight; E Drift; F Action; G Target value; H Trade; I Price; J Shares
Hold scenario: 63% stock; 28% bond; 9% cashB5 total: =SUM(B2:B4)
Hold scenario drift: +3, -2, -1 points; maximum 3 ≤ 5; HOLDC2 current weight: =B2/B$5
All values and investment products are fictional. The written threshold is strictly greater than five percentage points, not greater than or equal. The prescribed $1.44 spread and $31.44 total cost are calculated from the original ideal $900 sale and $540 purchase; if applying the spread to actual executed whole-share trades of $900 and $520 instead, the spread is $1.42, total cost is $31.42, cash becomes $1,188.58, and portfolio value becomes $11,968.58. The worked example consistently uses the prescribed $31.44 illustrative cost budget for its main reconciliation. Real taxes and costs are not represented.

Key terms

  • Rebalancing: adjusting holdings back toward the target weights in a written policy.
  • Target weight: the share of the portfolio a holding should have under the policy.
  • Drift: current weight minus target weight, in percentage points.
  • Threshold rule: a rule that rebalances when any drift exceeds a set size.
  • Calendar rule: a rule that rebalances on scheduled dates.
  • Target value: total portfolio value times the target weight.
  • Trade: target value minus current value; negative means sell, positive means buy.
  • Spread: the cost of trading, paid as the gap between buy and sell prices.
  • Realized gain: profit locked in by selling above the cost basis.
  • Whole shares: shares bought or sold in whole units, which can leave leftover cash.
  • New-money rebalancing: using new contributions to buy underweight holdings instead of selling.
Multi Asset Trading Lab provides educational information only and does not constitute personalized investment, trading, financial, accounting, legal, or tax advice. Global Stock ETF, Bond ETF, and Cash are hypothetical asset labels, and all portfolio values, weights, investment prices, transactions, fees, taxes, and outcomes are fictional. All calculations use simulated money only, and no real-money investing, brokerage activity, or actual fund purchase or sale is required or encouraged. The example target policy of 60% Global Stock ETF, 30% Bond ETF, and 10% Cash is an educational assumption, not an allocation recommendation or a universally appropriate strategy. The rule to rebalance when any asset's allocation differs from its target by strictly more than five percentage points is a hypothetical policy constraint. A five-percentage-point deviation exactly does not trigger the rule. Rebalancing seeks to maintain chosen portfolio exposure but does not guarantee profits, lower volatility, improved risk-adjusted returns, or protection against losses. Stocks, bonds, and cash each have different risks, and their market values or purchasing power can change over time. Rebalancing can involve selling assets that have performed well, purchasing assets that have performed poorly, and incurring transaction costs or taxable gains. The invented spread rate of 0.10% and the invented 15% tax on the stated $200 realized gain are arithmetic examples only; they do not describe any actual market quotation, tax treatment, investor circumstance, or jurisdiction. The prescribed $1.44 spread is calculated using the ideal $900 stock sale and $540 bond purchase, resulting in $31.44 total illustrative costs including $30 fictional tax. Actual whole-share execution in the example uses a $900 stock sale and $520 bond purchase. Applying the same 0.10% rate strictly to executed trades instead produces $1.42 spread and $31.42 combined costs, rather than the prescribed ideal-trade cost budget. The main example deliberately uses the stated $31.44 illustrative cost assumption, resulting in final cash of $1,188.56 and total value of $11,968.56; the execution-based alternative produces $1,188.58 cash and $11,968.58 total value. These two cost assumptions must not be silently mixed. Prices of $45 per Global Stock ETF share and $52 per Bond ETF share are fictional, and whole-share rounding can leave residual cash and differences from exact targets. Spreadsheet outputs depend on correct formulas, input values, rounding conventions, execution assumptions, and cost treatment. Trading fees, bid-ask spreads, commissions, slippage, account restrictions, taxes, and timing differences may materially change realized results. New-money rebalancing may reduce the need for selling existing holdings but is not guaranteed to eliminate costs or restore all target weights. Costs should be documented and evaluated according to a policy written in advance rather than used as an undocumented reason to abandon rules after market moves. The hold example at 63%, 28%, and 9% is a separate hypothetical observation and does not override the rebalance decision for the 67.5%, 25.5%, and 7.0% portfolio. Learners should preserve the original spreadsheet and journal records, verify that portfolio weights sum to 100%, confirm that frictionless target changes net to zero, reconcile actual cash flows and costs, and document every simulated decision. Historical or hypothetical asset performance does not predict future results. Nothing in this lesson constitutes a recommendation to buy, sell, or hold any real financial instrument, and qualified professionals should be consulted for real financial, legal, or tax decisions.
Lesson practice

Lesson Checkpoint

Review what you learned and get feedback on your work.

0/20
01What is the primary purpose of portfolio rebalancing in this lesson?
02When does the written five-percentage-point threshold rule require rebalancing?
03Which spreadsheet formula calculates current portfolio weight when B2 contains asset value and B5 contains the total?
04What should the learner do when a desired bond purchase requires 10.38 shares but the simulator permits whole shares only?
05Which checks help validate the initial frictionless portfolio rebalancing spreadsheet? Select all that apply.

Select all that apply

06Which items may affect the realized cost or implementation of a simulated rebalance? Select all that apply.

Select all that apply

07Which action follows the written policy?
Scenario

The portfolio targets 60% stocks, 30% bonds, and 10% cash, while observed weights are 67.5%, 25.5%, and 7.0%.

08Which decision follows the same rebalancing policy?
Scenario

A separate hypothetical portfolio has weights of 63% stocks, 28% bonds, and 9% cash against targets of 60%, 30%, and 10%.

09What is the correct way to interpret a mismatch between desired and executed target allocations?
Scenario

The ideal bond purchase is $540, but the ETF price is $52 and only whole shares are available, so the learner buys 10 shares for $520.

10Identify the incorrect statement in this hypothetical rebalancing calculation.
Current values are $8,100 stocks, $3,060 bonds, and $840 cash, with a total of $12,000 and target weights of 60%, 30%, and 10%.

Select every line that contains an error

11Fill in the blanks

Current portfolio weight minus target portfolio weight is called allocation .

12Fill in the blanks

A spreadsheet function that rounds a positive fractional share quantity downward to a permitted whole number is .

13Fill in the blanks

A rebalancing rule that acts when allocation deviation exceeds a predefined tolerance is called a rule.

14Arrange the steps for applying the written threshold rebalancing rule.

Tap the steps in the correct order

    15Arrange the steps for reconciling the simulated whole-share rebalancing execution.

    Tap the steps in the correct order

      16Match each spreadsheet field or formula to its purpose.
      Asset
      Value
      Weight
      Target weight
      Drift
      Action
      Target value
      Trade
      Price
      Shares
      17Match each numerical result in the hypothetical rebalancing example to its correct value.
      Current portfolio total
      Current stock weight
      Stock allocation drift
      Target stock value
      Target bond value
      Ideal stock sale
      Ideal bond purchase
      Invented spread on ideal traded amount
      Invented realized-gain tax
      Executed bond purchase
      Cash after prescribed illustrative costs
      Post-cost portfolio total
      18Global Stock ETF is worth $8,100 in a $12,000 portfolio with a 60% target weight. Calculate its current allocation drift in percentage points.
      percentage points
      19The ideal rebalance sells $900 of stock and buys $540 of bonds, with an invented spread charge of 0.10% on ideal traded value and an invented $30 realized-gain tax. Calculate the prescribed total cost.
      USD
      20Starting cash is $840, the executed stock sale adds $900, the rounded whole-share bond purchase costs $520, and the prescribed illustrative costs are $31.44. Calculate final cash.
      USD
      Answered · 0/20