Worksheet
Portfolio rebalance worksheet
Over time, the parts of a portfolio that grew faster take up a bigger share, and the mix drifts from where you started. This worksheet does the arithmetic: type what you hold in each category and the target mix you have chosen, and it shows your current mix and how many dollars would move to match the target. It does not suggest a target. That choice is yours, and it is the hard part. Nothing you type leaves your device.
Type your holdings and your own target mix above and the worksheet appears here. Nothing is pre-filled. Results are based only on your numbers.
Worked example of the arithmetic with made-up numbers (not a suggestion): three holdings worth 6,000, 3,000 and 1,000 make a total of 10,000, so the current mix is 60, 30 and 10 percent. If your own target were 50, 30 and 20 percent, the target values would be 5,000, 3,000 and 2,000, so you would move 1,000 out of the first holding and 1,000 into the third.
Before you decide
This is general education, not advice. The worksheet only compares your current mix with a target you typed. It cannot tell you whether the target suits your goals, timeline or comfort with risk, and it ignores taxes, trading costs and account rules, any of which can make moving money costly. A licensed adviser can look at your whole situation.
The arithmetic
The worksheet adds up the values you typed to get the total. Each holding's current mix is its value divided by the total. The target value is the total multiplied by your target percentage. The shift is the target value minus the current value: a positive number means money would move in, a negative number means it would move out. If you typed cash added or taken out, the total used for the targets is the current total plus that amount, and the shifts add up to that amount. Your target percentages must add up to 100, and the worksheet says so if they do not.
Why people rebalance at all
A mix that drifts changes how much risk you carry, because the faster-growing part grows as a share of the whole. Some investors review on a calendar date, some when a part drifts past a gap they chose, and some simply direct new money to whatever is below target, which needs no selling. The last method is why the cash box exists. The guides on stocks and bonds explain how people think about the split.
Limits
- Selling in a taxable account can create a tax bill. Inside many retirement accounts it usually does not, but account rules vary.
- Funds, commissions and spreads can cost money to trade, and small shifts may not be worth it.
- The worksheet treats each row as one category. If two rows hold overlapping investments, your real mix differs from what it shows.
- Values are whatever you type. It does not look up prices.
- Rows are rounded to the cent, so totals can differ by a cent or two.
Where this comes from
The percentage and dollar arithmetic is standard portfolio bookkeeping. The description of rebalancing and why mixes drift follows the investor education material on asset allocation and diversification from the U.S. Securities and Exchange Commission (Investor.gov). The worksheet gives no target and no recommendation, and the figures it shows are only your own inputs reworked.