| 12 Months | 1.0 | 2004 | 2004 | 2004 | 2004 | 2004 | 2004 | 2004 | 2004 | 2004 | 2004 | 2004 | 2004 | 2004 | ||||||
| to end Dec | 1.0 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Year | ||||||
| CASHFLOW PROJECTIONS | 1.0 | $000 | $000 | $000 | $000 | $000 | $000 | $000 | $000 | $000 | $000 | $000 | $000 | $000 | ||||||
| 1.0 | ||||||||||||||||||||
| CASH RECEIPTS | 1.0 | |||||||||||||||||||
| Cash sales & accounts receivable (Note 1) | 23.5 | 28.6 | 26.5 | 23.4 | 25.3 | 26.2 | 27.0 | 27.9 | 28.7 | 29.6 | 30.5 | 31.5 | 328.8 | |||||||
| Proceeds of new stock issues | 5.0 | 5.0 | ||||||||||||||||||
| Increases in longterm debt/notes | 10.0 | 10.0 | ||||||||||||||||||
| Proceeds from sale of fixed assets | 6.0 | 6.0 | ||||||||||||||||||
| Sales Tax recovered from State | 0.7 | 0.7 | 0.8 | 0.8 | 0.8 | 0.8 | 0.9 | 0.9 | 0.9 | 0.9 | 1.0 | 9.1 | ||||||||
| Capital grants/subsidies received | ||||||||||||||||||||
| Revenue grants/subsidies received | ||||||||||||||||||||
| Miscellaneous income received | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 12.0 | |||||||
| Interest received | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.1 | |||||||||||
| Total cash receipts | 1.0 | 24.5 | 35.3 | 44.3 | 25.2 | 27.1 | 28.0 | 28.8 | 29.7 | 30.6 | 31.5 | 32.5 | 33.4 | 371.0 | ||||||
| 1.0 | ||||||||||||||||||||
| CASH PAYMENTS | 1.0 | |||||||||||||||||||
| Materials/goods accounts payable (Note 2) | 17.2 | 14.7 | 14.5 | 13.9 | 11.8 | 12.2 | 12.6 | 13.0 | 13.4 | 13.8 | 14.3 | 14.7 | 166.2 | |||||||
| Total direct cost payments (Note 3) | 3.5 | 4.0 | 4.1 | 4.4 | 4.7 | 4.8 | 5.2 | 5.4 | 5.5 | 5.6 | 5.7 | 5.8 | 58.8 | |||||||
| Total overhead expense payments (Note 4) | 5.2 | 6.3 | 6.3 | 6.3 | 6.4 | 6.4 | 6.4 | 6.4 | 6.4 | 6.4 | 6.5 | 6.5 | 75.4 | |||||||
| Taxes paid | ||||||||||||||||||||
| Dividends paid | ||||||||||||||||||||
| Capital expenditure payments | 9.0 | 30.0 | 39.0 | |||||||||||||||||
| Operating lease payments | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 13.2 | |||||||
| Longterm debt/note repayments | 5.0 | 5.0 | 5.0 | 5.0 | 20.0 | |||||||||||||||
| Sales Tax paid on overheads, capex etc. | ||||||||||||||||||||
| Sales Tax paid to State | ||||||||||||||||||||
| Opening payroll taxes/benefits paid | 5.0 | 5.0 | ||||||||||||||||||
| Changes in prepaid expenses | (2.0) | (2.0) | ||||||||||||||||||
| Changes in accrued expenses | 4.0 | 4.0 | ||||||||||||||||||
| Interest paid | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.5 | 0.5 | 0.6 | 0.8 | 0.7 | 0.7 | 7.5 | |||||||
| Total cash payments | 1.0 | 35.6 | 30.7 | 35.7 | 31.4 | 24.6 | 25.1 | 30.8 | 26.5 | 57.1 | 32.8 | 28.3 | 28.8 | 387.2 | ||||||
| 1.0 | ||||||||||||||||||||
| Net cashflow | 1.0 | (11.1) | 4.7 | 8.6 | (6.2) | 2.5 | 2.9 | (1.9) | 3.3 | (26.5) | (1.2) | 4.2 | 4.6 | (16.1) | ||||||
| Opening | 1.0 | Opening | ||||||||||||||||||
| Closing net cash balance (deficit) | (22.0) | 1.0 | (22.0) | (33.1) | (28.5) | (19.8) | (26.1) | (23.5) | (20.6) | (22.6) | (19.3) | (45.8) | (47.0) | (42.8) | (38.1) | (38.1) | ||||
| Notes on Cashflow Projections | 1.0 | |||||||||||||||||||
| 1.0 | ||||||||||||||||||||
| Note 1 | 1.0 | |||||||||||||||||||
| Cash sales & accounts receivable | 3.5 | 18.6 | 21.5 | 23.4 | 25.3 | 26.2 | 27.0 | 27.9 | 28.7 | 29.6 | 30.5 | 31.5 | 293.8 | |||||||
| Opening accounts receivable | 20.0 | 10.0 | 5.0 | 35.0 | ||||||||||||||||
| 1.0 | 23.5 | 28.6 | 26.5 | 23.4 | 25.3 | 26.2 | 27.0 | 27.9 | 28.7 | 29.6 | 30.5 | 31.5 | 328.8 | |||||||
| Note 2 | 1.0 | |||||||||||||||||||
| Materials/goods accounts payable | 2.2 | 7.7 | 9.5 | 10.9 | 11.8 | 12.2 | 12.6 | 13.0 | 13.4 | 13.8 | 14.3 | 14.7 | 136.2 | |||||||
| Opening accounts payable | 15.0 | 7.0 | 5.0 | 3.0 | 30.0 | |||||||||||||||
| 1.0 | 17.2 | 14.7 | 14.5 | 13.9 | 11.8 | 12.2 | 12.6 | 13.0 | 13.4 | 13.8 | 14.3 | 14.7 | 166.2 | |||||||
| Note 3 | 1.0 | |||||||||||||||||||
| Direct cost payments: | 1.0 | |||||||||||||||||||
| -Wages and salaries (direct) | 0.5 | 0.5 | 0.5 | 0.8 | 0.8 | 0.8 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 10.1 | |||||||
| -Payroll taxes/benefits (direct) | 0.3 | 0.3 | 0.3 | 0.5 | 0.5 | 0.5 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 6.1 | |||||||
| -Energy (variable) | 1.0 | 1.1 | 1.2 | 1.3 | 1.4 | 1.5 | 1.6 | 1.7 | 1.8 | 1.9 | 2.0 | 2.1 | 18.6 | 18.6 | ||||||
| -Repairs/maintenance (variable) | 2.0 | 2.0 | 2.0 | 2.0 | 2.0 | 2.0 | 2.0 | 2.0 | 2.0 | 2.0 | 2.0 | 2.0 | 24.0 | 24.0 | ||||||
| -Subcontract | ||||||||||||||||||||
| -Consumables | ||||||||||||||||||||
| 1.0 | 3.5 | 4.0 | 4.1 | 4.4 | 4.7 | 4.8 | 5.2 | 5.4 | 5.5 | 5.6 | 5.7 | 5.8 | 58.8 | |||||||
| Note 4 | 1.0 | |||||||||||||||||||
| Overhead expense payments: | 1.0 | |||||||||||||||||||
| -Wages and salaries (overheads) | 1.7 | 1.7 | 1.7 | 1.7 | 1.7 | 1.7 | 1.7 | 1.7 | 1.7 | 1.7 | 1.7 | 1.7 | 19.8 | |||||||
| -Payroll taxes/benefits (overheads) | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 12.1 | |||||||
| -Freight expenses | 0.4 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 6.3 | |||||||
| -Advertising & brochures | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 6.0 | |||||||
| -Special promotion | ||||||||||||||||||||
| -Miscellaneous selling/dist | ||||||||||||||||||||
| -Office supplies etc. | 0.3 | 0.3 | 0.3 | 0.3 | 0.3 | 0.3 | 0.3 | 0.3 | 0.3 | 0.3 | 0.3 | 0.3 | 3.0 | |||||||
| -Mail, telephone, telex & fax | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 6.0 | |||||||
| -Travel | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 12.0 | |||||||
| -Computer supplies etc. | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 1.2 | |||||||
| -Utilities | ||||||||||||||||||||
| -Rent & property taxes | ||||||||||||||||||||
| -Insurances | ||||||||||||||||||||
| -Other establishment | ||||||||||||||||||||
| -Other administration | 0.8 | 0.8 | 0.8 | 0.8 | 0.8 | 0.8 | 0.8 | 0.8 | 0.8 | 0.8 | 0.8 | 0.8 | 9.0 | |||||||
| 1.0 | 5.2 | 6.3 | 6.3 | 6.3 | 6.4 | 6.4 | 6.4 | 6.4 | 6.4 | 6.4 | 6.5 | 6.5 | 75.4 | |||||||
| 1.0 | ||||||||||||||||||||