HISTORIC BALANCE SHEET

Company Products & Services

 


Scenarios

Year 1

Year 2

Year 3

Products

Total Sales

$

$****

$****

$****

Domestic Sales

%

Exports

%

****%

****%

****%

Pre-tax Profit

%

****%

****%

****%

Interest Paid

%

****%

****%

****%

Non-trading Income

%

****%

****%

****%

Operating Profit

%

****%

****%

****%

Depreciation:   Structures

%

****%

****%

****%

Depreciation:   Plant and Equipment

%

****%

****%

****%

Depreciation:   Miscellaneous Items

%

****%

****%

****%

Total Depreciation

%

****%

****%

****%

Trading Profit

%

****%

****%

****%

Intangible Assets

%

****%

****%

****%

Intermediate Assets

%

****%

****%

****%

Fixed Assets: Structures

%

****%

****%

****%

Fixed Assets: Plant and Equipment

%

****%

****%

****%

Fixed Assets: Miscellaneous Items

%

****%

****%

****%

Fixed Assets

%

****%

****%

****%

Capital Expenditure on Structures

%

****%

****%

****%

Capital Expenditure on Plant and Equipment

%

****%

****%

****%

Capital Expenditure on Vehicles

%

****%

****%

****%

Capital Expenditure on Data Processing Equipment

%

****%

****%

****%

Capital Expenditure on Miscellaneous Items

%

****%

****%

****%

Total Capital Expenditure

%

****%

****%

****%

Retirements:  Structures

%

****%

****%

****%

Retirements:  Plant and Equipment

%

****%

****%

****%

Retirements:  Miscellaneous Items

%

****%

****%

****%

Total Retirements

%

****%

****%

****%

Total Fixed Assets

%

****%

****%

****%

Finished Product Stocks

%

****%

****%

****%

Work in Progress as Stocks

%

****%

****%

****%

Materials as Stocks

%

****%

****%

****%

Total Stocks / Inventory

%

****%

****%

****%

Debtors

%

****%

****%

****%

Miscellaneous Current Assets

%

****%

****%

****%

Total Current Assets

%

****%

****%

****%

Total Assets

%

****%

****%

****%

Creditors

%

****%

****%

****%

Short Term Loans

%

****%

****%

****%

Miscellaneous Current Liabilities

%

****%

****%

****%

Total Current Liabilities

%

****%

****%

****%

Net Assets / Capital Employed

%

****%

****%

****%

Shareholders Funds

%

****%

****%

****%

Long Term Loans

%

****%

****%

****%

Miscellaneous Long Term Liabilities

%

****%

****%

****%

Workers

Unit

Hours Worked

Unit

Work in 1st Quarter

% p.a.

****%

****%

****%

Work in 2nd Quarter

% p.a.

****%

****%

****%

Work in 3rd Quarter

% p.a.

****%

****%

****%

Work in 4th Quarter

% p.a.

****%

****%

****%

Total Employees

Units

Raw Materials Cost

%

****%

****%

****%

Finished Materials Cost

%

****%

****%

****%

Fuel Cost

%

****%

****%

****%

Electricity Cost

%

****%

****%

****%

Total Input Supplies / Materials and Energy Costs

%

****%

****%

****%

Payroll Costs

%

****%

****%

****%

Wages

%

****%

****%

****%

Directors' Remunerations

%

****%

****%

****%

Employee Benefits

%

****%

****%

****%

Employee Commissions

%

****%

****%

****%

Total Employees Remunerations

%

****%

****%

****%

Sub Contractors

%

****%

****%

****%

Rental & Leasing: Structures

%

****%

****%

****%

Rental & Leasing: Plant and Equipment

%

****%

****%

****%

Total Rental & Leasing Costs

%

****%

****%

****%

Maintenance: Structures

%

****%

****%

****%

Maintenance: Plant and Equipment

%

****%

****%

****%

Total Maintenance Costs

%

****%

****%

****%

Services Purchased

%

****%

****%

****%

Communications Costs

%

****%

****%

****%

Miscellaneous Expenses

%

****%

****%

****%

Sales Personnel Variable & Commission Costs

%

****%

****%

****%

Sales Expenses and Costs

%

****%

****%

****%

Sales Materials Costs

%

****%

****%

****%

Total Sales Costs

%

****%

****%

****%

Distribution Fixed Costs

%

****%

****%

****%

Distribution Variable Costs

%

****%

****%

****%

Warehousing Fixed Costs

%

****%

****%

****%

Warehousing Variable Costs

%

****%

****%

****%

Physical Handling Fixed Costs

%

****%

****%

****%

Physical Handling Variable Costs

%

****%

****%

****%

Physical Process Fixed Costs

%

****%

****%

****%

Physical Process Variable Costs

%

****%

****%

****%

Total Distribution and Handling Costs

%

****%

****%

****%

Mailing & Correspondence Costs

%

****%

****%

****%

Media Advertising Costs

%

****%

****%

****%

Advertising Materials & Print Costs

%

****%

****%

****%

POS & Display Costs

%

****%

****%

****%

Exhibition & Events Costs

%

****%

****%

****%

Total Advertising Costs

%

****%

****%

****%

Product Returns & Rejection Costs

%

****%

****%

****%

Product Installation & Re-Installation Costs

%

****%

****%

****%

Product Breakdown & Post Installation Costs

%

****%

****%

****%

Product Systems & Configuration Costs

%

****%

****%

****%

Product Service & Maintenance Costs

%

****%

****%

****%

Customer Problem Solving & Complaint Costs

%

****%

****%

****%

Total After-Sales Costs

%

****%

****%

****%

Total Marketing Costs

%

****%

****%

****%

New Technology Expenditure

%

****%

****%

****%

New Production Technology Expenditure

%

****%

****%

****%

Total Research and Development Expenditure

%

****%

****%

****%

Total Operational & Process Costs

%

****%

****%

****%

Debtors within Agreed Terms

%

****%

****%

****%

Debtors Outside Agreed Terms

%

****%

****%

****%

Un-recoverable Debts

%

****%

****%

****%

Figures given as a % of Turnover