Investing · Practical tool
Portfolio costs and rebalancing worksheet
See weighted expenses, current allocation and hypothetical changes to targets you choose.
Enter up to five holdings or asset groups. Use current dollar balances, annual expense ratios and target weights that you have selected independently. Enter zero for an individual security's fund expense ratio when no fund expense applies; include other charges separately where appropriate. The examples are hypothetical.
Every target must be between 0% and 100%, and the targets must total 100%. An unused row should have zero balance, zero expense and zero target. The total portfolio must be greater than zero for weights and hypothetical changes to be calculated.
Method
Annual investment-expense estimate equals the sum of each balance multiplied by its expense ratio. Weighted expense ratio equals that expense estimate divided by total assets. A separate flat annual advisory rate applies to the full entered balance; it is not a tiered-fee calculator.
Current weight equals holding balance divided by total assets. Target dollars equal target weight multiplied by total assets. Hypothetical change equals target dollars less the current balance. Positive means an illustrative addition; negative means an illustrative reduction.
This is constant-balance arithmetic, not a forecast, security recommendation or trade instruction. It does not model taxes, spreads, commissions, liquidity, minimum trade sizes, restrictions, cash flows or changes in price during implementation. Consider using contributions or withdrawals before selling appreciated holdings.
Read the portfolio-building guide and benchmark guide for context. This calculator code runs in your browser without transmitting or tracking entries; general website analytics are separate. A reload resets the examples; browser form-restoration behavior may vary. Exported files contain your entries, so use generic labels and no account identifiers.
