The Excel 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 your portfolio on an ongoing basis. The key features of the Excel portfolio tracking template include: Ease and flexibility of product and transaction input, with embedded help prompts; Accurate handling of distributions, investments, and divestment to calculate returns. Rollover option to reset the model for a new reporting period and storage of historical transactions.
The financial investment portfolio is treated as a liquid and moving basket of investments. Transactions for buys, sells and distributions are fully accounted for in both the current valuation and performance calculations. Compatible with Excel for Windows and Excel for Mac 2011 and 2004.