Exl plan Ultra Plus description
Exl-plan Ultra Plus is a useful utility for new & substantial companies
Exl-plan Ultra Plus is a useful utility for new & substantial companies. Monthly projections for initial three years. Projects for the fourth and fifth years on a quarterly basis and, optionally, for sixth/seventh years on an annual basis. Similar to Ultra but includes a greater range of revenue and cost assumptions.
Here are some key features of "Exl plan Ultra Plus":
· 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 on-line 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
· 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.
Requirements:
· Microsoft Excel
Limitations:
· 12 runs trial