Home > Portfolio Performance Tracking User Guide Share

Portfolio Performance Tracking

User Guide for the Portfolio Performance Tracking Excel template by Business Spreadsheets


User Guide Navigation:
Business Spreadsheets User Guides: Project Planning and Management Multiple Regression Analysis and Forecasting Investment and Business Valuation Real Options Valuation Portfolio Optimization Portfolio Performance Tracking Customer Invoicing
Portfolio Performance Tracking Help Topics: Understanding the Model Structure Managing Portfolio Products Entering Transactions Executing Reports Understanding the Reports

The Portfolio Performance Tracking template enables the ongoing tracking and periodic valuation of a portfolio of financial investments. The model allows the entering of investment transactions during a reporting period to calculate performance. Furthermore, incremental investment transactions undertaken during a period are fully accounted for in the period's performance calculations by utilizing the 'Money Weighted Return'. Roll over of the model and archiving of transactions make the model suitable for monitoring and tracking a portfolio on an ongoing basis.

 

Additional support resources: Download | Video | Forum | FAQ