Facilities & Features of Exl-Plan

Once loaded, Exl-Plan automatically extends Excel's menu system (over 200 additional options) and adds its own toolbar and online help system.

This description concentrates on Exl-Plan Micro, Lite, Pro, Super, Super Plus, Ultra and Ultra Plus. Note that Exl-Plan Free and Basic are the most "junior" versions in the Exl-Plan range. They use the same general approach but are designed to generate comprehensive 2- and 5-year projections respectively based on annual assumptions rather than on the detailed monthly/quarterly assumptions used by all other versions.

Exl-Plan contains dozens of pre-formatted and protected worksheets incorporating many thousands of formulae, assumption values etc. Its facilities and features include the following:

Quik-Plan tool to enable a user produce first-cut projections (three years for Micro & Lite, and five years for Pro, Super, Super Plus, Ultra & Ultra Plus) quickly (i.e. within about 15 minutes). Click thumb opposite to see the automatically generated Summary & Diagnosis Report.
Facilities for inserting constant and varying monthly values and for entering assumptions based on seasonal patterns etc. specified by the user.
Selective what-if, or sensitivity analysis, covering months and quarters for the three (five) years.
Sensitivity-analysis tool for globally changing selling prices, volumes, direct costs and overheads for months and quarters (Pro, Super, Super Plus, Ultra and Ultra Plus versions only).
Book-marking facility to allow a user mark a location within a worksheet and to return quickly to it.
Multiple safeguards to protect formulae etc. and help prevent accidental changes being made to worksheets.
Extensive online help.
Comprehensive set of tailored toolbar buttons.
Error trapping to advise when any of a dozen types of data entry or calculation errors arise (click thumb opposite to see the Check Balances Report which monitors the integrity of Exl-Plan).
Full access to worksheets and formulae to facilitate customization and expansion.

The Super, Super Plus, Ultra and Ultra Plus versions include the following additional planning tools:

Automatically generated 'what-if' tables which display the impact of incremental changes in sales volumes, selling prices, cost of sales and overhead expenses on projected profitability for the first year.

DuPont-type profitability chart based on the first-year projections which also allows a user to explore the impact of specific changes in key variables and assumptions on overall profitability.

Facility to produce updated first-year projections of sales and profitability by combining year-to-date actuals with projections for remaining months of the year.

Tables to analyze longer term trends (five years historical plus five-years projected) for key ratios and performance measures.

Initial twelve-week cashflow forecasts derived from monthly cashflow projections for the first year.

Automatically generated "what-if" table (Super, Super Plus, Ultra & Ultra Plus versions) Profitability Planner to explore high-level "what-ifs" (Super, Super Plus, Ultra & Ultra Plus versions) Short-term weekly cash flow projections (Super, Super Plus, Ultra & Ultra Plus versions)


Automatically generated "what-if" table (Super, Super Plus, Ultra & Ultra Plus versions)	Profitability Planner to explore high-level "what-ifs" (Super, Super Plus, Ultra & Ultra Plus versions)	Short-term weekly cash flow projections (Super, Super Plus, Ultra & Ultra Plus versions)