Frontierby eninvs

Language: EN · RU

← Company

MX_KOF 2023-06-30 Q2 — 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/2023-06-30_Q2_coca-cola-femsa-results-2q23.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
Revenue61 428Row: revenue (mln MXN, batch apply) · dashboard=61,428.000 mln — [DeepSeek] revenue (mln MXN, batch apply)
Operating profit8 562Row: operating_profit (mln MXN, batch apply) · dashboard=8,562.000 mln — [DeepSeek] operating_profit (mln MXN, batch apply)
D&A0Row: derived: same-row components · dashboard=0.000 mln — derived: same-row components
EBITDA8 562Row: computed as operating_profit + D&A (D&A not split out in source → 0) · dashboard=8,562.000 mln — computed as operating_profit + D&A (D&A not split out in source → 0)
Net profit4 926Row: net_profit (mln MXN, batch apply) · dashboard=4,926.000 mln — [DeepSeek] net_profit (mln MXN, batch apply)
Cash30 949Row: cash (mln MXN, batch apply) · dashboard=30,949.000 mln — [DeepSeek] cash (mln MXN, batch apply)
Debt short996Row: debt_short (mln MXN, batch apply) · dashboard=996.000 mln — [DeepSeek] debt_short (mln MXN, batch apply)
Debt long67 188Row: debt_long (mln MXN, batch apply) · dashboard=67,188.000 mln — [DeepSeek] debt_long (mln MXN, batch apply)
Net debt45 759Components: short debt 996 + long debt 67 188 + other financial liab. 0 + NCI 8 524 − cash 30 949 = net debt 45 759.Row: net_debt (mln MXN, batch apply) · dashboard=45,759.000 mln — [DeepSeek] net_debt (mln MXN, batch apply)
Operating CF
Investing CF
Assets263 315Row: total_assets (mln MXN, batch apply) · dashboard=263,315.000 mln — [DeepSeek] total_assets (mln MXN, batch apply)
Equity123 685Row: total_equity (mln MXN, batch apply) · dashboard=123,685.000 mln — [DeepSeek] total_equity (mln MXN, batch apply)

Consistency checks · Failed

Balance sheet identity (A = L + E)TA (263,315) ≈ TL (139,630) + TE (123,685); residual +0 within 1%.
Net debt formulanet_debt 45,759 matches |debt_short|+|debt_long|+|other|+|NCI|−|cash| = 45,759.
EBITDA = OP + D&AEBITDA (8,562) ≈ OP (8,562) + D&A (0) = 8,562.
Net profit vs operating profitNet profit (4,926) sits within a plausible band vs operating profit (8,562).
Cash ≤ total assetsCash (30,949) ≤ total assets (263,315).
subtotal_BS_Other current assets 8,902 10,729 -17% Total curOther current assets 8,902 10,729 -17% Total current liabilities 55,006 57,959 -5%: Σ detail = 57,937, reported 57,959, diff -22 (0.0%, 5 lines).
subtotal_P&L_Gross profit 27,267 44.4% 25,271 44.1% 7.9% 16.9Gross profit 27,267 44.4% 25,271 44.1% 7.9% 16.9% 52,657 44.4% 47,933 44.1% 9.9%: Σ detail = 186,838 ≠ reported 52,657; diff +134,181 (71.8% 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
Revenue61 428
Operating profit8 562
EBITDA8 562
Net profit4 926
D&A0

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 item2023% of Rev.2022For the Sec ond Quarter of: → % o…Δ% ReportedΔ% Comparable (7)2023% of Rev.2022% of Rev.
0Millions of Pesos (1)Millions of Pesos (1)
1For the Sec ond Quarter of: For the First six months of:For the Sec ond Quarter of:For the First six months of:
2
32023 % of Rev. 2022 % of Rev. Δ% Reported Δ% Comparable (7) 2023 % of Rev. 20222023% of Rev.2022% of Rev.Δ% ReportedΔ% Comparable (7)2023% of Rev.2022% of Rev.
4
5Transactions (million transactions) 5,933.0 5,636.1 5.3% 5.3% 11,500.2 10,847.6Transactions (million transactions)5,933.05,636.15.3%5.3%11,500.210,847.6
6Volume (million unit cases) 1,018.9 952.4 7.0% 7.0% 1,958.5 1,834.1Volume (million unit cases)1,018.9952.47.0%7.0%1,958.51,834.1
7Average price per unit case 58.31 60.05 -2.9% 58.70 59.10Average price per unit case58.3160.05-2.9%58.7059.10
8Net revenues 61,283 57,190 7.2% 118,285 108,395Net revenues61,28357,1907.2%118,285108,395
9Other operating revenues 145 121 20.5% 356 239Other operating revenues14512120.5%356239
10Total revenues (2) 61,428 100.0% 57,311 100.0% 7.2% 16.9% 118,641 100.0% 108,635Total revenues (2)61,428100.0%57,311100.0%7.2%16.9%118,641100.0%108,635100.0%
11Cost of goods sold 34,161 55.6% 32,039 55.9% 6.6% 65,984 55.6% 60,702Cost of goods sold34,16155.6%32,03955.9%6.6%65,98455.6%60,70255.9%
12Gross profit 27,267 44.4% 25,271 44.1% 7.9% 16.9% 52,657 44.4% 47,933Gross profit27,26744.4%25,27144.1%7.9%16.9%52,65744.4%47,93344.1%
13Operating expenses 18,796 30.6% 17,448 30.4% 7.7% 36,571 30.8% 33,249Operating expenses18,79630.6%17,44830.4%7.7%36,57130.8%33,24930.6%
14Other operative expenses, net (46) -0.1% 260 0.5% NA (78) -0.1% 282Other operative expenses, net(46)-0.1%2600.5%NA(78)-0.1%2820.3%
15Operative equity method (gain) loss in associates (3) (44) -0.1% (89) -0.2% -50.6% (105) -0.1% (109)Operative equity method (gain) loss in associates (3)(44)-0.1%(89)-0.2%-50.6%(105)-0.1%(109)-0.1%
16Operating income (5) 8,562 13.9% 7,652 13.4% 11.9% 18.7% 16,269 13.7% 14,512Operating income (5)8,56213.9%7,65213.4%11.9%18.7%16,26913.7%14,51213.4%
17Other non operative expenses, net 228 0.4% 70 0.1% 227.1% 351 0.3% 249Other non operative expenses, net2280.4%700.1%227.1%3510.3%2490.2%
18Non Operative equity method (gain) loss in associates (4) 31 0.1% (25) 0.0% NA 165 0.1% (29)Non Operative equity method (gain) loss in associates (4)310.1%(25)0.0%NA1650.1%(29)0.0%
19Interest expense 1,769 1,688 4.8% 3,678 3,339Interest expense1,7691,6884.8%3,6783,339
20Interest income 834 541 54.3% 1,866 948Interest income83454154.3%1,866948
21Interest expense, net 935 1,147 -18.5% 1,812 2,391Interest expense, net9351,147-18.5%1,8122,391
22Foreign exchange loss (gain) 437 (80) NA 1,066 85Foreign exchange loss (gain)437(80)NA1,06685
23Loss (gain) on monetary position in inflationaryLoss (gain) on monetary position in inflationary
24subsidiaries (63) (138) -54.3% (120) (292)subsidiaries(63)(138)-54.3%(120)(292)
25Market value (gain) loss on financial instruments 68 (355) NA 15 581Market value (gain) loss on financial instruments68(355)NA15581
26Comprehensive financing result 1,377 574 139.9% 2,774 2,765Comprehensive financing result1,377574139.9%2,7742,765
27Income before taxes 6,926 7,034 -1.5% 12,978 11,526Income before taxes6,9267,034-1.5%12,97811,526
28Income taxes 1,881 2,458 -23.5% 3,860 3,787Income taxes1,8812,458-23.5%3,8603,787
29Result of discontinued operations - - NA - -Result of discontinued operations--NA--
30Consolidated net income 5,045 4,576 10.3% 9,118 7,740Consolidated net income5,0454,57610.3%9,1187,740
31Net income attributable to equity holders of the company 4,926 8.0% 4,627 8.1% 6.5% 12.0% 8,837 7.4% 7,532Net income attributable to equity holders of the company4,9268.0%4,6278.1%6.5%12.0%8,8377.4%7,5326.9%
32Non-controlling interest 119 0.2% (51) -0.1% NA 281 0.2% 208Non-controlling interest1190.2% (51)-0.1%NA2810.2%2080.2%
33
34EBITDA & CAPEX 2023 % of Rev. 2022 % of Rev. Δ% Reported Δ% Comparable (7) 2023 % of Rev. 2022EBITDA & CAPEX2023% of Rev.2022% of Rev.Δ% ReportedΔ% Comparable (7)2023% of Rev.2022% of Rev.
35
36Operating income (5) 8,562 13.9% 7,652 13.4% 11.9% 18.7% 16,269 13.7% 14,512Operating income (5)8,56213.9%7,65213.4%11.9%18.7%16,26913.7%14,51213.4%
37Depreciation 2,397 2,399 -0.1% 4,717 4,755Depreciation2,3972,399-0.1%4,7174,755
38Amortization and other operative non-cash charges 480 556 -13.7% 945 1,195Amortization and other operative non-cash charges480556-13.7%9451,195
39EBITDA (5)(6) 11,439 18.6% 10,607 18.5% 7.8% 16.0% 21,930 18.5% 20,461EBITDA (5)(6)11,43918.6%10,60718.5%7.8%16.0%21,93018.5%20,46118.8%
40CAPEX(8) 4,252 4,052 4.9% 6,749 7,157CAPEX(8)4,2524,0524.9%6,7497,157

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
12Gross profit 27,267 44.4% 25,271 44.1% 7.9% 16.9% 52,657 44.4% 47,933 44.1% 9.9%186,83852,6570.7182Mismatch (8 lines)

BS

Extracted metrics for this form (this period row)

MetricValue
Cash30 949
Debt Short996
Debt Long67 188
Assets263 315
Equity123 685
Net debt45 759

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,720 4.4% 1,806 5.2%Depreci a tion, a mortiza tion & other opera ting non-ca s h cha rges1,720 4.4% 1,806 5.2%
1EBITDA (4)(5) 8,229 21.1% 7,533 21.9% 9.2% 10.8%EBITDA (4)(5)8,229 21.1% 7,533 21.9% 9.2% 10.8%
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 for revenue breakdown.(2)Please refer to page 15 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 EBITDA lines are presented as non-GAAP measures for the convenience of the reader.(4)The operating income and EBITDA lines are presented as non-GAAP measures for the convenience of the
6(5) EBITDA = operating income + depreciation, amortization & other operating non-cash charges.(5)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-23Dec-22% Var.Liabilities & Equity → Current Li…Jun-23Dec-22% Var.
0Assets Jun-23 Dec-22 % Var. Liabilities & Equity Jun-23 Dec-22 % Var.AssetsJun-23Dec-22% Var.Liabilities & EquityJun-23Dec-22% Var.
1Current Assets Current LiabilitiesCurrent AssetsCurrent Liabilities
2Short-term bank loans and notes payable 387 8,524 -95%Short-term bank loans and notes payable3878,524-95%
3Cash, cash equivalents and marketableCash, cash equivalents and marketable
4securities 30,949 40,277 -23% Suppliers 22,949 26,834 -14%securities30,94940,277-23%Suppliers22,94926,834-14%
5Total accounts receivable 13,779 16,318 -16% Short-term leasing Liabilities 609 472 29%Total accounts receivable13,77916,318-16%Short-term leasing Liabilities60947229%
6Inventories 12,067 11,888 2% Other current liabilities 31,061 22,129 40%Inventories12,06711,8882%Other current liabilities31,06122,12940%
7Other current assets 8,902 10,729 -17% Total current liabilities 55,006 57,959 -5%Other current assets8,90210,729-17%Total current liabilities55,00657,959-5%
8Total current assets 65,697 79,211 -17% Non-Current Liabilities - -Total current assets65,69779,211-17%Non-Current Liabilities--
9Non-Current Assets - - Long-term bank loans and notes payable 65,371 70,146 -7%Non-Current Assets--Long-term bank loans and notes payable65,37170,146-7%
10Property, plant and equipment 125,650 125,293 0% Long Term Leasing Liabilities 1,817 1,663 9%Property, plant and equipment125,650125,2930%Long Term Leasing Liabilities1,8171,6639%
11Accumulated depreciation (54,627) (54,088) 1% Other long-term liabilities 17,436 16,351 7%Accumulated depreciation(54,627)(54,088)1%Other long-term liabilities17,43616,3517%
12Total property, plant and equipment, net 71,023 71,205 0% Total liabilities 139,630 146,119 -4%Total property, plant and equipment, net71,02371,2050%Total liabilities139,630146,119-4%
13Right of use assets 2,325 2,069 12% Equity - -Right of use assets2,3252,06912%Equity--
14Investment in shares 8,442 8,452 0% Non-controlling interest 6,465 6,491 0%Investment in shares8,4428,4520%Non-controlling interest6,4656,4910%
15Intangible assets and other assets 101,043 103,122 -2% Total controlling interest 117,221 125,384 -7%Intangible assets and other assets101,043103,122-2%Total controlling interest117,221125,384-7%
16Other non-current assets 14,784 13,936 6% Total equity 123,685 131,876 -6%Other non-current assets14,78413,9366%Total equity123,685131,876-6%
17Total Assets 263,315 277,995 -5% Total Liabilities and Equity 263,315 277,995 -5%Total Assets263,315277,995-5%Total Liabilities and Equity263,315277,995-5%

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 8,902 10,729 -17% Total current liabilities 55,006 57,959 -5%57,93757,9590.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 item2023% of Rev.2022% of Rev.Δ% → ReportedΔ% ComparableColumn 82023% of Rev.2022% 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
32023 % of Rev. 2022 % of Rev. Reported 2023 % of Rev.2023% of Rev.2022% of Rev.Reported2023% of Rev.2022% of Rev.ReportedComparable (6)
4Transactions (million transactions) 3,303.6 3,126.6 5.7% 5.7% 6,130.4Transactions (million transactions)3,303.63,126.65.7%5.7%6,130.45,774.96.2%
5Volume (million unit cases) 643.3 590.7 8.9% 8.9% 1,180.7Volume (million unit cases)643.3590.78.9%8.9%1,180.71,084.78.8%
6Avera ge pri ce per uni t ca s e 60.44 58.35 3.6% 61.40Avera ge pri ce per uni t ca s e60.4458.353.6%61.4058.445.1%
7Net revenues 39,081 34,466 72,693Net revenues39,08134,46672,69363,393
8Other opera ting revenues 6 9 12Other opera ting revenues691217
9Total Revenues (2) 39,088 100.0% 34,475 100.0% 13.4% 15.1% 72,705 100.0%Total Revenues (2)39,088100.0%34,475100.0%13.4%15.1%72,705100.0%63,410100.0%14.7%
10Cos t of goods s ol d 20,452 52.3% 17,980 52.2% 38,151 52.5%Cos t of goods s ol d20,45252.3%17,98052.2%38,15152.5%32,90851.9%
11Gross profit 18,635.4 47.7% 16,495.0 47.8% 13.0% 14.6% 34,554.2 47.5%Gross profit18,635.447.7%16,495.047.8%13.0%14.6%34,554.247.5%30,501.848.1%13.3%
12Opera ting expens es 12,251.8 31.3% 10,562.0 30.6% 23,310.5 0.3Opera ting expens es12,251.831.3%10,562.030.6%23,310.50.319,667.50.3
13Other opera tive expens es , net (101) -0.3% 236 0.7% (212) -0.3%Other opera tive expens es , net(101)-0.3%2360.7%(212)-0.3%2340.4%
14Opera tive equi ty method (ga i n) l os s i n a s s oci a tes (3) (24) -0.1% (30) -0.1% (64) -0.1%Opera tive equi ty method (ga i n) l os s i n a s s oci a tes (3)(24)-0.1%(30)-0.1%(64)-0.1%(76)-0.1%
15Operating income (4) 6,509 16.7% 5,727 16.6% 13.7% 15.1% 11,520 15.8%Operating income (4)6,50916.7%5,72716.6%13.7%15.1%11,52015.8%10,67716.8%7.9%
16Depreci a tion, a mortiza tion & other opera ting non-ca s h cha rges 1,720 4.4% 1,806 5.2% 3,415 4.7%Depreci a tion, a mortiza tion & other opera ting non-ca s h cha rges1,7204.4%1,8065.2%3,4154.7%3,5795.6%
17EBITDA (4)(5) 8,229 21.1% 7,533 21.9% 9.2% 10.8% 14,935 20.5%EBITDA (4)(5)8,22921.1%7,53321.9%9.2%10.8%14,93520.5%14,25622.5%4.8%

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 marketable000387852495
1securities30949402772372294926834-14
2Total ccounts receivable137791631816560947229
3Inventories1206711888290310612212940
4Other current assets89021072917955006579595
5Total current assets6569779211175
6Non-Current Assets5537170146-7
7Propertyplant and equipment12565012529356181716639
8Accumulated depreciation-54627-54088117436163517
9Tota property_Plant and equipment_net_71023712050139630146119-4
10Right of use assets232569127
11Investment in shares84424520646564910
12Intangible assets and other assets101043103122270117221125384-7
13Other non-current assets147841393667123685131876676
14Total Assets263315277995570263315277995-5

Formulas used