Although I generally love everything about Vanguard, I wish they had an easy way to rebalance your portfolio. Since they don’t, I’ve created this free portfolio rebalancing calculator to make it a bit easier.
All you have to do is enter your total portfolio value, the current amount of each investment, and your target allocation for each investment. Entering investment names and symbols is optional. I’ve pre-entered the investment names and symbols for the Vanguard funds you’ll find in my free portfolio allocation calculator, but you can use this calculator for any portfolio with up to 20 investments. If you need to figure out how many shares to buy or sell, simply divide the result by the current price per share. (This isn’t necessary when using Vanguard’s website. They let you buy in dollar amounts.)
The calculator will tell you how much to buy or sell of each investment to reach your target asset allocation. If you’re adding cash to the portfolio, simply add the amount you’re going to deposit to your “Total Portfolio Value”. If you’re planning to withdraw cash from the portfolio, simply subtract that amount from your “Total Portfolio Value”. Then enter everything else like normal.
Any odd cents will be added to or subtracted from the last investment listed on the spreadsheet. You’re responsible for double-checking the calculator’s results. I can’t fix user error, and I can’t guarantee that this calculator is error-free (though I’m fairly sure it works fine). If you have any questions or suggestions, leave them in the comments below and I’ll try to help you. You’ll want to expand it to full screen view or save it as an Excel file to see everything at once.
*Note: Click the ‘Click to Edit’ button to use the calculator with your own numbers.