América Móvil, S.A.B. de C.V. (AMX) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
América Móvil, S.A.B. de C.V. (AMX) Bundle
Explore the financial potential of América Móvil, S.A.B. de C.V. (AMX) with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to calculate the intrinsic value of América Móvil (AMX) and refine your investment approach.
Discounted Cash Flow (DCF) - (USD MM)
Year | AY1 2019 |
AY2 2020 |
AY3 2021 |
AY4 2022 |
AY5 2023 |
FY1 2024 |
FY2 2025 |
FY3 2026 |
FY4 2027 |
FY5 2028 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue | 49,791.6 | 50,263.1 | 42,287.7 | 41,742.3 | 40,334.2 | 38,359.5 | 36,481.5 | 34,695.4 | 32,996.7 | 31,381.3 |
Revenue Growth, % | 0 | 0.94694 | -15.87 | -1.29 | -3.37 | -4.9 | -4.9 | -4.9 | -4.9 | -4.9 |
EBITDA | 15,158.7 | 16,355.4 | 15,319.8 | 17,063.4 | 16,015.7 | 13,793.8 | 13,118.5 | 12,476.2 | 11,865.4 | 11,284.5 |
EBITDA, % | 30.44 | 32.54 | 36.23 | 40.88 | 39.71 | 35.96 | 35.96 | 35.96 | 35.96 | 35.96 |
Depreciation | 7,854.9 | 7,622.6 | 7,725.8 | 7,841.0 | 7,502.5 | 6,643.5 | 6,318.3 | 6,009.0 | 5,714.8 | 5,435.0 |
Depreciation, % | 15.78 | 15.17 | 18.27 | 18.78 | 18.6 | 17.32 | 17.32 | 17.32 | 17.32 | 17.32 |
EBIT | 7,303.8 | 8,732.7 | 7,594.0 | 9,222.4 | 8,513.1 | 7,150.3 | 6,800.2 | 6,467.3 | 6,150.7 | 5,849.5 |
EBIT, % | 14.67 | 17.37 | 17.96 | 22.09 | 21.11 | 18.64 | 18.64 | 18.64 | 18.64 | 18.64 |
Total Cash | 3,334.6 | 4,475.9 | 7,729.8 | 6,165.2 | 4,960.3 | 4,675.9 | 4,447.0 | 4,229.3 | 4,022.2 | 3,825.3 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 10,181.2 | 10,348.8 | 10,083.6 | 9,970.3 | 10,274.9 | 8,764.5 | 8,335.4 | 7,927.3 | 7,539.2 | 7,170.1 |
Account Receivables, % | 20.45 | 20.59 | 23.85 | 23.89 | 25.47 | 22.85 | 22.85 | 22.85 | 22.85 | 22.85 |
Inventories | 2,031.6 | 1,501.5 | 1,195.4 | 1,186.0 | 952.6 | 1,158.3 | 1,101.5 | 1,047.6 | 996.3 | 947.5 |
Inventories, % | 4.08 | 2.99 | 2.83 | 2.84 | 2.36 | 3.02 | 3.02 | 3.02 | 3.02 | 3.02 |
Accounts Payable | 5,603.7 | 3,671.8 | 4,346.8 | 3,422.3 | 3,125.6 | 3,436.0 | 3,267.8 | 3,107.8 | 2,955.6 | 2,810.9 |
Accounts Payable, % | 11.25 | 7.31 | 10.28 | 8.2 | 7.75 | 8.96 | 8.96 | 8.96 | 8.96 | 8.96 |
Capital Expenditure | -7,505.6 | -6,403.7 | -7,813.2 | -7,802.5 | -7,727.6 | -6,455.2 | -6,139.2 | -5,838.6 | -5,552.8 | -5,280.9 |
Capital Expenditure, % | -15.07 | -12.74 | -18.48 | -18.69 | -19.16 | -16.83 | -16.83 | -16.83 | -16.83 | -16.83 |
Tax Rate, % | 34.01 | 34.01 | 34.01 | 34.01 | 34.01 | 34.01 | 34.01 | 34.01 | 34.01 | 34.01 |
EBITAT | 4,076.1 | 6,045.4 | 14,235.7 | 5,692.6 | 5,618.0 | 5,044.6 | 4,797.6 | 4,562.7 | 4,339.3 | 4,126.9 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -2,183.6 | 5,695.0 | 15,394.5 | 4,929.4 | 5,025.1 | 6,847.9 | 5,294.2 | 5,035.0 | 4,788.5 | 4,554.1 |
WACC, % | 5.82 | 5.86 | 5.95 | 5.84 | 5.85 | 5.87 | 5.87 | 5.87 | 5.87 | 5.87 |
PV UFCF | ||||||||||
SUM PV UFCF | 22,672.8 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 4,645 | |||||||||
Terminal Value | 120,160 | |||||||||
Present Terminal Value | 90,361 | |||||||||
Enterprise Value | 113,034 | |||||||||
Net Debt | 29,620 | |||||||||
Equity Value | 83,414 | |||||||||
Diluted Shares Outstanding, MM | 62,467 | |||||||||
Equity Value Per Share | 1.34 |
What You Will Get
- Real AMX Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are computed automatically.
- Scenario Analysis: Explore various scenarios to assess América Móvil’s future performance.
- User-Friendly Design: Designed for professionals while remaining approachable for newcomers.
Key Features
- Real-Life AMX Data: Pre-filled with América Móvil’s historical financials and forward-looking projections.
- Fully Customizable Inputs: Adjust revenue growth, margins, WACC, tax rates, and capital expenditures.
- Dynamic Valuation Model: Automatic updates to Net Present Value (NPV) and intrinsic value based on your inputs.
- Scenario Testing: Create multiple forecast scenarios to analyze different valuation outcomes.
- User-Friendly Design: Simple, structured, and designed for professionals and beginners alike.
How It Works
- 1. Download the Template: Obtain and open the Excel file containing América Móvil, S.A.B. de C.V. (AMX) preloaded data.
- 2. Adjust Key Inputs: Modify essential parameters such as growth rates, WACC, and capital expenditures.
- 3. Instant Results: The DCF model automatically computes the intrinsic value and NPV based on your inputs.
- 4. Explore Different Scenarios: Analyze various forecasts to evaluate different valuation results.
- 5. Present with Assurance: Deliver professional valuation insights to inform your strategic decisions.
Why Choose This Calculator for América Móvil (AMX)?
- Designed for Experts: A sophisticated tool tailored for analysts, CFOs, and industry consultants.
- Accurate Financial Data: América Móvil’s historical and projected financials are preloaded for precise calculations.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Comprehensive Outputs: Instantly calculates intrinsic value, NPV, and essential financial metrics.
- User-Friendly Interface: Step-by-step guidance ensures a smooth experience throughout the process.
Who Should Use This Product?
- Finance Students: Understand telecommunications valuation methods and apply them with real-world data.
- Academics: Integrate industry-specific models into your teaching or research projects.
- Investors: Evaluate your investment strategies and analyze valuation results for América Móvil (AMX).
- Analysts: Enhance your analysis process with a ready-to-use, customizable DCF model tailored for telecom companies.
- Small Business Owners: Discover insights into how major telecom firms like América Móvil are valued in the market.
What the Template Contains
- Historical Data: Includes América Móvil's past financial performance and baseline forecasts.
- DCF and Levered DCF Models: Comprehensive templates for calculating América Móvil's intrinsic value.
- WACC Sheet: Pre-constructed calculations for Weighted Average Cost of Capital.
- Editable Inputs: Adjust key drivers such as growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A thorough breakdown of América Móvil's financial statements.
- Interactive Dashboard: Dynamically visualize valuation results and projections.