Excel Portfolio Tracking

Excel Portfolio Tracking 3

Portfolio performance tracking and periodic valuation of investsment portfolios with time weighted return calculations.

PROS

  • Accounts for financial asset transactions during the reporting period.

CONS

  • Requires Microsoft Excel 97 or higher.

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.

Excel Portfolio Tracking

Download

Excel Portfolio Tracking 3