Frontierby eninvs

Language: EN · RU

← Company

MX_FEMSA 2024-03-31 Q1 — report review

Status: OK — incomplete — unset metrics listed below; Currency: MXN; Amounts unit: millions; Forms:

Report published: Not stored for this period — set financial_report_date on the row (EDGAR filingDate, KASE change_date, or manual_catalog).

Full financial report: Link

PDF (local): /home/ubuntu/projects/frontier/data/raw_pdfs/MX_FEMSA/2024-03-31_Q1_FEMSA_1Q24.pdf

To recalculate statement detection and previews from the PDF, use this link The default link runs in the background: a status panel shows phase, elapsed time, rough ETA, CUDA vs CPU, and OOM hints, then loads the finished report. Heavy mode with refresh does this automatically so reverse proxies do not return 502. Add &sync=1 only for one long blocking request (not recommended). You can use ?refresh=1, ?recalc=1, ?nocache=1, or ?recompute=1 on the URL. (block in the browser until done: synchronous refresh)

Metric mapping (value → extracted evidence)

Metric values use dashboard units where applicable; evidence is the stored snippet from the PDF text layer or OCR used during extraction.

MetricValueEvidence / page extract
Revenue178 204Row: revenue (mln MXN, batch apply) · dashboard=178,204.000 mln — [DeepSeek] revenue (mln MXN, batch apply)
Operating profit14 767Row: operating_profit (mln MXN, batch apply) · dashboard=14,767.000 mln — [DeepSeek] operating_profit (mln MXN, batch apply)
D&A10 283Row: da (mln MXN, batch apply) · dashboard=10,283.000 mln — [DeepSeek] da (mln MXN, batch apply)
EBITDA25 050Row: ebitda (mln MXN, batch apply) · dashboard=25,050.000 mln — [DeepSeek] ebitda (mln MXN, batch apply)
Net profit5 884Row: net_profit (mln MXN, batch apply) · dashboard=5,884.000 mln — [DeepSeek] net_profit (mln MXN, batch apply)
Cash137 530Row: cash (mln MXN, batch apply) · dashboard=137,530.000 mln — [DeepSeek] cash (mln MXN, batch apply)
Debt short16 954Row: debt_short (mln MXN, batch apply) · dashboard=16,954.000 mln — [DeepSeek] debt_short (mln MXN, batch apply)
Debt long208 510Row: debt_long (mln MXN, batch apply) · dashboard=208,510.000 mln — [DeepSeek] debt_long (mln MXN, batch apply)
Net debt87 934Components: short debt 16 954 + long debt 208 510 + other financial liab. 0 + NCI 0 − cash 137 530 = net debt 87 934.Row: net_debt (mln MXN, batch apply) · dashboard=87,934.000 mln — [DeepSeek] net_debt (mln MXN, batch apply)
Operating CF
Investing CF
Assets797 560Row: total_assets (mln MXN, batch apply) · dashboard=797,560.000 mln — [DeepSeek] total_assets (mln MXN, batch apply)
Equity347 380Row: total_equity (mln MXN, batch apply) · dashboard=347,380.000 mln — [DeepSeek] total_equity (mln MXN, batch apply)

Consistency checks · All checks passed

Balance sheet identity (A = L + E)TA (797,560) ≈ TL (450,180) + TE (347,380); residual +0 within 1%.
Net debt formulanet_debt 87,934 matches |debt_short|+|debt_long|+|other|+|NCI|−|cash| = 87,934.
EBITDA = OP + D&AEBITDA (25,050) ≈ OP (14,767) + D&A (10,283) = 25,050.
Net profit vs operating profitNet profit (5,884) sits within a plausible band vs operating profit (14,767).
Cash ≤ total assetsCash (137,530) ≤ total assets (797,560).

Statement pages (discovery)

FormPages
P&L7, 8, 9
BS14
CF

Statement previews & reconstructed tables

Highlights Yellow row = matched stored evidence label; orange cell = exact number used for that metric (hover row for details). Revenue Operating profit D&A EBITDA Net profit cash debt_short debt_long Assets Equity Operating CF Investing CF

Green / amber / red bars on the label column mark subtotal rows where summed detail lines match the reported total (heuristic). The table under each reconstructed grid lists every check (Σ detail vs reported, status).

P&L

Extracted metrics for this form (this period row)

MetricValue
Revenue178 204
Operating profit14 767
EBITDA25 050
Net profit5 884
D&A10 283

Tables and checks run on 2 of 3 PDF pages for this form (timeout budget). Raise REPORT_REVIEW_HEAVY_RECON_PAGES for more.

P&L — PDF page 7
PDF page scan — P&L — 7
P&L PDF page 7

No Camelot table — OCR (v8) below.

GPU v8 OCR — page 7 (9 rows). Blank amount cells are normal for section headers and line-wrapped captions; 0 from OCR on those rows is not a reported financial zero. Amounts follow the PDF header (often thousands of currency).

#Joined labelColumn 22028Column 4
0SALUD
1Resumen Financiero del 1T24
2Cifras en millones de pesos mexicanos (Ps ) excepto ventas mismas-tiendas
3Ventas mismas-tiendas (miles de pesos)1017.81018.7-0.196
4Ingresos Totales1815418574-2.396
5Utilidad de Operacion6011002-40.096
6Margen de Operacion (%)3.35.4-210
7EBITDA Ajustado16792028-17.296
8Margen EBITDA Ajustado (9)9.210.9-170
P&L — PDF page 8
PDF page scan — P&L — 8
P&L PDF page 8

Camelot table (pages 8, primary page 8).

#Joined labelLine itemResumen Financiero del 1T24 → Cif…1T23Var. → (50 bps)
0Resumen Financiero del 1T24Resumen Financiero del 1T24
1Cifras en millones de pesos mexicanos (Ps.) excepto ventas mismas-estacionesCifras en millones de pesos mexicanos (Ps.) excepto ventas mismas-estaciones
21T24 1T23 Var.1T241T23Var.
3Same-station sales (thousands of Ps.) 7,601.7 7,109.5 6.9%Same-station sales (thousands of Ps.)7,601.77,109.56.9%
4Total Revenues 14,963 13,141 13.9%Total Revenues14,96313,14113.9%
5Income from Operations 530 523 1.4%Income from Operations5305231.4%
6Income from Operations Margin (%) 3.5 4.0 (50 bps)Income from Operations Margin (%)3.54.0(50 bps)
7Adjusted EBITDA 897 819 9.5%Adjusted EBITDA8978199.5%
8Adjusted EBITDA Margin (%) 6.0 6.2 (20 bps)Adjusted EBITDA Margin (%)6.06.2(20 bps)

No subtotal/total rows matched the built-in patterns on this table (or fewer than two detail lines above each candidate).

BS

Extracted metrics for this form (this period row)

MetricValue
Cash137 530
Debt Short16 954
Debt Long208 510
Assets797 560
Equity347 380
Net debt87 934
BS — PDF page 14
PDF page scan — BS — 14
BS PDF page 14

Camelot table (pages 14, primary page 14).

#Joined labelLine itemMar-24Dic-23% Var.Column 5PASIVOS Y CAPITAL CONTABLE → Prés…Mar-24Dic-23% Var.
0FEMSA Consolidado – Balance GeneralFEMSA Consolidado – Balance General
1Cifras en millones de pesos mexicanos (Ps.)Cifras en millones de pesos mexicanos (Ps.)
2A PASIVOS Y CAPITAL CONTABLE Mar-24 Dic-23 % Var.APASIVOS Y CAPITAL CONTABLEMar-24Dic-23% Var.
3CTIVOS Mar-24 Dic-23 % Var.CTIVOSMar-24Dic-23% Var.
4Préstamos bancarios C.P. 2,373 2,453 (3.3)Préstamos bancarios C.P.2,3732,453(3.3)
5Efectivo y valores de realización inmediata 137,530 165,112 (16.7)Efectivo y valores de realización inmediata137,530165,112(16.7)
6Vencimientos C.P. del pasivo L.P 2,704 8,955 (69.8)Vencimientos C.P. del pasivo L.P2,7048,955(69.8)
7Inversiones 42,176 26,728 57.8Inversiones42,17626,72857.8
8Intereses por pagar 1,644 1,677 (2.0)Intereses por pagar1,6441,677(2.0)
9Cuentas por cobrar 38,683 38,863 (0.5)Cuentas por cobrar38,68338,863(0.5)
10Vencimientos de arrendamientos de L.P. en C.P. 12,233 12,236 (0.0)Vencimientos de arrendamientos de L.P. en C.P.12,23312,236(0.0)
11Inventarios 54,571 58,222 (6.3)Inventarios54,57158,222(6.3)
12Pasivo de operación 175,897 148,447 18.5Pasivo de operación175,897148,44718.5
13Otros activos circulantes 48,871 41,415 18.0Otros activos circulantes48,87141,41518.0
14Pasivos circulantes Disponibles para la venta 11,887 11,569 2.7Pasivos circulantes Disponibles para la venta11,88711,5692.7
15Activos Disponibles para venta 25,596 25,819 (0.9)Activos Disponibles para venta25,59625,819(0.9)
16Total pasivo circulante 206,738 185,337 11.5Total pasivo circulante206,738185,33711.5
17Total activo circulante 347,427 356,159 (2.5)Total activo circulante347,427356,159(2.5)
18Deuda a largo plazo (2) 126,303 125,417 0.7Deuda a largo plazo (2)126,303125,4170.7
19Inversión en acciones 26,092 26,247 (0.6)Inversión en acciones26,09226,247(0.6)
20Arrendamientos L.P. 82,207 83,838 (1.9)Arrendamientos L.P.82,20783,838(1.9)
21Propiedad, planta y equipo, neto 142,785 141,530 0.9Propiedad, planta y equipo, neto142,785141,5300.9
22Obligaciones laborales 7,174 6,920 3.7Obligaciones laborales7,1746,9203.7
23Derecho de uso 86,150 87,941 (2.0)Derecho de uso86,15087,941(2.0)
24Otros pasivos 27,757 25,975 6.9Otros pasivos27,75725,9756.9
25Activos Intangibles(1) 141,168 143,218 (1.4)Activos Intangibles(1)141,168143,218(1.4)
26Total pasivos 450,180 427,487 5.3Total pasivos450,180427,4875.3
27Otros activos 53,938 50,761 6.3Otros activos53,93850,7616.3
28Total capital contable 347,380 378,369 (8.2)Total capital contable347,380378,369(8.2)
29TOTAL PASIVO Y CAPITAL CONTABLE 797,560 805,856 (1.0)TOTAL PASIVO Y CAPITAL CONTABLE797,560805,856(1.0)
30TOTAL ACTIVOS 797,560 805,856 (1.0)TOTAL ACTIVOS797,560805,856(1.0)
3131 de Marzo de 202431 de Marzo de 2024
32TasaTasa
33MEZCLA DE MONEDAS Y TASAS (2) % del TotalMEZCLA DE MONEDAS Y TASAS (2)% del Total
34PromedioPromedio
35Contratado en:Contratado en:
36Pesos mexicanos 54.6% 9.1%Pesos mexicanos54.6%9.1%
37Dólares 27.0% 3.4%Dólares27.0%3.4%
38Euros 6.6% 2.6%Euros6.6%2.6%
39Francos Suizos 0.0% 0.0%Francos Suizos0.0%0.0%
40Pesos Colombianos 0.7% 6.3%Pesos Colombianos0.7%6.3%
41Pesos Argentinos 0.0% 130.0%Pesos Argentinos0.0%130.0%
42Reales 10.2% 9.3%Reales10.2%9.3%
43Pesos Chilenos 0.9% 8.9%Pesos Chilenos0.9%8.9%
44Deuda total 100.0% 7.2%Deuda total100.0%7.2%
45Tasa fija (2) 83.8%Tasa fija (2)83.8%
46Tasa variable (2) 16.2%Tasa variable (2)16.2%
47VENCIMIENTO DE LA DEUDA 2024 2025 2026 2027 2028 2029+VENCIMIENTO DE LA DEUDA2024202520262027 2028 2029+
48% de la Deuda Total 3.6% 1.7% 9.2% 8.0% 11.3% 66.3%% de la Deuda Total3.6%1.7%9.2%8.0% 11.3% 66.3%

No subtotal/total rows matched the built-in patterns on this table (or fewer than two detail lines above each candidate).

Formulas used