| 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) | 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 disposals of fixed assets | 6.0 | 6.0 | ||||||||||||||||||
| Sales Tax recovered from State | ||||||||||||||||||||
| 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 | 34.6 | 43.6 | 24.4 | 26.3 | 27.2 | 28.0 | 28.9 | 29.7 | 30.6 | 31.6 | 32.5 | 361.9 | ||||||
| 1.0 | ||||||||||||||||||||
| Cash payments | 1.0 | |||||||||||||||||||
| Materials/goods accounts payable (Note 2) | 16.8 | 13.4 | 12.9 | 12.1 | 9.9 | 10.2 | 10.5 | 10.8 | 11.2 | 11.5 | 11.9 | 12.3 | 143.5 | |||||||
| 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 | ||||||||||||||||||||
| Total capital expend. payments (Note 5) | 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 o/h expense, capex etc. inputs | ||||||||||||||||||||
| Sales Tax paid to State | 4.0 | 1.1 | 1.1 | 1.2 | 1.2 | 1.3 | 1.3 | 1.3 | 1.4 | 1.4 | 1.5 | 1.5 | 18.3 | |||||||
| 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.7 | 0.7 | 0.6 | 0.7 | 0.6 | 0.6 | 0.6 | 0.7 | 0.8 | 0.8 | 0.7 | 8.1 | |||||||
| Total cash payments | 1.0 | 39.2 | 30.5 | 35.2 | 30.8 | 23.9 | 24.3 | 30.0 | 25.7 | 56.3 | 31.9 | 27.4 | 27.9 | 383.3 | ||||||
| 1.0 | ||||||||||||||||||||
| Net cashflow | 1.0 | (14.8) | 4.1 | 8.3 | (6.4) | 2.5 | 2.8 | (2.0) | 3.2 | (26.6) | (1.3) | 4.1 | 4.6 | (21.5) | ||||||
| Opening | 1.0 | Opening | ||||||||||||||||||
| Closing net cash balance (deficit) | (22.0) | 1.0 | (22.0) | (36.8) | (32.7) | (24.4) | (30.8) | (28.3) | (25.5) | (27.5) | (24.3) | (50.9) | (52.2) | (48.0) | (43.5) | (43.5) | ||||
| Notes on Cashflow Projections | 1.0 | |||||||||||||||||||
| 1.0 | ||||||||||||||||||||
| Note 1 | 1.0 | |||||||||||||||||||
| Cash sales & accounts receivable: | 1.0 | |||||||||||||||||||
| - Current | 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 | 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: | 1.0 | |||||||||||||||||||
| - Current | 1.8 | 6.4 | 7.9 | 9.1 | 9.9 | 10.2 | 10.5 | 10.8 | 11.2 | 11.5 | 11.9 | 12.3 | 113.5 | |||||||
| - Opening | 15.0 | 7.0 | 5.0 | 3.0 | 30.0 | |||||||||||||||
| 1.0 | 16.8 | 13.4 | 12.9 | 12.1 | 9.9 | 10.2 | 10.5 | 10.8 | 11.2 | 11.5 | 11.9 | 12.3 | 143.5 | |||||||
| 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 | |||||||
| -Utilities (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 | |||||||
| -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 | |||||||
| -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 (expenses) | 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 (expenses) | 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 | |||||||
| -Variable selling | 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 | |||||||
| -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. | ||||||||||||||||||||
| -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 | ||||||||||||||||||||
| -Miscellaneous expenses | ||||||||||||||||||||
| 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 | |||||||
| Note 5 | 1.0 | |||||||||||||||||||
| Capital expenditure payments | 30.0 | 30.0 | ||||||||||||||||||
| Opening capital expend creditor payments | 9.0 | 9.0 | ||||||||||||||||||
| 1.0 | 9.0 | 30.0 | 39.0 | |||||||||||||||||
| 1.0 | ||||||||||||||||||||