Additional FAQs< Browse all Support Topics
Differences in Model Portfolio Returns vs. “Portfolio Holdings” Excel Templates Returns
The Model Portfolio Returns can be calculated using periodic rebalancing for returns (monthly, quarterly, annual or never) whereas the “Portfolio Holdings” excel templates use a total weighted average of all holdings in the portfolio. This will cause a difference in returns in time frames.
For example, if you wanted a 5 year total return of a monthly rebalanced portfolio, the “Portfolio Holdings” excel templates will take the weighted average of the 5 year total return for all holdings included in the portfolio. Model Portfolios, on the other hand, will take the weighted average monthly returns of the holdings over the same time frame to then calculate the 5 year total return of the portfolio