Skip to content
The title slide and first slides of the Portfolio Rebalancing Calculator template

Portfolio Rebalancing Calculator

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Difficulty
Beginner
Updated
November 16, 2026

Every slide (5)

Overview

Rebalancing is arithmetic: compare what you hold with what you wanted and trade the difference. List every fund on Holdings with its class, value and price per share. On Targets, give each class a weight. The calculator splits each class trade across the funds in that class in proportion to their value and converts the dollars to shares.

Trades Needed totals what to buy and what to sell, counts how many funds change and charts current against target value by class. In the sample, bonds are over weight by about $6,100 and international stocks under by $3,900. To invest new money, add a Cash row and give it its own target weight.

Useful for

  • Turn target weights into exact dollars and share counts
  • See whether total buys match total sells
  • Prepare a rebalance for several funds in one class

What's included

  • 4 tabs: Holdings, Targets, Trades Needed, How to use
  • Holdings: a table
  • Targets: a table with 1 summary figures
  • Trades Needed: a dashboard with 4 summary figures
  • 1 chart that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Holdings tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How do I rebalance a portfolio?

Compare each asset class with its target weight, then sell what is over and buy what is under. You can also steer new deposits to the low classes instead of selling.

What is the formula for shares to trade?

Divide the dollar trade by the price per share. The Shares to trade column does this for every fund using the price you enter.

Does rebalancing create taxes?

Selling in a taxable account can create a taxable gain, while trades inside most retirement accounts usually do not. Ask a tax advisor what your own sale would trigger.

  • #investment-tracker
  • #portfolio-rebalancing-calculator
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More investment tracker templates

See all 14

Also in Finance

All finance templates
Get this template

Preparing your template…