Portfolio Tracking & Monitoring

The Excel Portfolio Performance Monitoring template enables the ongoing monitoring and periodic valuation of a portfolio of financial investment assets. Investment asset categories can be configured and chosen to be hidden or shown to monitor and value the portfolio by asset category.

The portfolio tracking enables the entering of investment transactions during a reporting period to calculate performance. Incremental investment transactions including withdraw, reinvestment and distributions undertaken during a period are accounted for in performance calculations under the time weighted return method for the portfolio reporting period.

The investment portfolio can be rolled over whereby transactions are archived and values reset to be ready for a new reporting period. Snapshots of portfolio values by asset category can be made at any time to track the portfolio performance trend and overall valuation over time.

The Portfolio Performance Monitoring template is designed for ease and flexibility of product and transaction input with embedded help prompts providing detailed explanatory information. The portfolio tracking accurately handles of distributions, investments and divestments including reinvestment of dividends to calculate period returns for the portfolio.

The Portfolio Performance Monitoring template is compatible with Excel 97-2013 for Windows and Excel 2011 or 2004 for Mac as a cross platform portfolio tracking and valuation solution.