Spreadsheet format
UNFINISHED

If you have a computer with a spreadsheet application, this is how to set out your accounts. To predict all the figures with a reasonable degree of accuracy, requires a lot of frustrating research, but this essential for minimizing risk, and for approaching a bank manager for a loan.


Table 1 - Profit & Loss Projections (Year 1)


INCOME

Total sales from Sales Mix
Other income



......
......
  
Total income...... 

EXPENDITURE

Accounting fees
Advertising
Cartage
Electricity / gas
Employees wages
Insurances
Legal expenses
Motor vehicle costs
Rent / lease of property
Repairs and maintenance
Stationery / office supply
Printing / postage
Telephone
Leasing / hire purchase payments
Bank interest and charges
Sales tax payments and commissions
Costs from Sales Mix
Bulk purchases
Other expenses (specify)




Depreciation



......
......
......
......
......
......
......
......
......
......
......
......
......
......
......
......
......
......

......
......
......
......
......
  
Total expenses...... 
 Net Profit......
COVERAGE

Estimated tax liability__%
Loan repayments
Owners drawings &/or dividends
Purchase of plant and equipment


......
......
......
......
Total coverage......
PROFIT RESERVES......




Table 2 - Profit & Loss Projections (Year 2)


INCOME

Total sales from Sales Mix
Other income



......
......
  
Total income...... 

EXPENDITURE

Accounting fees
Advertising
Cartage
Electricity / gas
Employees wages
Insurances
Legal expenses
Motor vehicle costs
Rent / lease of property
Repairs and maintenance
Stationery / office supply
Printing / postage
Telephone
Leasing / hire purchase payments
Bank interest and charges
Sales tax payments and commissions
Costs from Sales Mix
Bulk purchases
Other expenses (specify)




Depreciation



......
......
......
......
......
......
......
......
......
......
......
......
......
......
......
......
......
......

......
......
......
......
......
  
Total expenses...... 
 Net Profit......
COVERAGE

Estimated tax liability__%
Loan repayments
Owners drawings &/or dividends
Purchase of plant and equipment


......
......
......
......
Total coverage......
PROFIT RESERVES......