Portfolio rebalancing tool

This portfolio rebalancing tool will help you keep your asset mix just right, even as you invest more money.

  9 Premium content image

by

Online only.

  9 Premium content image

Download: MoneySense Portfolio Rebalancing Tool

Instructions:

  • Click to download the spreadsheet tool and open the file.
  • In column B (under the heading Asset Class), enter the names of the funds or securities in your portfolio. You can use the Insert function to add new rows or the Delete function to remove them as necessary.
  • In column C (Target Allocation), enter the target allocation you’ve set for each asset class.
  • In column D (Current Allocation), enter the current market value of each of your funds. The spreadsheet will calculate what percentage of your portfolio each fund represents and display this in column E.
  • When you’re ready to rebalance, enter the amount of new money you’re adding in cell D5. (If you plan to rebalance without adding any new money, enter $0.)
  • The spreadsheet will then calculate how much money you need to add or subtract from each fund in order to rebalance the portfolio. These values will appear in column F.
  • If you customize the spreadsheet, be careful not to change the formulas!

For more on this topic read, “Portfolio rebalancing: Why, when and how much,” and “Getting back to balanced.”

9 comments on “Portfolio rebalancing tool

  1. With what program do I open this spreadsheet document with?

    Reply

    • Open the document with Excel. You may find that you’ll need a 2010 version or newer…

      Reply

    • Turns out you are CCP. Uh, my bad. I sure look like a jackass

      Reply

  2. My spreadsheet will ONLY calculate if I put a number other than $0 in the “how much money are you adding?” box. If I want to simply rebalance my portfolio as it is, it doesn’t seem to be working. What am I doing wrong? As far as I can see, no formulas have been changed/compromised. Please advise. Thank you!

    Reply

    • We advise you place $1 in the box. It won’t materially affect your results, says Canadian Couch Potato Dan Bortolotti.

      Reply

  3. At the present I have several accounts and am asking if i can somehow add a separate sheet for each account? If so, how?

    Reply

Leave a comment

Your email address will not be published. Required fields are marked *