Mondelez International, Inc. (MDLZ) 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
Mondelez International, Inc. (MDLZ) Bundle
Whether you’re an investor or analyst, this (MDLZ) DCF Calculator is your go-to resource for accurate valuation. Preloaded with real data from Mondelez International, Inc., you can 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 | 25,868.0 | 26,581.0 | 28,720.0 | 31,496.0 | 36,016.0 | 39,151.2 | 42,559.3 | 46,264.1 | 50,291.5 | 54,669.4 |
| Revenue Growth, % | 0 | 2.76 | 8.05 | 9.67 | 14.35 | 8.71 | 8.71 | 8.71 | 8.71 | 8.71 |
| EBITDA | 5,134.0 | 5,416.0 | 6,107.0 | 5,838.0 | 8,110.0 | 8,029.1 | 8,728.0 | 9,487.8 | 10,313.7 | 11,211.6 |
| EBITDA, % | 19.85 | 20.38 | 21.26 | 18.54 | 22.52 | 20.51 | 20.51 | 20.51 | 20.51 | 20.51 |
| Depreciation | 1,047.0 | 1,116.0 | 1,113.0 | 1,107.0 | 1,215.0 | 1,488.5 | 1,618.1 | 1,758.9 | 1,912.0 | 2,078.5 |
| Depreciation, % | 4.05 | 4.2 | 3.88 | 3.51 | 3.37 | 3.8 | 3.8 | 3.8 | 3.8 | 3.8 |
| EBIT | 4,087.0 | 4,300.0 | 4,994.0 | 4,731.0 | 6,895.0 | 6,540.6 | 7,110.0 | 7,728.9 | 8,401.7 | 9,133.1 |
| EBIT, % | 15.8 | 16.18 | 17.39 | 15.02 | 19.14 | 16.71 | 16.71 | 16.71 | 16.71 | 16.71 |
| Total Cash | 1,291.0 | 3,619.0 | 3,546.0 | 1,923.0 | 1,810.0 | 3,295.2 | 3,582.1 | 3,893.9 | 4,232.9 | 4,601.4 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 2,927.0 | 2,954.0 | 3,188.0 | 3,907.0 | 4,512.0 | 4,577.6 | 4,976.1 | 5,409.3 | 5,880.2 | 6,392.1 |
| Account Receivables, % | 11.32 | 11.11 | 11.1 | 12.4 | 12.53 | 11.69 | 11.69 | 11.69 | 11.69 | 11.69 |
| Inventories | 2,546.0 | 2,647.0 | 2,708.0 | 3,381.0 | 3,615.0 | 3,915.2 | 4,256.1 | 4,626.5 | 5,029.3 | 5,467.1 |
| Inventories, % | 9.84 | 9.96 | 9.43 | 10.73 | 10.04 | 10 | 10 | 10 | 10 | 10 |
| Accounts Payable | 5,853.0 | 6,209.0 | 6,730.0 | 7,562.0 | 8,321.0 | 9,124.7 | 9,919.0 | 10,782.4 | 11,721.1 | 12,741.4 |
| Accounts Payable, % | 22.63 | 23.36 | 23.43 | 24.01 | 23.1 | 23.31 | 23.31 | 23.31 | 23.31 | 23.31 |
| Capital Expenditure | -925.0 | -863.0 | -965.0 | -906.0 | -1,112.0 | -1,264.3 | -1,374.4 | -1,494.0 | -1,624.1 | -1,765.5 |
| Capital Expenditure, % | -3.58 | -3.25 | -3.36 | -2.88 | -3.09 | -3.23 | -3.23 | -3.23 | -3.23 | -3.23 |
| Tax Rate, % | 23.77 | 23.77 | 23.77 | 23.77 | 23.77 | 23.77 | 23.77 | 23.77 | 23.77 | 23.77 |
| EBITAT | 4,588.5 | 2,744.2 | 3,633.8 | 3,982.1 | 5,256.3 | 5,193.1 | 5,645.1 | 6,136.5 | 6,670.7 | 7,251.4 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 5,090.5 | 3,225.2 | 4,007.8 | 3,623.1 | 5,279.3 | 5,855.0 | 5,943.8 | 6,461.2 | 7,023.7 | 7,635.1 |
| WACC, % | 6.58 | 6.27 | 6.35 | 6.45 | 6.38 | 6.4 | 6.4 | 6.4 | 6.4 | 6.4 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 27,193.3 | |||||||||
| Long Term Growth Rate, % | 3.00 | |||||||||
| Free cash flow (T + 1) | 7,864 | |||||||||
| Terminal Value | 231,039 | |||||||||
| Present Terminal Value | 169,394 | |||||||||
| Enterprise Value | 196,588 | |||||||||
| Net Debt | 18,135 | |||||||||
| Equity Value | 178,453 | |||||||||
| Diluted Shares Outstanding, MM | 1,370 | |||||||||
| Equity Value Per Share | 130.26 |
What You Will Get
- Real MDLZ Financials: Access 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 calculated in real-time.
- Scenario Analysis: Explore various scenarios to assess Mondelez’s future performance.
- User-Friendly Design: Designed for professionals but easy to navigate for newcomers.
Key Features
- 🔍 Real-Life MDLZ Financials: Pre-filled historical and projected data for Mondelez International, Inc.
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Mondelez’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Mondelez’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review Mondelez International’s pre-filled financial data and forecasts.
- Step 3: Modify critical inputs like revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Watch the DCF model update instantly as you tweak assumptions.
- Step 5: Analyze the outputs and use the results for investment decisions.
Why Choose This Calculator for Mondelez International, Inc. (MDLZ)?
- Accurate Data: Utilize real Mondelez financials for dependable valuation outcomes.
- Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-structured calculations save you the hassle of starting from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants in the food and beverage sector.
- User-Friendly: An intuitive design and clear step-by-step guidance make it accessible for all users.
Who Should Use This Product?
- Finance Students: Understand market strategies and apply them using real-time data for Mondelez International, Inc. (MDLZ).
- Academics: Integrate industry models into your studies or research focused on consumer goods.
- Investors: Evaluate your investment strategies and analyze valuation trends for Mondelez International, Inc. (MDLZ).
- Analysts: Enhance your analysis process with a customizable financial model tailored for Mondelez International, Inc. (MDLZ).
- Small Business Owners: Discover how major companies like Mondelez International, Inc. (MDLZ) are evaluated in the market.
What the Template Contains
- Comprehensive DCF Model: Editable template with detailed valuation calculations tailored for Mondelez International, Inc. (MDLZ).
- Real-World Data: Mondelez’s historical and projected financials preloaded for analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to explore different scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into Mondelez's performance.
- Key Ratios: Built-in analysis for profitability, efficiency, and leverage specific to Mondelez International, Inc. (MDLZ).
- Dashboard with Visual Outputs: Charts and tables for clear, actionable results related to Mondelez's financial standing.