Portfolio Tracking Background
Portfolio Tracking Icon

Excel template for evaluating investment portfolios.

4
Downloads
5.0
1 Ratings
All Versions
4
Total Downloads
0
Downloads Last Week
Current Version
4
Total Downloads
0
Downloads Last Week
Downloads Last 10 Weeks
All Versions
5.0
1 Ratings
5
4
3
2
1
Current Version
5.0
1 Ratings
5
4
3
2
1

Portfolio TrackingOverview

The Portfolio Tracking template enables the ongoing monitoring 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. Roll over of the model and archiving of transactions make this model ideal for monitoring a financial investment portfolio on an ongoing basis. 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.

New

  • Enhanced exporting functionality
  • Conversion to XLSM for current and future version of Excel for Mac
  • Tested for Yosemite compatibility

Portfolio TrackingTech Specs

Version
3.0
Date
11.02.14
License
Free to try
Language
English
File Size
100 KB
Category
Operating Systems
Mac OS X
System Requirements
  • OS X 10.5 or later.
  • Excel 2004 or Excel 2011.

AppsSelected For You

OmniGraffle Icon
The Omni Group
Create diagrams, flow charts, and more.
Vitamin-R Icon
publicspace.net
Personal productivity tool.
Evernote Icon
Evernote Corporation
Create searchable notes and access them anywhere.
Neat Icon
The Neat Company
Digital filing system for receipts, business cards, and documents.
Bookends Icon
Sonny Software
Reference management and bibliography software.
Things Icon
Cultured Code
Elegant personal task management.
InPreflight Studio Icon
Zevrix Solutions
Comprehensive quality-control and reporting solution for Adobe InDesign.
Risky Business SOS Icon
MacSOS Solutions Pty Ltd
Online register of Procedures, Hazards and Hazardous Substances.