Cash flow Mr D.I.Y. Group (M)

Equities

5296

MYL5296OO008

Home Improvement Products & Services Retailers

Delayed BURSA MALAYSIA Other stock markets 08:11:37 2025-02-09 pm EST			5-day change	1st Jan Change
1.660 ^MYR	-1.19%		+0.61%	-10.27%

Nov. 25	Mr. D.I.Y.'s Indonesian Business Aims to Raise About $297 Million in IPO	DJ
Nov. 25	Mr. DIY Group's Indonesian Affiliate to Raise Up to 4.7 Trillion Indonesian Rupiah in IPO	MT

15fc7d2d620e79a8e0ea375f63d4d.vEKwUq1tTGa9jweffjo80Ij_Bdn0jrVus0KlbR_3GSA.iAvpDc87YSmP10TKL25mh-GaQY662v9X8if6XH6YThT6G9k9xxsvDcrLdA

Published financial data: MR D.I.Y. GROUP (M)

Annual

Quarterly

Halfyear

YTD

LTM

Fiscal Period: December	2019	2020	2021	2022	2023
Revenues	2.28B	2.56B	3.37B	3.99B	4.36B
Total Revenues	2.28B	2.56B	3.37B	3.99B	4.36B
Cost of Goods Sold, Total	1.32B	1.47B	1.98B	2.34B	2.38B
Gross Profit	954M	1.09B	1.39B	1.65B	1.98B
Selling General & Admin Expenses, Total	61.22M	90.23M	117M	151M	177M
Other Operating Expenses	385M	477M	634M	796M	983M
Other Operating Expenses, Total	446M	567M	751M	948M	1.16B
Operating Income	508M	524M	641M	700M	818M
Interest Expense, Total	-63.89M	-68.33M	-59.92M	-62.42M	-69.34M
Interest And Investment Income	3.12M	3.17M	1.66M	2.02M	4.57M
Net Interest Expenses	-60.77M	-65.16M	-58.26M	-60.4M	-64.76M
Income (Loss) On Equity Invest.	1.71M	1.92M	2.12M	4.02M	3.62M
Currency Exchange Gains (Loss)	334K	-	-	-	-
EBT, Excl. Unusual Items	449M	461M	585M	643M	757M
Gain (Loss) On Sale Of Assets	306K	-	-	-	-
Asset Writedown	-1.94M	-1.09M	-2.07M	-3.23M	-3.43M
Other Unusual Items	-9.8M	-2.25M	3.66M	1.42M	-
EBT, Incl. Unusual Items	438M	458M	586M	641M	753M
Income Tax Expense	120M	121M	155M	168M	192M
Earnings From Continuing Operations	318M	337M	432M	473M	561M
Net Income to Company	318M	337M	432M	473M	561M
Net Income - (IS)	318M	337M	432M	473M	561M
Net Income to Common Incl Extra Items	318M	337M	432M	473M	561M
Net Income to Common Excl. Extra Items	318M	337M	432M	473M	561M
Per Share Items
Net EPS - Basic	211.71	0.13	0.05	0.05	0.06
Basic EPS - Continuing Operations	211.71	0.13	0.05	0.05	0.06
Basic Weighted Average Shares Outstanding	1.5M	2.52B	9.42B	9.43B	9.44B
Net EPS - Diluted	211.71	0.13	0.05	0.05	0.06
Diluted EPS - Continuing Operations	211.71	0.13	0.05	0.05	0.06
Diluted Weighted Average Shares Outstanding	1.5M	2.53B	9.45B	9.46B	9.45B
Normalized Basic EPS	187.15	0.11	0.04	0.04	0.05
Normalized Diluted EPS	187.15	0.11	0.04	0.04	0.05
Dividend Per Share	344.49	0.01	0.02	0.02	0.03
Payout Ratio	157.45	28.42	39.98	43.18	47.13
Supplemental Items
EBITDA	550M	577M	712M	785M	916M
EBITA	509M	525M	642M	700M	819M
EBIT	508M	524M	641M	700M	818M
EBITDAR	557M	586M	723M	799M	934M
Effective Tax Rate - (Ratio)	27.45	26.33	26.36	26.26	25.56
Total Current Taxes	119M	126M	145M	171M	197M
Total Deferred Taxes	1.06M	-5.43M	9.38M	-2.66M	-4.77M
Normalized Net Income	281M	288M	366M	402M	473M
Interest on Long-Term Debt	55.47M	61.12M	52.16M	54.9M	58.97M
Supplemental Operating Expense Items
Advertising Expense	7.84M	-	-	-	-
Selling and Marketing Expenses	7.84M	-	-	-	-
General and Administrative Expenses	46.44M	90.23M	117M	151M	177M
Net Rental Expense, Total	6.94M	8.8M	11M	14.08M	17.73M
Imputed Operating Lease Interest Expense	3.56M	3.77M	4.18M	4.75M	6.22M
Imputed Operating Lease Depreciation	3.38M	5.02M	6.82M	9.33M	11.51M
Maintenance & Repair Expenses, Total	9.72M	-	-	-	-
Stock-Based Comp., Other (Total)	-	1.21M	6.79M	2.99M	1.32M
Total Stock-Based Compensation	-	1.21M	6.79M	2.99M	1.32M

Fiscal Period: December	2019	2020	2021	2022	2023
Assets
Cash And Equivalents	141M	90.88M	193M	138M	232M
Short Term Investments	51.67M	64.31M	58M	64.68M	72.48M
Total Cash And Short Term Investments	192M	155M	251M	203M	305M
Accounts Receivable, Total	4.18M	2.9M	5.01M	7.48M	12.37M
Other Receivables	3.37M	2.32M	4.18M	4.65M	5.69M
Total Receivables	7.56M	5.22M	9.19M	12.14M	18.05M
Inventory	553M	740M	816M	1.14B	1.09B
Prepaid Expenses	6.29M	8.1M	8.9M	16.6M	12.65M
Other Current Assets, Total	-	-	-	-	-
Total Current Assets	759M	909M	1.08B	1.38B	1.43B
Gross Property Plant And Equipment	1.42B	1.84B	2.31B	2.86B	3.29B
Accumulated Depreciation	-377M	-522M	-717M	-946M	-1.23B
Net Property Plant And Equipment	1.04B	1.32B	1.59B	1.91B	2.06B
Long-term Investments	4.76M	6.23M	7.89M	9.87M	34.25M
Other Intangibles, Total	3.73M	5.04M	6.2M	6.96M	7.65M
Deferred Tax Assets Long-Term	11.86M	17.27M	13.72M	17.06M	20.96M
Total Assets	1.82B	2.25B	2.7B	3.32B	3.55B
Liabilities
Accounts Payable, Total	23.87M	37.62M	46.38M	51.2M	66M
Accrued Expenses, Total	37.47M	47.6M	67.04M	79.33M	88.19M
Short-term Borrowings	7.11M	26.11M	16.77M	22.97M	19.34M
Current Portion of Long-Term Debt	4.27M	216M	175M	295M	171M
Current Portion of Leases	94.65M	121M	148M	179M	200M
Current Income Taxes Payable	34.37M	39.54M	48.47M	49.92M	60.64M
Other Current Liabilities	20.97M	35.24M	37.06M	43.4M	35.92M
Total Current Liabilities	223M	524M	538M	721M	641M
Long-Term Debt	609M	18.41M	13.54M	8.67M	7.64M
Long-Term Leases	635M	816M	971M	1.13B	1.13B
Deferred Tax Liability Non Current	2.34M	2.32M	8.15M	8.84M	7.98M
Other Non Current Liabilities	14.22M	16.01M	20.34M	20.34M	22.33M
Total Liabilities	1.48B	1.38B	1.55B	1.89B	1.81B
Common Stock, Total	1.97M	296M	303M	317M	333M
Additional Paid In Capital	-	-	-	-	-
Retained Earnings	456M	697M	956M	1.23B	1.52B
Comprehensive Income and Other	-117M	-116M	-111M	-109M	-109M
Total Common Equity	340M	877M	1.15B	1.43B	1.75B
Total Equity	340M	877M	1.15B	1.43B	1.75B
Total Liabilities And Equity	1.82B	2.25B	2.7B	3.32B	3.55B
Supplemental Items
ECS Total Shares Outstanding on Filing Date	1.5M	9.41B	9.42B	9.43B	9.45B
ECS Total Common Shares Outstanding	1.5M	9.41B	9.42B	9.43B	9.44B
Book Value / Share	226.98	0.09	0.12	0.15	0.18
Tangible Book Value	337M	872M	1.14B	1.43B	1.74B
Tangible Book Value Per Share	224.5	0.09	0.12	0.15	0.18
Total Debt	1.35B	1.2B	1.32B	1.64B	1.52B
Net Debt	1.16B	1.04B	1.07B	1.44B	1.22B
Debt Equivalent Oper. Leases	55.52M	70.39M	88M	113M	142M
Equity Method Investments, Total	4.76M	6.23M	7.89M	9.87M	34.25M
Account Code - Inventory Valuation	6	6	6	6	6
Inventories - Finished Goods, Total	497M	690M	749M	1.1B	1.08B
Land - (BS)	58.46M	70.54M	83.69M	108M	108M
Buildings, Total	13.43M	45.3M	45.3M	45.32M	55.24M
Machinery, Total	253M	337M	451M	564M	657M
Full Time Employees	9.47K	11.61K	12.5K	16.5K	18K

Fiscal Period: December	2019	2020	2021	2022	2023
Net Income	318M	337M	432M	473M	561M
Depreciation & Amortization - CF	138M	171M	227M	264M	301M
Amortization of Goodwill and Intangible Assets - (CF)	717K	624K	707K	902K	1.12M
Depreciation & Amortization, Total	139M	172M	227M	265M	302M
Amortization of Deferred Charges, Total - (CF)	917K	1.19M	1.74M	2.16M	2.5M
(Gain) Loss From Sale Of Asset	-306K	-370K	-328K	-200K	-181K
Asset Writedown & Restructuring Costs	1.94M	1.09M	2.07M	3.23M	3.43M
(Income) Loss On Equity Investments - (CF)	-1.71M	-1.92M	-2.12M	-4.02M	-3.62M
Stock-Based Compensation (CF)	-	1.21M	6.79M	2.99M	1.32M
Other Operating Activities, Total	98.01M	77.13M	83.84M	84.17M	106M
Change In Accounts Receivable	-40.62M	-5.95M	-28.24M	5.67M	27.2M
Change In Inventories	-109M	-218M	-80.82M	-386M	-26M
Change In Accounts Payable	-1.72M	21.68M	8.69M	-2.75M	-1.89M
Cash from Operations	403M	385M	651M	443M	972M
Capital Expenditure	-115M	-120M	-145M	-214M	-229M
Sale of Property, Plant, and Equipment	487K	921K	2.07M	3.05M	1.81M
Cash Acquisitions	-105M	-	-	-	-
Sale (Purchase) of Intangible assets	-1.85M	-2.13M	-2.43M	-2.63M	-2.51M
Investment in Marketable and Equity Securities, Total	-	-	-	-	-22.4M
Other Investing Activities, Total	3.42M	3.62M	2.12M	4.07M	6.21M
Cash from Investing	-218M	-118M	-143M	-210M	-246M
Short Term Debt Issued, Total	-	-	50.67M	230M	30M
Long-Term Debt Issued, Total	600M	213M	-	-	-
Total Debt Issued	600M	213M	50.67M	230M	30M
Short Term Debt Repaid, Total	-	-	-92.33M	-110M	-150M
Long-Term Debt Repaid, Total	-139M	-679M	-129M	-160M	-189M
Total Debt Repaid	-139M	-679M	-221M	-270M	-339M
Issuance of Common Stock	-	302M	6.36M	10.99M	13.41M
Common Dividends Paid	-500M	-95.82M	-173M	-204M	-264M
Common & Preferred Stock Dividends Paid	-500M	-95.82M	-173M	-204M	-264M
Other Financing Activities, Total	-71.79M	-67.6M	-59.58M	-61.87M	-69.04M
Cash from Financing	-111M	-328M	-396M	-295M	-628M
Foreign Exchange Rate Adjustments	-60K	-6K	28K	545K	347K
Net Change in Cash	74.49M	-60.6M	111M	-61M	98.11M
Supplemental Items
Cash Interest Paid	62.03M	67.9M	59.58M	61.87M	69.04M
Cash Income Tax Paid (Refund)	111M	121M	139M	171M	188M
Levered Free Cash Flow	103M	194M	410M	136M	619M
Unlevered Free Cash Flow	143M	237M	448M	175M	662M
Change In Net Working Capital	197M	143M	41.18M	315M	-76.24M
Net Debt Issued / Repaid	461M	-466M	-170M	-39.55M	-309M

Fiscal Period: December	2019	2020	2021	2022	2023
Profitability
Return on Assets	19.79	16.07	16.17	14.52	14.87
Return on Total Capital	22.21	17.4	17.62	15.77	16.12
Return On Equity %	73.42	55.4	42.63	36.63	35.28
Return on Common Equity	73.42	55.4	42.63	36.63	35.28
Margin Analysis
Gross Profit Margin %	41.92	42.65	41.26	41.33	45.36
SG&A Margin	2.69	3.53	3.47	3.79	4.05
EBITDA Margin %	24.18	22.55	21.09	19.69	21.02
EBITA Margin %	22.35	20.51	19.02	17.57	18.78
EBIT Margin %	22.32	20.48	19	17.55	18.76
Income From Continuing Operations Margin %	13.96	13.17	12.8	11.87	12.86
Net Income Margin %	13.96	13.17	12.8	11.87	12.86
Net Avail. For Common Margin %	13.96	13.17	12.8	11.87	12.86
Normalized Net Income Margin	12.34	11.26	10.84	10.09	10.85
Levered Free Cash Flow Margin	4.51	7.58	12.16	3.42	14.19
Unlevered Free Cash Flow Margin	6.27	9.25	13.27	4.4	15.19
Asset Turnover
Asset Turnover	1.42	1.26	1.36	1.32	1.27
Fixed Assets Turnover	2.47	2.17	2.32	2.28	2.19
Receivables Turnover (Average Receivables)	775.46	722.26	852.09	637.84	439.22
Inventory Turnover (Average Inventory)	2.66	2.27	2.55	2.39	2.13
Short Term Liquidity
Current Ratio	3.41	1.74	2.01	1.91	2.23
Quick Ratio	0.9	0.31	0.48	0.3	0.5
Operating Cash Flow to Current Liabilities	1.81	0.74	1.21	0.61	1.52
Days Sales Outstanding (Average Receivables)	0.47	0.51	0.43	0.57	0.83
Days Outstanding Inventory (Average Inventory)	137.2	161.22	143.28	152.97	171.46
Average Days Payable Outstanding	5.21	6.8	7.45	6.68	9.18
Cash Conversion Cycle (Average Days)	132.46	154.92	136.26	146.86	163.11
Long Term Solvency
Total Debt/Equity	396.58	136.65	115.21	114.3	87.36
Total Debt / Total Capital	79.86	57.74	53.53	53.34	46.63
LT Debt/Equity	365.44	95.17	85.67	79.62	65.01
Long-Term Debt / Total Capital	73.59	40.22	39.81	37.16	34.7
Total Liabilities / Total Assets	81.33	61.09	57.45	56.89	50.85
EBIT / Interest Expense	7.95	7.67	10.7	11.21	11.79
EBITDA / Interest Expense	10.12	10.19	14.49	15.45	16.15
(EBITDA - Capex) / Interest Expense	8.32	8.44	12.07	12.02	12.85
Total Debt / EBITDA	2.09	1.72	1.52	1.7	1.36
Net Debt / EBITDA	1.79	1.5	1.24	1.49	1.09
Total Debt / (EBITDA - Capex)	2.54	2.08	1.83	2.18	1.71
Net Debt / (EBITDA - Capex)	2.18	1.81	1.48	1.91	1.37
Growth Over Prior Year
Total Revenues, 1 Yr. Growth %	28.49	12.47	31.81	18.15	9.37
Gross Profit, 1 Yr. Growth %	24.26	13.26	27.52	18.34	20.03
EBITDA, 1 Yr. Growth %	20.52	6.66	26.06	10.27	16.79
EBITA, 1 Yr. Growth %	19.51	5.09	25.28	9.16	16.91
EBIT, 1 Yr. Growth %	19.53	5.12	25.3	9.14	16.9
Earnings From Cont. Operations, 1 Yr. Growth %	3	6.17	28.08	9.52	18.55
Net Income, 1 Yr. Growth %	3	6.17	28.08	9.52	18.55
Normalized Net Income, 1 Yr. Growth %	12.74	4.85	30.45	9.98	17.64
Diluted EPS Before Extra, 1 Yr. Growth %	3	295.2	-65.72	9.41	18.6
Accounts Receivable, 1 Yr. Growth %	148.1	-30.58	72.66	49.26	65.23
Inventory, 1 Yr. Growth %	25.48	33.86	10.18	40.36	-4.48
Net Property, Plant and Equip., 1 Yr. Growth %	30.86	25.97	20.73	20.48	7.6
Total Assets, 1 Yr. Growth %	31.83	23.52	19.87	23.07	6.84
Tangible Book Value, 1 Yr. Growth %	-35.51	158.84	31.13	24.75	21.86
Common Equity, 1 Yr. Growth %	-35.09	157.49	31.09	24.68	21.8
Cash From Operations, 1 Yr. Growth %	51.59	-4.5	68.98	-31.94	119.39
Capital Expenditures, 1 Yr. Growth %	-7.21	4.21	21.12	47.59	6.74
Levered Free Cash Flow, 1 Yr. Growth %	34.01	100.09	120.46	-66.75	353.66
Unlevered Free Cash Flow, 1 Yr. Growth %	50.07	72.92	95.68	-60.82	277.47
Dividend Per Share, 1 Yr. Growth %	222.24	-100	107.37	11.68	45.45
Compound Annual Growth Rate Over Two Years
Total Revenues, 2 Yr. CAGR %	36.06	20.21	21.76	24.8	13.68
Gross Profit, 2 Yr. CAGR %	33.17	19.24	20.18	22.85	19.18
EBITDA, 2 Yr. CAGR %