Frontierby eninvs

Language: EN · RU

← Company

MX_FEMSA 2023-09-30 Q3 — 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/2023-09-30_Q3_FEMSA_3Q23.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
Revenue539 113Row: revenue (mln MXN, batch apply) · dashboard=539,113.000 mln — [DeepSeek] revenue (mln MXN, batch apply)
Operating profit44 009Row: operating_profit (mln MXN, batch apply) · dashboard=44,009.000 mln — [DeepSeek] operating_profit (mln MXN, batch apply)
D&A28 425Row: da (mln MXN, batch apply) · dashboard=28,425.000 mln — [DeepSeek] da (mln MXN, batch apply)
EBITDA72 434Row: ebitda (mln MXN, batch apply) · dashboard=72,434.000 mln — [DeepSeek] ebitda (mln MXN, batch apply)
Net profit71 994Row: net_profit (mln MXN, batch apply) · dashboard=71,994.000 mln — [DeepSeek] net_profit (mln MXN, batch apply)
Cash160 442Row: cash (mln MXN, batch apply) · dashboard=160,442.000 mln — [DeepSeek] cash (mln MXN, batch apply)
Debt short20 741Row: debt_short (mln MXN, batch apply) · dashboard=20,741.000 mln — [DeepSeek] debt_short (mln MXN, batch apply)
Debt long215 560Row: debt_long (mln MXN, batch apply) · dashboard=215,560.000 mln — [DeepSeek] debt_long (mln MXN, batch apply)
Net debt413 660Components: short debt 20 741 + long debt 215 560 + other financial liab. 0 + NCI 337 801 − cash 160 442 = net debt 413 660.Row: net_debt (mln MXN, batch apply) · dashboard=413,660.000 mln — [DeepSeek] net_debt (mln MXN, batch apply)
Operating CF
Investing CF
Assets818 158Row: total_assets (mln MXN, batch apply) · dashboard=818,158.000 mln — [DeepSeek] total_assets (mln MXN, batch apply)
Equity375 901Row: total_equity (mln MXN, batch apply) · dashboard=375,901.000 mln — [DeepSeek] total_equity (mln MXN, batch apply)

Consistency checks · Warnings

Balance sheet identity (A = L + E)TA (818,158) ≈ TL (442,257) + TE (375,901); residual +0 within 1%.
Net debt formulanet_debt 413,660 matches |debt_short|+|debt_long|+|other|+|NCI|−|cash| = 413,660.
EBITDA = OP + D&AEBITDA (72,434) ≈ OP (44,009) + D&A (28,425) = 72,434.
Net profit vs operating profitNet profit (71,994) > 1.5× operating profit (44,009) — implies a large non-operating gain (asset disposal, FX, one-off). Check the column mapping if no such item is reported.
Cash ≤ total assetsCash (160,442) ≤ total assets (818,158).
subtotal_BS_Total current assets 378,441 226,449 67.1 Total Total current assets 378,441 226,449 67.1 Total current liabilities 196,424 174,914 12.3: Σ detail = 174,892, reported 174,914, diff -22 (0.0%, 6 lines).
subtotal_P&L_Gross profit 72,081 38.3 59,016 37.4 22.1 205,8Gross profit 72,081 38.3 59,016 37.4 22.1 205,836 38.2 169,729 37.6 21.3: Σ detail = 207,859, reported 205,836, diff +2,023 (1.0%, 3 lines).

Statement pages (discovery)

FormPages
P&L13, 14, 15
BS14, 15, 16
CF16, 17, 18

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
Revenue539 113
Operating profit44 009
EBITDA72 434
Net profit71 994
D&A28 425

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 13
PDF page scan — P&L — 13
P&L PDF page 13

No Camelot table — OCR (v8) below.

v8 OCR page 13: empty rows.

P&L — PDF page 14
PDF page scan — P&L — 14
P&L PDF page 14

Camelot table (pages 14, primary page 14).

#Joined labelLine item2023of rev.2022of rev.% Var. → N.S.Org.(A)2023of rev.2022of rev.
0% % % %%%%%%
12023 2022 % Var. 2023 202220232022% Var.20232022
2of rev. of rev. Org.(A) of rev.of rev.of rev.Org.(A)of rev.of rev.
3Total revenues 188,095 100.0 157,693 100.0 19.3 11.9 539,113 100.0 451,443Total revenues188,095100.0157,693100.019.311.9539,113100.0451,443100.0
4Cost of sales 116,013 61.7 98,677 62.6 17.6 333,277 61.8 281,714Cost of sales116,01361.798,67762.617.6333,27761.8281,71462.4
5Gross profit 72,081 38.3 59,016 37.4 22.1 205,836 38.2 169,729Gross profit72,08138.359,01637.422.1205,83638.2169,72937.6
6Administrative expenses 8,339 4.4 7,365 4.7 13.2 24,862 4.6 20,534Administrative expenses8,3394.47,3654.713.224,8624.620,5344.5
7Selling expenses 48,060 25.5 37,414 23.6 28.5 136,871 25.4 108,545Selling expenses48,06025.537,41423.628.5136,87125.4108,54524.1
8Other operating expenses (income), net (1) (246) (0.1) 91 0.1 N.S. 94 - 203Other operating expenses (income), net (1)(246)(0.1)910.1N.S.94-203-
9Income from operations (2) 15,929 8.5 14,146 9.0 12.6 9.8 44,009 8.2 40,447Income from operations (2)15,9298.514,1469.012.69.844,0098.240,4479.0
10Other non-operating expenses (income) (262) 41 N.S. (9,577) 146Other non-operating expenses (income)(262)41N.S.(9,577)146
11Interest expense 3,170 3,615 (12.3) 8,964 11,965Interest expense3,1703,615(12.3)8,96411,965
12Interest income 2,697 1,161 132.3 12,963 2,694Interest income2,6971,161132.312,9632,694
13Interest expense, net 472 2,455 (80.8) (3,999) 9,270Interest expense, net4722,455(80.8)(3,999)9,270
14Foreign exchange loss (gain) (5,374) (1,212) N.S. 3,575 211Foreign exchange loss (gain)(5,374)(1,212)N.S.3,575211
15Other financial expenses (income), net 504 47 N.S. 520 346Other financial expenses (income), net50447N.S.520346
16Financing expenses, net (4,397) 1,290 N.S. 96 9,827Financing expenses, net(4,397)1,290N.S.969,827
17Income before income tax and participation in associates results 20,588 12,815 60.7 53,490 30,321Income before income tax and participation in associates results20,58812,81560.753,49030,321
18Income tax 6,540 4,482 45.9 16,431 11,124Income tax6,5404,48245.916,43111,124
19Participation in associates results (3) (110) 37 N.S. (538) 87Participation in associates results (3)(110)37N.S.(538)87
20Continued Operations net income (Loss) 13,938 8,370 66.5 36,521 19,284Continued Operations net income (Loss)13,9388,37066.536,52119,284
21Discontinued Operations net income (Loss) (1,180) 4,898 (108.9) 35,473 7,509Discontinued Operations net income (Loss)(1,180)4,898(108.9)35,4737,509
22Consolidated net income (Loss) 12,758 13,268 (3.8) 71,994 26,793Consolidated net income (Loss)12,75813,268(3.8)71,99426,793
23Net majority income 9,742 10,748 (9.4) 63,964 19,980Net majority income9,74210,748(9.4)63,96419,980
24Net minority income 3,016 2,520 19.7 8,030 6,813Net minority income3,0162,52019.78,0306,813
25% % % %%%%%%
26Operative Cash Flow & CAPEX 2023 2022 % Var. 2023 2022Operative Cash Flow & CAPEX20232022% Var.20232022
27of rev. of rev. Org.(A) of rev.of rev.of rev.Org.(A)of rev.of rev.
28Income from operations 15,929 8.5 14,146 9.0 12.6 9.8 44,009 8.2 40,447Income from operations15,9298.514,1469.012.69.844,0098.240,4479.0
29Depreciation 8,234 4.4 6,669 4.2 23.5 24,328 4.5 19,533Depreciation8,2344.46,6694.223.524,3284.519,5334.3
30Amortization & other non-cash charges 1,190 0.6 1,230 0.8 (3.2) 4,097 0.7 3,502Amortization & other non-cash charges1,1900.61,2300.8(3.2)4,0970.73,5020.8
31Adjusted EBITDA 25,366 13.5 22,046 14.0 15.1 7.7 72,434 13.4 63,481Adjusted EBITDA25,36613.522,04614.015.17.772,43413.463,48114.1
32CAPEX 9,791 8,017 22.1 23,279 19,900CAPEX9,7918,01722.123,27919,900
33( A) Organic basis (% Org.) excludes the effects of significant mergers and acquisitions in the last twelve months.( A) Organic basis (% Org.) excludes the effects of significant mergers and acquisitions in the last

Subtotals vs summed lines (heuristic)

For each recognised total/subtotal row, amounts in the detected reporting column are summed over preceding detail rows until another subtotal or a lookback limit. This mirrors coarse PHP-style checks; it is not a full chart-of-accounts reconciliation.

RowLabel (trimmed)Σ detailReported|Δ|/scaleStatus
5Gross profit 72,081 38.3 59,016 37.4 22.1 205,836 38.2 169,729 37.6 21.3207,859205,8360.0097OK (3 lines)

BS

Extracted metrics for this form (this period row)

MetricValue
Cash160 442
Debt Short20 741
Debt Long215 560
Assets818 158
Equity375 901
Net debt413 660

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

BS — PDF page 14
PDF page scan — BS — 14
BS PDF page 14

Camelot table (pages 14, primary page 14).

#Joined labelLine item2023of rev.2022of rev.% Var. → N.S.Org.(A)2023of rev.2022of rev.
0% % % %%%%%%
12023 2022 % Var. 2023 202220232022% Var.20232022
2of rev. of rev. Org.(A) of rev.of rev.of rev.Org.(A)of rev.of rev.
3Total revenues 188,095 100.0 157,693 100.0 19.3 11.9 539,113 100.0 451,443Total revenues188,095100.0157,693100.019.311.9539,113100.0451,443100.0
4Cost of sales 116,013 61.7 98,677 62.6 17.6 333,277 61.8 281,714Cost of sales116,01361.798,67762.617.6333,27761.8281,71462.4
5Gross profit 72,081 38.3 59,016 37.4 22.1 205,836 38.2 169,729Gross profit72,08138.359,01637.422.1205,83638.2169,72937.6
6Administrative expenses 8,339 4.4 7,365 4.7 13.2 24,862 4.6 20,534Administrative expenses8,3394.47,3654.713.224,8624.620,5344.5
7Selling expenses 48,060 25.5 37,414 23.6 28.5 136,871 25.4 108,545Selling expenses48,06025.537,41423.628.5136,87125.4108,54524.1
8Other operating expenses (income), net (1) (246) (0.1) 91 0.1 N.S. 94 - 203Other operating expenses (income), net (1)(246)(0.1)910.1N.S.94-203-
9Income from operations (2) 15,929 8.5 14,146 9.0 12.6 9.8 44,009 8.2 40,447Income from operations (2)15,9298.514,1469.012.69.844,0098.240,4479.0
10Other non-operating expenses (income) (262) 41 N.S. (9,577) 146Other non-operating expenses (income)(262)41N.S.(9,577)146
11Interest expense 3,170 3,615 (12.3) 8,964 11,965Interest expense3,1703,615(12.3)8,96411,965
12Interest income 2,697 1,161 132.3 12,963 2,694Interest income2,6971,161132.312,9632,694
13Interest expense, net 472 2,455 (80.8) (3,999) 9,270Interest expense, net4722,455(80.8)(3,999)9,270
14Foreign exchange loss (gain) (5,374) (1,212) N.S. 3,575 211Foreign exchange loss (gain)(5,374)(1,212)N.S.3,575211
15Other financial expenses (income), net 504 47 N.S. 520 346Other financial expenses (income), net50447N.S.520346
16Financing expenses, net (4,397) 1,290 N.S. 96 9,827Financing expenses, net(4,397)1,290N.S.969,827
17Income before income tax and participation in associates results 20,588 12,815 60.7 53,490 30,321Income before income tax and participation in associates results20,58812,81560.753,49030,321
18Income tax 6,540 4,482 45.9 16,431 11,124Income tax6,5404,48245.916,43111,124
19Participation in associates results (3) (110) 37 N.S. (538) 87Participation in associates results (3)(110)37N.S.(538)87
20Continued Operations net income (Loss) 13,938 8,370 66.5 36,521 19,284Continued Operations net income (Loss)13,9388,37066.536,52119,284
21Discontinued Operations net income (Loss) (1,180) 4,898 (108.9) 35,473 7,509Discontinued Operations net income (Loss)(1,180)4,898(108.9)35,4737,509
22Consolidated net income (Loss) 12,758 13,268 (3.8) 71,994 26,793Consolidated net income (Loss)12,75813,268(3.8)71,99426,793
23Net majority income 9,742 10,748 (9.4) 63,964 19,980Net majority income9,74210,748(9.4)63,96419,980
24Net minority income 3,016 2,520 19.7 8,030 6,813Net minority income3,0162,52019.78,0306,813
25% % % %%%%%%
26Operative Cash Flow & CAPEX 2023 2022 % Var. 2023 2022Operative Cash Flow & CAPEX20232022% Var.20232022
27of rev. of rev. Org.(A) of rev.of rev.of rev.Org.(A)of rev.of rev.
28Income from operations 15,929 8.5 14,146 9.0 12.6 9.8 44,009 8.2 40,447Income from operations15,9298.514,1469.012.69.844,0098.240,4479.0
29Depreciation 8,234 4.4 6,669 4.2 23.5 24,328 4.5 19,533Depreciation8,2344.46,6694.223.524,3284.519,5334.3
30Amortization & other non-cash charges 1,190 0.6 1,230 0.8 (3.2) 4,097 0.7 3,502Amortization & other non-cash charges1,1900.61,2300.8(3.2)4,0970.73,5020.8
31Adjusted EBITDA 25,366 13.5 22,046 14.0 15.1 7.7 72,434 13.4 63,481Adjusted EBITDA25,36613.522,04614.015.17.772,43413.463,48114.1
32CAPEX 9,791 8,017 22.1 23,279 19,900CAPEX9,7918,01722.123,27919,900
33( A) Organic basis (% Org.) excludes the effects of significant mergers and acquisitions in the last twelve months.( A) Organic basis (% Org.) excludes the effects of significant mergers and acquisitions in the last

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

BS — PDF page 15
PDF page scan — BS — 15
BS PDF page 15

Camelot table (pages 15, primary page 15).

#Joined labelLine itemSep-23Dec-22% Inc. → N.S.LIABILITIES & STOCKHOLDERS’ EQUIT…Sep-23Dec-22% Inc. → N.S.
0FEMSA – Consolidated Balance SheetFEMSA – Consolidated Balance Sheet
1Amounts expressed in millions of Mexican Pesos (Ps.)Amounts expressed in millions of Mexican Pesos (Ps.)
2ASSETS Sep-23 Dec-22 % Inc. LIABILITIES & STOCKHOLDERS’ EQUITY Sep-23 Dec-22 % Inc.ASSETSSep-23Dec-22% Inc.LIABILITIES & STOCKHOLDERS’ EQUITYSep-23Dec-22% Inc.
3Cash and cash equivalents 160,442 83,439 92.3 Bank loans 2,936 1,862 57.7Cash and cash equivalents160,44283,43992.3Bank loans2,9361,86257.7
4Investments 18,840 51 N.S. Current maturities of long-term debt 6,062 14,471 (58.1)Investments18,84051N.S.Current maturities of long-term debt6,06214,471(58.1)
5Accounts receivable 45,304 45,527 (0.5) Interest payable 1,770 2,075 (14.7)Accounts receivable45,30445,527(0.5)Interest payable1,7702,075(14.7)
6Inventories 55,782 62,224 (10.4) Current maturities of long-term leases 11,743 12,095 (2.9)Inventories55,78262,224(10.4)Current maturities of long-term leases11,74312,095(2.9)
7Other current assets 43,350 35,208 23.1 Operating liabilities 164,085 144,411 13.6Other current assets43,35035,20823.1Operating liabilities164,085144,41113.6
8Current Assets Available for sale 54,723 - N.S. Short term liabilities available for sale 9,828 - N.S.Current Assets Available for sale54,723-N.S.Short term liabilities available for sale9,828-N.S.
9Total current assets 378,441 226,449 67.1 Total current liabilities 196,424 174,914 12.3Total current assets378,441226,44967.1Total current liabilities196,424174,91412.3
10Investments in shares 10,876 103,669 (89.5) Long-term debt (2) 132,350 170,989 (22.6)Investments in shares10,876103,669(89.5)Long-term debt (2)132,350170,989(22.6)
11Property, plant and equipment, net 138,420 134,001 3.3 Long-term leases 83,210 81,222 2.4Property, plant and equipment, net138,420134,0013.3Long-term leases83,21081,2222.4
12Right of use 85,076 83,966 1.3 Laboral obligations 7,583 7,048 7.6Right of use85,07683,9661.3Laboral obligations7,5837,0487.6
13Intangible assets (1) 153,133 190,772 (19.7) Other liabilities 22,690 26,841 (15.5)Intangible assets (1)153,133190,772(19.7)Other liabilities22,69026,841(15.5)
14Other assets 52,212 59,958 (12.9) Total liabilities 442,257 461,014 (4.1)Other assets52,21259,958(12.9)Total liabilities442,257461,014(4.1)
15Total stockholders’ equity 375,901 337,801 11.3Total stockholders’ equity375,901337,80111.3
16TOTAL ASSETS 818,158 798,815 2.4 TOTAL LIABILITIES AND STOCKHOLDERS’ EQUITY 818,158 798,815 2.4TOTAL ASSETS818,158798,8152.4TOTAL LIABILITIES AND STOCKHOLDERS’ EQUITY818,158798,8152.4

Subtotals vs summed lines (heuristic)

For each recognised total/subtotal row, amounts in the detected reporting column are summed over preceding detail rows until another subtotal or a lookback limit. This mirrors coarse PHP-style checks; it is not a full chart-of-accounts reconciliation.

RowLabel (trimmed)Σ detailReported|Δ|/scaleStatus
9Total current assets 378,441 226,449 67.1 Total current liabilities 196,424 174,914 12.3174,892174,9140.0001OK (6 lines)

CF

Extracted metrics for this form (this period row)

MetricValue
Operating CF
Investing CF

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

CF — PDF page 16
PDF page scan — CF — 16
CF PDF page 16

No Camelot table — OCR (v8) below.

v8 OCR stopped early (1 more page(s) skipped to stay under the heavy-mode wallclock budget). Reload after the cache warms up to see them.

Stopped mid-form (CF) after wallclock budget (90s).

Formulas used