Investment Portfolio Allocation Spreadsheet: Build and Rebalance Your Portfolio

Asset allocation — the split between stocks, bonds, and other asset classes — determines roughly 90% of your portfolio’s long-term performance variability. Not stock picking. Not market timing. Not which fund manager you chose. The allocation decision dominates everything else.

Yet most self-directed investors set their allocation once (often based on a rough sense of risk tolerance rather than a deliberate analysis) and never revisit it. Over time, market movements cause the portfolio to drift from the original targets. A year of strong stock returns might push a 70/30 stock/bond portfolio to 80/20, dramatically increasing risk without the investor making a conscious decision. A market decline might shift it to 60/40, reducing exposure to equities right when they are cheapest — the opposite of what a disciplined investor would choose.

This spreadsheet imposes the discipline that free-floating portfolios lack. You set your target allocation, enter your current holdings, and the tool calculates exactly how much each asset class has drifted from target — and precisely how many dollars to buy or sell in each class to rebalance back to your intended allocation.

The editorial position on rebalancing frequency: annually is sufficient for most investors. The evidence shows that more frequent rebalancing (quarterly, monthly) adds transaction costs and tax events without producing meaningfully better returns. Less frequent rebalancing (every two years or more) allows drift to accumulate to levels that materially change the portfolio’s risk profile. Once a year — or when any asset class drifts more than 5 percentage points from target — is the sweet spot.

Disclaimer: This spreadsheet is provided for informational and educational purposes only. It does not constitute investment or financial advice. Asset allocation decisions should reflect your individual risk tolerance, time horizon, and financial goals. Consult a qualified financial advisor before making investment decisions. SpreadsheetTemplates.info is not responsible for decisions made based on the information provided.

Common Allocation Models#

Your target allocation should reflect two variables: your time horizon (how many years until you need the money) and your risk tolerance (how much volatility you can emotionally and financially withstand). The following models serve as starting points — not prescriptions.

Allocation Model	US Stocks	International Stocks	Bonds	REITs	Cash	Historical Annual Return (Approx.)	Max Historical Drawdown (Approx.)	Best For
Aggressive	60%	25%	10%	5%	0%	9–10%	-45% to -50%	20+ year horizon; high risk tolerance
Growth	50%	20%	20%	5%	5%	8–9%	-35% to -40%	15–25 year horizon; moderate-high tolerance
Moderate	40%	15%	35%	5%	5%	7–8%	-25% to -30%	10–20 year horizon; moderate tolerance
Conservative	25%	10%	50%	5%	10%	5–7%	-15% to -20%	5–15 year horizon; lower tolerance
Capital Preservation	15%	5%	55%	0%	25%	4–5%	-10% to -12%	Under 5 years; very low tolerance

Historical returns and drawdowns are approximate long-term averages based on US market data. Future returns may differ. Past performance does not guarantee future results.

The right model for you sits at the intersection of your time horizon and your honest answer to the question: “If my portfolio dropped 30% in six months, would I sell, hold, or buy more?” If the answer is sell, you are in a model that is too aggressive for your temperament — regardless of your time horizon.

What the Spreadsheet Tracks#

Target Allocation#

You define your target allocation by asset class. The default classes are US equities, international equities, US bonds, international bonds, REITs, and cash/short-term. You can customise these — adding emerging markets, commodities, or alternative assets — though for most investors, the core classes are sufficient.

For each class, you set a target percentage. The percentages must total 100%.

Current Holdings#

You enter each holding in your portfolio: the fund or stock name, the ticker symbol, the asset class it belongs to (a total US stock market fund belongs to “US equities”; a bond ETF belongs to “US bonds”), and the current market value. The spreadsheet totals the value in each asset class and calculates the actual allocation percentages.

Drift Analysis#

The core output: a side-by-side comparison of target allocation versus actual allocation for each asset class. The drift column shows the difference — positive drift means overweight (more than your target), negative drift means underweight (less than your target). A heat map highlights drifts exceeding 3% (caution) and 5% (rebalance recommended).

Rebalancing Recommendations#

The spreadsheet calculates the dollar amount to buy or sell in each asset class to return to your target allocation. If US equities have drifted from 50% to 55% of a $200,000 portfolio, the recommendation is to sell $10,000 of US equities and redistribute it to the underweight classes.

For tax-efficient rebalancing, the spreadsheet also shows a “buy only” rebalancing option: instead of selling overweight positions (which may trigger capital gains taxes in taxable accounts), you direct new contributions entirely to underweight asset classes until the drift corrects. This approach is slower but avoids the tax drag of selling. For modelling the tax impact of rebalancing sales, see our capital gains tax calculator.

Multi-Account View#

Many investors hold assets across multiple accounts (401(k), IRA, Roth IRA, taxable brokerage). The spreadsheet supports a multi-account view where you enter holdings per account, and the allocation analysis operates at the portfolio level — not the account level. This is important because optimal tax placement may put bonds in your tax-deferred accounts and stocks in your Roth, which makes individual account allocations look wildly different from your target. The portfolio-level view shows the true allocation across all accounts combined.

How to Use the Spreadsheet#

Step 1: Choose your target allocation. Use the comparison table as a starting point, adjusted for your time horizon and risk tolerance. If you are unsure, the Moderate model is a reasonable default for most investors with 10–20 year horizons.

Step 2: Enter all holdings across all accounts. Pull current market values from each brokerage and retirement account. Classify each holding into an asset class. For multi-asset funds (like a target-date fund that holds both stocks and bonds), estimate the split and enter it as separate line items — or look up the fund’s published allocation on Morningstar.

Step 3: Review the drift analysis. Are any asset classes more than 5% away from target? If so, rebalancing is warranted. If all classes are within 3–5% of target, no action is needed — check again at your next scheduled review.

Step 4: Execute the rebalancing. In tax-advantaged accounts (401(k), IRA, Roth), sell overweight positions and buy underweight positions freely — there are no tax consequences for trades within these accounts. In taxable accounts, prioritise the “buy only” approach or use new contributions to correct drift. If selling is necessary, use our capital gains tax calculator to estimate the tax impact before executing.

Step 5: Review annually. Update all account values, check drift, and reassess whether your target allocation still matches your time horizon and risk tolerance. As you approach retirement or a major financial goal, your allocation should gradually shift toward more conservative models.

Download: Portfolio Allocation Spreadsheet — Excel (.xlsx)

Why Asset Allocation Matters More Than Stock Picking#

The academic evidence is extensive and consistent: asset allocation explains the vast majority of portfolio return variability over time. The seminal Brinson, Hood, and Beebower study found that over 90% of the variation in quarterly returns for institutional portfolios was explained by asset allocation policy — not by security selection or market timing.

For individual investors, the practical implication is freeing: you do not need to pick winning stocks or time the market to build wealth. You need to choose an allocation that matches your risk tolerance and time horizon, implement it with low-cost index funds, and rebalance periodically to maintain it. This three-step process, executed consistently over decades, produces better results than most active strategies — and requires dramatically less time, effort, and stress.

Tax-Efficient Asset Location#

Asset allocation determines what you own. Asset location determines where you own it — which account type holds each asset class. The right location strategy can save thousands in taxes over a portfolio’s lifetime.

The general principle: place the least tax-efficient assets in tax-advantaged accounts (where their tax drag is eliminated or deferred) and the most tax-efficient assets in taxable accounts (where their favourable tax treatment is preserved).

Tax-deferred accounts (traditional 401(k), traditional IRA): Best for bonds and bond funds (interest is taxed as ordinary income — the highest rate), REITs (dividends are taxed as ordinary income, not at the qualified dividend rate), and actively managed funds with high turnover (frequent capital gains distributions are sheltered from tax).

Tax-free accounts (Roth IRA, Roth 401(k)): Best for your highest-growth assets — typically equities with the highest expected long-term return. The gains in a Roth are never taxed, so maximising the growth in this account type produces the largest lifetime tax benefit.

Taxable brokerage accounts: Best for tax-efficient equity index funds (low turnover, minimal capital gains distributions), international stock funds (which generate foreign tax credits that can only be used in taxable accounts), and municipal bonds (interest is federally tax-exempt, which is only valuable in a taxable account).

The spreadsheet’s multi-account view supports this by showing your allocation at the portfolio level while letting you see where each asset class is held. When rebalancing, you can direct trades to the most tax-efficient location rather than rebalancing mechanically within each account.

For tracking the dividend income component of your equity allocation, see our dividend portfolio tracker. For the broader financial picture, see our net worth tracker. And for modelling how your portfolio supports your retirement timeline, see our retirement savings tracker and FIRE planner.

Frequently Asked Questions#

How often should I rebalance my portfolio?

Annually is the recommendation for most investors. Rebalance on a fixed schedule (same date each year) or when any asset class drifts more than 5 percentage points from target. More frequent rebalancing adds transaction costs and potential tax events without improving long-term returns. Less frequent rebalancing allows drift to accumulate to levels that change your risk profile.

Should I rebalance in all accounts at once?

Rebalance at the portfolio level, not the account level. Execute trades preferentially in tax-advantaged accounts (where there are no tax consequences) and use new contributions in taxable accounts to correct drift. Only sell in taxable accounts when drift is large and cannot be corrected through contributions alone.

What funds should I use for each asset class?

Low-cost, broad index funds are the default recommendation. For US equities: a total US stock market fund (e.g., Vanguard VTI, Fidelity FSKAX). For international: a total international fund (e.g., VXUS, FTIHX). For bonds: a total bond market fund (e.g., BND, FXNAX). For REITs: a REIT index fund (e.g., VNQ). The expense ratio should be below 0.10% for core holdings.

Does rebalancing improve returns?

Rebalancing does not reliably increase returns — it controls risk. By selling assets that have appreciated (overweight) and buying assets that have declined (underweight), you systematically buy low and sell high within your portfolio. Over long periods, this risk management benefit can contribute modest return improvement, but the primary purpose is maintaining your intended risk level.

Should I change my allocation as I age?

Yes. The conventional guidance — “hold your age in bonds” (a 35-year-old holds 35% bonds; a 60-year-old holds 60% bonds) — is a rough heuristic. The more nuanced approach: shift gradually toward more conservative allocations as you approach the date you will begin withdrawing from the portfolio. A “glide path” that moves from aggressive to moderate to conservative over a 30-year accumulation period is what target-date funds automate, and what this spreadsheet lets you manage manually with more control.

What about alternative investments like crypto, gold, or commodities?

The spreadsheet supports custom asset classes, so you can add a “crypto” or “commodities” allocation. However, the editorial position is that alternatives should not exceed 5–10% of a diversified portfolio for most investors. They add complexity, are harder to value, and have shorter track records than traditional asset classes. If you include them, treat them as a satellite allocation around a core of stocks and bonds — not as a replacement for either.