Software Developed by Business Spreadsheets

Regression Analysis and Forecasting

The Multiple Regression Analysis and Forecasting model provides a solid basis for identifying value drivers and forecasting business plan data. While it utilises a range of commonly employed statistical measures to test the validity of the analysis,

Real Option Valuation

The Real Option Valuation model encompasses a suite of option pricing tools to quantify the embedded strategic value for a range of financial analysis and investment scenarios. Traditional discounted cash flow investment analysis will only accept an

Project Planning and Management  v.2.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.

Portfolio Performance Monitoring  v.2.0

The Portfolio Performance Monitoring model enables the ongoing monitoring and periodic valuation of a portfolio of financial investments. Amount and timing of investment and divestment transactions are taken into account in performance calculations.

Portfolio Optimization  v.2.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 action required and probability analysis through Monte Carlo simulation.

Investment and Business Valuation

The Investment and Business Valuation template is ideal for evaluating a wide range of investment, and business case scenarios. While it is based on the traditional DCF method of valuation, its also provides ability to evaluate economic value added

Customer Invoice Template  v.2.0

The customer invoicing system is an Excel invoice template with ability to store created invoices, products and customer details and perform advanced order sales reporting.

Bond Yield Calculator

The Bond Yield Calculator for Excel or OpenOffice Calc enables the automatic generation of scheduled bond payments and the calculation of resulting yield to maturity. The model is equipped to handle 'odd' first time periods and is ideal to speed up bond