CEMEX, S.A.B. de C.V. (CX) DCF Valuation

CEMEX, S.A.B. de C.V. (CX) DCF Valuation
  • ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
  • ✓ Design Profissional: Modelos Confiáveis ​​E Padrão Da Indústria
  • ✓ Pré-Construídos Para Uso Rápido E Eficiente
  • ✓ Não É Necessária Experiência; Fácil De Seguir

CEMEX, S.A.B. de C.V. (CX) Bundle

DCF model
Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

As an investor or analyst, the CEMEX, S.A.B. de C.V. (CX) DCF Calculator is your go-to resource for accurate valuation. Equipped with real data from CEMEX, you can easily adjust forecasts and observe the effects in real-time.


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 646.9 639.0 716.8 767.5 856.7 920.2 988.4 1,061.6 1,140.3 1,224.9
Revenue Growth, % 0 -1.22 12.17 7.07 11.63 7.41 7.41 7.41 7.41 7.41
EBITDA 99.9 29.3 132.1 119.4 160.5 133.9 143.8 154.5 165.9 178.2
EBITDA, % 15.44 4.59 18.43 15.56 18.73 14.55 14.55 14.55 14.55 14.55
Depreciation 51.5 54.4 55.2 55.2 60.7 70.8 76.0 81.7 87.7 94.2
Depreciation, % 7.96 8.52 7.7 7.19 7.09 7.69 7.69 7.69 7.69 7.69
EBIT 48.4 -25.1 76.9 64.2 99.7 63.1 67.8 72.8 78.2 84.0
EBIT, % 7.48 -3.93 10.73 8.37 11.64 6.86 6.86 6.86 6.86 6.86
Total Cash 38.8 46.8 30.2 24.4 30.7 44.7 48.0 51.6 55.4 59.5
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 90.9 98.7 81.1 89.6 94.7
Account Receivables, % 14.05 15.44 11.32 11.68 11.06
Inventories 48.7 47.8 62.1 82.2 88.1 82.2 88.3 94.9 101.9 109.5
Inventories, % 7.53 7.49 8.67 10.71 10.29 8.94 8.94 8.94 8.94 8.94
Accounts Payable 124.5 126.7 136.1 146.1 153.2 174.8 187.7 201.6 216.6 232.6
Accounts Payable, % 19.24 19.82 18.99 19.04 17.88 18.99 18.99 18.99 18.99 18.99
Capital Expenditure -37.8 -29.1 -48.9 -52.2 -57.9 -56.7 -60.9 -65.4 -70.2 -75.4
Capital Expenditure, % -5.84 -4.56 -6.83 -6.8 -6.76 -6.16 -6.16 -6.16 -6.16 -6.16
Tax Rate, % 87.44 87.44 87.44 87.44 87.44 87.44 87.44 87.44 87.44 87.44
EBITAT 27.3 -28.9 62.1 71.6 12.5 44.2 47.4 50.9 54.7 58.8
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 25.9 -8.3 81.1 56.0 11.4 63.6 60.8 65.3 70.1 75.3
WACC, % 9.71 9.73 9.72 9.73 9.7 9.72 9.72 9.72 9.72 9.72
PV UFCF
SUM PV UFCF 253.6
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 77
Terminal Value 996
Present Terminal Value 626
Enterprise Value 880
Net Debt 371
Equity Value 508
Diluted Shares Outstanding, MM 14,703
Equity Value Per Share 0.03

What You Will Get

  • Real CEMEX Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures.
  • Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
  • Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on CEMEX’s fair value.
  • Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections.
  • Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility.

Key Features

  • Real-Life CX Data: Pre-filled with CEMEX’s historical financials and future projections.
  • Fully Customizable Inputs: Modify revenue growth, profit margins, WACC, tax rates, and capital expenditures.
  • Dynamic Valuation Model: Automatic updates to Net Present Value (NPV) and intrinsic value based on your adjustments.
  • Scenario Testing: Develop multiple forecasting scenarios to evaluate various valuation results.
  • User-Friendly Design: Intuitive, organized, and crafted for both professionals and novices.

How It Works

  1. Step 1: Download the Excel file.
  2. Step 2: Review pre-entered CEMEX data (historical and projected).
  3. Step 3: Adjust key assumptions (yellow cells) based on your analysis.
  4. Step 4: View automatic recalculations for CEMEX’s intrinsic value.
  5. Step 5: Use the outputs for investment decisions or reporting.

Why Choose This Calculator for CEMEX, S.A.B. de C.V. (CX)?

  • Designed for Industry Experts: A sophisticated tool favored by construction analysts, financial officers, and industry consultants.
  • Comprehensive Data: CEMEX’s historical and projected financials are preloaded for enhanced precision.
  • Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
  • Insightful Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
  • User-Friendly: Clear, step-by-step instructions make navigation simple.

Who Should Use This Product?

  • Construction Management Students: Understand project financing and apply valuation techniques using real data related to CEMEX, S.A.B. de C.V. (CX).
  • Researchers: Integrate industry-specific models into academic studies or market analysis.
  • Investors: Evaluate your investment strategies and analyze valuation scenarios for CEMEX, S.A.B. de C.V. (CX) stock.
  • Financial Analysts: Enhance your analysis process with a customizable DCF model tailored for CEMEX, S.A.B. de C.V. (CX).
  • Construction Industry Professionals: Gain valuable insights into how major companies like CEMEX, S.A.B. de C.V. (CX) are assessed in the market.

What the Template Contains

  • Operating and Balance Sheet Data: Pre-filled CEMEX historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
  • WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
  • DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
  • Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
  • Key Ratios: Includes profitability, leverage, and efficiency ratios for CEMEX, S.A.B. de C.V. (CX).
  • Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.

No products were found matching.