| 12 Months | 1.0 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2006 | 05-06 | ||||||
| to end Jan | 1.0 | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | 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) | 32.9 | 52.4 | 49.6 | 39.5 | 44.1 | 43.3 | 48.5 | 47.2 | 49.9 | 54.3 | 55.7 | 55.2 | 572.7 | |||||||
| Proceeds of new stock issues | 5.0 | 5.0 | ||||||||||||||||||
| Increases in longterm debt/notes | 10.0 | 50.0 | 50.0 | 110.0 | ||||||||||||||||
| Proceeds from disposals of fixed assets | 10.0 | 10.0 | ||||||||||||||||||
| Sales Tax recovered from State | ||||||||||||||||||||
| Miscellaneous income received | 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 | |||||||
| Interest received | 0.0 | 0.0 | 0.0 | 0.1 | 0.1 | 0.1 | 0.3 | |||||||||||||
| Total cash receipts | 1.0 | 34.9 | 59.4 | 61.6 | 41.5 | 46.1 | 45.3 | 50.5 | 49.2 | 102.0 | 106.4 | 57.7 | 67.3 | 722.0 | ||||||
| 1.0 | ||||||||||||||||||||
| Cash payments | 1.0 | |||||||||||||||||||
| Materials/goods accounts payable (Note 2) | 18.0 | 20.9 | 18.9 | 15.1 | 16.5 | 16.6 | 18.0 | 17.9 | 18.9 | 20.3 | 20.8 | 21.1 | 222.7 | |||||||
| Total direct cost payments (Note 3) | 8.0 | 8.8 | 8.9 | 10.0 | 10.7 | 12.1 | 12.2 | 12.8 | 13.3 | 14.4 | 14.5 | 14.6 | 140.3 | |||||||
| Total overhead expense payments (Note 4) | 9.8 | 12.3 | 12.2 | 12.3 | 12.2 | 12.4 | 12.3 | 12.4 | 12.5 | 12.5 | 12.5 | 12.6 | 146.3 | |||||||
| Taxes paid | ||||||||||||||||||||
| Dividends paid | ||||||||||||||||||||
| Lease repayments | 2.0 | 2.0 | 2.0 | 2.0 | 3.3 | 2.0 | 2.0 | 3.3 | 2.0 | 1.3 | 21.9 | |||||||||
| Lease interest expense | 1.0 | 1.0 | 1.0 | 1.0 | 2.0 | 1.0 | 1.0 | 2.0 | 1.0 | 1.0 | 12.0 | |||||||||
| Total capital expend. payments (Note 5) | 10.0 | 9.0 | 30.0 | 49.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 o/h expense, capex etc. inputs | ||||||||||||||||||||
| Sales Tax paid to State | 4.0 | 2.3 | 2.6 | 2.3 | 2.6 | 2.3 | 2.9 | 2.6 | 2.9 | 3.2 | 3.3 | 3.1 | 33.9 | |||||||
| 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.7 | 0.7 | 0.8 | 0.8 | 0.9 | 0.9 | 0.9 | 0.9 | 1.2 | 1.5 | 1.4 | 1.4 | 12.0 | |||||||
| Total cash payments | 1.0 | 52.6 | 63.1 | 56.5 | 49.7 | 49.2 | 48.4 | 55.4 | 53.0 | 82.9 | 58.0 | 55.8 | 53.8 | 678.3 | ||||||
| 1.0 | ||||||||||||||||||||
| Net cashflow | 1.0 | (17.7) | (3.7) | 5.1 | (8.1) | (3.1) | (3.1) | (4.9) | (3.8) | 19.1 | 48.4 | 2.0 | 13.5 | 43.7 | ||||||
| Opening | 1.0 | Opening | ||||||||||||||||||
| Closing net cash balance (deficit) | (13.0) | 1.0 | (13.0) | (30.7) | (34.4) | (29.3) | (37.4) | (40.6) | (43.6) | (48.5) | (52.3) | (33.2) | 15.2 | 17.2 | 30.7 | 30.7 | ||||
| Notes on Cashflow Projections | 1.0 | |||||||||||||||||||
| 1.0 | ||||||||||||||||||||
| Note 1 | 1.0 | |||||||||||||||||||
| Cash sales & accounts receivable: | 1.0 | |||||||||||||||||||
| - Group1 | 3.2 | 17.4 | 20.5 | 20.3 | 23.0 | 20.7 | 25.5 | 23.5 | 26.4 | 29.3 | 30.0 | 29.5 | 269.4 | |||||||
| - Group2 | 2.7 | 14.9 | 19.1 | 19.2 | 21.1 | 22.7 | 23.0 | 23.7 | 23.5 | 25.0 | 25.7 | 25.7 | 246.3 | |||||||
| Opening accounts receivable | 27.0 | 20.0 | 10.0 | 57.0 | ||||||||||||||||
| 1.0 | 32.9 | 52.4 | 49.6 | 39.5 | 44.1 | 43.3 | 48.5 | 47.2 | 49.9 | 54.3 | 55.7 | 55.2 | 572.7 | |||||||
| Note 2 | 1.0 | |||||||||||||||||||
| Materials/goods accounts payable: | 1.0 | |||||||||||||||||||
| - Group1 | 1.6 | 5.9 | 7.3 | 8.0 | 8.6 | 8.3 | 9.4 | 9.1 | 10.1 | 11.0 | 11.3 | 11.4 | 102.2 | |||||||
| - Group2 | 1.3 | 5.0 | 6.6 | 7.2 | 7.9 | 8.3 | 8.5 | 8.7 | 8.8 | 9.2 | 9.5 | 9.6 | 90.6 | |||||||
| Opening accounts payable | 15.0 | 10.0 | 5.0 | 30.0 | ||||||||||||||||
| 1.0 | 18.0 | 20.9 | 18.9 | 15.1 | 16.5 | 16.6 | 18.0 | 17.9 | 18.9 | 20.3 | 20.8 | 21.1 | 222.7 | |||||||
| Note 3 | 1.0 | |||||||||||||||||||
| Direct cost payments: | 1.0 | |||||||||||||||||||
| -Wages and salaries (direct) | 1.0 | 1.0 | 1.0 | 1.0 | 1.6 | 1.6 | 1.6 | 2.1 | 2.1 | 2.1 | 2.1 | 2.1 | 19.2 | |||||||
| -Payroll taxes/benefits (direct) | 0.7 | 0.7 | 0.7 | 0.7 | 1.0 | 1.0 | 1.0 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 11.4 | |||||||
| -Utilities (variable) | 2.5 | 2.5 | 2.5 | 3.0 | 3.0 | 3.5 | 3.5 | 3.5 | 3.5 | 4.0 | 4.0 | 4.0 | 39.5 | |||||||
| -Repairs/maintenance (variable) | 3.0 | 3.0 | 3.0 | 3.5 | 3.5 | 4.0 | 4.0 | 4.0 | 4.0 | 4.5 | 4.5 | 4.5 | 45.5 | |||||||
| -Subcontract | ||||||||||||||||||||
| -Consumables | 1.5 | 1.6 | 1.7 | 1.8 | 1.9 | 2.0 | 2.1 | 2.2 | 2.3 | 2.4 | 2.5 | 2.6 | 24.6 | |||||||
| 1.0 | 8.0 | 8.8 | 8.9 | 10.0 | 10.7 | 12.1 | 12.2 | 12.8 | 13.3 | 14.4 | 14.5 | 14.6 | 140.3 | |||||||
| Note 4 | 1.0 | |||||||||||||||||||
| Overhead expense payments: | 1.0 | |||||||||||||||||||
| -Repairs/maintenance (fixed) | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 5.4 | |||||||
| -Utilities (fixed) | ||||||||||||||||||||
| -Miscellaneous indirect expenses | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 | 10.8 | |||||||
| -Wages and salaries (expenses) | 3.6 | 3.6 | 3.6 | 3.6 | 3.6 | 3.6 | 3.6 | 3.6 | 3.6 | 3.6 | 3.6 | 3.6 | 43.3 | |||||||
| -Payroll taxes/benefits (expenses) | 2.4 | 2.4 | 2.4 | 2.4 | 2.4 | 2.4 | 2.4 | 2.4 | 2.4 | 2.4 | 2.4 | 2.4 | 26.5 | |||||||
| -Freight | 0.7 | 0.9 | 0.8 | 0.9 | 0.8 | 1.0 | 0.9 | 0.9 | 1.0 | 1.1 | 1.0 | 1.1 | 11.1 | |||||||
| -Advertising & brochures | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 18.0 | |||||||
| -Travel expenses | ||||||||||||||||||||
| -Public relations, exhibitions | ||||||||||||||||||||
| -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. | ||||||||||||||||||||
| -Vehicle expenses | ||||||||||||||||||||
| -Utilities | 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 | |||||||
| -Rent & property taxes | 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 | |||||||
| -Professional fees & audit | ||||||||||||||||||||
| -Other establish expenses | ||||||||||||||||||||
| 1.0 | 9.8 | 12.3 | 12.2 | 12.3 | 12.2 | 12.4 | 12.3 | 12.4 | 12.5 | 12.5 | 12.5 | 12.6 | 146.3 | |||||||
| Note 5 | 1.0 | |||||||||||||||||||
| Capital expenditure payments: | 1.0 | |||||||||||||||||||
| -Land, buildings & improvements | 30.0 | 30.0 | ||||||||||||||||||
| -Plant, equipment & vehicles | 10.0 | 10.0 | ||||||||||||||||||
| Opening capex creditor payments | 9.0 | 9.0 | ||||||||||||||||||
| 1.0 | 10.0 | 9.0 | 30.0 | 49.0 | ||||||||||||||||
| 1.0 | ||||||||||||||||||||