KOF Intrinsic Value
Intrinsic Value of KOF Overview
KOF Historical Intrinsic Value
KOF Valuation Metrics
KOF DCF Model
| Dec'19 Actual | Dec'20 Actual | Dec'21 Actual | Dec'22 Actual | Dec'23 Actual | Dec'24 Estimate | Dec'25 Estimate | Dec'26 Estimate | Dec'27 Estimate | Dec'28 Estimate | Dec'29 Estimate | Dec'30 Estimate | Dec'31 Estimate | Dec'32 Estimate | Dec'33 Estimate | Dec'34 Terminal | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
% growth | 194,471.0 6.7% | 183,615.0 (5.6%) | 194,804.0 6.1% | 226,740.0 16.4% | 245,088.0 8.1% | 277,219.6 13.1% | 299,773.2 8.1% | 323,421.4 7.9% | 357,742.4 10.6% | 390,341.3 9.1% | 421,283.7 7.9% | 449,684.9 6.7% | 474,670.3 5.6% | 495,417.2 4.4% | 511,198.2 3.2% | 521,422.2 2.0% |
% margin | 25,423.0 13.1% | 25,243.0 13.7% | 27,402.0 14.1% | 30,838.0 13.6% | 34,348.0 14.0% | 35,838.6 12.9% | 38,754.3 12.9% | 41,811.6 12.9% | 46,248.5 12.9% | 50,462.9 12.9% | 54,463.1 12.9% | 58,134.8 12.9% | 61,364.8 12.9% | 64,047.0 12.9% | 66,087.1 12.9% | 67,408.9 12.9% |
NOPAT % effective tax rate | 17,567.2 9.0% | 16,568.7 9.0% | 19,507.5 10.0% | 23,124.1 10.2% | 23,872.5 9.7% | 24,908.5 9.0% | 26,935.0 9.0% | 29,059.8 9.0% | 32,143.6 9.0% | 35,072.7 9.0% | 37,852.9 9.0% | 40,404.8 9.0% | 42,649.8 9.0% | 44,513.9 9.0% | 45,931.8 9.0% | 46,850.5 9.0% |
% of revenue | 10,642.0 5.5% | 10,031.0 5.5% | 9,834.0 5.0% | 10,425.0 4.6% | 10,531.0 4.3% | 12,884.0 4.6% | 13,932.2 4.6% | 15,031.3 4.6% | 16,626.4 4.6% | 18,141.4 4.6% | 19,579.5 4.6% | 20,899.5 4.6% | 22,060.7 4.6% | 23,024.9 4.6% | 23,758.4 4.6% | 24,233.5 4.6% |
% of revenue | (11,745.0) (6.0%) | (9,944.0) (5.4%) | (9,989.0) (5.1%) | (17,735.0) (7.8%) | (20,632.0) (8.4%) | (19,745.1) (7.1%) | (21,351.5) (7.1%) | (23,035.9) (7.1%) | (25,480.4) (7.1%) | (27,802.3) (7.1%) | (30,006.1) (7.1%) | (32,029.0) (7.1%) | (33,808.6) (7.1%) | (35,286.3) (7.1%) | (36,410.4) (7.1%) | (37,138.6) (7.1%) |
% of revenue | 2,397.0 1.2% | 5,181.0 2.8% | 1,637.0 0.8% | (1,076.0) (0.5%) | 2,572.0 1.0% | 1,307.7 0.5% | 1,414.1 0.5% | 1,525.7 0.5% | 1,687.6 0.5% | 1,841.4 0.5% | 1,987.3 0.5% | 2,121.3 0.5% | 2,239.2 0.5% | 2,337.0 0.5% | 2,411.5 0.5% | 2,459.7 0.5% |
Free Cash Flow to Firm (FCFF) % of revenue | 18,861.2 9.7% | 21,836.7 11.9% | 20,989.5 10.8% | 14,738.1 6.5% | 16,343.5 6.7% | 19,355.2 7.0% | 20,929.9 7.0% | 22,581.0 7.0% | 24,977.2 7.0% | 27,253.2 7.0% | 29,413.6 7.0% | 31,396.5 7.0% | 33,141.0 7.0% | 34,589.5 7.0% | 35,691.3 7.0% | 36,405.2 7.0% |
% of FCFF used in calculation | 100.0% | 83.0% | 100.0% | 100.0% | 100.0% | 100.0% | 100.0% | 100.0% | 100.0% | 100.0% | ||||||
Discount period | 0.50 | 1.50 | 2.50 | 3.50 | 4.50 | 5.50 | 6.50 | 7.50 | 8.50 | |||||||
Discount factor | 0.96 | 0.87 | 0.80 | 0.73 | 0.67 | 0.61 | 0.56 | 0.51 | 0.46 | |||||||
Discounted FCFF (DFCFF) | 16,607.7 | 19,720.8 | 19,930.3 | 19,869.0 | 19,592.7 | 19,108.1 | 18,428.5 | 17,573.4 | 16,567.7 |
KOF DCF Value
DCF Value Calculation
Equity Value Bridge
KOF Earnings Power Value and Enterprise Value
KOF Reverse DCF
Reverse DCF Assumptions and Outputs
Implied Free Cash Flow growth vs Historical average vs Industry growth
Competing with KOF Intrinsic Value
Company name | Market Cap | Enterprise Value | Intrinsic Value | DCF Value | Relative value | Ben Graham Revised fair value | Peter Lynch fair value | Earnings Power Value (EPV),
% of EV | Market-Implied Value of Growth (MIVoG),
% of EV | Reverse DCF (implied FCF growth) | Reverse DCF (implied Revenue growth) |
$18.7B | $22.3B | $252.3 190.2% undervalued | $80.9 7.0% overvalued | $423.7 387.4% undervalued | $499.6 474.7% undervalued | $1,317.4 1,415.4% undervalued | 6.5% | 93.5% | 50.5% | 48.5% | |
$309.3B | $341.0B | $44.5 38.5% overvalued | $48.3 33.0% overvalued | $40.6 43.9% overvalued | $57.0 21.1% overvalued | $39.6 45.2% overvalued | 40.8% | 59.2% | 13.8% | 11.2% | |
$213.0B | $248.7B | $139.1 10.8% overvalued | $99.2 36.0% overvalued | $178.9 14.7% undervalued | $177.0 13.5% undervalued | $126.3 19.0% overvalued | 65.5% | 34.5% | 4.7% | 5.4% | |
$53.8B | $53.0B | $35.5 35.6% overvalued | $38.1 31.0% overvalued | $33.0 40.1% overvalued | $16.2 70.7% overvalued | $14.6 73.6% overvalued | 43.6% | 56.4% | 7.1% | 7.8% | |
$46.3B | $63.1B | $34.4 0.8% undervalued | $36.6 7.0% undervalued | $32.2 5.7% overvalued | $29.7 13.0% overvalued | $18.0 47.3% overvalued | 58.3% | 41.7% | 1.5% | 4.7% | |
$40.3B | $51.2B | $158.8 82.7% undervalued | N/A | $158.8 82.7% undervalued | $128.1 47.4% undervalued | $108.0 24.2% undervalued | N/A | N/A | 0.0% | 0.0% | |
$12.3B | $12.8B | $1,249.1 11.2% overvalued | $561.7 60.0% overvalued | $1,936.4 37.6% undervalued | Negative 496.4% overvalued | N/A | 83.5% | 16.5% | 2.7% | 2.8% | |
$6,270.1M | $5,400.1M | $16.1 37.3% overvalued | N/A | $16.1 37.3% overvalued | Negative 112.8% overvalued | $4.8 81.2% overvalued | 19.7% | 80.3% | 19.6% | 18.2% | |
$4,538.3M | $5,336.5M | $20.1 29.1% overvalued | $6.2 78.0% overvalued | $33.9 19.8% undervalued | Negative 143.8% overvalued | Negative 128.1% overvalued | 37.4% | 62.6% | (1.6%) | (1.9%) | |
$3,772.6M | $3,710.2M | $33.3 17.6% overvalued | $27.3 32.0% overvalued | $39.3 2.8% overvalued | $23.9 40.7% overvalued | $27.3 32.5% overvalued | 53.7% | 46.3% | 6.2% | 6.5% | |
$3,227.4M | $4,319.2M | $24.4K 120,518.9% undervalued | $8,433.0 41,524.0% undervalued | $40.4K 199,513.9% undervalued | $1,020.9K 5,038,988.0% undervalued | $12.2K 60,344.8% undervalued | 110.2% | (10.2%) | (13.0%) | (2.1%) |
Intrinsic Valuation Tools
FAQ
What is the DCF value of Coca-Cola FEMSA, S.A.B. de C.V. (KOF)?
As of today, DCF Value of Coca-Cola FEMSA, S.A.B. de C.V. is $80.9, which is overvalued by 7.0%, compared to the current market share price of $86.9
How was the DCF Value calculated?
Step 1: Calculating Intrinsic Enterprise Value DCF Value was calculated by estimating Coca-Cola FEMSA, S.A.B. de C.V. future free cash flow and then discounting it, using a chosen discount rate to determine Intrinsic Enterprise Value of $0.0B Step 2: Balance Sheet Adjustments Intrinsic Equity Value is calculated by subtracting Balance Sheet items (Cash & Equivalents, Short-term investments and Total Debt) from previously calculated Intrinsic Enterprise Value. This Intrinsic Equity Value is then divided by the total number of outstanding shares of 0 to determine DCF Value of $80.9
What is the Relative value of Coca-Cola FEMSA, S.A.B. de C.V. (KOF)?
As of today, Relative Value of Coca-Cola FEMSA, S.A.B. de C.V. is $423.7, which is undervalued by 387.4%, compared to the current market share price of $86.9
How was the Relative Value calculated?
Relative Value was calculated by applying various valuation multiples (EV/Revenue, EV/EBITDA, P/E etc.) to Coca-Cola FEMSA, S.A.B. de C.V. financials to determine Relative Value of $423.7
What is Coca-Cola FEMSA, S.A.B. de C.V. (KOF) discount rate?
Coca-Cola FEMSA, S.A.B. de C.V. current Cost of Equity is 10.9%, while its WACC stands at 9.4%. Cost of Equity is used to value equity, while discounting free cash flow to equity holders (such as Net Income or Free Cash Flow to Equity). Weighted Average Cost of Capital (WACC) is used to value the entire firm, while discounting cash flows available to both debt and equity holders (NOPAT or Free Cash Flow to the Firm)
How is Cost of Equity for Coca-Cola FEMSA, S.A.B. de C.V. (KOF) calculated?
The Cost of Equity represents the return a company must offer investors to compensate for the risk of investing in its stock. It's calculated using the Capital Asset Pricing Model (CAPM), which combines the risk-free rate, the stock's beta, and the equity risk premium (ERP). This model considers the inherent risk of investing in the stock compared to a risk-free investment and the market's overall risk. Cost of Equity = Risk-Free Rate + Beta x Effective Risk Premium (ERP) 10.9% = 4.2% + 0.9 x 4.6%
How is WACC for Coca-Cola FEMSA, S.A.B. de C.V. (KOF) calculated?
WACC, or Weighted Average Cost of Capital, is a calculation that reflects the average rate of return a company is expected to pay its security holders to finance its assets. It is a critical measure in financial analysis for valuing a company's entire operations. The WACC formula combines the costs of equity and debt, weighted by their respective proportions in the company's capital structure. WACC = Cost of Equity x Equity Weight in Total Capital + Cost of Debt x (1 - Effective Tax Rate) Debt Weight in Total Capital 9.4% = 10.9% x 16.3% + 2.5% x (1 - 30.8%) x 83.7%