Frontierby eninvs

Язык: EN · RU

← Компания

MX_KOF 2023-09-30 Q3 — report review

Status: PARTIAL — неполно — см. пустые метрики ниже; Currency: MXN; Amounts unit: millions; Forms:

Дата публикации отчёта: Не сохранена для этого периода — укажите financial_report_date в строке (EDGAR filingDate, KASE change_date или manual_catalog).

Full financial report: Ссылка

PDF (local): /home/ubuntu/projects/frontier/data/raw_pdfs/MX_KOF/2023-09-30_Q3_coca-cola-femsa-results-3q23.pdf

Чтобы заново выполнить поиск форм и превью из PDF, откройте эту ссылку Основная ссылка запускает пересчёт в фоне: панель статуса, затем готовая страница. Тяжёлый режим с refresh по умолчанию тоже в фоне (иначе прокси даёт 502). &sync=1 — только для одного долгого синхронного ответа (не рекомендуется). Можно ?refresh=1, ?recalc=1, ?nocache=1 или ?recompute=1. (дождаться в браузере: синхронное обновление)

Сопоставление метрик (значение → evidence)

Значения метрик приведены к единицам дашборда, где это применимо; в колонке evidence — сохранённый фрагмент из текстового слоя PDF или OCR на этапе извлечения.

MetricValueEvidence / page extract
Выручка62 853Row: revenue (mln MXN, batch apply) · dashboard=62,853.000 mln — [DeepSeek] revenue (mln MXN, batch apply)
Опер. прибыль8 460Row: operating_profit (mln MXN, batch apply) · dashboard=8,460.000 mln — [DeepSeek] operating_profit (mln MXN, batch apply)
Аморт. и износ3 370Row: da (mln MXN, batch apply) · dashboard=3,370.000 mln — [DeepSeek] da (mln MXN, batch apply)
EBITDA11 830Row: ebitda (mln MXN, batch apply) · dashboard=11,830.000 mln — [DeepSeek] ebitda (mln MXN, batch apply)
Чистая прибыль5 380Row: net_profit (mln MXN, batch apply) · dashboard=5,380.000 mln — [DeepSeek] net_profit (mln MXN, batch apply)
Cash38 544Row: cash (mln MXN, batch apply) · dashboard=38,544.000 mln — [DeepSeek] cash (mln MXN, batch apply)
Debt short647Row: debt_short (mln MXN, batch apply) · dashboard=647.000 mln — [DeepSeek] debt_short (mln MXN, batch apply)
Debt long67 738Row: debt_long (mln MXN, batch apply) · dashboard=67,738.000 mln — [DeepSeek] debt_long (mln MXN, batch apply)
Чистый долг38 365Компоненты: краткосрочный долг 647 + долгосрочный 67 738 + прочие фин. обязательства 0 + доля НКУ 8 524 − денежные средства 38 544 = чистый долг 38 365.Row: net_debt (mln MXN, batch apply) · dashboard=38,365.000 mln — [DeepSeek] net_debt (mln MXN, batch apply)
Операц. ДДС95 000Row: operating_cash_flow (mln MXN, batch apply) · dashboard=95,000.000 mln — [DeepSeek] operating_cash_flow (mln MXN, batch apply)
Инвест. ДДС
Активы274 616Row: total_assets (mln MXN, batch apply) · dashboard=274,616.000 mln — [DeepSeek] total_assets (mln MXN, batch apply)
Капитал130 825Row: total_equity (mln MXN, batch apply) · dashboard=130,825.000 mln — [DeepSeek] total_equity (mln MXN, batch apply)

Проверки финансовой согласованности · Не пройдены

Балансовое тождество (A = L + E)TA (274,616) ≈ TL (143,791) + TE (130,825); residual +0 within 1%.
Формула чистого долгаnet_debt 38,365 matches |debt_short|+|debt_long|+|other|+|NCI|−|cash| = 38,365.
EBITDA = OP + D&AEBITDA (11,830) ≈ OP (8,460) + D&A (3,370) = 11,830.
Чистая прибыль vs операционнаяNet profit (5,380) sits within a plausible band vs operating profit (8,460).
Денежные средства ≤ активовCash (38,544) ≤ total assets (274,616).
subtotal_BS_Other current assets 8,329 10,729 -22% Total curOther current assets 8,329 10,729 -22% Total current liabilities 58,947 57,959 2%: Σ detail = 57,937, reported 57,959, diff -22 (0.0%, 5 lines).
subtotal_P&L_Gross profit 28,848 45.9% 25,392 44.5% 13.6% 22.Gross profit 28,848 45.9% 25,392 44.5% 13.6% 22.9% 81,451 44.9% 73,469 44.2% 10.9%: Σ detail = 285,449 ≠ reported 81,451; diff +203,998 (71.5% of scale, 8 lines).

Statement pages (discovery)

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

Превью страниц и восстановленные таблицы

Подсветка Жёлтая строка — совпадение с evidence; оранжевая ячейка — точное число, взятое для метрики (наведите на строку). Выручка Опер. прибыль Аморт. и износ EBITDA Чистая прибыль cash debt_short debt_long Активы Капитал Операц. ДДС Инвест. ДДС

Зелёная / янтарная / красная полоса у подписи строки — итог/субитог, где сумма детальных строк сравнивается с числом в отчёте (эвристика). Под каждой таблицей — список проверок (Σ строк vs отчёт, статус).

P&L

Извлечённые метрики по этой форме (строка периода)

ПоказательЗначение
Выручка62 853
Опер. прибыль8 460
EBITDA11 830
Чистая прибыль5 380
Аморт. и износ3 370

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

Camelot table (pages 12, primary page 12).

#Joined labelLine item2023% of Rev.2022For the Third Quarter of: → % of…Δ% ReportedΔ% Comparable (7)2023% of Rev.2022% of Rev.
0Millions of Pesos (1)Millions of Pesos (1)
1For the Third Quarter of: For the First Nine Months of:For the Third Quarter of:For the First Nine 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) 6,048.6 5,507.3 9.8% 9.8% 17,548.7 16,327.4Transactions (million transactions)6,048.65,507.39.8%9.8%17,548.716,327.4
6Volume (million unit cases) 1,033.1 925.8 11.6% 11.6% 2,991.6 2,759.9Volume (million unit cases)1,033.1925.811.6%11.6%2,991.62,759.9
7Average price per unit case 58.87 60.15 -2.1% 58.72 58.65Average price per unit case58.8760.15-2.1%58.7258.65
8Net revenues 62,612 57,017 9.8% 180,780 165,723Net revenues62,61257,0179.8%180,780165,723
9Other operating revenues 241 77 213.6% 596 319Other operating revenues24177213.6%596319
10Total revenues (2) 62,853 100.0% 57,093 100.0% 10.1% 19.2% 181,376 100.0% 166,042Total revenues (2)62,853100.0%57,093100.0%10.1%19.2%181,376100.0%166,042100.0%
11Cost of goods sold 34,005 54.1% 31,702 55.5% 7.3% 99,925 55.1% 92,573Cost of goods sold34,00554.1%31,70255.5%7.3%99,92555.1%92,57355.8%
12Gross profit 28,848 45.9% 25,392 44.5% 13.6% 22.9% 81,451 44.9% 73,469Gross profit28,84845.9%25,39244.5%13.6%22.9%81,45144.9%73,46944.2%
13Operating expenses 19,970 31.8% 17,933 31.4% 11.4% 56,500 31.2% 51,290Operating expenses19,97031.8%17,93331.4%11.4%56,50031.2%51,29030.9%
14Other operative expenses, net 500 0.8% 167 0.3% 200.0% 421 0.2% 451Other operative expenses, net5000.8%1670.3%200.0%4210.2%4510.3%
15Operative equity method (gain) loss in associates (3) (82) -0.1% (43) -0.1% 91.3% (187) -0.1% (152)Operative equity method (gain) loss in associates (3)(82)-0.1%(43)-0.1%91.3%(187)-0.1%(152)-0.1%
16Operating income (5) 8,460 13.5% 7,335 12.8% 15.3% 24.1% 24,716 13.6% 21,881Operating income (5)8,46013.5%7,33512.8%15.3%24.1%24,71613.6%21,88113.2%
17Other non operative expenses, net 138 0.2% 94 0.2% 46.5% 484 0.3% 343Other non operative expenses, net1380.2%940.2%46.5%4840.3%3430.2%
18Non Operative equity method (gain) loss in associates (4) (16) 0.0% (113) -0.2% -85.6% 149 0.1% (141)Non Operative equity method (gain) loss in associates (4)(16)0.0%(113)-0.2%-85.6%1490.1%(141)-0.1%
19Interest expense 1,707 1,339 27.5% 5,382 4,694Interest expense1,7071,33927.5%5,3824,694
20Interest income 721 649 11.1% 2,578 1,606Interest income72164911.1%2,5781,606
21Interest expense, net 986 690 42.9% 2,804 3,088Interest expense, net98669042.9%2,8043,088
22Foreign exchange loss (gain) (322) (40) 696.8% 739 46Foreign exchange loss (gain)(322)(40)696.8%73946
23Loss (gain) on monetary position in inflationaryLoss (gain) on monetary position in inflationary
24subsidiaries (17) (124) -86.3% (134) (434)subsidiaries(17)(124)-86.3%(134)(434)
25Market value (gain) loss on financial instruments (95) 157 -160.4% (80) 738Market value (gain) loss on financial instruments(95)157-160.4%(80)738
26Comprehensive financing result 552 682 -19.0% 3,329 3,438Comprehensive financing result552682-19.0%3,3293,438
27Income before taxes 7,786 6,671 16.7% 20,754 18,241Income before taxes7,7866,67116.7%20,75418,241
28Income taxes 2,273 2,166 4.9% 6,128 5,972Income taxes2,2732,1664.9%6,1285,972
29Result of discontinued operations - - NA - -Result of discontinued operations--NA--
30Consolidated net income 5,513 4,505 22.4% 14,627 12,269Consolidated net income5,5134,50522.4%14,62712,269
31Net income attributable to equity holders of the company 5,380 8.6% 4,374 7.7% 23.0% 33.9% 14,213 7.8% 11,931Net income attributable to equity holders of the company5,3808.6%4,3747.7%23.0%33.9%14,2137.8%11,9317.2%
32Non-controlling interest 133 0.2% 131 0.2% 1.4% 414 0.2% 339Non-controlling interest1330.2%1310.2%1.4%4140.2%3390.2%
33
34Adj. EBITDA & CAPEX 2023 % of Rev. 2022 % of Rev. Δ% Reported Δ% Comparable (7) 2023 % of Rev. 2022Adj. EBITDA & CAPEX2023% of Rev.2022% of Rev.Δ% ReportedΔ% Comparable (7)2023% of Rev.2022% of Rev.
35
36Operating income (5) 8,460 13.5% 7,335 12.8% 15.3% 24.1% 24,716 13.6% 21,881Operating income (5)8,46013.5%7,33512.8%15.3%24.1%24,71613.6%21,88113.2%
37Depreciation 2,468 2,515 -1.9% 7,179 7,287Depreciation2,4682,515-1.9%7,1797,287
38Amortization and other operative non-cash charges 902 777 16.1% 1,841 1,983Amortization and other operative non-cash charges90277716.1%1,8411,983
39Adj. EBITDA (5)(6) 11,830 18.8% 10,626 18.6% 11.3% 20.5% 33,737 18.6% 31,151Adj. EBITDA (5)(6)11,83018.8%10,62618.6%11.3%20.5%33,73718.6%31,15118.8%
40CAPEX(8) 4,976 4,026 23.6% 11,713 11,191CAPEX(8)4,9764,02623.6%11,71311,191

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 28,848 45.9% 25,392 44.5% 13.6% 22.9% 81,451 44.9% 73,469 44.2% 10.9%285,44981,4510.7147Mismatch (8 lines)

BS

Извлечённые метрики по этой форме (строка периода)

ПоказательЗначение
Cash38 544
Debt Short647
Debt Long67 738
Активы274 616
Капитал130 825
Чистый долг38 365

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 — 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 2,151 5.5% 2,111 6.2% 5,566Depreci a tion, a mortiza tion & other opera ting non-ca s h cha rges2,151 5.5% 2,111 6.2% 5,566
1Adj. EBITDA (4)(5) 8,182 21.0% 7,171 21.2% 14.1% 17.0% 23,118Adj. EBITDA (4)(5)8,182 21.0% 7,171 21.2% 14.1% 17.0% 23,118
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 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 — BS — 14
BS PDF page 14

Camelot table (pages 14, primary page 14).

#Joined labelLine itemSep-23Dec-22% Var.Liabilities & Equity → Current Li…Sep-23Dec-22% Var.
0Assets Sep-23 Dec-22 % Var. Liabilities & Equity Sep-23 Dec-22 % Var.AssetsSep-23Dec-22% Var.Liabilities & EquitySep-23Dec-22% Var.
1Current Assets Current LiabilitiesCurrent AssetsCurrent Liabilities
2Short-term bank loans and notes payable 38 8,524 -100%Short-term bank loans and notes payable388,524-100%
3Cash, cash equivalents and marketableCash, cash equivalents and marketable
4securities 38,544 40,277 -4% Suppliers 24,452 26,834 -9%securities38,54440,277-4%Suppliers24,45226,834-9%
5Total accounts receivable 14,292 16,318 -12% Short-term leasing Liabilities 609 472 29%Total accounts receivable14,29216,318-12%Short-term leasing Liabilities60947229%
6Inventories 11,591 11,888 -2% Other current liabilities 33,847 22,129 53%Inventories11,59111,888-2%Other current liabilities33,84722,12953%
7Other current assets 8,329 10,729 -22% Total current liabilities 58,947 57,959 2%Other current assets8,32910,729-22%Total current liabilities58,94757,9592%
8Total current assets 72,756 79,211 -8% Non-Current LiabilitiesTotal current assets72,75679,211-8%Non-Current Liabilities
9Non-Current Assets Long-term bank loans and notes payable 66,123 70,146 -6%Non-Current AssetsLong-term bank loans and notes payable66,12370,146-6%
10Property, plant and equipment 130,010 125,293 4% Long Term Leasing Liabilities 1,615 1,663 -3%Property, plant and equipment130,010125,2934%Long Term Leasing Liabilities1,6151,663-3%
11Accumulated depreciation (56,024) (54,088) 4% Other long-term liabilities 17,107 16,351 5%Accumulated depreciation(56,024)(54,088)4%Other long-term liabilities17,10716,3515%
12Total property, plant and equipment, net 73,986 71,205 4% Total liabilities 143,791 146,119 -2%Total property, plant and equipment, net73,98671,2054%Total liabilities143,791146,119-2%
13Right of use assets 2,119 2,069 2% EquityRight of use assets2,1192,0692%Equity
14Investment in shares 8,664 8,452 3% Non-controlling interest 6,597 6,491 2%Investment in shares8,6648,4523%Non-controlling interest6,5976,4912%
15Intangible assets and other assets 101,241 103,122 -2% Total controlling interest 124,228 125,384 -1%Intangible assets and other assets101,241103,122-2%Total controlling interest124,228125,384-1%
16Other non-current assets 15,851 13,936 14% Total equity 130,825 131,876 -1%Other non-current assets15,85113,93614%Total equity130,825131,876-1%
17Total Assets 274,616 277,995 -1% Total Liabilities and Equity 274,616 277,995 -1%Total Assets274,616277,995-1%Total Liabilities and Equity274,616277,995-1%

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,329 10,729 -22% Total current liabilities 58,947 57,959 2%57,93757,9590.0004OK (5 lines)

CF

Извлечённые метрики по этой форме (строка периода)

ПоказательЗначение
Операц. ДДС95 000
Инвест. ДДС

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 — 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 Third Quarter of:For the Third Quarter of:For the First Nine 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,232.8 2,937.1 10.1% 10.1% 9,363.2Transactions (million transactions)3,232.82,937.110.1%10.1%9,363.28,712.07.5%7.5%
5Volume (million unit cases) 633.2 555.8 13.9% 13.9% 1,813.9Volume (million unit cases)633.2555.813.9%13.9%1,813.91,640.510.6%10.6%
6Avera ge pri ce per uni t ca s e 61.28 60.80 0.8% 61.36Avera ge pri ce per uni t ca s e61.2860.800.8%61.3659.243.6%
7Net revenues 39,024 33,791 111,717Net revenues39,02433,791111,71797,184
8Other opera ting revenues 11 8 23Other opera ting revenues1182325
9Total Revenues (2) 39,035 100.0% 33,799 100.0% 15.5% 18.2% 111,740 100.0%Total Revenues (2)39,035100.0%33,799100.0%15.5%18.2%111,740100.0%97,209100.0%14.9%17.0%
10Cos t of goods s ol d 20,346 52.1% 17,945 53.1% 58,497 52.4%Cos t of goods s ol d20,34652.1%17,94553.1%58,49752.4%50,85352.3%
11Gross profit 18,689 47.9% 15,855 46.9% 17.9% 20.5% 53,243 47.6%Gross profit18,68947.9%15,85546.9%17.9%20.5%53,24347.6%46,35647.7%14.9%16.8%
12Opera ting expens es 12,370 31.7% 10,710 31.7% 35,680 0.3Opera ting expens es12,37031.7%10,71031.7%35,6800.330,3780.3
13Other opera tive expens es , net 344 0.9% 121 0.4% 132 0.1%Other opera tive expens es , net3440.9%1210.4%1320.1%3550.4%
14Opera tive equi ty method (ga i n) l os s i n a s s oci a tes (3) (57) -0.1% (36) -0.1% (121) -0.1%Opera tive equi ty method (ga i n) l os s i n a s s oci a tes (3)(57)-0.1%(36)-0.1%(121)-0.1%(112)-0.1%
15Operating income (4) 6,032 15.5% 5,059 15.0% 19.2% 22.5% 17,552 15.7%Operating income (4)6,03215.5%5,05915.0%19.2%22.5%17,55215.7%15,73616.2%11.5%11.5%
16Depreci a tion, a mortiza tion & other opera ting non-ca s h cha rges 2,151 5.5% 2,111 6.2% 5,566 5.0%Depreci a tion, a mortiza tion & other opera ting non-ca s h cha rges2,1515.5%2,1116.2%5,5665.0%5,6905.9%
17( Adj. EBITDA (4)(5) 8,182 21.0% 7,171 21.2% 14.1% 17.0% 23,118 20.7%( Adj. EBITDA (4)(5)8,18221.0%7,17121.2%14.1%17.0%23,11820.7%21,42622.0%7.9%7.9%

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 — 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 marketable000388524100
1ecurities385444027747244522683497
2Total ccounts receivable14292163181260947229
3Inventories1159111888290338472212953
4Other current assets83291072922958947579592
5Total current assets72756792118
6Non-Current Assets5612370146-6
7Property plant and equipment13001012529345016151663-3
8Accumulated depreciation56.024-54088417107163515
9Tota property_Plant and equipment_net_73986712054143791146119-2
10Right of use assets2119692
11Investment in shares8664845237659764912
12Intangible assets and other assets1012411031222712422812538417
13Other non-current assets158511393614130825131876-1
14Total Assets27461627799519274616277995-1

Formulas used