Portfolio Performance Monitoring
Monitoring and tracking the performance of a portfolio of financial assets.
The Portfolio Performance Monitoring template enables the ongoing monitoring and periodic valuation of a portfolio of financial investments. The model 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 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 over time. The Portfolio Performance Monitoring template is designed for ease and flexibility of product and transaction input with embedded help prompts. The portfolio tracking accurately handles of distributions, investments and divestments to calculate returns. 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.
Changes: Compatible with Microsoft Excel 2016 for Windows and Mac
Minimum requirements: Requires Microsoft Excel 97 or higher
Operating system: Win2000,WinXP,Win7 x32,Win7 x64,Windows 8,Windows 10,WinServer,WinOther,WinVista,WinVista x64
Program URL: http://www.business-spreadsheets.com/portmon.htm
Video: https://www.youtube.com/watch?v=poAgAFwVh2Q
G+ Linikedin Twitter FacebookPortfolio Performance Monitoring screenshot
Press release: Track and manage financial investment portfolios in Excel
Portfolio valuation is a concise and portable solution for tracking and monitoring financial portfolio valuation and performance.
Special permissions
You are able to make multiple copies of this model on the same computer. It is recommended to make a copy of the model before use so that an original 'clean' copy is accessible without the need to download a new one. Site licenses are available on purchase so that the model can be registered for an unlimited number of users within the same organization.
EULA
Business Spreadsheets MAKE NO REPRESENTATIONS OR WARRANTIES OF ANY KIND, EXPRESS OR IMPLIED, AS TO THE OPERATION OF THIS SOFTWARE OR THE INFORMATION, CONTENT, MATERIALS, OR SERVICES INCLUDED WITHIN IT. YOU EXPRESSLY AGREE THAT YOUR USE OF THIS SOFTWARE IS AT YOUR SOLE RISK. TO THE FULL EXTENT PERMISSIBLE BY APPLICABLE LAW, Business Spreadsheets DISCLAIM ALL WARRANTIES, EXPRESSED OR IMPLIED.