Support
Free Registration
Purchase Upgrade
Exl-Plan Free - Online Manual
Contents
| Index
- A -
Accounts payable
Accounts receivable
Accrued expenses
Additional license terms for distribution of shareware ("trial") & freeware versions
Additional license terms for unregistered shareware ("trial") & freeware versions
Assumption reports
Detailed guidance
Entering assumptions
Fixed assets
Funding, interest rates & related items
Materials/goods, other direct costs & purchases
Overhead expenses
Sales & related taxes
Sales forecasts
Year-end credit balances
Assumptions
Accounts payable
Accounts receivable
Accrued expenses
Average input tax rate for non-payroll expenses
Average input tax rate for purchases of materials/packaging & goods
Average input tax rate for these items
Average output tax rates on sales
Capital expenditure
Capital expenditure outstanding at year end
Cash at bank
Changes in accrued expenses
Changes in prepaid expenses
Clerical payroll/benefits
Clerical staff
Corporation tax rate
Cost of materials/pack or goods for resale
Cost of materials/packaging or goods for resale
Cost of sales
Creditors
Debtors
Depreciation rate
Desired inventory of materials/packaging or goods for resale
Detailed guidance
Direct costs
Direct labor
Direct payroll/benefits cost
Disposal of fixed assets
Dividends declared
Dividends payable at year end
Drawings
Effective federal/state tax rate
Entering assumptions
Entering opening balance sheet
Entering prior-year income statement (P&L)
Erasing existing values
Exl-Plan range
Exl-Plan versions
Fast entry
Federal/state tax payable at year end
Gathering & entering assumptions
General expenses
Goods for resale
GST rates
Income tax payments
Income tax provisions
Increases in long-term debt/notes
Input tax rates
Intangible asset amortization
Interest rates
Inventory
Long-term debt/note repayments
Long-term debt/notes
Management payroll/benefits
Management staff
Material costs
Miscellaneous income
Net input taxes payable at year end
Net selling prices
No. of new ordinary shares issued
Opening balance sheet
Operating lease payments
Other direct costs
Output tax rates
Overdraft
Payroll taxes & benefits payable at year end
Percent of all other non-payroll expenses (operating exs etc.) subject to input taxes
Percent of capital expenditure and disposals subject to input taxes
Prepaid expenses
Prices
Prior-year income statement (P&L)
Proceeds of new stock issues
Proportions payable within one year
Purchases of materials/packaging & goods for resale
Reducing detail
Sales
Sales tax rates
Selling expenses
Selling prices
Share/stock issues
Short-term loans/credit
Specify descriptive term for sales or input/output tax
Stocks
Tax rate
Total long-term debt/notes
Total sales
VAT rates
Avoiding calculation errors
- B -
Balance sheet
Opening
Building new projections
Business planning
- C -
Calculation
Calculation errors
One or more balance sheets are unbalanced
Opening balance sheet is unbalanced
Some formulae are generating errors
The two sub-models are not producing indentical results
Capital expenditure
Capital expenditure outstanding at year end
Changing column widths
Changing Exl-Plan
Changing the name of an existing variable
Combining simple changes
Deleting a row
Extending Exl-Plan
Extending the power of plugging in
General procedure for complex changes
Inserting a new balance sheet item
Inserting an additional expense item
Plugging new variables into an existing variable
Using formulae instead of values
Changing report layouts
Changing the name of an existing variable
Changing view of reports
Chnaging Exl-Plan
Changing column widths
Changing report layouts
Combining simple changes
Completing the projections
Computers & modeling
Costs
Direct labor
Direct payroll/benefits cost
Goods for resale
Materials
Other direct costs
Creditors
- D -
Dashboard
Debt
Debtors
Deleting a row
Depreciation
Detailed guidance on generating projections
Direct costs
Dividends
Declared
Dividends payable at year end
Doing sensitivity analyses
- E -
Entering Assumptions
Entering opening balance sheet
Entering prior-year income statement (P&L)
Erasing existing values
Excel
Set up tutorial
Setting up
Exl-Plan
Basics - tutorial
Calculation errors
Changing view of reports
Completing projections
Dashboard
Detailed guidance on generating projections
Doing sensitivity analyses
Entering assumptions
Entering opening balance sheet
Entering prior-year income statement (P&L)
Erasing existing values
Extending Exl-Plan
Familarization
Familiarization
Formats
Freezing titles
General description
Get orientated
Get started
Get started - tutorial
Help
Installation
License agreements
Making complex changes
Making simple changes
Manual recalculation
Model-building pocedure
Output
Pasting data into Word
Printing
Protection
Range of versions
recalculation
Reducing detail
Reports & charts
Set up Excel
Set up Excel - tutorial
Setting up Exl-Plan
Structuring a model
Support
Toolbar
Tutorials
Versions
Very quick start
Welcome
Zoom settings
Exl-Plan range
Assumptions handled
Credit & input/output tax assumptions
Description of versions
Facilities & features
Fixed asset, investment & financing assumptions
Sales, cost, inventory & expense assumptions
Scope
Exl-Plan versions
Assumptions handled
Credit & input/output tax assumptions
Description of versions
Facilities & features
Fixed asset, investment & financing assumptions
Sales, cost, inventory & expense assumptions
Scope
Expenses
General
Selling
Extending Exl-Plan
Extending the power of plugging in
- F -
Familarization
Familiarisation
Tutorials
Familiarization Exercise
Fast entry of assumptions
Financial modelling & business planning
Fixed assets
Capital expenditure
Depreciation rate
Disposal
Formats
UK/International
US/Canadian
Free-Plan
Freezing titles
- G -
Gathering & entering assumptions
General procedure for complex changes
Get orientated with Exl-Plan
Get started
Detailed guidance on generating projections
Enter assumptions
Entering assumptions
Entering opening balance sheet
Entering prior-year income statement (P&L)
Erase existing values
Familiarization
Familiarization exercise
Gather & enter assumptions
Get the basics - tutorial
Installation
Loading Exl-Plan
Make new projections
Model-building pocedure
Orientation
Register Exl-Plan Free
Register Free-Plan
Set up Excel
Set up Excel - tutorial
Set up Exl-Plan
Starting to use Exl-Plan
Structuring a model
Summary of model-building pocedure
Tutorial
Very quick start
Guidance on entering assumptions
- H -
Help & Manual
Contents
Typographical conventions
Help systems
HTML Help
WinHelp
How to
Adjust zoom settings
Avoid calculation errors
Avoid problems
Change Exl-Plan
Change view of reports
Complete projections
Detailed guidance on generating projections
Do sensitivity analyses
Enter assumptions
Enter opening balance sheet
Enter prior-year income statement (P&L)
Erase existing values
Extend Exl-Plan
Freeze titles
Gather & enter assumptions
Get help
Get started - tutorial
Get support
Get the basics - tutorial
Install Exl-Plan
Load Exl-Plan
Make complex changes
Make new projections
Make simple changes
Paste data into Word
Prepare to plan
Print
Protect your work
Reduce detail
Register Exl-Plan Free
Register Free-Plan
Set up Excel
Set up Excel - tutorial
Set up Exl-Plan
Set zoom
Structure a model
Summary of model-building pocedure
Tutorials
Use Exl-Plan
HTML Help
- I -
Income statement (P&L)
Prior-year
Inserting a new balance sheet item
Inserting an additional expense item
Installation
Intangible assets
Interest rates
Introducing the Exl-Plan range
Inventory
Invest-Tech Limited
- L -
Labor
Clerical payroll/benefits
Clerical staff
Direct labor
Direct payroll/benefits cost
Management payroll/benefits
Management staff
Payroll taxes & benefits payable at year end
Leases
License agreement for commercial/registered version
License agreements
Commercial/registered version
Distribution of shareware ("trial") & freeware versions
Unregistered shareware ("trial") & freeware versions
List of reports & charts
Loading Exl-Plan for first time
Loans
- M -
Making complex changes
Making new projections
Making simple chnages
Manual recalculation
Materials/Goods
Model-building pocedure
Summary of procedure
Modeling
Completing the projections
Detailed guidance on generating projections
Sensitivity analyses
Setting up Exl-Plan
Structuring a model
Summary of model-building pocedure
- N -
New projections
- O -
One or more balance sheets are unbalanced
Online tutorials
Opening balance sheet
Opening balance sheet is unbalanced
Output
Changing view of reports
Dashboard
Pasting data into Word
Printing
Reducing detail
Reports & charts
- P -
Pasting data into Word
Pitfalls & dangers
Planning
Doing sensitivity analyses
Pitfalls & dangers
Preparation
PlanWare
Plugging new variables into an existing variable
Prepaid expenses
Preparing to plan
Printing
Change view of reports
Prior-year income statement (P&L
Prior-year income statement (P&L)
Profit & Loss accounts
Prior-year
Protecting your work
Protection
Avoiding problems
Facilities
Protecting your work
Purchases
- R -
Rates
Cash at bank interest rates
Corporation tax rate
Depreciation
Effective federal/state tax rate
GST rates
Input tax rates
Output tax rates
Overdraft rates
Sales tax rates
Short-term loans/credit rates
Tax rate
VAT rates
Recalculation
Reducing detail in assumptions & reports
Register Exl-Plan Free
Register Free-Plan
Reports
Assumption reports
Changing view
Entering assumptions
Pasting data into Word
Printing
Reducing detail
Reports & charts
- S -
Sales forecasts
Selling prices
Sensitivity analyses
Set up Excel
Tutorial
Setting up Excel to run Exl-Plan
Setting up Exl-Plan
Share issues
Some formulae are generating errors
Starting to use Exl-Plan
Stock issues
Stocks
Structuring a model
Summary of model-building pocedure
Support
Avoid problems
Avoiding calculation errors
Other sources of assistance
Support & assistance
- T -
Tax
Average input tax rate for non-payroll expenses
Average input tax rate for purchases of materials/packaging & goods
Corporation tax rate
Effective federal/state tax rate
GST rates
Income tax payments
Income tax provisions
Input tax rates
Output tax rates
Percent of all other non-payroll expenses (operating exs etc.) subject to input taxes
Percent of capital expenditure and disposals subject to input taxes
Sales tax rates
Tax rate
VAT rates
Taxes
Federal/state tax payable at year end
Net input taxes payable at year end
Payroll taxes & benefits payable at year end
The two sub-models are not producing indentical results
Toolbar
Entering assumptions
List of buttons
Tutorials
Basics of Exl-Plan
Get started
How to set up Excel
- U -
UK/International format
US/Canadian format
Uses of a model
Using Exl-Plan
Using formulae instead of values
- V -
Very quick start
- W -
Welcome to Exl-Plan
WinHelp
Word
Pasting in data
- Z -
Zoom settings
