Ratio Analysis for 2002 to 2004 in excel

Fiscal Year Ended February 28 Assumptions Forecast 0.13 0.4 0.52 2002-2004 1999 303.7 127.7 176.0 2000 330.1 130.9 199.2 2001 374.1 149.0 225.1 Growth 39.89 % sales 2002 422.7 169.1 253.6 13.096 40.096 Sales Growth COGS 2004 Operating Expense 539.8 215.9 323.9 2003 477.7 191.1 286.6 42.0% 39.7% 49.9% 1.5% 5.5% 166.2 0.0 151.4 4.5 16.6 0.1 50.3% 0.0% 0.8% 195.7 11.2 52.3% % sales 3.0%% sales 0.3% % sales % of Debt, EFN and Excess Cash 52.0% 0.0% 0.0% 6.0% 219.8 0.0 0.0 4.4 29.4 248.4 0.0 0.0 5.3 33.0 9.9 23.1 10.9 % of PBT 280.7 0.0 0.0 6.2 37.0 11.1 25.9 10.9 15.0 1.5 28.8 10.4 18.4 10.9 7.5 30.0% 4.4 12.8 3.5 9.3 10.9 (1.6) 8.0 (4.6) 10.9 (15.5) Constant 10.9 20.6 10.9 9.7 34.0 11.2% 19.2 5.8% 13.1 4.096 3.79% sales Plug 16.9 0.0 19.1 0.0 21.6 0.0 Income Statement Turnover Cost of sales Gross profit Operating expenses -excluding exceptional costs -exceptional costs Restructuring costs Net interest expense Profit before tax (PBT) Tax expense Profit(los) after tax Ordinary dividends Profit(loss) retained Balance Sheet |cash Excess Cash (Plus) Excess Cash from Previous Years Accounts receivable Inventories Other current assets Net fixed assets Other assets Total assets Accounts payable Taxes payable Accruals Overdrafts Other current liabilities Long-term liabilities EFN (Plug) Other liabilities Shareholders' equity Total liabs & equity 8.0% 13.7% 30.3 51.3 17.3 110.6 30.09 1.8% 27.8 33.6 12.5 87.8 0.0 200.7 13.0 11.3 10.8 0.0 21.6 28.0 9.2% 12.7% 4.1% 28.9% 0.0% 66.10 4.3% 3.7% 3.6% 0.0% 7.1% 303 44.7 13.6 104.7 6.0 220.5 20.3 11.7 15.6 0.3 13.3 36.7 9.29 13.5% 4.7% 31.7% 1.8% 66.896 6.29 3.5% 4.7% 0.1% 4.0% 230.1 10.7 7.1 11.5 8.19 % sales 13.796% sales 4.79% sales 29.6%% sales 1.89% sales 61.5 2.99 % sales 1.9% % sales 3.196% sales 0.2% sales 4.5% % sales Fixed Plug 0.1% % sales 4.0% 2.09 3.5% 0.296 4.0% 0.7 33.8 $7.9 19.9 126.8 7.6 262.9 16.9 8.5 14.8 0.8 16.9 61.2 12.1 0.4 131.3 262.9 262.9 250.8 12.1 38.2 65.4 22.3 143.3 3.6 297.1 19.1 9.6 16.7 1.0 19.1 73.3 14.4 0.5 143.5 297.1 297.1 282.7 14.4 74.0 23.4 161.9 9.7 335.7 21.6 10.8 18.9 1.1 21.6 87.7 15.0 0.5 158.5 335.7 335.7 320.7 15.0 16.9 61.2 0.6% 0.3% 0.1% 1.7 114.3 200.7 1.0 121.4 220.5 0.4 121.6 230.1 Trial assets Trial liabs & equity Trial plug Fiscal Year Ended February 28 Assumptions Forecast 0.13 0.4 0.52 2002-2004 1999 303.7 127.7 176.0 2000 330.1 130.9 199.2 2001 374.1 149.0 225.1 Growth 39.89 % sales 2002 422.7 169.1 253.6 13.096 40.096 Sales Growth COGS 2004 Operating Expense 539.8 215.9 323.9 2003 477.7 191.1 286.6 42.0% 39.7% 49.9% 1.5% 5.5% 166.2 0.0 151.4 4.5 16.6 0.1 50.3% 0.0% 0.8% 195.7 11.2 52.3% % sales 3.0%% sales 0.3% % sales % of Debt, EFN and Excess Cash 52.0% 0.0% 0.0% 6.0% 219.8 0.0 0.0 4.4 29.4 248.4 0.0 0.0 5.3 33.0 9.9 23.1 10.9 % of PBT 280.7 0.0 0.0 6.2 37.0 11.1 25.9 10.9 15.0 1.5 28.8 10.4 18.4 10.9 7.5 30.0% 4.4 12.8 3.5 9.3 10.9 (1.6) 8.0 (4.6) 10.9 (15.5) Constant 10.9 20.6 10.9 9.7 34.0 11.2% 19.2 5.8% 13.1 4.096 3.79% sales Plug 16.9 0.0 19.1 0.0 21.6 0.0 Income Statement Turnover Cost of sales Gross profit Operating expenses -excluding exceptional costs -exceptional costs Restructuring costs Net interest expense Profit before tax (PBT) Tax expense Profit(los) after tax Ordinary dividends Profit(loss) retained Balance Sheet |cash Excess Cash (Plus) Excess Cash from Previous Years Accounts receivable Inventories Other current assets Net fixed assets Other assets Total assets Accounts payable Taxes payable Accruals Overdrafts Other current liabilities Long-term liabilities EFN (Plug) Other liabilities Shareholders' equity Total liabs & equity 8.0% 13.7% 30.3 51.3 17.3 110.6 30.09 1.8% 27.8 33.6 12.5 87.8 0.0 200.7 13.0 11.3 10.8 0.0 21.6 28.0 9.2% 12.7% 4.1% 28.9% 0.0% 66.10 4.3% 3.7% 3.6% 0.0% 7.1% 303 44.7 13.6 104.7 6.0 220.5 20.3 11.7 15.6 0.3 13.3 36.7 9.29 13.5% 4.7% 31.7% 1.8% 66.896 6.29 3.5% 4.7% 0.1% 4.0% 230.1 10.7 7.1 11.5 8.19 % sales 13.796% sales 4.79% sales 29.6%% sales 1.89% sales 61.5 2.99 % sales 1.9% % sales 3.196% sales 0.2% sales 4.5% % sales Fixed Plug 0.1% % sales 4.0% 2.09 3.5% 0.296 4.0% 0.7 33.8 $7.9 19.9 126.8 7.6 262.9 16.9 8.5 14.8 0.8 16.9 61.2 12.1 0.4 131.3 262.9 262.9 250.8 12.1 38.2 65.4 22.3 143.3 3.6 297.1 19.1 9.6 16.7 1.0 19.1 73.3 14.4 0.5 143.5 297.1 297.1 282.7 14.4 74.0 23.4 161.9 9.7 335.7 21.6 10.8 18.9 1.1 21.6 87.7 15.0 0.5 158.5 335.7 335.7 320.7 15.0 16.9 61.2 0.6% 0.3% 0.1% 1.7 114.3 200.7 1.0 121.4 220.5 0.4 121.6 230.1 Trial assets Trial liabs & equity Trial plug