Portfolio Performance Tracking

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

Find Excel Solutions


Search User Guides:


Need a Customized Excel Solution?
Post your project to the community of experienced Excel professionals to ensure that your development requirements are most efficiently met and complete. Post a Project


Follow Business Spreadsheets On:
 
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


  
 




Find Excel templates
and add-ins in the
Excel Business Solutions Directory

       
  © 2013 Business Spreadsheets. All Rights Reserved. Legal |