Support   Free Registration   Purchase Upgrade


- 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

Building New Projections
How to Get Started
Preparing to Plan
Model-Building Procedure

Business planning

Financial Modeling & Business Planning
Preparing to Plan
Pitfalls & Dangers

- 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 Exl-Plan
Making Simple Changes
Making Complex Changes

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

Fast Entry of Assumptions
Entering Assumptions
Guidance on Entering Assumptions

Entering opening balance sheet

Entering prior-year income statement (P&L)

Erasing existing values

Erasing Existing Values
Gathering & Entering Assumptions

Extending Exl-Plan

Familarization

Familiarization

Formats

Freezing titles

General description

Get orientated

Get started

Get started - tutorial

Help

Exl-Plan Help
Support & Assistance

Installation

License agreements

Making complex changes

Making simple changes

Manual recalculation

Model-building pocedure

Output

Lists of Reports & Charts
Dashboard

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

Exl-Plan Help
Support & Assistance

Toolbar

Fast Entry of Assumptions
Exl-Plan’s Toolbar

Tutorials

Versions

Very quick start

Welcome

Zoom settings

Exl-Plan range

Introducing the Exl-Plan Range
Exl-Plan Range
Scope of Exl-Plan Range
Facilities & Features of Exl-Plan Range
Assumptions Handled by 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

Introducing the Exl-Plan Range
Exl-Plan Range
Scope of Exl-Plan Range
Facilities & Features of Exl-Plan Range
Assumptions Handled by 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

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
Completing the Projections

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

Fast Entry of Assumptions
Entering Assumptions
Guidance on Entering 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

Setting Up Excel to Run Exl-Plan
Installation of Exl-Plan

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

Computers & Modeling
Uses of a Model

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

Very Quick Start
Building New Projections

- O -

One or more balance sheets are unbalanced

Online tutorials

Opening balance sheet

Entering Prior-Year Income Statement & Opening Balance Sheet
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

Pitfalls & Dangers
Doing 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