An Effective and Reliable Investment Portfolio Performance Tracking Tool
Excel Portfolio Performance Tracking is a tool that lets you monitor and track your financial investment portfolio performance continually with periodic valuation. The investment transactions could be inputted during reporting periods. You can refresh the tracking template after a specific reporting period is over so that you can archive transactions, start a new tracking period, and reset start values. The input forms help with inputting transaction and investment information. If you do not understand certain calculations, the built-in explanations would help. You can enter in any number of transactions for each investment. There is also the facility to handle entire investment liquidation and reinvestment of dividends.
Portfolio performance tracking and periodic valuation of investment portfolios with time weighted return calculations.
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.
