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.
The Multiple Regression Analysis and Forecasting template provides a reliable identification of value drivers and forecasting business plan data. Advanced statistical tests performed include significance, autocorrelation and multicollinearity.
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.
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.
The Bond Yield to Maturity calculator for Excel and OpenOffice Calc enables the automatic generation of scheduled bond payments and the calculation of resulting yield to maturity.
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.
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.
The invoice template for Excel is a complete customer invoicing system with ability to store created invoices, products and customer details, manage inventory and perform advanced order sales reporting.