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

6. Additional risk disclosures

as at 31 August 2021

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.

As at 31 August 2021, there is one customer in Latin America, with a gross value of US$71.5 million which represents more than 5% of the total balance of trade receivables
(H1 FY21: no customers; FY21: one customer with a gross value of US$56.4 million).

Covid-19 has had a minimal impact on trade receivables. Collections from customers during H1 FY22 have remained in line with historic norms. As intermediaries in the supply chain, both Logicalis and Westcon International are working with vendors to provide support to their supply chains during the pandemic. 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

   Unaudited
Six months to 31 August 2021 
US$'000  North 
America 
Latin 
America 
Europe  Asia- 
Pacific 
MEA  Total 
DATATEC GROUP TOTAL 
Current  53 126  137 515  495 063  170 379  69 673  925 756 
1 – 30 days past due  13 477  6 195  53 496  24 385  13 019  110 572 
31 – 60 days past due  4 026  4 361  9 951  6 366  9 439  34 143 
61 – 90 days past due  4 486  664  6 505  4 122  3 416  19 193 
91 – 120 days past due  992  613  5 671  1 805  3 132  12 213 
Over 120 days past due  2 267  3 217  11 626  7 773  25 464  50 347 
Gross trade receivables  78 374  152 565  582 312  214 830  124 143  1 152 224 
Expected credit loss allowance  (69) (514) (8 704) (3 613) (13 836) (26 736)
Net trade receivables  78 305  152 051  573 608  211 217  110 307  1 125 488 
WESTCON INTERNATIONAL~ 
Current  –  –  430 565  141 128  65 874  637 567 
1 – 30 days past due  –  –  31 981  16 197  11 900  60 078 
31 – 60 days past due  –  –  7 729  4 043  9 030  20 802 
61 – 90 days past due  –  –  5 338  2 819  3 402  11 559 
91 – 120 days past due  –  –  5 157  846  3 123  9 126 
Over 120 days past due  –  –  10 770  2 739  24 473  37 982 
Gross trade receivables  –  –  491 540  167 772  117 802  777 114 
Expected credit loss allowance  –  –  (7 454) (1 198) (13 388) (22 040)
Net trade receivables  –  –  484 086  166 574  104 414  755 074 

   Unaudited
Six months to 31 August 2021 
US$'000  North 
America 
Latin 
America 
Europe  Asia- 
Pacific 
MEA  Total 
LOGICALIS 
Current  52 107  137 515  59 873  28 476  2 580  280 551 
1 – 30 days past due  13 369  6 195  20 456  7 937  687  48 644 
31 – 60 days past due  3 893  4 361  2 102  2 323  224  12 903 
61 – 90 days past due  4 486  664  890  1 303  11  7 354 
91 – 120 days past due  992  613  450  959  9  3 023 
Over 120 days past due  2 236  3 217  761  4 875  84  11 173 
Gross trade receivables  77 083  152 565  84 532  45 873  3 595  363 648 
Expected credit loss allowance  (38) (514) (1 172) (2 256) (56) (4 036)
Net trade receivables  77 045  152 051  83 360  43 617  3 539  359 612 
CORPORATE AND MANAGEMENT CONSULTING~ 
Current  1 019  –  4 625  775  1 219  7 638 
1 – 30 days past due  108  –  1 059  251  432  1 850 
31 – 60 days past due  133  –  120  –  185  438 
61 – 90 days past due  –  –  277  –  3  280 
91 – 120 days past due  –  –  64  –  –  64 
Over 120 days past due  31  –  95  159  907  1 192 
Gross trade receivables  1 291  –  6 240  1 185  2 746  11 462 
Expected credit loss allowance  (31) –  (78) (159) (392) (660)
Net trade receivables  1 260  –  6 162  1 026  2 354  10 802 
~ Datatec Financial Services has been included in the Westcon International segment in August 2021 and in the Corporate segment in August 2020 and February 2021.

The past due receivables ageing categories above are shown gross, before taking into account expected credit loss allowances. US$23.7 million expected credit losses have been allocated to the US$62.6 million over 90 days past due receivables, resulting in a net over 90 days past due receivables balance of US$38.9 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.

   Unaudited
Six months to 31 August 2020 
US$'000  North 
America 
Latin 
America 
Europe  Asia- 
Pacific 
MEA  Total 
DATATEC GROUP TOTAL 
Current  64 619  87 884  545 807  115 933  54 630  868 873 
1 – 30 days past due  19 739  3 549  41 615  37 360  14 165  116 428 
31 – 60 days past due  2 991  959  14 507  12 744  9 706  40 907 
61 – 90 days past due  1 302  2 165  4 271  3 766  2 170  13 674 
91 – 120 days past due  686  769  2 938  1 351  3 307  9 051 
Over 120 days past due  936  2 368  13 471  10 666  29 346  56 787 
Gross trade receivables  90 273  97 694  622 609  181 820  113 324  1 105 720 
Expected credit loss allowance  (182) (974) (9 721) (4 997) (13 764) (29 638)
Net trade receivables  90 091  96 720  612 888  176 823  99 560  1 076 082 
WESTCON INTERNATIONAL~ 
Current  4 429  –  439 608  87 726  52 857  584 620 
1 – 30 days past due  –  –  30 286  30 784  13 332  74 402 
31 – 60 days past due  –  –  10 537  7 775  9 500  27 812 
61 – 90 days past due  –  –  3 423  1 320  2 131  6 874 
91 – 120 days past due  –  –  2 410  511  2 506  5 427 
Over 120 days past due  –  –  6 661  6 560  28 820  42 041 
Gross trade receivables  4 429  –  492 925  134 676  109 146  741 176 
Expected credit loss allowance  –  –  (5 881) (3 088) (13 443) (22 412)
Net trade receivables  4 429  –  487 044  131 588  95 703  718 764 

   Unaudited
Six months to 31 August 2020 
US$'000  North 
America 
Latin 
America 
Europe  Asia- 
Pacific 
MEA  Total 
LOGICALIS  
Current  59 501  87 415  101 991  27 330  603  276 840 
1 – 30 days past due  19 523  3 549  10 017  6 462  191  39 742 
31 – 60 days past due  2 940  959  3 820  4 869  51  12 639 
61 – 90 days past due  1 302  2 165  848  2 305  39  6 659 
91 – 120 days past due  686  769  519  838  13  2 825 
Over 120 days past due  936  2 368  6 640  4 103  60  14 107 
Gross trade receivables  84 888  97 225  123 835  45 907  957  352 812 
Expected credit loss allowance  (182) (974) (3 761) (1 909) (35) (6 861)
Net trade receivables  84 706  96 251  120 074  43 998  922  345 951 
CORPORATE AND MANAGEMENT CONSULTING~ 
Current  689  469  4 208  877  1 170  7 413 
1 – 30 days past due  216  –  1 312  114  642  2 284 
31 – 60 days past due  51  –  150  100  155  456 
61 – 90 days past due  –  –  –  141  –  141 
91 – 120 days past due  –  –  9  2  788  799 
Over 120 days past due  –  –  170  3  466  639 
Gross trade receivables  956  469  5 849  1 237  3 221  11 732 
Expected credit loss allowance  –  –  (79) –  (286) (365)
Net trade receivables  956  469  5 770  1 237  2 935  11 367 
~ Datatec Financial Services has been included in the Westcon International segment in August 2021 and in the Corporate segment in August 2020 and February 2021.

   Audited
Year ended 28 February 2021 
US$'000  North 
America 
Latin 
America 
Europe  Asia- 
Pacific 
MEA  Total 
DATATEC GROUP TOTAL  
Current  53 766  115 771  563 157  137 742  99 730  970 166 
1 – 30 days past due  9 060  3 675  26 259  23 364  10 705  73 063 
31 – 60 days past due  2 766  3 592  9 644  9 036  6 337  31 375 
61 – 90 days past due  743  1 095  4 135  4 449  1 286  11 708 
91 – 120 days past due  530  193  2 606  1 795  2 035  7 159 
Over 120 days past due  1 863  1 782  7 170  7 618  23 113  41 546 
Gross trade receivables  68 728  126 108  612 971  184 004  143 206  1 135 017 
Expected credit loss allowance  (158) (489) (9 024) (3 707) (13 534) (26 912)
Net trade receivables  68 570  125 619  603 947  180 297  129 672  1 108 105 
WESTCON INTERNATIONAL~  
Current  –  –  467 407  107 163  97 844  672 414 
1 – 30 days past due  –  –  13 153  15 829  9 883  38 865 
31 – 60 days past due  –  –  7 203  5 821  6 059  19 083 
61 – 90 days past due  –  –  3 391  1 036  1 241  5 668 
91 – 120 days past due  –  –  2 203  538  2 009  4 750 
Over 120 days past due  –  –  6 418  3 297  22 546  32 261 
Gross trade receivables  –  –  499 775  133 684  139 582  773 041 
Expected credit loss allowance  –  –  (7 738) (1 373) (13 091) (22 202)
Net trade receivables  –  –  492 037  132 311  126 491  750 839 
LOGICALIS   
Current  52 588  115 694  89 616  30 025  778  288 701 
1 – 30 days past due  8 755  3 675  11 530  7 390  473  31 823 
31 – 60 days past due  2 766  3 487  2 157  3 072  81  11 563 
61 – 90 days past due  742  1 095  335  3 054  18  5 244 
91 – 120 days past due  530  193  403  1 167  15  2 308 
Over 120 days past due  1 832  1 782  655  4 227  63  8 559 
Gross trade receivables  67 213  125 926  104 696  48 935  1 428  348 198 
Expected credit loss allowance  (142) (489) (1 207) (2 295) (50) (4 183)
Net trade receivables  67 071  125 437  103 489  46 640  1 378  344 015 

   Audited
Year ended 28 February 2021 
US$'000  North 
America 
Latin 
America 
Europe  Asia- 
Pacific 
MEA  Total 
CORPORATE AND MANAGEMENT CONSULTING~ 
Current  1 178  77  6 134  554  1 108  9 051 
1 – 30 days past due  305  –  1 576  145  349  2 375 
31 – 60 days past due  –  105  284  143  197  729 
61 – 90 days past due  1  –  409  359  27  796 
91 – 120 days past due  –  –  –  90  11  101 
Over 120 days past due  31  –  97  94  504  726 
Gross trade receivables  1 515  182  8 500  1 385  2 196  13 778 
Expected credit loss allowance  (16) –  (79) (39) (393) (527)
Net trade receivables  1 499  182  8 421  1 346  1 803  13 251 
~ Datatec Financial Services has been included in the Westcon International segment in August 2021 and in the Corporate segment in August 2020 and February 2021. 

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, are secured against the assets of the company to which the facility is made available and 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, among other things, mean that the facility may be repayable on demand. The Group continues to closely monitor the outlook for liquidity in its divisions to ensure that sufficient cash will continue to be generated to settle liabilities as they fall due.

Logicalis is supported by a corporate facility of US$155.0 million, covering all operations outside of Latin America, comprising a rolling credit facility to fund working capital requirements and an acquisition facility. The Latin America region is supported separately via a number of uncommitted overdraft facilities and short-term lending arrangements.

Westcon International has an invoice assignment facility of EUR275.0 million for its European subsidiaries and a securatisation facility of US$80.0 million for its Asia-Pacific subsidiaries. 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 (GBP3.6 million) and Africa (US$1.0 million), a securatisation facility in South Africa (ZAR50.0 million) and a line of credit in Singapore (US$1.2 million) to finance the business.

Analysys Mason continues to have access to an overdraft supporting its working capital requirements.

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 twelve months to confirm that banking covenants are expected to be met and Covid-19 is not expected to impact the Group’s ability to meet its banking covenants.