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 The Portfolio Optimization template optimizes capital weightings for portfolios of financial investments that maximizes return and minimizes risk. Technical analysis constant parameters are optimized to maximize back tested returns on signal trading.
Advanced Find Replace for Excel The Ablebits.com Advanced Find Replace enhances Excel's built-in Find with simultaneous search in values, formulas and comments in all opened or selected worksheets and workbooks. The add-in works in Excel 2003 - 2010.
Ablebits.com Ultimate Suite for Excel 40+ professional tools for Excel 2016-2007 to automate frequently performed tasks such as matching and merging worksheets, removing duplicates in one sheet or between two lists, consolidating multiple files into one, cleaning data and more.
Quote Generator Quote Generator is the answer to your Quote Administration needs. It provides a simple and effective business tool to create, manage and track quotations for your customers. The system allows for the storage of customer details, product descriptions
Investment and Business Valuation The Investment and Business Valuation template is ideal for evaluating a wide range of investment, financial analysis and business case scenarios. Analysis performed includes accounting impact, Economic Value Added, and NPV of cash flows.
Real Options Valuation 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.
Version: 3.1 Released: Sep, 30 2015 License: Shareware, $22.00 Expires: Expires after 30 Days
File size: 123 K Platforms: Windows 8/7/Vista/XP/2000; Other OS Downloads: 137
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.