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.
» version 3.2 - posted on 2016-09-05
Compatible with Microsoft Excel 2016 for Windows and Mac
» version 1.0 - posted on 2006-12-01
EULA - End User License Agreement
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. Business Spreadsheets DO NOT WARRANT THAT THIS SOFTWARE, ITS SITE, ITS SERVERS, OR E-MAIL SENT FROM ANY OF ITS AFFILIATES ARE FREE OF VIRUSES OR OTHER HARMFUL COMPONENTS. Business Spreadsheets WILL NOT BE LIABLE FOR ANY LOSSES OF ANY KIND ARISING FROM THE USE OF THIS SOFTWARE, INCLUDING, BUT NOT LIMITED TO DIRECT, INDIRECT, INCIDENTAL, PUNITIVE, AND CONSEQUENTIAL LOSSES.
Tell us your experience with Portfolio Performance Monitoring3.2
RELATED PROGRAMS Our Recommendations
PortfolioTK TRIAL PortfolioTK is a stock portfolio manager that provides both accurate quantitative statistics and advanced charting. It includes overall portfolio equity curve performance with risk analysis, trade log entry supporting partial position matching of both long and short trades, and a charting... Download
WebCab Portfolio (J2EE Edition) TRIAL Apply the Markowitz Theory and Capital Asset Pricing Model (CAPM) to analyze and construct the optimal portfolio with/without asset weight constraints with respect to Markowitz Theory by giving the risk, return or investors utility function; or with respect to CAPM by given the risk, return or... Download
WebCab Portfolio (J2SE Edition) TRIAL Apply the Markowitz Theory and Capital Asset Pricing Model (CAPM) to analyze and construct the optimal portfolio with/without asset weight constraints with respect to Markowitz Theory by giving the risk, return or investors utility function; or with respect to CAPM by given the risk, return or... Download