Financials Magazine Luiza S.A.

Equities

MGLU3

BRMGLUACNOR2

Department Stores

Market Closed - Sao Paulo Other stock markets 21:07:58 12/09/2024 BST			5-day change	1st Jan Change
11.17 ^BRL	-0.89%		-9.19%	-48.29%

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

Projected Income Statement: Magazine Luiza S.A.

Fiscal Period: December	2019	2020	2021	2022	2023	2024	2025	2026
Net sales ¹	19,886	29,177	35,278	37,299	36,768	39,046	41,843	45,047
Change	-	46.72%	20.91%	5.73%	-1.42%	6.2%	7.16%	7.66%
EBITDA ¹	1,304	1,506	1,477	2,128	2,132	2,971	3,451	3,877
Change	-	15.5%	-1.92%	44.03%	0.2%	39.37%	16.13%	12.36%
EBIT ¹	1,093	824.6	470.6	771.6	-372.1	1,635	2,093	2,530
Change	-	-24.56%	-42.93%	63.96%	-	-	27.99%	20.87%
Interest Paid ¹	-378.7	-410.5	-689	-2,041	-2,058	-1,436	-1,404	-1,368
Earnings before Tax (EBT) ¹	1,218	414.1	-218.4	-1,269	-2,064	243.5	823.2	1,254
Change	-	-66.01%	-	481.23%	62.63%	-	238.11%	52.37%
Net income ¹	921.8	391.7	590.7	-499	-979.1	249.1	616.4	959.9
Change	-	-57.51%	50.8%	-	96.21%	-	147.42%	55.72%
Announcement Date	17/02/20	08/03/21	14/03/22	10/03/23	18/03/24	-	-	-

¹BRL in Million

Estimates

Fiscal Period: December	2019 Q3	2019 Q4	2020 Q1	2020 Q2	2020 Q3	2020 Q4	2021 Q1	2021 Q2	2021 Q3	2021 Q4	2022 Q1	2022 Q2	2022 Q3	2022 Q4	2023 Q1	2023 Q2	2023 Q3	2023 Q4	2024 Q1	2024 Q2	2024 Q3	2024 Q4	2025 Q1	2025 Q2	2025 Q3	2025 Q4	2026 Q1	2026 Q2
Net sales ¹	4,864	6,385	5,235	5,568	8,308	10,066	8,253	9,013	8,612	9,400	8,762	8,562	8,807	11,167	9,067	8,572	8,579	10,550	9,239	9,010	9,249	11,465	9,929	9,651	9,857	12,175	10,414	10,076
Change	-	31.27%	-18.02%	6.37%	49.21%	21.15%	-18.01%	9.22%	-4.45%	9.15%	-6.79%	-2.28%	2.86%	26.8%	-18.81%	-5.46%	0.08%	22.97%	-12.42%	-2.48%	2.65%	23.96%	-13.39%	-2.8%	2.13%	23.51%	-14.46%	-3.25%
EBITDA ¹	300.7	394.5	332.6	147.2	561.2	523.8	427.2	455.4	351	243.5	434.2	492.1	527.5	673.7	448	439.8	487.5	756.5	687.8	710.7	718.5	914.3	810	866.7	856.2	1,020	886.8	949.1
Change	-	31.19%	-15.69%	-55.74%	281.25%	-6.66%	-18.44%	6.6%	-22.92%	-30.63%	78.32%	13.33%	7.19%	27.72%	-33.5%	-1.83%	10.85%	55.18%	-9.08%	3.33%	1.1%	27.24%	-11.41%	7%	-1.21%	19.17%	-13.09%	7.03%
EBIT ¹	241.9	323.6	157.8	-	376.9	318.4	517.3	260.4	-73	-234	74.4	221.3	222.7	287.8	16.3	-35.9	661.2	243.2	362.2	331.7	381.8	599.6	469.5	490.1	523	684	546.5	606.5
Change	-	33.77%	-51.24%	-100%	-	-15.52%	62.47%	-49.66%	-	220.55%	-	197.45%	0.65%	29.21%	-94.34%	-	-	-63.22%	48.93%	-8.42%	15.09%	57.06%	-21.7%	4.39%	6.7%	30.79%	-20.1%	10.98%
Charge d'intérêts	-39.5	-108.6	-94.41	-94.56	-102.7	-118.8	-170.3	-229.7	-40.98	-248	-422.1	-493.8	-556.3	-	-575	-532.1	-300.6	-437.7	-383.4	-401.1	-	-	-	-	-	-	-	-
Earnings before Tax (EBT) ¹	-	-	63.4	-	274.2	199.6	346.9	30.7	-114	-482.1	-347.7	-307.2	-333.5	-281	-616	-568	360.6	16	-21.24	-69.36	56.92	273.6	164.3	220.8	207.6	412.6	272.4	320.3
Change	-	-	-	-100%	-	-27.21%	73.8%	-91.15%	-	322.89%	-27.89%	-11.64%	8.58%	-15.75%	119.22%	-7.79%	-	-95.56%	-	226.57%	-	380.65%	-39.95%	34.37%	-5.97%	98.76%	-33.99%	17.59%
Net income ¹	235.1	168	30.8	-	206	219.5	258.6	95.5	143.5	93	-161.3	-135	-166.8	-35.9	-391.2	-301.7	331.2	212.2	27.92	23.61	42.53	187.6	111.2	147.9	138.7	273.7	181	213.1
Change	-	-28.54%	-81.67%	-100%	-	6.55%	17.81%	-63.07%	50.26%	-35.19%	-	-16.3%	23.53%	-78.47%	989.69%	-22.88%	-	-35.94%	-86.84%	-15.46%	80.15%	341.07%	-40.74%	33.07%	-6.23%	97.26%	-33.86%	17.73%
Announcement Date	29/10/19	17/02/20	25/05/20	17/08/20	09/11/20	08/03/21	13/05/21	12/08/21	11/11/21	14/03/22	16/05/22	11/08/22	10/11/22	10/03/23	16/05/23	13/08/23	13/11/23	18/03/24	09/05/24	08/08/24	-	-	-	-	-	-	-	-

¹BRL in Million

Estimates

Forecast Balance Sheet: Magazine Luiza S.A.

Fiscal Period: December	2019	2020	2021	2022	2023	2024	2025	2026
Net Debt ¹	-3,905	1,310	6,125	8,382	3,982	6,747	6,671	6,526
Change	-	-66.45%	367.56%	36.85%	-52.49%	69.42%	-1.13%	-2.17%
Announcement Date	17/02/20	08/03/21	14/03/22	10/03/23	18/03/24	-	-	-

¹BRL in Million

Estimates

Cash Flow Forecast: Magazine Luiza S.A.

Fiscal Period: December	2019	2020	2021	2022	2023	2024	2025	2026
CAPEX ¹	521.5	543.8	1,164	695.4	640.8	1,327	1,094	1,136
Change	-	4.28%	114.07%	-40.26%	-7.85%	107.13%	-17.61%	3.85%
Free Cash Flow (FCF) ¹	979.5	2,539	-5,529	2,369	2,714	2,722	1,940	2,248
Change	-	159.24%	-317.72%	-142.84%	14.57%	0.28%	-28.7%	15.87%
Announcement Date	17/02/20	08/03/21	14/03/22	10/03/23	18/03/24	-	-	-

¹BRL in Million

Estimates

Forecast Financial Ratios: Magazine Luiza S.A.

Fiscal Period: December	2019	2020	2021	2022	2023	2024	2025	2026
Profitability
EBITDA Margin (%)	6.56%	5.16%	4.19%	5.7%	5.8%	7.33%	7.97%	8.61%
EBIT Margin (%)	5.5%	2.83%	1.33%	2.07%	-1.01%	4.19%	5.04%	5.62%
EBT Margin (%)	6.13%	1.42%	-0.62%	-3.4%	-5.61%	0.62%	1.97%	2.78%
Net margin (%)	4.64%	1.34%	1.67%	-1.34%	-2.66%	0.63%	1.45%	2.13%
FCF margin (%)	4.93%	8.7%	-15.67%	6.35%	7.38%	6.97%	4.64%	4.99%
FCF / Net Income (%)	106.26%	648.28%	-935.94%	-474.69%	-277.17%	1,098.47%	320.42%	234.24%
Profitability
ROA	6.45%	1.76%	1.87%	-1.31%	-1.46%	1.07%	1.54%	2.1%
ROE	18.68%	5.26%	6.36%	-4.56%	-5.43%	2.58%	5.59%	7.92%
Financial Health
Leverage (Debt/EBITDA)	-	0.87x	4.15x	3.94x	1.87x	2.36x	2x	1.68x
Debt / Free cash flow	-	0.52x	-1.11x	3.54x	1.47x	2.48x	3.44x	2.9x
Capital Intensity
CAPEX / Current Assets (%)	2.62%	1.86%	3.3%	1.86%	1.74%	3.4%	2.61%	2.52%
CAPEX / EBITDA (%)	40%	36.11%	78.81%	32.69%	30.06%	46.35%	32.77%	29.29%
CAPEX / FCF (%)	53.24%	21.42%	-21.06%	29.36%	23.61%	48.77%	56.36%	50.51%
Items per share
Cash flow per share ¹	2.288	3.98	-6.479	4.546	-	-	-	-
Change	-	73.97%	-262.8%	-170.16%	-	-	-	-
Dividend per Share ¹	-	0.418	0.1549	-	-	-	0.1793	0.2963
Change	-	-	-62.94%	-	-	-	-	65.24%
Book Value Per Share ¹	11.53	11.33	16.9	15.95	14.36	15.11	16.41	17.52
Change	-	-1.71%	49.07%	-5.61%	-9.95%	5.24%	8.56%	6.81%
EPS ¹	1.405	0.6	0.88	-0.75	-1.46	0.3641	0.8419	1.311
Change	-	-57.3%	46.67%	-185.23%	94.67%	-124.94%	131.26%	55.69%
Nbr of stocks (in thousands)	648,641	647,590	660,284	667,611	669,128	735,945	735,945	735,945
Announcement Date	17/02/20	08/03/21	14/03/22	10/03/23	18/03/24	-	-	-