Frontierby eninvs

Язык: EN · RU

← Компания

MX_KOF 2024-03-31 Q1 — report review

Status: OK — неполно — см. пустые метрики ниже; 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/2024-03-31_Q1_coca-cola-femsa-results-1q24.pdf

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

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

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

MetricValueEvidence / page extract
Выручка63 803Row: revenue (mln MXN, batch apply) · dashboard=63,803.000 mln — [DeepSeek] revenue (mln MXN, batch apply)
Опер. прибыль8 617Row: operating_profit (mln MXN, batch apply) · dashboard=8,617.000 mln — [DeepSeek] operating_profit (mln MXN, batch apply)
Аморт. и износ3 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)
Чистая прибыль5 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)
Чистый долг169 499Компоненты: краткосрочный долг 170 + долгосрочный 64 375 + прочие фин. обязательства 0 + доля НКУ 140 000 − денежные средства 35 046 = чистый долг 169 499.Row: net_debt (mln MXN, batch apply) · dashboard=169,499.000 mln — [DeepSeek] net_debt (mln MXN, batch apply)
Операц. ДДС
Инвест. ДДС
Активы278 104Row: total_assets (mln MXN, batch apply) · dashboard=278,104.000 mln — [DeepSeek] total_assets (mln MXN, batch apply)
Капитал125 886Row: total_equity (mln MXN, batch apply) · dashboard=125,886.000 mln — [DeepSeek] total_equity (mln MXN, batch apply)

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

Балансовое тождество (A = L + E)TA (278,104) ≈ TL (152,218) + TE (125,886); residual +0 within 1%.
Формула чистого долгаnet_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.
Чистая прибыль vs операционнаяNet profit (5,006) sits within a plausible band vs operating profit (8,617).
Денежные средства ≤ активовCash (35,046) ≤ total assets (278,104).
subtotal_BS_Other current assets 7,472 7,049 6% Total currenOther current assets 7,472 7,049 6% Total current liabilities 67,256 54,916 22%: Σ detail = 54,893, reported 54,916, diff -23 (0.0%, 5 lines).

Statement pages (discovery)

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

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

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

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

P&L

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

ПоказательЗначение
Выручка63 803
Опер. прибыль8 617
EBITDA11 944
Чистая прибыль5 006
Аморт. и износ3 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 — 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 — 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

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

ПоказательЗначение
Cash35 046
Debt Short170
Debt Long64 375
Активы278 104
Капитал125 886
Чистый долг169 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 — 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 — 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

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

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

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 — 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 — 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