Build monthly, quarterly, "stub" (partial year) or annual models, or a combination thereof, from a single template. Make it easy to maintain your library of financial models by eliminating the need to use separate templates for models covering different time periods.

Compare operating statistics and valuation multiples (not just P/E ratios) for publicly traded companies. Whether you are analyzing company value as an investor or a financial advisor, "equity comps" are one of the most basic and important valuation techniques. (Privately held companies also refer to comps to assess relative operating performance and to gauge valuation from the perspective of the public markets.)

The LBO template is now available exclusively with our Financial Analysis Knowledge Base Level II packages. The Level II content provides in-depth discussion of LBO fundamentals, capital structure and a step-by-step walk through of the LBO model building process. Please click the following link to learn more about the Financial Analysis Knowledge Base Level II.

This M&A Accretion / Dilution template is now available exclusively with our Financial Analysis Knowledge Base Level II packages. The Level II content provides discussion about the impact of an M&A (merger / acquisition) transaction on earnings per share (EPS). It also covers converts, options, and cash/stock mix, a lookup for potential targets and purchase accounting rules. Please click the following link to learn more about the Financial Analysis Knowledge Base Level II

The Investment Valuation template is ideal for evaluating a wide range of investment and business case scenarios. While it is based on the traditional discounted cash flow method of valuation, its also provides ability to evaluate economic value added valuation, accounting impact, and a range of other evaluation parameters. Furthermore, the step-by-step input flow makes usage straightforward, gaining quick results to drive decision-making.

The key features of the Investment Valuation template include:
- Ease and flexibility of input, with embedded help prompts.
- Cost of capital calculation.
- Economic value added valuation with flexibility on identifying economic costs with specific amortization periods.
- Accurate handling of asset purchase, disposal and depreciation with capital and gearing impacts.
- Evaluation of new investments or changes to existing investments.
- Unique 'finite' terminal value calculation alternative to mimic product and investment life cycles.
- Unique Comparative Investment Score can be set to evaluate and prioritise different investments, depending on the prevailing business environment.

(Requires Microsoft Excel 97 or higher)

The Multiple Regression Forecasting template provides a solid basis for identifying value drivers and forecasting data. While it utilises a range of commonly employed statistical measures to test the validity of the analysis, results are summarized in text for ease of use. Once relationships have been identified, forecasting can be accomplished based on a range of available methodologies. The intuitive step-by-step usage flow enables you to develop strong forecasts for your projects in a timely manner.

The key features of the Multiple Regression Forecasting template include:
- Ease and flexibility of input, with embedded help prompts.
- User-friendly results display for the 'Non-statistician'.
- Multiple and Individual Regression of independent variables.
- Tests for statistical significance, auto-correlation, and multi-colinearity.
- Quick forecasting process with options to employ 3rd polynomial, 2nd polynomial, exponential or linear trend lines on independent variables.

(Requires Microsoft Excel 97 or higher)

The Portfolio Optimization model calculates the optimal capital weightings for a basket of investments that gives the highest return for the least risk. The unique design of the model enables it to be applied to either financial instrument or business portfolios. The ability to apply optimization analysis to a portfolio of businesses represents an excellent framework for driving capital allocation, investment, and divestment decisions.

The key features of the Portfolio Optimisation template include:
- Ease and flexibility of input, with embedded help prompts.
- Ability to specify the number of units held in each product or business.
- Specify minimum and maximum constraints for the optimised portfolio.
- Unique 'Maintain Current Return Level' option to ensure that return is not deteriorated at the expense of risk.
- Intuitive graphical result display with Monte Carlo simulation, including probability analysis on specified 'Target' return level.

(Requires Microsoft Excel 97 or above)

The Portfolio Performance Monitoring 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 periods 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 Portfolio Monitoring template include:
- Ease and flexibility of product and transaction input, with embedded help prompts.
- Accurate handling of distributions, investments, and divestments to calculate returns.
- Portfolio 'Rollover' option to reset the model for a new reporting period.
- Storage of historical transactions.

(Requires Microsoft Excel 97 or above)

The Project Planning and Management template is designed as a generic, affordable, Excel based solution to plan and manage any project. The ability to build the projects budget as tasks are identified facilitates the processes of business case proposal, valuation analysis, and securing the required funding. Project dynamics can be altered and performance monitored with best practice Earned Value Analysis throughout the complete project lifecycle.

Key features of the Project Planning and Management template include:
- Ability to define project budget as tasks are defined;
- Pre-define project phases, task titles, holidays, and other key project parameters;
- Creation of task dependencies and timing constraints;
- 'Auto-timing' function calculates optimal project schedule automatically;
- Gantt schedule charting with mouseover details;
- Project status reporting based on best practice Earned Value Analysis;
- Emailing of participant task lists and creation of individual participant workbooks to enable updating of task progress from remote workbooks.

(Requires Microsoft Excel 97 or higher)

IMPORTANT NOTE for Macintosh users:
Due to this product's integration with some Windows API functions, this template is not compatible with Excel on the Macintosh operating system.

The Real Option Valuation model encompasses a suite of option pricing tools to quantify the embedded strategic value for a range of investment scenarios. Traditional discounted cash flow investment analysis will only accept an investment if the returns on the project exceed the hurdle rate. While this is a worthwhile exercise, it fails to consider the myriad of strategic options that are associated with many investments. This model provides the ability to identify what options might exist in your proposal and the tools to estimate the quantification of them.

The key features of the Real Option Valuation model include:
- Ease and flexibility of input, with embedded help prompts.
- Informative 'Quick Start' menu for choosing the correct tool for the situation.
- Modified Black Scholes models to value the options to delay, expand, or abandon investments.
- Automatic binomial 'tree' builder model to evaluate complex strategic options with multiple stages.
- Nash equilibrium Game Theory model to evaluate market entry strategies in a competitive environment.
- Ability to predefine historical investment and/or industry risk profiles to utilize across models.

(Requires Microsoft Excel 97 or higher)

Note for Excel 2002 users: This model invokes the Solver.xla add-in within the VBA code. This may cause a compile error when opening the model in Excel 2002 (XP). This error can be resolved by following the instructions here.

The Customer Invoicing Template is an invoice template with the ability to store invoices, products and customers and perform advanced invoice sales reporting. The database type structure of the invoice system allows the insertion, update and quick access to saved products, customers, and historical customer invoices. Product and customer lists can be imported from and exported back to text lists enabling integration with existing inventory and customer reporting management systems.

Key features of the Customer Invoicing Template include:
- Control panel to establish predefined content for the invoice template and facilitate efficient customer invoice management.
- Add, update, access and remove products, customers and orders quickly and easily.
- Capacity to save 65000 products, 65000 customers, and 1.3 million orders in each template. Multiple templates can also be created and used.
- Advanced search options to locate and load previously saved invoices in the system.
- Import and export customer and product lists in CSV text file formats for integration with existing inventory and customer management systems.
- Export invoices to Excel worksheets or Microsoft InfoPath XML files. - Automatic product inventory stock level adjustment for new and updated invoices.
- Update of amount paid for invoices by customers allows calculation of uncollected revenue outstanding.
- Sales reporting for the analysis of product and customer profitability and performance with ranking options.
- Download version can be used as free invoice template for unlimited time with the ability to release advanced features at any time.

(Requires Microsoft Excel 97 or higher)