The Portfolio Performance Monitoring template enables the ongoing monitoring and periodic valuation for portfolios of financial investments. Amount and timing of investment and divestment transactions are accounted for in performance calculations.
Real Options Valuation 3.2 The Real Option Valuation template provides a set of option pricing tools to quantify the embedded strategic value for a range of financial analysis and investment scenarios. Option pricing models include Black-Scholes, Binomial, and Game Theory.
Project Planning and Management 3.0 The Project Planning and Management template is designed as a generic solution to plan and manage any project from start to finish. Automated features include Gantt scheduling, participant workbook creation and progress update from remote files.
Description: The Portfolio Performance Monitoring template enables the ongoing monitoring and periodic valuation of a portfolio of financial investments. The model enables the entering of investment transactions during a reporting period to calculate performance. 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.
Portfolio Optimization 1.0 The Portfolio Optimization model calculates the optimal capital weightings for a basket of financial investments that gives the highest return for the least risk. Results display