Frontierby eninvs

Language: EN · RU

← Company

MX_KOF 2024-06-30 H1 — 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-06-30_Q2_coca-cola-femsa-results-2q24.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
Revenue133 685Row: revenue (mln MXN, batch apply) · dashboard=133,685.000 mln — [DeepSeek] revenue (mln MXN, batch apply)
Operating profit18 380Row: operating_profit (mln MXN, batch apply) · dashboard=18,380.000 mln — [DeepSeek] operating_profit (mln MXN, batch apply)
D&A7 568Row: da (mln MXN, batch apply) · dashboard=7,568.000 mln — [DeepSeek] da (mln MXN, batch apply)
EBITDA25 948Row: ebitda (mln MXN, batch apply) · dashboard=25,948.000 mln — [DeepSeek] ebitda (mln MXN, batch apply)
Net profit10 598Row: net_profit (mln MXN, batch apply) · dashboard=10,598.000 mln — [DeepSeek] net_profit (mln MXN, batch apply)
Cash38 271Row: cash (mln MXN, batch apply) · dashboard=38,271.000 mln — [DeepSeek] cash (mln MXN, batch apply)
Debt short1 378Row: debt_short (mln MXN, batch apply) · dashboard=1,378.000 mln — [DeepSeek] debt_short (mln MXN, batch apply)
Debt long70 067Row: debt_long (mln MXN, batch apply) · dashboard=70,067.000 mln — [DeepSeek] debt_long (mln MXN, batch apply)
Net debt173 174Components: short debt 1 378 + long debt 70 067 + other financial liab. 0 + NCI 140 000 − cash 38 271 = net debt 173 174.Row: net_debt (mln MXN, batch apply) · dashboard=173,174.000 mln — [DeepSeek] net_debt (mln MXN, batch apply)
Operating CF
Investing CF
Assets288 028Row: total_assets (mln MXN, batch apply) · dashboard=288,028.000 mln — [DeepSeek] total_assets (mln MXN, batch apply)
Equity134 892Row: total_equity (mln MXN, batch apply) · dashboard=134,892.000 mln — [DeepSeek] total_equity (mln MXN, batch apply)

Consistency checks · Failed

Balance sheet identity (A = L + E)TA (288,028) ≈ TL (153,136) + TE (134,892); residual +0 within 1%.
Net debt formulanet_debt 173,174 matches |debt_short|+|debt_long|+|other|+|NCI|−|cash| = 173,174.
EBITDA = OP + D&AEBITDA (25,948) ≈ OP (18,380) + D&A (7,568) = 25,948.
Net profit vs operating profitNet profit (10,598) sits within a plausible band vs operating profit (18,380).
Cash ≤ total assetsCash (38,271) ≤ total assets (288,028).
subtotal_BS_Other current assets 7,290 7,049 3% Total currenOther current assets 7,290 7,049 3% Total current liabilities 65,813 54,916 20%: Σ detail = 54,893, reported 54,916, diff -23 (0.0%, 5 lines).
subtotal_P&L_Gross profit 31,961 46.0% 27,267 44.4% 17.2% 22.Gross profit 31,961 46.0% 27,267 44.4% 17.2% 22.0% 60,561 45.3% 52,657 44.4% 15.0%: Σ detail = 210,767 ≠ reported 60,561; diff +150,206 (71.3% of scale, 8 lines).

Statement pages (discovery)

FormPages
P&L11, 12, 13
BS13, 14, 15
CF13, 14, 15

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
Revenue133 685
Operating profit18 380
EBITDA25 948
Net profit10 598
D&A7 568

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

No Camelot table — OCR (v8) below.

v8 OCR page 11: empty rows.

P&L — PDF page 12
PDF page scan — P&L — 12
P&L PDF page 12

Camelot table (pages 12, primary page 12).

#Joined labelLine item2024% of Rev.2023For the Sec ond Quarter of: → % o…Δ% ReportedΔ% Comparable (7)2024% of Rev.2023For the First Six Months of: → %…
0Millions of Pesos (1)Millions of Pesos (1)
1For the Sec ond Quarter of:For the Sec ond Quarter of:For the First Six Months of:
22024 % of Rev. 2023 % of Rev. Δ% Reported Δ% Comparable (7) 2024 % of Rev. 20232024% of Rev.2023% of Rev.Δ% ReportedΔ% Comparable (7)2024% of Rev.2023% of Rev.
3Transactions (million transactions) 6,372.8 5,933.0 7.4% 7.4% 12,330.8 11,500.2Transactions (million transactions)6,372.85,933.07.4%7.4%12,330.811,500.2
4Volume (million unit cases) 1,095.8 1,018.9 7.5% 7.5% 2,104.4 1,958.5Volume (million unit cases)1,095.81,018.97.5%7.5%2,104.41,958.5
5Average price per unit case 61.89 58.31 6.1% 61.77 58.70Average price per unit case61.8958.316.1%61.7758.70
6Net revenues 69,297 61,283 13.1% 133,359 118,285Net revenues69,29761,28313.1%133,359118,285
7Other operating revenues 159 145 9.6% 326 356Other operating revenues1591459.6%326356
8Total revenues (2) 69,456 100.0% 61,428 100.0% 13.1% 17.9% 133,685 100.0% 118,641Total revenues (2)69,456100.0%61,428100.0%13.1%17.9%133,685100.0%118,641100.0%
9Cost of goods sold 37,495 54.0% 34,161 55.6% 9.8% 73,124 54.7% 65,984Cost of goods sold37,49554.0%34,16155.6%9.8%73,12454.7%65,98455.6%
10Gross profit 31,961 46.0% 27,267 44.4% 17.2% 22.0% 60,561 45.3% 52,657Gross profit31,96146.0%27,26744.4%17.2%22.0%60,56145.3%52,65744.4%
11Operating expenses 21,621 31.1% 18,796 30.6% 15.0% 41,438 31.0% 36,571Operating expenses21,62131.1%18,79630.6%15.0%41,43831.0%36,57130.8%
12Other operative expenses, net 672 1.0% (46) NA NA 864 0.6% (78)Other operative expenses, net6721.0%(46)NANA8640.6%(78)NA
13Operative equity method (gain) loss in associates (3) (78) NA (44) NA 77.2% (122) NA (105)Operative equity method (gain) loss in associates (3)(78)NA(44)NA77.2%(122)NA(105)NA
14Operating income (5) 9,746 14.0% 8,562 13.9% 13.8% 17.5% 18,380 13.7% 16,269Operating income (5)9,74614.0%8,56213.9%13.8%17.5%18,38013.7%16,26913.7%
15Other non operative expenses, net 63 0.1% 228 0.4% -72.2% (27) 0.0% 351Other non operative expenses, net630.1%2280.4%-72.2%(27)0.0%3510.3%
16Non Operative equity method (gain) loss in associates (4) 45 0.1% 31 0.1% NA 58 0.0% 165Non Operative equity method (gain) loss in associates (4)450.1%310.1%NA580.0%1650.1%
17Interest expense 1,836 1,769 3.7% 3,648 3,678Interest expense1,8361,7693.7%3,6483,678
18Interest income 678 834 -18.7% 1,307 1,866Interest income678834-18.7%1,3071,866
19Interest expense, net 1,157 935 23.8% 2,341 1,812Interest expense, net1,15793523.8%2,3411,812
20Foreign exchange loss (gain) (177) 437 NA (204) 1,066Foreign exchange loss (gain)(177)437NA(204)1,066
21Loss (gain) on monetary position in inflationaryLoss (gain) on monetary position in inflationary
22subsidiaries (34) (63) -46.0% (42) (120)subsidiaries(34)(63)-46.0%(42)(120)
23Market value (gain) loss on financial instruments (61) 68 NA (15) 15Market value (gain) loss on financial instruments(61)68NA(15)15
24Comprehensive financing result 885 1,377 -35.7% 2,080 2,774Comprehensive financing result8851,377-35.7%2,0802,774
25Income before taxes 8,752 6,926 26.4% 16,269 12,978Income before taxes8,7526,92626.4%16,26912,978
26Income taxes 3,044 1,881 61.8% 5,329 3,860Income taxes3,0441,88161.8%5,3293,860
27Result of discontinued operations - - NA - -Result of discontinued operations--NA--
28Consolidated net income 5,709 5,045 13.2% 10,941 9,118Consolidated net income5,7095,04513.2%10,9419,118
29Net income attributable to equity holders of the company 5,608 8.1% 4,926 8.0% 13.8% 18.7% 10,598 7.9% 8,837Net income attributable to equity holders of the company5,6088.1%4,9268.0%13.8%18.7%10,5987.9%8,8377.4%
30Non-controlling interest 101 0.1% 119 0.2% NA 342 0.3% 281Non-controlling interest1010.1%1190.2%NA3420.3%2810.2%
31Adj. EBITDA & CAPEX 2024 % of Rev. 2023 % of Rev. Δ% Reported Δ% Comparable (7) 2024 % of Rev. 2023Adj. EBITDA & CAPEX2024% of Rev.2023% of Rev.Δ% ReportedΔ% Comparable (7)2024% of Rev.2023% of Rev.
32Operating income (5) 9,746 14.0% 8,562 13.9% 13.8% 17.5% 18,380 13.7% 16,269Operating income (5)9,74614.0%8,56213.9%13.8%17.5%18,38013.7%16,26913.7%
33Depreciation 2,657 2,397 10.8% 5,219 4,717Depreciation2,6572,39710.8%5,2194,717
34Amortization and other operative non-cash charges 1,519 480 216.7% 2,349 945Amortization and other operative non-cash charges1,519480216.7%2,349945
35Adj. EBITDA (5)(6) 13,922 20.0% 11,439 18.6% 21.7% 27.0% 25,949 19.4% 21,930Adj. EBITDA (5)(6)13,92220.0%11,43918.6%21.7%27.0%25,94919.4%21,93018.5%
36CAPEX(8) 5,512 4,252 29.6% 8,693 6,749CAPEX(8)5,5124,25229.6%8,6936,749

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
10Gross profit 31,961 46.0% 27,267 44.4% 17.2% 22.0% 60,561 45.3% 52,657 44.4% 15.0%210,76760,5610.7127Mismatch (8 lines)

BS

Extracted metrics for this form (this period row)

MetricValue
Cash38 271
Debt Short1 378
Debt Long70 067
Assets288 028
Equity134 892
Net debt173 174

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

Camelot table (pages 13, primary page 13).

#Joined labelLine itemExcept volume and average price p…
0Depreci a tion, a mortiza tion & other opera ting non-ca s h cha rges 1,585 6.5% 1,156 5.2% 2,915 5.7%Depreci a tion, a mortiza tion & other opera ting non-ca s h cha rges1,585 6.5% 1,156 5.2% 2,915 5.7%
1Adj. EBITDA (4)(5) 4,040 16.6% 3,209 14.4% 25.9% 46.5% 8,323 16.4%Adj. EBITDA (4)(5)4,040 16.6% 3,209 14.4% 25.9% 46.5% 8,323 16.4%
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 15 and 16 for revenue breakdown.(2)Please refer to page 15 and 16 for revenue breakdown.
4(3) Includes equity method in Leão Alimentos, among others.(3)Includes equity method in Leão Alimentos, 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 10 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 10 for our definition of “comparable” and a description of the factors affectin

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

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

Camelot table (pages 14, primary page 14).

#Joined labelLine itemJun-24Dec-23% Var.Liabilities & Equity → Current Li…Jun-24Dec-23% Var.
0Assets Jun-24 Dec-23 % Var. Liabilities & Equity Jun-24 Dec-23 % Var.AssetsJun-24Dec-23% Var.Liabilities & EquityJun-24Dec-23% Var.
1Current Assets Current LiabilitiesCurrent AssetsCurrent Liabilities
2Short-term bank loans and notes payable 622 140 345%Short-term bank loans and notes payable622140345%
3Cash, cash equivalents and marketableCash, cash equivalents and marketable
4securities 38,271 31,060 23% Suppliers 25,653 27,351 -6%securities38,27131,06023%Suppliers25,65327,351-6%
5Total accounts receivable 16,803 17,749 -5% Short-term leasing Liabilities 756 752 1%Total accounts receivable16,80317,749-5%Short-term leasing Liabilities7567521%
6Inventories 12,413 11,880 4% Other current liabilities 38,782 26,673 45%Inventories12,41311,8804%Other current liabilities38,78226,67345%
7Other current assets 7,290 7,049 3% Total current liabilities 65,813 54,916 20%Other current assets7,2907,0493%Total current liabilities65,81354,91620%
8Total current assets 74,777 67,738 10% Non-Current Liabilities - -Total current assets74,77767,73810%Non-Current Liabilities--
9Non-Current Assets - - Long-term bank loans and notes payable 67,929 65,074 4%Non-Current Assets--Long-term bank loans and notes payable67,92965,0744%
10Property, plant and equipment 142,619 133,406 7% Long Term Leasing Liabilities 2,138 1,769 21%Property, plant and equipment142,619133,4067%Long Term Leasing Liabilities2,1381,76921%
11Accumulated depreciation (58,855) (54,676) 8% Other long-term liabilities 17,255 18,056 -4%Accumulated depreciation(58,855)(54,676)8%Other long-term liabilities17,25518,056-4%
12Total property, plant and equipment, net 83,764 78,730 6% Total liabilities 153,136 139,815 10%Total property, plant and equipment, net83,76478,7306%Total liabilities153,136139,81510%
13Right of use assets 2,738 2,388 15% Equity - -Right of use assets2,7382,38815%Equity--
14Investment in shares 9,458 9,246 2% Non-controlling interest 6,751 6,680 1%Investment in shares9,4589,2462%Non-controlling interest6,7516,6801%
15Intangible assets and other assets 100,283 101,162 -1% Total controlling interest 128,141 127,025 1%Intangible assets and other assets100,283101,162-1%Total controlling interest128,141127,0251%
16Other non-current assets 17,007 14,256 19% Total equity 134,892 133,705 1%Other non-current assets17,00714,25619%Total equity134,892133,7051%
17Total Assets 288,028 273,520 5% Total Liabilities and Equity 288,028 273,520 5%Total Assets288,028273,5205%Total Liabilities and Equity288,028273,5205%

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,290 7,049 3% Total current liabilities 65,813 54,916 20%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 13
PDF page scan — CF — 13
CF PDF page 13

Camelot table (pages 13, primary page 13).

#Joined labelLine item2024% of Rev.2023% of Rev.Δ% → ReportedΔ% ComparableColumn 82024% of Rev.2023% of Rev.Δ% → ReportedΔ% → Comparable (6)
0For the Sec ond Quarter of:For the Sec ond Quarter of:For the First Six Months of:
1Δ% Δ% ComparableΔ%Δ% ComparableΔ%Δ%
2
32024 % of Rev. 2023 % of Rev. Reported 2024 % of Rev.2024% of Rev.2023% of Rev.Reported2024% of Rev.2023% of Rev.ReportedComparable (6)
4Transactions (million transactions) 3,565.3 3,303.6 7.9% 7.9% 6,584.4Transactions (million transactions)3,565.33,303.67.9%7.9%6,584.46,130.47.4%
5Volume (million unit cases) 695.6 643.3 8.1% 8.1% 1,275.4Volume (million unit cases)695.6643.38.1%8.1%1,275.41,180.78.0%
6Avera ge pri ce per uni t ca s e 64.48 60.44 6.7% 64.68Avera ge pri ce per uni t ca s e64.4860.446.7%64.6861.405.3%
7Net revenues 45,078 39,081 82,922Net revenues45,07839,08182,92272,693
8Other opera ting revenues (11) 6 (11)Other opera ting revenues(11)6(11)12
9Total Revenues (2) 45,067 100.0% 39,088 100.0% 15.3% 15.6% 82,911 100.0%Total Revenues (2)45,067100.0%39,088100.0%15.3%15.6%82,911100.0%72,705100.0%14.0%
10Cos t of goods s ol d 23,119 51.3% 20,452 52.3% 43,075 52.0%Cos t of goods s ol d23,11951.3%20,45252.3%43,07552.0%38,15152.5%
11Gross profit 21,947.5 48.7% 18,635.4 47.7% 17.8% 18.1% 39,835.6 48.0%Gross profit21,947.548.7%18,635.447.7%17.8%18.1%39,835.648.0%34,554.247.5%15.3%
12Opera ting expens es 14,240.6 31.6% 12,251.8 31.3% 26,354.4 31.8%Opera ting expens es14,240.631.6%12,251.831.3%26,354.431.8%23,310.532.1%
13Other opera tive expens es , net 478 1.1% (101) NA 597 0.7%Other opera tive expens es , net4781.1%(101)NA5970.7%(212)NA
14Opera tive equi ty method (ga i n) l os s i n a s s oci a tes (3) (62) NA (24) NA (88) NAOpera tive equi ty method (ga i n) l os s i n a s s oci a tes (3)(62)NA(24)NA(88)NA(64)NA
15Operating income (4) 7,291 16.2% 6,509 16.7% 12.0% 12.3% 12,972 15.6%Operating income (4)7,29116.2%6,50916.7%12.0%12.3%12,97215.6%11,52015.8%12.6%
16Depreci a tion, a mortiza tion & other opera ting non-ca s h cha rges 2,591 5.8% 1,720 4.4% 4,654 5.6%Depreci a tion, a mortiza tion & other opera ting non-ca s h cha rges2,5915.8%1,7204.4%4,6545.6%3,4154.7%
17Adj. EBITDA (4)(5) 9,882 21.9% 8,229 21.1% 20.1% 20.4% 17,626 21.3%Adj. EBITDA (4)(5)9,88221.9%8,22921.1%20.1%20.4%17,62621.3%14,93520.5%18.0%

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

CF — PDF page 14
PDF page scan — CF — 14
CF PDF page 14

No Camelot table — OCR (v8) below.

GPU v8 OCR — page 14 (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 marketable000622140345
1securities382713106023702565327351676
2Total ccounts receivable16803177495756752176
3Inventories1241311880496387822667345
4Other current assets72907049376658135491620
5Total current assets747776773810
6Non-Current Assets57929550744
7Propertyplant and equipment14261913340672138176921
8Accumulated depreciation58.855-546768701725518056-4
9Tota property_Plant and equipment_net_8376478730615313613981510
10Right of use assets2738238815
11Investment in shares945892462675166801
12Intangible assets and other assets10028310116211281411270251
13Other non-current assets1700714256191348921337051
14Total Assets2880282735205702880282735205

Formulas used