Currently viewing: 6. Additional risk disclosures / Next: 7. Summarised segmental analysis

6. Additional risk disclosures
as at 28 February 2023

There have been no material changes to the Group's concentration of credit risk or the maturity analysis of its financial liabilities since the year end.

There is one customer in Latin America, with a gross value of US$75.7 million, which represents approximately 5% of the total balance of trade receivables (FY22: US$64.4 million (over 5%)).

Collections from customers during FY23 have remained in line with historic norms. Management has concluded that the likelihood of material expected credit losses is low.

The following table details the credit risk profile of trade receivables based on the Group's provision matrix.

Days past due

      Audited
Year ended  February 2023 
US$'000     North 
America 
Latin 
America 
Europe  Asia- 
Pacific 
MEA  Total 
Datatec Group Total                      
Current     60 749  125 311  746 423  229 392  99 622  1 261 497 
1-30 days past due     14 917  12 887  50 427  35 400  20 228  133 859 
31-60 days past due     3 324  10 622  17 716  15 254  5 814  52 730 
61-90 days past due     2 224  1 737  11 184  4 681  3 903  23 729 
91-120 days past due     937  1 342  2 857  2 157  2 988  10 281 
Over 120 days past due     3 322  9 066  15 436  5 571  20 721  54 116 
Gross trade receivables     85 473  160 965  844 043  292 455  153 276  1 536 212 
Expected credit loss allowance     –  (619) (7 902) (3 392) (15 829) (27 742)
Net trade receivables     85 473  160 346  836 141  289 063  137 447  1 508 470 
Westcon International                      
Current     –  –  626 226  178 756  97 025  902 007 
1 – 30 days past due     –  –  29 617  20 132  19 372  69 121 
31 – 60 days past due     –  –  16 038  11 325  5 617  32 980 
61 – 90 days past due     –  –  10 695  2 752  3 835  17 282 
91 – 120 days past due     –  –  1 909  1 962  2 973  6 844 
Over 120 days past due     –  –  15 333  1 792  20 673  37 798 
Gross trade receivables     –  –  699 818  216 719  149 495  1 066 032 
Expected credit loss allowance     –  –  (7 269) (1 056) (15 802) (24 127)
Net trade receivables     –  –  692 549  215 663  133 693  1 041 905 
      Audited
Year ended 28 February 2023 
US$'000     North 
America 
Latin 
America 
Europe  Asia- 
Pacific 
MEA  Total 
Logicalis International                      
Current     60 749  –  120 197  50 636  2 597  234 179 
1 – 30 days past due     14 917  –  20 810  15 268  856  51 851 
31 – 60 days past due     3 324  –  1 678  3 929  197  9 128 
61 – 90 days past due     2 224  –  489  1 929  68  4 710 
91 – 120 days past due     937  –  948  195  15  2 095 
Over 120 days past due     3 322  –  103  3 779  48  7 252 
Gross trade receivables     85 473  –  144 225  75 736  3 781  309 215 
Expected credit loss allowance     –  –  (633) (2 336) (27) (2 996)
Net trade receivables     85 473  –  143 592  73 400  3 754  306 219 
Logicalis Latin America                      
Current     –  125 311  –  –  –  125 311 
1 – 30 days past due     –  12 887  –  –  –  12 887 
31 – 60 days past due     –  10 622  –  –  –  10 622 
61 – 90 days past due     –  1 737  –  –  –  1 737 
91 – 120 days past due     –  1 342  –  –  –  1 342 
Over 120 days past due     –  9 066  –  –  –  9 066 
Gross trade receivables     –  160 965  –  –  –  160 965 
Expected credit loss allowance     –  (619) –  –  –  (619)
Net trade receivables     –  160 346  –  –  –  160 346 
Corporate and Management Consulting                      
Current     –  –  –  –  –  – 
1 – 30 days past due     –  –  –  –  –  – 
31 – 60 days past due     –  –  –  –  –  – 
61 – 90 days past due     –  –  –  –  –  – 
91 – 120 days past due     –  –  –  –  –  – 
Over 120 days past due     –  –  –  –  –  – 
Gross trade receivables     –  –  –  –  –  – 
Expected credit loss allowance     –  –  –  –  –  – 
Net trade receivables     –  –  –  –  –  – 

The past due receivables ageing categories above are shown gross, before taking into account expected credit loss allowances. US$27.1 million (FY22: US$ 26.2 million) expected credit losses have been allocated to the US$64.4 million (FY22: US$43.8 million) over 90 days past due receivables, resulting in a net over 90 days past due receivables balance of US$37.3 million (FY22: US$17.6 million). Where there are no expected credit loss allowances, the balances are deemed to be recoverable and there are either payment plans in place with the relevant customers or discussions with the customers are ongoing to resolve the payment of the outstanding balances.

      Audited
Year ended  February 2022 
US$'000     North 
America 
Latin 
America 
Europe  Asia- 
Pacific 
MEA  Total 
Datatec Group Total                      
Current     72 233  115 848  599 579  173 409  108 068  1 069 137 
1 – 30 days past due     14 594  9 737  42 915  18 664  10 053  95 963 
31 – 60 days past due     7 104  8 779  9 795  5 601  1 181  32 460 
61 – 90 days past due     1 608  1 379  4 639  416  1 212  9 254 
91 – 120 days past due     1 699  867  1 379  1 464  (566) 4 843 
Over 120 days past due     5 323  2 819  8 120  5 680  16 985  38 927 
Gross trade receivables     102 561  139 429  666 427  205 234  136 933  1 250 584 
Expected credit loss allowance     (185) (629) (7 428) (3 281) (15 237) (26 760)
Net trade receivables     102 376  138 800  658 999  201 953  121 696  1 223 824 
Westcon International                      
Current     –  –  492 045  136 335  103 469  731 849 
1 – 30 days past due     –  –  29 049  11 485  8 751  49 285 
31 – 60 days past due     –  –  6 891  3 373  854  11 118 
61 – 90 days past due     –  –  2 484  (460) 461  2 485 
91 – 120 days past due     –  –  1 322  698  (603) 1 417 
Over 120 days past due     –  –  7 823  941  16 236  25 000 
Gross trade receivables     –  –  539 614  152 372  129 168  821 154 
Expected credit loss allowance     –  –  (6 836) (883) (14 883) (22 602)
Net trade receivables     –  –  532 778  151 489  114 285  798 552 
Logicalis International – Re-presented#                      
Current     70 716  –  96 996  36 142  2 556  206 410 
1 – 30 days past due     14 336  –  13 143  7 043  764  35 286 
31 – 60 days past due     7 064  –  2 463  2 021  173  11 721 
61 – 90 days past due     1 608  –  1 112  798  12  3 530 
91 – 120 days past due     1 699  –  45  763  30  2 537 
Over 120 days past due     5 292  –  279  4 739  34  10 344 
Gross trade receivables     100 715  –  114 038  51 506  3 569  269 828 
Expected credit loss allowance     (154) –  (592) (2 398) (41) (3 185)
Net trade receivables     100 561  –  113 446  49 108  3 528  266 643 
    Audited
Year ended  February 2022
US$'000   North
America
Latin
America
Europe Asia-
Pacific
MEA Total
Logicalis Latin America – Re-presented#              
Current   – 115 807 – – – 115 807
1 – 30 days past due   – 9 687 – – – 9 687
31 – 60 days past due   – 8 779 – – – 8 779
61 – 90 days past due   – 1 298 – – – 1 298
91 – 120 days past due   – 867 – – – 867
Over 120 days past due   – 2 819 – – – 2 819
Gross trade receivables   – 139 257 – – – 139 257
Expected credit loss allowance   – (629) – – – (629)
Net trade receivables   – 138 628 – – – 138 628
Corporate and Management Consulting              
Current   1 517 41 10 538 932 2 043 15 071
1 – 30 days past due   258 50 723 136 538 1 705
31 – 60 days past due   40 – 441 207 154 842
61 – 90 days past due   – 81 1 043 78 739 1 941
91 – 120 days past due   – – 12 3 7 22
Over 120 days past due   31 – 18 – 715 764
Gross trade receivables   1 846 172 12 775 1 356 4 196 20 345
Expected credit loss allowance   (31) – – – (313) (344)
Net trade receivables   1 815 172 12 775 1 356 3 883 20 001
Negative amounts represent credits on accounts that have not yet been applied/cleared due to timing of customer approvals, as well as payments received in advance.
# The Logicalis segment previously reported in the prior period is now being reported as two management segments, Logicalis Latin America and Logicalis International (representing the Logicalis business outside of Latin America). The ultimate Logicalis holding company, Logicalis Group Limited, and its associated costs, is now included in the “Corporate and Management Consulting” segment. Comparative results have been re-presented.

The Group is dependent on its bank overdrafts and trade finance facilities to operate. These facilities generally consist of either a fixed term or fixed period and may be repayable on demand and are secured against the assets of the company to which the facility is made available. These facilities contain certain covenants including financial covenants such as minimum liquidity, maximum leverage and pre-tax earnings coverage. In certain circumstances, if these covenants are violated and a waiver is not obtained for such violation, this may, amongst other things, mean that the facility may be repayable on demand.

Logicalis International is supported by a corporate facility of US$135.0 million, covering all its operations, comprising an acquisition facility and a rolling credit facility to fund working capital requirements. Logicalis Inc., a subsidiary operating in the United States, has a receivables purchase agreement. This agreement qualifies as a transfer of risks and rewards to the buyer and therefore permits the company to derecognise the relating accounts receivable. There is a finance cost to this company, which is based on the individual customer's credit score and credit term of the customer invoices selected for sale. There is an agreed list of customers, each with an individual credit limit which, when combined, totals US$200.0 million. As at 28 February 2023, US$10.5 million has been utilised.

Logicalis Latin America is supported separately via a number of uncommitted overdraft facilities and short-term lending arrangements and is predominantly sourced via Tier 1 banks in Brazil as it is the largest territory in the region.

Westcon International has an invoice assignment facility of EUR390.6 million for its European subsidiaries, as well as an extended payables facility of US$105.0 million. Westcon International has a securitisation facility of US$120.0 million for its Asia-Pacific facilities. In addition, Westcon International utilises accounts receivable facilities in the Middle East (US$15.0 million) and Indonesia (US$11.0 million) as well as overdraft facilities in Europe (EUR4.0 million) and Africa (US$1.0 million), and a securitisation facility in South Africa (ZAR250.0 million) to finance the business.

The Group continues to monitor the funding needs of its individual operations and works closely with various financial institutions to ensure adequate liquidity.

The Group has performed covenant projections for the next 12 months to confirm that banking covenants are expected to be met.