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