Contact form/Disclaimer

Author: Piotr Wenda
Analysed Company: ASBISC 
Published: 04/03/2022






Disclaimer:

The information in this document has been created and is provided for educational and informational purposes only. It does not constitute any offer, recommendation or advice to any person to enter into any transaction or adopt any hedging, trading or investment strategy. Readers of this document should seek advice regarding the appropriateness of investing in any securities, financial instruments or investment strategies referred to on this document and should understand that statements regarding future prospects may not be realised. Opinions, analyses and estimates are subject to change and to readers’ own interpretation. I accept no liability and will not be liable for any loss or damage arising directly or indirectly from your use of this document.

P & L

Row

Income Statements

2016 2017 2018 2019 2020
Revenue 1,137,709 1,484,913 2,069,564 1,914,881 2,366,441
Cost of goods sold -1,072,295 -1,408,177 -1,971,471 -1,810,735 -2,228,156
Gross Profit 65,414 76,736 98,093 104,146 138,285
Selling Expenses -26,694 -32,509 -43,463 -38,882 -44,154
Depreciation of fixed assets -1,544 -1,520 -1,562 -2,998 -3,388
Depreciation of intangible assets -600 -716 -1,005 -1,033 -999
Administrative expenses -15,781 -16,940 -22,173 -26,805 -32,040
Research expenses -558 -645 -480 -1,342 -1,031
EBIT 20,237 24,406 29,410 33,086 56,673
Financial income 590 1,598 4,452 3,488 4,319
Interest expenses -14,855 -16,006 -18,622 -17,662 -16,708
Net finance costs -14,265 -14,408 -14,170 -14,174 -12,389
Other gains and losses 42 -985 -111 53 383
NPBT 6,014 9,013 15,129 18,965 44,667
Taxes -1,378 -2,104 -3,092 -3,725 -8,152
Net Earnings 4,636 6,909 12,037 15,240 36,515

Key Metrics

2017 2018 2019 2020 Average Geometric_Mean Median
Countries of the former USSR 61.63% 50.9% -5.63% 25.88% 33.19% 30.47% 38.39%
Central and Eastern Europe 16.42% 15.95% -12.02% 13.52% 8.47% 7.75% 14.73%
Middle East and Africa 133.05% 24.63% 7.5% 28.26% 48.36% 41.46% 26.45%
Western Europe -44.25% 74.74% -22.12% 34.24% 10.65% 0.46% 6.06%
Rest -53.97% 221.42% -8.01% 32.86% 48.07% 15.96% 12.42%
Total 30.52% 39.37% -7.47% 23.58% 21.5% 20.09% 27.05%
Selected Ratios
2016 2017 2018 2019 2020 Average
COGS/Sales 94.25% 94.83% 95.26% 94.56% 94.16% 94.61%
Gross Profit Margin 5.75% 5.17% 4.74% 5.44% 5.84% 5.39%
SG&A/Sales 3.78% 3.37% 3.19% 3.5% 3.26% 3.42%
Other gains and(or) losses/EBIT 0.21% -4.04% -0.38% 0.16% 0.68% -0.67%
NPBT/Sales 0.53% 0.61% 0.73% 0.99% 1.89% 0.95%
NPAT/Sales 0.41% 0.47% 0.58% 0.8% 1.54% 0.76%
EBIT/Sales 1.78% 1.64% 1.42% 1.73% 2.39% 1.79%
EBIDTA/Sales 1.97% 1.79% 1.55% 1.94% 2.58% 1.97%
Interest/Sales 1.31% 1.08% 0.9% 0.92% 0.71% 0.98%
Financial Income/EBIT 2.92% 6.55% 15.14% 10.54% 7.62% 8.55%
EBIT/Interest 136.23% 152.48% 157.93% 187.33% 339.2% 194.63%
Tax rate 22.91% 23.34% 20.44% 19.64% 18.25% 20.92%

Row

Revenue Distribution

Distribution by currency

Row

Summary

1.Data Modifications

Depreciation & Research

In note no.5 attached to a consolidated financial statement(ASBISCs, 2020) a depreciation is stated to be expensed prior to earnings before tax, thus, we have modified and dissected originally reported selling and administrative expenses to accommodate for research and depreciation costs, respectively. Such a maneuver has been done for modelling and forecasting purposes.

Other gains and losses; Share of profit/(loss) of equity-accounted investees; Negative goodwill on acquisition of subsidiary

The foregoing three positions have been merged into one called “Other gains and losses” due to immaterial value thereof and to streamline the forecasting schedule.

2.Acquisitions

The scope of this research does not encompass a comprehensive M&A analysis, however, the record of numerous acquisitions is summarized below and taken into consideration when assessing revenue growth authenticity and used while determining specific assumptions underlying forecasting schedule and future valuation.

2016 - Ownership % 2017 - Ownership % 2018 - Ownership % 2019 - Ownership % 2020 - Ownership %
ASBIS Cloud Ltd I ON LTD (100%) ASBIS Cloud Ltd (100%) Vizuatika LLC (75%) Real Scientists Ltd (55%)
SHARK Computers a.s. ASBC LLC (68.5%) ASBC Kazakhstan LLP (100%) Vizuators LLC (75%) ASBIS IT Solutions Hungary Kft (100%)
ASBIS SERVIC Ltd (100%) Atlantech Ltd (100%) ALC Avectis (100%) MakoSolutions LLC (100%)
ASBIS Cloud Ltd (85%) ASBC LLC (100%) Cafe-Connect LLC (100%)
OOO Avectis (former OOO Aksiomtech) (100%) TOO”ASNEW” (100%)
OOO IT Training (100%) Brezzy Ltd (100%)
Center of excellence in Education for executives and specialists in Information Technology (100%) I.O.N Clinical Trading Ltd (70%)
OOO Must (100%) R.SC. Real Scientists Cyprus Ltd (85%)

3.Revenue

In 5 years, ASBISc more than doubled its revenue with a compounded annual growth rate (CAGR) of 15.8% and geometric mean (GM) of 20.09%, respectively. The highest growth was noted predominantly in the regions of former USSR countries (GM = 30.47%), the Middle East, and Africa (GM = 41.46%), either growing in their importance, comprising 54.49%, and 11.81% of the reported revenue as of 2020, accordingly.

Undoubtedly, the extent of gains, either in earnings per share or share price might have surpassed any expectations of the investors and equity-holders. Nevertheless, a financial conservatism implies a solitary skepticism when analysing soaring streams of revenues and net earnings, especially in the light of continuous acquisitions. It, therefore, becomes increasingly important to establish whether we are dealing with a generic growth or merely a product of accounting consolidations resulting from the M&A transactions.

In this regard, it seems that M&A enabled a company to expand its base of customers varying from region to region. On the other hand, Gross Profit Margin remains nearly constant and balances between 5-6% with no improvement in managing costs in primary activities. With c. 2$bn in sales, I would expect a company to achieve greater economies of scales and more efficient cost management. Similarly, the SG&A-to-Sales ratio hangs at 3%, leaving marginal NPAT-to-Sales that grew only from 0.41% in 2016 to 1.54% in 2020. In the event of an economic stagnation, the probable sales decline would automatically pull down net earnings and share price, putting investors at the risk of a capital loss. Albeit, interest coverage grew from 1.36 to 3.39 times, in continuously stagnant/adverse market conditions, the company’s capacity to cover the interest and principal on their debt would have curtailed, lowering its cash position.

4.Geopolitical Risk (State of war)

With the growing concerns around economic sanctions imposed on Belarus and Russia, it would be useful to establish what percentage of revenue is actually received in currencies for either countries, to get an idea of what minimal/acceptable revenue elimination could be expected. As for Russia and Belarus in 2020, revenue generated in rubles comprised 8.7% and 5.78%, respectively, whereas for Ukraine it was 8.82%, collectively amounting to 22.7% of total sales. Whilst Ukraine’s share would annihilate due to war, the future prognosis for sales in Russia and Belarus would largely depend on imposed sanctions. However, some of the subsidiaries operating internally within aforementioned countries might still be continuing its activities with sales contingent on disruptions to supply chain management. Thus, an absolute sales cut in Ukraine is inevitable, however, when it comes to other countries, it might vary to different extent.

Balance Sheet & Cash-flow

Row

Balance Sheet

2016 2017 2018 2019 2020
Non-current assets NA NA NA NA NA
PP&E 23,210 24,533 25,250 29,680 32,728
Intangible assets 2,992 3,164 3,068 2,593 2,418
Equity-accounted investees 12 12 336 227 827
Goodwill 1,255 419 400 591 629
Deferred tax assets 1,007 228 133 227 466
Total non-current assets 28,475 28,356 29,187 33,318 37,068
Current assets NA NA NA NA NA
Inventory 113,858 144,980 180,211 266,039 277,557
Trade receivables 221,068 238,192 174,580 212,168 295,846
Other current assets 16,990 18,127 16,859 16,035 19,140
Derivative financial assets 1,079 373 1,088 945 199
Current taxation. 664 493 451 595 204
Cash & cash equivalents 33,352 93,401 101,425 103,687 158,898
Total current assets 387,011 495,566 474,614 599,469 751,844
Total assets 415,486 523,922 503,801 632,787 788,912
Equity & liabilities NA NA NA NA NA
Equity NA NA NA NA NA
Share capital 11,100 11,100 11,100 11,100 11,100
Share premium 23,518 23,518 23,518 23,518 23,518
Retained earnings 51,109 59,542 64,340 73,323 100,725
Equity attributable to owners of the parent 85,728 94,160 98,958 107,941 135,343
Non-controlling interest 167 308 275 254 295
Total equity 85,895 94,468 99,233 108,195 135,638
Non-current liabilities NA NA NA NA NA
Long-term debt 1,184 169 87 3,338 5,729
Other long-term liabilities 313 369 578 635 732
Deferred tax liabilities 150 60 34 511 306
Total non-current liabilities 1,647 598 699 4,484 6,767
Current liabilities NA NA NA NA NA
Trade payables and prepayments 202,038 253,021 208,145 321,277 336,010
Trade payables factoring facilities 50,751 0 0 29,106 51,403
Other current liabilities 26,945 38,083 46,938 59,036 92,369
Short-term borrowings 47,873 136,492 146,566 107,173 160,962
Derivative financial liabilities 1 739 358 2,082 883
Current taxation 335 521 1,862 1,434 4,880
Total current liabilities 327,943 428,856 403,869 520,108 646,507
Total liabilities 329,591 429,454 404,568 524,592 653,274
Total equity and liabilities 415,486 523,922 503,801 632,787 788,912

Cash flow plot 1

Row

Cash flow Statement

2016 2017 2018 2019 2020
Profit for the year before tax 6,014 9,013 15,130 18,965 44,667
Adjustments for: NA NA NA NA NA
Exchange difference arising on consolidation 159 1,441 -690 -850 205
Depreciation of PP&E 1,544 1,520 1,562 2,998 3,388
Amortisation of intangible assets 600 716 1,005 1,033 999
Impairment loss on intangible assets 250 1,232 360 315 39
Provision for obsolete stock 2,870 -2,502 -1,483 554 1,410
Share of loss of equity-accounted investees 0 0 30 25 -6
Loss/(profit) from the sale of PP&E incl. intangible assets 13 -28 -25 96 -24
Provision for bad debts and receivables written off 2,933 -2,107 -2,256 -1,835 477
Bad debts recovered -15 -12 -51 -80 -24
Impairment of investments in associates 0 0 12 152 0
Interest received -114 -49 -137 -249 -231
Interest paid 4,428 4,075 4,317 4,643 4,308
Operating profit before working capital changes 18,682 13,299 17,774 25,767 55,208
Increase in inventory -19,806 -28,621 -33,513 -86,383 -12,926
Increase in trade receivables -6,520 -15,006 65,919 -35,675 -84,131
(Increase)/decrease in other current assets -3,304 -431 865 967 -2,359
Increase in trade payables and prepayments 11,345 50,983 -46,586 113,132 14,734
Increase/(decrease) in trade payables factoring facilities 0 15,089 -18,694 -998 22,297
Increase in other current liabilities 6,964 11,876 8,473 14,076 32,095
Increase in other non-current liabilities -53 56 209 57 97
Increase in factoring creditors 7,451 0 0 7,054 25,858
Cash inflow from operations 14,760 47,245 -5,553 37,997 50,873
Interest paid. -4,428 -4,075 -4,317 -4,643 -3,948
Tax paid -898 -1,059 -1,556 -3,863 -4,750
Net operating cash flow 9,434 42,111 -11,426 29,491 42,175
Cash flow from investing activities NA NA NA NA NA
Purchase of intangible assets -854 -928 -1,017 -515 -808
Purchase of PP&E -1,570 -1,404 -1,997 -2,355 -3,608
Proceeds from sale of PP&E incl. intangible assets -1 0 -366 26 24
Payment for purchase in subsidiaries 0 120 111 -1,045 -594
Interest received. 114 49 137 249 231
Net cash from investing -2,310 -2,163 -3,132 -3,640 -4,755
Cash inflows/outflows from financing activities NA NA NA NA NA
Acquisition of treasury shares 0 0 0 -162 -36
Payment of final dividend 0 -1,665 -6,105 -6,089 -9,684
Repayment of long-term loans -657 -1,015 -82 0 0
Proceeds from long-term lease 0 0 0 332 194
Proceeds from short term borrowings and loans -4,220 2,126 32,921 266 7,483
Net cash from financing activities -4,876 -554 26,734 -5,653 -2,043
Net increase/decrease in cash & cash equivalents 2,247 39,394 12,176 20,198 35,377
Cash & cash equivalents at the beginning of the year 4,290 6,537 45,933 58,109 78,306
Cash & cash equivalents at the end of the year 6,537 45,933 58,109 78,307 113,683

Cash flow plot 2

Credit Risk Analyses

Row

Performance

ROE
2016 2017 2018 2019 2020
NPAT to Revenue 0.41% 0.47% 0.58% 0.8% 1.54%
Revenue to Assets 273.83% 283.42% 410.79% 302.61% 299.96%
Assets to Equity 483.71% 554.6% 507.7% 584.86% 581.63%
Return on Equity 5.4% 7.31% 12.13% 14.09% 26.92%
ROIC Financing Approach
2017 2018 2019 2020
NOPAT
Net Income 6,909.00 12,037.00 15,240.00 36,515.00
(+) Depreciation and amortisation on PP&E 1,520.00 1,562.00 2,998.00 3,388.00
(+) Depreciation and amortisation on intangible assets 716.00 1,005.00 1,033.00 999.00
(-) Other income / loss -14,408.00 -14,170.00 -14,174.00 -12,389.00
(+) Deferred tax (current year - previous year) 186.00 1,341.00 -428.00 3,446.00
Tax rate 0.23 0.20 0.20 0.18
(-) Tax shield (Other income/loss x tax rate) 3,363.41 2,896.00 2,783.98 2,261.07
NOPAT 20,375.59 27,219.00 30,233.02 54,475.93
Invested Capital
Current portion long-term debt 136,492.00 146,566.00 107,173.00 160,962.00
Long-term debt 169.00 87.00 3,338.00 5,729.00
Other current liabilities incl. deferred revenue 38,083.00 46,938.00 59,036.00 92,369.00
Total common shareholders’ equity 94,468.00 99,233.00 108,195.00 135,638.00
(-) Cash & equivalents 93,401.00 101,425.00 103,687.00 158,898.00
(-) Other current assets incl. short-term investments 18,127.00 16,859.00 16,035.00 19,140.00
(+) Cash (Revenue x 4%) 59,396.52 82,782.56 76,595.24 94,657.64
Shareholders’ equity 42,336.52 63,731.56 65,068.24 52,257.64
Invested Capital 217,080.52 257,322.56 234,615.24 311,317.64
ROIC
ROIC [NOPAT / ((Current Year invested capital + previous year’s)/ 2)] NA 0.11 0.12 0.20
Du Pont Analysis Annual 2020 Results - Mixed IT and Electronics distribution companies
Asset Turnover Return on Sales (%) Return on Assets Financial Leverage Return on Equity
ASBISc Enterprises Plc GPW:ASB 3 1.54 % 4.62 % 5.82 26.89 %
AB SA GPW:ABPL 3.9 0.65 % 2.54 % 3.07 7.8 %
Arrow Electronics NYSE:ARW 1.68 2.04 % 3.43 % 3.31 11.35 %
Avnet Inc NASDAQ:AVT 2.18 11.7 % 25.51 % 2.18 55.61 %
Action SA GPW:ACT 3.27 8.9 % 29.1 % 2.1 61.11 %
Maxcom GPW:MXC 1.25 3.95 % 4.94 % 1.24 6.13 %
NTT System GPW:NTT 2.89 1.08 % 3.12 % 1.9 5.93 %
Note:
Calculations are subject to rounding error.
Market Value to Book Value Ratios Annual 2020 Results - Mixed IT and Electronics distribution companies
Sales Market Value Sales to Market Cap Book Value Market Cap to Book Value Ratio
ASBISc Enterprises Plc GPW:ASB 2,366.4 114.0 20.8 135.5 0.8
AB SA GPW:ABPL 10,206.9 516.4 19.8 850.2 0.6
Arrow Electronics NYSE:ARW 28,673.4 7,651.2 3.8 7,037.1 1.1
Avnet Inc NASDAQ:AVT 17,634.3 3,527.6 5.0 3,726.4 0.9
Action SA GPW:ACT 2,062.0 106.7 19.3 300.3 0.4
Maxcom GPW:MXC 103.1 33.6 3.1 67.0 0.5
NTT System GPW:NTT 791.0 72.0 11.0 144.1 0.5
Note:
Calculations are subject to rounding error.
1 For ASBISc, market value in dollars was calculated as per the average exchange rate $/PLN for 2020.
2 Market Value for companies was calculated as per the number of shares outstanding times share price as of 30 Dec 2020.
3 Book Value was computed based on the financial data extracted from annual reports for 2020.
4 For GPW listed enterprises (row no. 2,5,6,7), data is provided in PLN except ASBISc.
5 For US listed enterprises incl. ASBISc (row no. 1,3,4), data is provided in USD.

Liquidity & Funding

Liquidity and Funding
2016 2017 2018 2019 2020
Working capital to current assets 15.26% 13.46% 14.91% 13.24% 14.01%
Working Capital Requirements to sales 7.22% 8.76% 7.09% 6.68% 7.86%
Working investment to sales 16.03% 11.48% 5.53% 11.69% 7.45%
Current assets to current liabilities 118.01% 115.56% 117.52% 115.26% 116.29%
Total assets to total liabilities 126.06% 122% 124.53% 120.62% 120.76%
Cash to current liabilities 10.17% 21.78% 25.11% 19.94% 24.58%
Cash & Receivables to current liabilities 77.58% 77.32% 68.34% 60.73% 70.34%
Inventory reliance 49.65% 54.58% 61.6% 70.75% 62.19%
Fixed assets to equity 27.02% 25.97% 25.45% 27.43% 24.13%

Asset Efficiency

Cash conversion cycle
2017 2018 2019 2020
Receivables days on hand 58.55 30.79 40.44 45.63
Receivables average collection period 56.44 36.40 36.86 39.18
Receivables turnover 6.47 10.03 9.90 9.32
Inventory turnover 10.88 12.13 8.12 8.20
Inventory days on hand 37.58 33.36 53.63 45.47
Average inventory conversion 33.55 30.10 44.98 44.52
Payables days on hand 65.58 38.54 64.76 55.04
Average payables period 58.98 42.69 53.36 53.84
Estimated short-term funding required 31.01 23.81 28.48 29.87
Assets quality
2016 2017 2018 2019 2020 Average
Obsolote stock to inventory 2.52% -1.73% -0.82% 0.21% 0.51% 0.14%
Provision for bad debts to receivables 1.33% -0.88% -1.29% -0.86% 0.16% -0.31%
Goodwill & Intangible assets to equity 4.94% 3.79% 3.49% 2.94% 2.25% 3.48%
Cash from operations to capex 389.24% 1805.79% -379.1% 1027.56% 955.05% 759.71%
Depreciation to cash from operations 22.73% 5.31% -22.47% 13.67% 10.4% 5.93%
Capex to depreciation 113.04% 104.29% 117.41% 71.2% 100.66% 101.32%

Leverage

Leverage
2016 2017 2018 2019 2020 Average
(Net Income + Tax paid + Interest) / Interest 1.40 1.56 1.81 2.07 3.67 2.11
(EBIDTA - capex) / Interest 1.34 1.52 1.56 1.94 3.39 1.95
Short term debt inc. factoring to EBIDTA 4.41 5.12 4.58 3.67 3.48 4.25
Long term debt to EBIDTA 0.05 0.01 0.00 0.09 0.09 0.05
Total debt incl. factoring to EBIDTA 4.46 5.13 4.59 3.76 3.57 4.30
Total debt incl. factoring to net operating cash flow 10.58 3.25 -12.84 4.73 5.17 2.18
Fixed charges coverage = Gross income / (Gross income - net income) 1.08 1.10 1.14 1.17 1.36 1.17

Row

Performance

The company experienced continuous and uninterrupted growth with noticeable improvements in both ROE and ROIC, accordingly. However, in the context of ASBISc, it was essential to establish whether the performance adequately compensates for the credit risk exposure comparative to companies within a similar line of business. Thus, a Du Pont Analysis was conducted to assess the relationship between financial leverage and both, returns on assets and equity, respectively.

A mix purposely consists of companies with varying market capitalizations and sales power, which enables to discriminate between the size, financial leverage, and competitiveness, given earnings power and size of the listed firms.

Amid analysed companies, ASBISc has the highest financial leverage (5.82) and third-largest ROE (26.89%). Nota bene, it only succumbs to Avnet Inc and Action SA, who equally outperform based on ROS and ROA metrics, in particular, the latter one with more than doubling the ASBISCs’s performance, whilst utilising more than twice as least debt. The firm nonetheless, generated sales twenty times against its capitalisation, however, marginal ROS might be indicative of higher running costs incurred thereon. If we measure sales against the book value, ASBISc would be leading across the tabulated enterprises, which can be attributed to inadequate levels of assets, pinpointing their sales advancing more rapidly comparative to PP&E and intangibles.

With hindsight, I would expect greater returns on sales, equity, and assets, as well as financial leverage, being no greater than 3.5. The primary question we should be asking is whether they can maintain the current levels of sales and hence, the profitability. In the event of a sales decline, the reduced cash position would be inadequate to buttress further acquisitions, and the revenue growth is likely to be stemmed, earnings normalised, with a reduction in ROE, dividend rate, and share price. At the same time, yet, being highly leveraged and liable to repay all of its outstanding debt, making it a riskier asset in the investment portfolio.

Assets Efficiency, Liquidity and Funding

The company heavily relied on selling inventories and stretching credit terms to customers, as showcased through growing inventory reliance and a high level of receivables against the current liabilities. Decreasing inventory turnover and simultaneously increasing the average conversion cycle might imply subsiding revenue growth due to product oversaturation. The rationale is that when the company has maximised the sales of their products and cannot sell more due to customers already having the product. The management is likely to shift focus on fostering the collection of the outstanding payments through improving receivables policies, and ultimately, the average receivables collection period. This partially explains numerous acquisitions that are medium of reaching out to a broader group of consumers.

Satisfactorily insubstantial levels of obsolete stock, and bad debts, while capital expenditures merely maintained to accommodate depreciation and amortisation with a discernible downward trend, as per Capex-to-depreciation ratio. The cash from operations to CAPEX, although raising, can suggest the company is cutting back on outlays, attempting to decrease the costs at the expense of impairing long-term competitiveness.

Leverage

Interest coverage progressed significantly across 5 years from 1.4 to 3.7 that is indicative of earnings power more than providing for required debt repayments and important capital expenditures. Nonetheless, I would be inclined to see the average coverage at 3 times the interest, which ASBISc failed to meet (2.11). Short-term borrowings comprise a main source of financing and should be perceived as a permanent debt and/or included when assessing credit capacity. Total debt can be repaid in c. 5 years, conjecturing current sales levels. In the event of declining revenues and reduced earnings capacity, this might prolong, putting additional strains on funding requirements. Fixed charges coverage grew marginally with the average 1.17 ratio that does not constitute a sufficient cushion to cater for possibly soaring costs of running the business. Moreover, $33.3m in cash & equivalents, $29.6m in deposits and $9m in estates sitting on the balance sheet has been put as a lien against the pre-existing debt alongside all assets.

Conclusions

If I was about to assign a credit mark to ASBISc using Fitch or S&P credit ratings, it would be positioned within the high yield rank and marked as BB-. I acknowledge the noticeable advancement in earnings power that cater for fixed charges including interest and principal debt repayments. Nonetheless, we put an emphasis on evaluating an ability to sustain long-term profitability, and in such, debt capacity is prone to low earnings margin and/or potential deterioration in revenues. By the same token, the hard-earned advancement can readily return to its previous state, making ASBISc a more volatile and riskier asset.

Income & Cash flow 5-years projection

Row

Income statement 5-years projection - Stress case

Income Statement 5-year projection
2021 2022 2023 2024 2025
Revenue 2,839,729 2,641,609 2,297,051 1,914,209 2,009,920
Cost of goods sold -2,673,889 -2,487,339 -2,162,903 -1,802,419 -1,892,540
Gross Profit 165,840 154,270 134,148 111,790 117,379
Selling Expenses -59,634 -55,474 -48,238 -40,198 -42,208
Depreciation of fixed assets -4,372 -4,067 -3,537 -2,947 -3,095
Administrative expenses -36,082 -33,564 -29,186 -24,322 -25,538
Research expenses -1,302 -1,212 -1,054 -878 -922
EBIT 64,449 59,953 52,133 43,444 45,616
Financial income 4,199 3,906 3,396 2,830 2,972
Interest expenses -15,168 -16,125 -15,813 -1,733 -9,677
Net finance costs -10,970 -12,220 -12,417 1,097 -6,706
Other gains and/or losses -432 -402 -349 -291 -306
NPBT 53,048 47,332 39,367 44,251 38,605
Taxes -11,140 -9,940 -8,267 -9,293 -8,107
Net Earnings 41,908 37,392 31,100 34,958 30,498
P&L supporting schedule
2021 2022 2023 2024 2025
Revenue growth/decline 20% -7.5% -15% -20% 5%
COGS/sales (2020) 94.16% 94.16% 94.16% 94.16% 94.16%
Selling expenses/revenue (average) 2.1% 2.1% 2.1% 2.1% 2.1%
Depreciation/assets (average) 10.06% 10.06% 10.06% 10.06% 10.06%
Admin expenses/sales (average) 1.27% 1.27% 1.27% 1.27% 1.27%
Research/sales (average) 0.05% 0.05% 0.05% 0.05% 0.05%
Financial income/sales (average) 0.15% 0.15% 0.15% 0.15% 0.15%
Taxes (average) 21% 21% 21% 21% 21%
Note:
Calculations are subject to a rounding error.
The supporting schedule was founded on the historical values calculated under tab ‘Financial Statements - Statistics 2016-2020’.
*Revenue forecast for 2021 was calculated as per geometric mean growth rate (20%), whilst other periods being stressed under declining sales scenarios.

Cashflow 5-year projection - Stress case

Cashflow 5-years projection stress case
2021 2022 2023 2024 2025
Profit for the year before tax 53,048 47,332 39,367 44,251 38,605
Exchange difference on consolidation 53 53 53 53 53
Depreciation & Amortisation 4,372 4,067 3,537 2,947 3,095
Impairment loss on intangible assets 439 439 439 439 439
Provision for obsolete stock 1,663 1,547 1,345 1,121 1,177
Provision for bad debts on receivables 488 454 395 329 345
Interest received 156 156 156 156 156
Interest paid 4,332 3,465 2,599 1,733 866
Operating profit before working capital changes 64,239 57,201 47,578 50,717 44,425
(Increase)/decrease in inventory -48,584 22,754 39,572 43,969 -10,992
(Increase)/decrease in receivables -8,978 21,267 36,986 41,095 -10,274
(Increase)/decrease in current assets -852 -852 -852 -852 -852
Increase/(decrease) in payables 67,198 -28,131 -48,923 -54,359 13,590
Increase/(decrease) in factoring payables 48,155 22,118 6,727 -160,306 106,888
Increase/(decrease) in other current liabilities -11,793 -5,622 -9,777 -10,863 2,716
Increase/(decrease) in other non-current liabilities 182 228 285 356 444
Interest paid -4,332 -3,465 -2,599 -1,733 -866
Taxes paid -11,140 -9,940 -8,267 -9,293 -8,107
Net operating cash flow 94,096 75,559 60,730 -101,269 136,971
Capital Expenditures/assets disposal -12,515 -1,047 1,716 2,889 -4,554
Acquisitions -282 -282 -282 -282 -282
Interest received -156 -156 -156 -156 -156
Net cash from investing -12,640 -1,173 1,590 2,763 -4,679
Acquisition of shares -519 0 0 0 0
Dividends paid -11,734 -10,470 -8,708 -9,788 -8,539
Long-term debt principal repayments -17,327 -17,327 -17,327 -17,327 -17,327
Debt renewal 0 0 0 0 0
Net financing -29,580 -27,797 -26,035 -27,115 -25,866
Changes in cash & equivalents 51,876 46,589 36,285 -125,621 106,425
Cash & equivalents at the beginning of the year 113,683 165,559 212,148 248,434 122,813
Cash & equivalents at the end of the year 165,559 212,148 248,434 122,813 229,238
Note:
Calculations are subject to a rounding error.
Assumptions:
Acquisitions of shares: pursuant to 12-months ongoing shares buyback program with the spending no greater than $300k at an average price of $2.25. Therafter, no repurchasing planned.

Following positions have been calculated at its historical cash flow mean:
Exchange difference on consolidation
Impairment loss on intangibles
Interest received
(Increase)/decrease in current assets
Acquisitions
Cash flow schedule
2021 2022 2023 2024 2025
Other current liabilities/sales (average) 2.84% 2.84% 2.84% 2.84% 2.84%
Non-current liabilities growth rate (average) 24.92% 24.92% 24.92% 24.92% 24.92%
Obsolete stock/inventory (2020) 0.51% 0.51% 0.51% 0.51% 0.51%
Bad debts/receivables (2020) 0.16% 0.16% 0.16% 0.16% 0.16%
CAPEX/depreciation (average) 101% 101% 101% 101% 101%
Dividend payout ratio (average) 28% 28% 28% 28% 28%
Note:
Calculations:
Other current liabilities: based on average to sales ratio.
Other non-current liabilities: at its historical mean growth rate.
Obsolete stock: based on inventory ratio as of 2020.
Provision for bad debts: grounded on 2020 to receiveables.
Dividends: at historical average div/net income ratio.

Calculations are subject to a rounding error.

Row

Forecasting Schedule

Long-term debt schedule
Loans at the beginning of the year Interest paid Principal paid Total payment Amount outstanding
2021 86,634 4,332 17,327 21,658 69,307
2022 69,307 3,465 17,327 20,792 51,980
2023 51,980 2,599 17,327 19,926 34,654
2024 34,654 1,733 17,327 19,059 17,327
2025 17,327 866 17,327 18,193 0
Factoring debt schedule
Factoring debt at the beginning of the year Interest paid Principal paid New factoring issued Changes in factoring
2020 83,305 6,867 83,305 131,460 48,155
2021 131,460 10,837 131,460 153,578 22,118
2022 153,578 12,660 153,578 160,306 6,727
2023 160,306 13,214 160,306 0 -160,306
2024 0 0 0 106,888 106,888
2025 106,888 8,811 106,888 NA NA
Note:
Factoring:
The amount of $131.5m in factoring for 2021 represents the combined ending balance for 2020 of factoring trade payables (c.$51m) and factoring debt (c.$80m) extracted and deducted from short-term borrowings (current liabilities). Hypothetically, factoring lines are carried forward next year, repaid, and new borrowings renewed throughout the year in an amount representing one-third of the forecasted receivables in conjunction with cash at the beginning of that period. Since factoring is most probably used on quarterly basis to buttress an asset conversion life cycle, the interest has been compounded quarterly at 8%, which reflects ASBISC’s average cost of debt on factoring facilities. It recurs quarterly captured at its collective annualised value from 2021 to 2023, whilst revolving facility being halted throughout 2023 and resumed closer to 2025.

Long-term debt:
The remaining short-term (c.$81m) and long-term ($5.7m) debts were accumulated and treated as long-term liabilities.
Interest on long-term debt, including revolving credit facilities, was determined at an average cost of 5% per year, accordingly with estimates provided in the footnotes attached to the company’s financial statements of 2020. It is assumed to be fictitiously re-paid in 5 years, with no further long-term loans raised.

Calculations are subject to a rounding error.
Other current and non-current liabilities schedule
Other current liabilities Other non-current liabilities
2020 92,369 732
2021 80,576 914
2022 74,955 1,142
2023 65,178 1,427
2024 54,315 1,782
2025 57,031 2,226
Note:
Other current liabilities: based on average to sales ratio.
Other non-current liabilities: at its historical mean growth rate.
Asset Schedule
2021 2022 2023 2024 2025
CAPEX 12,515 1,047 -1,716 -2,889 4,554
Depreciation 4,372 4,067 3,537 2,947 3,095
Net PPE & Intangibles 43,288 40,268 35,016 29,180 30,639
Inventory 326,141 303,387 263,815 219,846 230,838
Receivables 304,824 283,557 246,571 205,476 215,750
Payables 403,208 375,077 326,154 271,795 285,385
Note:
PPE & Intangibles: both positions have been merged and a historical average asset turnover ratio of c. 65.6 derived therefrom to streamline the forecast.
Depreciation: derived as an average dep. to assets ratio of 10.1%.
Inventory: an average inventory conversion rate (44.52, 2020) was used to obtain it via forecasted COGS - 44.52 x COGS/365.
Receivables: an average collection period rate (39.18,2020) was used to derive its value from revenues - 39.18 x forecasted revenue/365.
Payables: A payable days on hand rate (55.04, 2020) was used to forecast its future value - 55.04 x forecasted COGS/365.

Income & Cash flow 5-years projections - Summary

Sensitivity Forecast

The purpose of the following study was to determine how ASBISC would react to negative scenario of inhibited revenue growth and market contraction. I recommend reading this excerpt whilst referring to the forecast schedule that explains the underlying assumptions, based on which, the future values have been extrapolated.

The foregoing discussion will shed some light on company’s acquisitive business model, whose understanding largely depends on comprehending the relationship between acquisitions and revolving credit facilities, known as factoring.

Factoring heavily relies on accounts receivables, whose value, the greater, the better, enables organisations to obtain short term borrowing correspondingly to the amount of receivables and/or cash, which are utilised as a lien against the credit facilities. Thus, lenders when evaluating company’s credit capacity and safety, appraise not only the earnings power, but the amount of receivables and cash sitting on the balance sheet. The total amount of factoring for ASBISC in 2020 was equivalent to one third of accounts receivables, cash and cash equivalents altogether. For this reason, we used this as a benchmark in factoring forecasting schedule to arrive at the amount re-borrowed each year.

Ordinarily, factoring is used on quarterly basis, so that stock can get replenished, whilst third-party suppliers liabilities being paid. Once customers have settled their payments for the products purchased in the past, a company returns the loan and revolve it to again support asset/cash conversion cycle. The intricacy is that companies might have multiple factoring providers, who do not necessarily may know about each other, and the problem arises, when an enterprise starts repaying an old factoring debt with the new one via cycle of unending acquisitions. As acquisitions complete, and consolidation takes place, merged accounts receivables reflect the required cushion benchmark (e.g. 1/3), despite the outstanding debt. Thereby,enabling management to boost its debt capacity. As an ongoing cycle of borrowing goes on, it becomes difficult to define the actual cash flow, whose value is inflated with new and/or revolving factoring. If we look at ASBISC’s forecasted cash flow at the end of each period, we are getting an impression of a solid growth and cash influx, despite consecutive declines in sales. In this model, we presumed that at the end of 2023, the current creditors halted the renewal of debt as a result of deteriorating performance, demanding a full repayment until the release of the annual financial report for 2024. A sudden slide from $248m to c. $123m represents the actual cash position and analysts should be on guard against evaluating company’s worth grounded on the discounted cash flow model, whose values can be distorted in the above-explained way. If we deduct outstanding factoring debt in 2021 with creditors not extending it, it becomes apparent that the factual cash position for 2021 is equal to $34m. This showcases how company uses debt to support its operations and acquisitions.

Dividend Discount Model

Row

Key Metrics

Key Metrics
Year Range for Stock Average Exchange Rate $/PLN (1) EPS Paid per share P/E Earnings Yield Dividend Yield Dividend Payout Ratio
2016 PLN 0.940 - 3.070 3.94 0.32 0.00 9.59 10.42% 0% 0%
2017 PLN 2.240 - 3.390 3.78 0.49 0.11 6.92 14.45% 3.24% 22.45%
2018 PLN 2.340 - 3.640 3.61 0.79 0.40 4.61 21.7% 10.99% 50.63%
2019 PLN 2.050 - 3.560 3.84 1.07 0.42 3.33 30.06% 11.8% 39.25%
2020 PLN 1.770 - 8.080 3.89 2.57 0.68 3.14 31.81% 8.42% 26.46%

[1] For Average Exchange Rates 2016-2020, please see:

Investing.com, Fusion Media Limited, Forex-USD/PLN Historical Data. Accessed 27 January, 2021. Retrieved from: https://uk.investing.com/currencies/usd-pln-historical-data

Selected Financial Data
2021
Revenue $2,842,096
Net Earnings at average Net-to-Sales 0.76% $21,599.93
Dividend at average dividend payout 0.28 $6047.98
Common Shares Outstanding 55,200.11
Dividend per share in $ $0.11
Dividend per share in PLN at average exchange rate as per 2020 PLN0.42
E/V 17.2%
Re 11.1%
D/V 82.8%
Cost of debt 7.5%
Tax Rate as of 2020 18.25%
WACC - required rate of return 7%
ICT Market Growth 2019 (1) 5%
S&P 500 2020 rate of return (2) 18.4%
Risk free rate - US 10-Year Government Bonds Yield (3) 1.75%
Beta (4) 0.56

[1] For ICT Market Growth, please see:

IDC, IDC - Global ICT Spending. Forecast 2020-2023. Accessed 27 January, 2021. Retrieved from: https://www.idc.com/promo/global-ict-spending/forecast

[2] For S&P 500 rate of returns, please see:

Slickcharts, S&P 500 Total Returns. Accessed 27 January, 2021. Retrieved from: https://www.slickcharts.com/sp500/returns

[3] For US 10-Year Government Bonds Yield, please see:

Bloomberg, Markets United States Rates & Bonds. Accessed 27 January, 2021. Retrieved from: https://www.bloomberg.com/markets/rates-bonds/government-bonds/us

[4] For ASBISCs’ Beta , please see:

Finance Yahoo, ASBISc Enterprises Plc. Statistics Accessed 27 January, 2021. Retrieved from: https://finance.yahoo.com/quote/ASB.WA/key-statistics?p=ASB.WA


The Dividend Discount Model 1 (1-year projection)

\[\begin{align} P = \frac D {K - g} \end{align}\]

\[\begin{align} P = \frac {0.43}{0.07 - 0.05} \end{align}\]

\[\begin{align} P = PLN\:21.5 \end{align}\]

Where:

D - Dividend Rate

K - WACC

g - ICT Market Growth


The Dividend Discount Model 2 (1-year projection)

\[\begin{align} P = \frac D {K - g} \end{align}\]

\[\begin{align} P = \frac {0.43}{0.184 - 0.05} \end{align}\]

\[\begin{align} P = PLN\:3.20 \end{align}\]

Where:

D - Dividend Rate

K - Expected S&P 500 2020 rate of return

g - ICT Market Growth


WACC

\[\begin{align} WACC = (E/V \times Re) + ((D/V \times Rd) \times (1-T)) \end{align}\]

\[\begin{align} WACC = (0.172 \times 0.111) + ((0.828 \times 0.075) \times (1-0.1825)) \end{align}\]

\[\begin{align} WACC \approx 0.07 \end{align}\]

Where:

E/V - Equity to total capital

Re - Required rate of return

D/V - Debt to total capital

Rd - Cost of debt

T - Tax rate

\[\begin{align} Re = Rf + \beta \times (Rm - Rf) \end{align}\]

\[\begin{align} Re = 0.0175 + 0.56 \times (0.184 - 0.0175) \end{align}\]

\[\begin{align} Re = 0.111 \end{align}\]


The Dividend Discount Model 3 (5-year stress case projection)

\[\begin{align} P = \frac {0.83}{(1 + 0.184)^1} + \frac {0.78}{(1 + 0.184)^2} + \frac {0.65}{(1 + 0.184)^3} + \frac {0.69}{(1 + 0.184)^4} + \frac {0.61}{(1 + 0.184)^5} \end{align}\]

\[\begin{align} P = PLN\:2.26 \end{align}\]

Where:

r - S&P 500 2020 rate of return

\[\begin{align} P = \frac {0.83}{(1 + 0.07)^1} + \frac {0.78}{(1 + 0.07)^2} + \frac {0.65}{(1 + 0.07)^3} + \frac {0.69}{(1 + 0.07)^4} + \frac {0.61}{(1 + 0.07)^5} \end{align}\]

\[\begin{align} P = PLN\:2.94 \end{align}\]

Where:

r - WACC

The Dividend Discount Model 4 (5-year positive scenario)

2021 2022 2023 2024 2025
Group 1
Revenue 2,839,729.20 3,407,675.04 4,089,210.05 4,907,052.06 5,888,462.47
Earnings in USD 85,192.00 102,230.00 122,676.00 147,212.00 176,654.00
Dividend in USD 23,853.73 28,624.47 34,349.36 41,219.24 49,463.08
Dividend in PLN 92,790.99 111,349.19 133,619.03 160,342.83 192,411.40
Dividend per share in PLN 1.69 2.02 2.43 2.91 3.49
Group 2
Dividend in USD 21,468.35 24,535.26 28,040.30 32,046.05 36,624.06
Dividend in PLN 83,512.00 95,442.00 109,077.00 124,659.00 142,468.00
Dividend per share in PLN 1.52 1.73 1.98 2.26 2.59

General:
Revenue was forecasted at 20% growth rate, whilst earnings as boosted 3% profit margin. Dividend subsequently was converted at historical exchange rate of 3.89 USD/PLN as per 2020.

Group 1:
Dividend: computed at average payout ratio of 28%

Group 2:
Dividend: computed at declining 5% per year


Group 1

\[\begin{align} P = \frac {1.69}{(1 + 0.184)^1} + \frac {2.02}{(1 + 0.184)^2} + \frac {2.43}{(1 + 0.184)^3} + \frac {2.91}{(1 + 0.184)^4} + \frac {3.49}{(1 + 0.184)^5} \end{align}\]

\[\begin{align} P = PLN\:7.31 \end{align}\]

Where:

r - S&P 500 2020 rate of return

\[\begin{align} P = \frac {1.69}{(1 + 0.07)^1} + \frac {2.02}{(1 + 0.07)^2} + \frac {2.43}{(1 + 0.07)^3} + \frac {2.91}{(1 + 0.07)^4} + \frac {3.49}{(1 + 0.07)^5} \end{align}\]

\[\begin{align} P = PLN\:10 \end{align}\]

Where:

r - WACC

Group 2

\[\begin{align} P = \frac {1.52}{(1 + 0.184)^1} + \frac {1.73}{(1 + 0.184)^2} + \frac {1.98}{(1 + 0.184)^3} + \frac {2.26}{(1 + 0.184)^4} + \frac {2.59}{(1 + 0.184)^5} \end{align}\]

\[\begin{align} P = PLN\:6 \end{align}\]

Where:

r - S&P 500 2020 rate of return

\[\begin{align} P = \frac {1.52}{(1 + 0.07)^1} + \frac {1.73}{(1 + 0.07)^2} + \frac {1.98}{(1 + 0.07)^3} + \frac {2.26}{(1 + 0.07)^4} + \frac {2.59}{(1 + 0.07)^5} \end{align}\]

\[\begin{align} P = PLN\:8 \end{align}\]

Where:

r - WACC

DDM Evaluation Table - Multiperiod Growth Model

Terminal value Net present terminal value Forecasted share price (higher results) Forecasted share price + Net present terminal value EPS Price/EPS
DDM 3 (5-year stress case projection) 5.73 2.46 2.94 5.40 2.18 2.48
DDM 4 (5-year positive scenario - group 1) 32.76 14.08 10.00 24.08 12.46 1.93
DDM 4 (5-year positive scenario - group 2) 24.31 10.45 8.00 18.45 11.26 1.64

Terminal value Formula

\[\begin{align} TV = \dfrac{{Dividend_5} \times {1 + g}}{K-g} \end{align}\]

Where:

D - Dividend Rate at year 5

K - S&P 500 2020 rate of return

g - WACC

NPV Terminal value Formula

\[\begin{align} TV = \dfrac{TV}{(1 + K)^5} \end{align}\]

Summary

Please note that dividends in ASBISc’s case are ordinarily paid in the form of advanced and final payments declared in annual reports. However, in this analysis, calculations are based on data contained in cash flow statements on a year-to-year basis.

Both DDMs are grounded on the assumption of n - periods, being infinite and earnings computed as an average net-to-sales ratio, given the revenue growth rate of 20.1% as per geometric mean calculated earlier in an exhibit called “Revenue Growth” under row name “Total”. The averaged dividend payout of 28% was used as a means of determining and establishing future dividend payment and fair valuation range under different assumptions made to the denominator. The dividend per share in PLN represents the conversion at an average $/PLN exchange rate for 2020 (Fusion Media Limited, 2022).
For other assumptions refer directly to data contained in the “Selected Financial Data” table.

A diminutive average net-to-sales of 0.76% is a vital indicator of the earnings margin being inadequate to accommodate future sales decline and delineate risk exposure with regard to insufficient cash levels and reduced liquidity. One year price projection via dividend discount model ranges from PLN 3.20 - 21.5 showing high volatility of this particular stock pricing and alerts that any potential economic downturn might dwindle the sales and decrease if not gradually eliminate the dividend payments.

5-year stress case projections, however, lean towards the lower bound, oscillating between PLN 2.26 - 2.94 indicating what can happen in a negative revenue scenario and what possible capital loss can be inflicted against the current share price of PLN 10.02 (04/03/2022).

Positive 5-year exhibit showcases the appraisal considering a constant revenue growth of 20% and improved profitability margin (net to earnings) of 3%. In the first instance, dividend payout ratio remained at historical average of 28% with share price ranging from PLN 7.31-10. Whilst, in the later example, the dividend payout ratio reflects the current downward trend, with assumed decline of 5% annually, and stock price range between PLN 6-8.

Under Multi-Period DDM Growth Model, a net present terminal share price has been established and added to previously computed net present dividends variants. In a negative scenario, the share price melts to the notch of PLN 5.4, which might be indicative of the lowest threshold, at which it would be ideal to acquire the company’s stocks thereby maximising returns. In either positive scenarios, assuming constant revenue growth and despite the decreasing dividend payout ratio in the second instance, values return to PLN 18.45 - 24.08. Purchasing a stock at PLN 5.4 and selling it at 24.08 would have amounted to 346% rate of return. The following models exhibit that once company had dealt with possible sales declines, the share price is likely to go back to the level around PLN 20.

I would personally be inclined to purchasing this stock at the threshold below PLN 5 to accommodate for the intrinsically written risk to minimise the capital loss and get greater returns for higher risk incurred (high leverage). In the current geopolitical situation arisen from the war in Ukraine, such a scenario seem to be highly probable, taking into account that nearly 9% of the company’s revenue in 2020 derived from Ukraine, another c.9% from Russia and approximately 6% from Belarus. With the imposition of sanctions that might vary from the company’s standing and their government actions, these might affect future performance and hence, the final stock price.