Frontierby eninvs

Language: EN · RU

← Company

MX_KOF 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_KOF/2024-03-31_Q1_coca-cola-femsa-results-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)

Default view is fast (metric table + statement page numbers only) so reverse proxies do not time out. Use ?heavy=1 when you need embedded page images and Camelot tables.

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
Revenue63 803Row: revenue (mln MXN, batch apply) · dashboard=63,803.000 mln — [DeepSeek] revenue (mln MXN, batch apply)
Operating profit8 617Row: operating_profit (mln MXN, batch apply) · dashboard=8,617.000 mln — [DeepSeek] operating_profit (mln MXN, batch apply)
D&A3 327Row: da (mln MXN, batch apply) · dashboard=3,327.000 mln — [DeepSeek] da (mln MXN, batch apply)
EBITDA11 944Row: ebitda (mln MXN, batch apply) · dashboard=11,944.000 mln — [DeepSeek] ebitda (mln MXN, batch apply)
Net profit5 006Row: net_profit (mln MXN, batch apply) · dashboard=5,006.000 mln — [DeepSeek] net_profit (mln MXN, batch apply)
Cash35 046Row: cash (mln MXN, batch apply) · dashboard=35,046.000 mln — [DeepSeek] cash (mln MXN, batch apply)
Debt short170Row: debt_short (mln MXN, batch apply) · dashboard=170.000 mln — [DeepSeek] debt_short (mln MXN, batch apply)
Debt long64 375Row: debt_long (mln MXN, batch apply) · dashboard=64,375.000 mln — [DeepSeek] debt_long (mln MXN, batch apply)
Net debt169 499Components: short debt 170 + long debt 64 375 + other financial liab. 0 + NCI 140 000 − cash 35 046 = net debt 169 499.Row: net_debt (mln MXN, batch apply) · dashboard=169,499.000 mln — [DeepSeek] net_debt (mln MXN, batch apply)
Operating CF
Investing CF
Assets278 104Row: total_assets (mln MXN, batch apply) · dashboard=278,104.000 mln — [DeepSeek] total_assets (mln MXN, batch apply)
Equity125 886Row: total_equity (mln MXN, batch apply) · dashboard=125,886.000 mln — [DeepSeek] total_equity (mln MXN, batch apply)

Consistency checks · All checks passed

Balance sheet identity (A = L + E)TA (278,104) ≈ TL (152,218) + TE (125,886); residual +0 within 1%.
Net debt formulanet_debt 169,499 matches |debt_short|+|debt_long|+|other|+|NCI|−|cash| = 169,499.
EBITDA = OP + D&AEBITDA (11,944) ≈ OP (8,617) + D&A (3,327) = 11,944.
Net profit vs operating profitNet profit (5,006) sits within a plausible band vs operating profit (8,617).
Cash ≤ total assetsCash (35,046) ≤ total assets (278,104).

Statement pages (discovery)

FormPages
P&L9, 10, 11
BS11, 12, 13
CF11, 12, 13

Below: last full statement reconstruction (PDF scans + tables + subtotal checks) cached from a ?heavy=1 run. Open heavy mode to rebuild if the PDF, discovery, or extraction changed. full previews & tables (?heavy=1).

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
Revenue63 803
Operating profit8 617
EBITDA11 944
Net profit5 006
D&A3 327

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

No Camelot table — OCR (v8) below.

v8 OCR page 9: empty rows.

P&L — PDF page 10
PDF page scan — P&L — 10
P&L PDF page 10

Camelot table (pages 10, primary page 10).

#Joined labelLine item2024
0Amortization and other operative non-cash charges 786 471 66.9%Amortization and other operative non-cash charges786 471 66.9%
1Adj. EBITDA (5)(6) 11,944 18.7% 10,522 18.3% 13.5%Adj. EBITDA (5)(6)11,944 18.7% 10,522 18.3% 13.5%
2CAPEX 3,181 2,506 26.9%CAPEX3,181 2,506 26.9%
3(1) Except volume and average price per unit case figures.(1)Except volume and average price per unit case figures.
4(2) Please refer to page 13 for revenue breakdown.(2)Please refer to page 13 for revenue breakdown.
5(3) Includes equity method in Jugos del Valle and Leão Alimentos, among others.(3)Includes equity method in Jugos del Valle and Leão Alimentos, among others.
6(4) Includes equity method in PIASA, IEQSA, Beta San Miguel, IMER, and KSP Participacoes, among others.(4)Includes equity method in PIASA, IEQSA, Beta San Miguel, IMER, and KSP Participacoes, among others.
7(5) The operating income and Adjusted EBITDA lines are presented as non-GAAP measures for the convenience of the reader.(5)The operating income and Adjusted EBITDA lines are presented as non-GAAP measures for the convenienc
8(6) Adjusted EBITDA = operating income + depreciation, amortization & other operating non-cash charges.(6)Adjusted EBITDA = operating income + depreciation, amortization & other operating non-cash charges.
9(7) Please refer to page 8 for our definition of “comparable” and a description of the factors affecting the comparability of our financial and operating performance.(7)Please refer to page 8 for our definition of “comparable” and a description of the factors affecting
10(8) As of March 31, 2024, the investment in fixed assets effectively paid is equivalent to Ps. 3, 775 million.(8)As of March 31, 2024, the investment in fixed assets effectively paid is equivalent to Ps. 3, 775 mi

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
Cash35 046
Debt Short170
Debt Long64 375
Assets278 104
Equity125 886
Net debt169 499

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 11
PDF page scan — BS — 11
BS PDF page 11

Camelot table (pages 11, primary page 11).

#Joined labelLine itemExcept volume and average price p…
0Depreci a tion, a mortiza tion & other opera ting non-ca s h cha rges 2,062 5.4% 1,695 5.0%Depreci a tion, a mortiza tion & other opera ting non-ca s h cha rges2,062 5.4% 1,695 5.0%
1Adj. EBITDA (4)(5) 7,744 20.5% 6,706 19.9% 15.5% 17.3%Adj. EBITDA (4)(5)7,744 20.5% 6,706 19.9% 15.5% 17.3%
2(1) Except volume and average price per unit case figures.(1)Except volume and average price per unit case figures.
3(2) Please refer to page 13 for revenue breakdown.(2)Please refer to page 13 for revenue breakdown.
4(3) Includes equity method in Jugos del Valle, among others.(3)Includes equity method in Jugos del Valle, among others.
5(4) The operating income and Adjusted EBITDA lines are presented as non-GAAP measures for the convenience of the reader.(4)The operating income and Adjusted EBITDA lines are presented as non-GAAP measures for the convenienc
6(5) Adjusted EBITDA = operating income + depreciation, amortization & other operating non-cash charges.(5)Adjusted EBITDA = operating income + depreciation, amortization & other operating non-cash charges.
7(6) Please refer to page 8 for our definition of “comparable” and a description of the factors affecting the comparability of our financial and operating performance.(6)Please refer to page 8 for our definition of “comparable” and a description of the factors affecting

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

BS — PDF page 12
PDF page scan — BS — 12
BS PDF page 12

Camelot table (pages 12, primary page 12).

#Joined labelLine itemMar-24Dec-23% Var.Liabilities & Equity → Current Li…Mar-24Dec-23% Var.
0Assets Mar-24 Dec-23 % Var. Liabilities & Equity Mar-24 Dec-23 % Var.AssetsMar-24Dec-23% Var.Liabilities & EquityMar-24Dec-23% Var.
1Current Assets Current LiabilitiesCurrent AssetsCurrent Liabilities
2Short-term bank loans and notes payable 170 140 21%Short-term bank loans and notes payable17014021%
3Cash, cash equivalents and marketableCash, cash equivalents and marketable
4securities 35,046 31,060 13% Suppliers 24,604 27,351 -10%securities35,04631,06013%Suppliers24,60427,351-10%
5Total accounts receivable 15,946 17,749 -10% Short-term leasing Liabilities 723 752 -4%Total accounts receivable15,94617,749-10%Short-term leasing Liabilities723752-4%
6Inventories 12,181 11,880 3% Other current liabilities 41,759 26,673 57%Inventories12,18111,8803%Other current liabilities41,75926,67357%
7Other current assets 7,472 7,049 6% Total current liabilities 67,256 54,916 22%Other current assets7,4727,0496%Total current liabilities67,25654,91622%
8Total current assets 70,645 67,738 4% Non-Current Liabilities - -Total current assets70,64567,7384%Non-Current Liabilities--
9Non-Current Assets - - Long-term bank loans and notes payable 64,375 65,074 -1%Non-Current Assets--Long-term bank loans and notes payable64,37565,074-1%
10Property, plant and equipment 136,132 133,406 2% Long Term Leasing Liabilities 1,753 1,769 -1%Property, plant and equipment136,132133,4062%Long Term Leasing Liabilities1,7531,769-1%
11Accumulated depreciation (56,621) (54,676) 4% Other long-term liabilities 18,835 18,056 4%Accumulated depreciation(56,621)(54,676)4%Other long-term liabilities18,83518,0564%
12Total property, plant and equipment, net 79,511 78,730 1% Total liabilities 152,218 139,815 9%Total property, plant and equipment, net79,51178,7301%Total liabilities152,218139,8159%
13Right of use assets 2,325 2,388 -3% Equity - -Right of use assets2,3252,388-3%Equity--
14Investment in shares 9,345 9,246 1% Non-controlling interest 6,678 6,680 0%Investment in shares9,3459,2461%Non-controlling interest6,6786,6800%
15Intangible assets and other assets 99,882 101,162 -1% Total controlling interest 119,208 127,025 -6%Intangible assets and other assets99,882101,162-1%Total controlling interest119,208127,025-6%
16Other non-current assets 16,396 14,256 15% Total equity 125,886 133,705 -6%Other non-current assets16,39614,25615%Total equity125,886133,705-6%
17Total Assets 278,104 273,520 2% Total Liabilities and Equity 278,104 273,520 2%Total Assets278,104273,5202%Total Liabilities and Equity278,104273,5202%

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
7Other current assets 7,472 7,049 6% Total current liabilities 67,256 54,916 22%54,89354,9160.0004OK (5 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 11
PDF page scan — CF — 11
CF PDF page 11

Camelot table (pages 11, primary page 11).

#Joined labelLine item2024% of Rev.2023For the First Quarter of: → % of…Δ% ReportedΔ% Comparable (6)
0For the First Quarter of:For the First Quarter of:
12024 % of Rev. 2023 % of Rev. Δ% Reported Δ% Comparable (6)2024% of Rev.2023% of Rev.Δ% ReportedΔ% Comparable (6)
2Transactions (million transactions) 3,019.1 2,826.8 6.8% 6.8%Transactions (million transactions)3,019.12,826.86.8%6.8%
3Volume (million unit cases) 579.8 537.4 7.9% 7.9%Volume (million unit cases)579.8537.47.9%7.9%
4Avera ge pri ce per uni t ca s e 64.92 62.55 3.8%Avera ge pri ce per uni t ca s e64.9262.553.8%
5Net revenues 37,844 33,612Net revenues37,84433,612
6Other opera ting revenues (0) 5Other opera ting revenues(0)5
7Total Revenues (2) 37,844 100.0% 33,617 100.0% 12.6% 14.1%Total Revenues (2)37,844100.0%33,617100.0%12.6%14.1%
8Cos t of goods s ol d 19,956 52.7% 17,699 52.6%Cos t of goods s ol d19,95652.7%17,69952.6%
9Gross profit 17,888 47.3% 15,919 47.4% 12.4% 13.9%Gross profit17,88847.3%15,91947.4%12.4%13.9%
10Opera ting expens es 12,114 32.0% 11,059 32.9%Opera ting expens es12,11432.0%11,05932.9%
11Other opera tive expens es , net 119 0.3% (111) NAOther opera tive expens es , net1190.3%(111)NA
12Opera tive equi ty method (ga i n) l os s i n a s s oci a tes (3) (26) NA (40) NAOpera tive equi ty method (ga i n) l os s i n a s s oci a tes (3)(26)NA(40)NA
13Operating income (4) 5,681 15.0% 5,011 14.9% 13.4% 15.1%Operating income (4)5,68115.0%5,01114.9%13.4%15.1%
14Depreci a tion, a mortiza tion & other opera ting non-ca s h cha rges 2,062 5.4% 1,695 5.0%Depreci a tion, a mortiza tion & other opera ting non-ca s h cha rges2,0625.4%1,6955.0%
15Adj. EBITDA (4)(5) 7,744 20.5% 6,706 19.9% 15.5% 17.3%Adj. EBITDA (4)(5)7,74420.5%6,70619.9%15.5%17.3%

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

CF — PDF page 12
PDF page scan — CF — 12
CF PDF page 12

No Camelot table — OCR (v8) below.

GPU v8 OCR — page 12 (15 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 2Column 3Column 4Column 5Column 6Column 7
0Cash; cash equivalents and marketable00017014021
1securities3504631060137246042735110
2Total ccounts receivable159461774910572375247
3Inventories121811188039417592667357
4Other current assets7.472704967672565491622
5Total current assets7064567738476
6Non-Current Assets5437555074-1
7Propertyplant and equipment136132133406217531769-1
8Accumulated depreciation56.621-54676418835180564
9Tota property_Plant and equipment_net_795117873011522181398159
10Right of use assets2325238837
11Investment in shares934592461667866800
12Intangible assets and other assets9988210116211192081270256
13Other non-current assets1639614256151258861337056
14Total Assets2781042735202562781042735202

Formulas used