Cash flow Magazine Luiza S.A.

Equities

MGLU3

BRMGLUACNOR2

Department Stores

Market Closed - Sao Paulo Other stock markets 21:07:42 06/09/2024 BST			5-day change	1st Jan Change
11.80 ^BRL	-2.96%		-2.96%	-45.37%

09-02	Magazine Luiza S.A.(BOVESPA:MGLU3) added to Brazil Valor BM&FBOVESPA Index	CI
08-09	Transcript : Magazine Luiza S.A., Q2 2024 Earnings Call, Aug 09, 2024

59db97c66d9ada47dc.sSAbW0AL5pqZht7OS14DIBfwybsPaX25bLCr7YaeZdw.6FZzIy5hjt7o34ujERhuQk6XnPw3EDn0NeP0o7T8K4Pmb10RcTmu8fzNhw

Published financial data: MAGAZINE LUIZA S.A.

Annual

Quarterly

Halfyear

YTD

LTM

Fiscal Period: December	2019	2020	2021	2022	2023
Revenues	19.89B	29.18B	35.28B	37.3B	36.77B
Total Revenues	19.89B	29.18B	35.28B	37.3B	36.77B
Cost of Goods Sold, Total	14.33B	21.66B	26.79B	26.86B	26.6B
Gross Profit	5.55B	7.52B	8.49B	10.44B	10.16B
Selling General & Admin Expenses, Total	4.15B	6.07B	7.41B	8.11B	8.34B
Provision for Bad Debts	75.99M	118M	154M	240M	386M
Depreciation & Amortization - (IS)	487M	703M	817M	1.16B	1.24B
Other Operating Expenses	-57.58M	-	-	-	680M
Other Operating Expenses, Total	4.65B	6.89B	8.38B	9.51B	10.65B
Operating Income	903M	630M	110M	924M	-482M
Interest Expense, Total	-238M	-252M	-420M	-1.29B	-1.37B
Interest And Investment Income	66.33M	77.62M	116M	286M	328M
Net Interest Expenses	-172M	-175M	-305M	-1B	-1.04B
Income (Loss) On Equity Invest.	26.61M	120M	99.33M	-35.74M	-19.01M
Currency Exchange Gains (Loss)	-	-	-	-	-
Other Non Operating Income (Expenses)	102M	-236M	-384M	-1.04B	-652M
EBT, Excl. Unusual Items	859M	339M	-480M	-1.15B	-2.19B
Merger & Related Restructuring Charges	-	-	-	-30.42M	-27.66M
Impairment of Goodwill	-	-	-	-	-
Gain (Loss) On Sale Of Investments	-	-	-	-	202M
Gain (Loss) On Sale Of Assets	7.24M	-3.34M	964K	-695K	-
Asset Writedown	-	-	-	-	-20.51M
Legal Settlements	-241M	35.37M	421M	-34.66M	-363M
Other Unusual Items	593M	42.71M	-160M	-51.15M	338M
EBT, Incl. Unusual Items	1.22B	414M	-218M	-1.27B	-2.06B
Income Tax Expense	296M	22.37M	-809M	-770M	-1.09B
Earnings From Continuing Operations	922M	392M	591M	-499M	-979M
Net Income to Company	922M	392M	591M	-499M	-979M
Net Income - (IS)	922M	392M	591M	-499M	-979M
Net Income to Common Incl Extra Items	922M	392M	591M	-499M	-979M
Net Income to Common Excl. Extra Items	922M	392M	591M	-499M	-979M
Per Share Items
Net EPS - Basic	1.42	0.61	0.89	-0.75	-1.46
Basic EPS - Continuing Operations	1.42	0.61	0.89	-0.75	-1.46
Basic Weighted Average Shares Outstanding	648M	646M	667M	668M	669M
Net EPS - Diluted	1.4	0.6	0.88	-0.75	-1.46
Diluted EPS - Continuing Operations	1.4	0.6	0.88	-0.75	-1.46
Diluted Weighted Average Shares Outstanding	656M	654M	674M	668M	669M
Normalized Basic EPS	0.83	0.33	-0.45	-1.08	-2.05
Normalized Diluted EPS	0.82	0.32	-0.45	-1.08	-2.05
Dividend Per Share	-	0.42	0.15	-	-
Payout Ratio	19.74	76.44	24.74	-20.03	-
American Depositary Receipts Ratio (ADR)	4	4	4	4	4
Supplemental Items
EBITDA	1.02B	838M	333M	1.23B	-178M
EBITA	903M	675M	152M	988M	-428M
EBIT	903M	630M	110M	924M	-482M
EBITDAR	1.1B	927M	404M	1.31B	-95.71M
Effective Tax Rate - (Ratio)	24.33	5.4	370.44	60.69	52.57
Current Domestic Taxes	125M	222M	-110M	34.72M	68.93M
Total Current Taxes	125M	222M	-110M	34.72M	68.93M
Deferred Domestic Taxes	171M	-200M	-699M	-805M	-1.15B
Total Deferred Taxes	171M	-200M	-699M	-805M	-1.15B
Normalized Net Income	537M	212M	-300M	-720M	-1.37B
Interest on Long-Term Debt	152M	179M	225M	298M	310M
Supplemental Operating Expense Items
Selling and Marketing Expenses	3.44B	5.16B	6.37B	6.74B	7B
General and Administrative Expenses	702M	907M	1.03B	1.37B	1.34B
Net Rental Expense, Total	89.3M	88.95M	71.91M	73.36M	82.45M
Imputed Operating Lease Interest Expense	95.01M	48.89M	33.44M	71.83M	83.03M
Imputed Operating Lease Depreciation	-5.71M	40.06M	38.47M	1.53M	-588K
Stock-Based Comp., Other (Total)	84.36M	111M	118M	117M	68.32M
Total Stock-Based Compensation	84.36M	111M	118M	117M	68.32M

Fiscal Period: December	2019	2020	2021	2022	2023
Assets
Cash And Equivalents	306M	1.68B	2.57B	2.42B	2.59B
Short Term Investments	4.45B	1.22B	1.56B	304M	779M
Trading Asset Securities, Total	-	-	-	-	-
Total Cash And Short Term Investments	4.75B	2.9B	4.12B	2.72B	3.37B
Accounts Receivable, Total	3.29B	7.09B	9.36B	9.34B	7.16B
Other Receivables	864M	716M	1.51B	1.88B	1.75B
Total Receivables	4.15B	7.81B	10.87B	11.22B	8.91B
Inventory	3.8B	5.93B	9.11B	7.79B	7.5B
Other Current Assets, Total	136M	161M	403M	208M	438M
Total Current Assets	12.84B	16.8B	24.51B	21.94B	20.22B
Gross Property Plant And Equipment	4.67B	5.41B	7.35B	8.33B	8.83B
Accumulated Depreciation	-1.32B	-1.69B	-2.05B	-2.86B	-3.65B
Net Property Plant And Equipment	3.35B	3.72B	5.3B	5.47B	5.18B
Long-term Investments	305M	387M	408M	339M	323M
Goodwill	870M	1.1B	2.25B	2.25B	2.25B
Other Intangibles, Total	676M	782M	2.05B	2.17B	2.25B
Accounts Receivable Long-Term	16.84M	16.14M	17.35M	17.16M	72.69M
Deferred Tax Assets Long-Term	12.71M	197M	915M	1.69B	2.84B
Other Long-Term Assets, Total	1.72B	1.64B	2.93B	3.89B	4.31B
Total Assets	19.79B	24.65B	38.38B	37.77B	37.46B
Liabilities
Accounts Payable, Total	5.93B	8.5B	10.1B	9.54B	9.32B
Accrued Expenses, Total	357M	370M	373M	424M	415M
Short-term Borrowings	-	822M	4.05M	-	-
Current Portion of Long-Term Debt	9.97M	845M	408M	124M	2.95B
Current Portion of Leases	331M	351M	434M	620M	508M
Current Income Taxes Payable	352M	401M	240M	225M	360M
Unearned Revenue Current, Total	43.04M	43.01M	50.33M	76.91M	146M
Other Current Liabilities	976M	2.08B	3.65B	3.82B	3.7B
Total Current Liabilities	8B	13.42B	15.26B	14.83B	17.41B
Long-Term Debt	839M	19.58M	6.38B	6.98B	4.4B
Long-Term Leases	1.95B	2.18B	3.02B	3.07B	3.07B
Unearned Revenue Non Current	357M	301M	245M	423M	1.1B
Deferred Tax Liability Non Current	39.04M	24.84M	114M	109M	105M
Other Non Current Liabilities	1.04B	1.38B	2.1B	1.69B	1.76B
Total Liabilities	12.23B	17.32B	27.12B	27.12B	27.84B
Common Stock, Total	5.95B	5.95B	12.35B	12.35B	12.35B
Retained Earnings	1.41B	1.57B	1.99B	1.44B	457M
Treasury Stock	-125M	-604M	-1.45B	-1.25B	-991M
Comprehensive Income and Other	326M	402M	-1.64B	-1.89B	-2.21B
Total Common Equity	7.56B	7.33B	11.26B	10.65B	9.61B
Total Equity	7.56B	7.33B	11.26B	10.65B	9.61B
Total Liabilities And Equity	19.79B	24.65B	38.38B	37.77B	37.46B
Supplemental Items
ECS Total Shares Outstanding on Filing Date	648M	646M	667M	668M	669M
ECS Total Common Shares Outstanding	648M	646M	667M	668M	669M
Book Value / Share	11.67	11.33	16.89	15.95	14.36
Tangible Book Value	6.02B	5.44B	6.95B	6.22B	5.11B
Tangible Book Value Per Share	9.29	8.41	10.43	9.32	7.63
Total Debt	3.13B	4.21B	10.25B	10.8B	10.93B
Net Debt	-1.62B	1.31B	6.13B	8.08B	7.56B
Debt Equivalent Oper. Leases	714M	712M	575M	587M	660M
Equity Method Investments, Total	305M	387M	408M	339M	323M
Account Code - Inventory Valuation	6	6	6	6	6
Inventories - Raw Materials, Total	25.28M	38.64M	65.7M	31.38M	35.42M
Inventories - Finished Goods, Total	3.97B	5.99B	9.21B	7.94B	7.64B
Machinery, Total	842M	981M	1.49B	1.58B	1.65B
Full Time Employees	30K	40K	40K	-	-

Fiscal Period: December	2019	2020	2021	2022	2023
Net Income	922M	392M	591M	-499M	-979M
Depreciation & Amortization - CF	404M	539M	644M	855M	853M
Amortization of Goodwill and Intangible Assets - (CF)	16K	44.98M	42.97M	63.99M	54.34M
Depreciation & Amortization, Total	404M	584M	687M	919M	908M
Amortization of Deferred Charges, Total - (CF)	82.57M	118M	130M	245M	335M
(Gain) Loss From Sale Of Asset	-4.99M	1.9M	-588K	695K	-
(Gain) Loss on Sale of Investments - (CF)	-	-	-	-37.66M	-40.49M
Asset Writedown & Restructuring Costs	-40.64M	-161M	-2.85M	-	-768M
(Income) Loss On Equity Investments - (CF)	-26.61M	-120M	-99.33M	35.74M	19.01M
Stock-Based Compensation (CF)	84.36M	111M	118M	117M	68.32M
Provision and Write-off of Bad Debts	106M	127M	174M	343M	523M
Other Operating Activities, Total	1.1B	436M	-466M	615M	728M
Change In Accounts Receivable	-1.05B	-3.88B	-1.99B	-306M	2.02B
Change In Inventories	-1.03B	-2.07B	-2.92B	1.15B	231M
Change In Accounts Payable	1.44B	2.54B	1.18B	130M	1.17B
Change In Income Taxes	-1.35B	396M	-1.46B	-930M	-233M
Change in Other Net Operating Assets	-3.97B	4.13B	-301M	1.28B	-633M
Cash from Operations	-3.33B	2.6B	-4.36B	3.06B	3.35B
Capital Expenditure	-399M	-372M	-863M	-265M	-168M
Sale of Property, Plant, and Equipment	-	-	-	-	-
Cash Acquisitions	-407M	-108M	-153M	-620M	-529M
Sale (Purchase) of Intangible assets	-122M	-172M	-301M	-158M	382M
Investment in Marketable and Equity Securities, Total	-	-	-	-	167M
Other Investing Activities, Total	-	-	-	-	-
Cash from Investing	-929M	-651M	-1.32B	-1.04B	-148M
Long-Term Debt Issued, Total	799M	801M	6.3B	400M	-
Total Debt Issued	799M	801M	6.3B	400M	-
Long-Term Debt Repaid, Total	-821M	-313M	-2.06B	-870M	-517M
Total Debt Repaid	-821M	-313M	-2.06B	-870M	-517M
Issuance of Common Stock	4.44B	-	3.98B	-	-
Repurchase of Common Stock	-	-567M	-1.05B	-	-
Common Dividends Paid	-182M	-299M	-146M	-99.97M	-
Common & Preferred Stock Dividends Paid	-182M	-299M	-146M	-99.97M	-
Other Financing Activities, Total	-272M	-198M	-457M	-1.6B	-2.52B
Cash from Financing	3.96B	-577M	6.57B	-2.17B	-3.03B
Net Change in Cash	-293M	1.38B	885M	-146M	173M
Supplemental Items
Cash Interest Paid	205M	198M	376M	938M	1.07B
Cash Income Tax Paid (Refund)	52.13M	118M	97.06M	59.83M	38.86M
Levered Free Cash Flow	186M	-1.57B	-3.9B	1.48B	2.59B
Unlevered Free Cash Flow	335M	-1.41B	-3.64B	2.29B	3.44B
Change In Net Working Capital	279M	2.07B	3.48B	-851M	-2.22B
Net Debt Issued / Repaid	-22.37M	488M	4.24B	-470M	-517M

Fiscal Period: December	2019	2020	2021	2022	2023
Profitability
Return on Assets	3.95	1.77	0.22	1.52	-0.8
Return on Total Capital	8.39	3.54	0.41	2.69	-1.44
Return On Equity %	18.68	5.26	6.36	-4.55	-9.67
Return on Common Equity	18.68	5.26	6.36	-4.55	-9.67
Margin Analysis
Gross Profit Margin %	27.93	25.77	24.06	27.99	27.64
SG&A Margin	20.85	20.8	20.99	21.75	22.68
EBITDA Margin %	5.1	2.87	0.94	3.31	-0.48
EBITA Margin %	4.54	2.31	0.43	2.65	-1.16
EBIT Margin %	4.54	2.16	0.31	2.48	-1.31
Income From Continuing Operations Margin %	4.64	1.34	1.67	-1.34	-2.66
Net Income Margin %	4.64	1.34	1.67	-1.34	-2.66
Net Avail. For Common Margin %	4.64	1.34	1.67	-1.34	-2.66
Normalized Net Income Margin	2.7	0.73	-0.85	-1.93	-3.73
Levered Free Cash Flow Margin	0.94	-5.37	-11.05	3.97	7.04
Unlevered Free Cash Flow Margin	1.69	-4.83	-10.31	6.13	9.37
Asset Turnover
Asset Turnover	1.39	1.31	1.12	0.98	0.98
Fixed Assets Turnover	9.69	8.25	7.82	6.93	6.9
Receivables Turnover (Average Receivables)	7.2	5.62	4.29	3.99	4.46
Inventory Turnover (Average Inventory)	4.34	4.45	3.56	3.18	3.48
Short Term Liquidity
Current Ratio	1.6	1.25	1.61	1.48	1.16
Quick Ratio	1.11	0.8	0.98	0.94	0.71
Operating Cash Flow to Current Liabilities