|
Valoración de DCF de la Compañía Mosaic (MOS)
US | Basic Materials | Agricultural Inputs | NYSE
|
- ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
- ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
- ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
- ✓ No Se Necesita Experiencia; Fáciles De Seguir
The Mosaic Company (MOS) Bundle
¡Simplifique la valoración de Mosaic Company (MOS) con esta calculadora DCF personalizable! Con Real The Mosaic Company (MOS) Financials y aportes de pronóstico ajustables, puede probar escenarios y descubrir el valor razonable de Mosaic Company (MOS) en minutos.
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 | 8,906.3 | 8,681.7 | 12,357.4 | 19,125.2 | 13,696.1 | 15,962.7 | 18,604.4 | 21,683.3 | 25,271.7 | 29,453.9 |
| Revenue Growth, % | 0 | -2.52 | 42.34 | 54.77 | -28.39 | 16.55 | 16.55 | 16.55 | 16.55 | 16.55 |
| EBITDA | -92.3 | 412.9 | 3,303.9 | 4,785.3 | 2,571.6 | 2,370.6 | 2,762.9 | 3,220.1 | 3,753.0 | 4,374.1 |
| EBITDA, % | -1.04 | 4.76 | 26.74 | 25.02 | 18.78 | 14.85 | 14.85 | 14.85 | 14.85 | 14.85 |
| Depreciation | 945.1 | 915.6 | 884.8 | 1,188.5 | 1,056.7 | 1,348.8 | 1,572.0 | 1,832.1 | 2,135.3 | 2,488.7 |
| Depreciation, % | 10.61 | 10.55 | 7.16 | 6.21 | 7.72 | 8.45 | 8.45 | 8.45 | 8.45 | 8.45 |
| EBIT | -1,037.4 | -502.7 | 2,419.1 | 3,596.8 | 1,514.9 | 1,021.8 | 1,190.9 | 1,388.0 | 1,617.7 | 1,885.4 |
| EBIT, % | -11.65 | -5.79 | 19.58 | 18.81 | 11.06 | 6.4 | 6.4 | 6.4 | 6.4 | 6.4 |
| Total Cash | 519.1 | 574.0 | 769.5 | 735.4 | 348.8 | 800.0 | 932.4 | 1,086.7 | 1,266.6 | 1,476.2 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 645.8 | 732.1 | 1,344.2 | 1,491.5 | 1,538.5 | 1,455.6 | 1,696.5 | 1,977.2 | 2,304.4 | 2,685.8 |
| Account Receivables, % | 7.25 | 8.43 | 10.88 | 7.8 | 11.23 | 9.12 | 9.12 | 9.12 | 9.12 | 9.12 |
| Inventories | 2,076.4 | 1,739.2 | 2,741.4 | 3,543.1 | 2,523.2 | 3,271.7 | 3,813.1 | 4,444.2 | 5,179.7 | 6,036.9 |
| Inventories, % | 23.31 | 20.03 | 22.18 | 18.53 | 18.42 | 20.5 | 20.5 | 20.5 | 20.5 | 20.5 |
| Accounts Payable | 1,421.0 | 1,409.1 | 2,004.4 | 2,043.7 | 1,566.8 | 2,251.7 | 2,624.4 | 3,058.7 | 3,564.9 | 4,154.9 |
| Accounts Payable, % | 15.95 | 16.23 | 16.22 | 10.69 | 11.44 | 14.11 | 14.11 | 14.11 | 14.11 | 14.11 |
| Capital Expenditure | -1,272.2 | -1,170.6 | -1,288.6 | -1,247.3 | -1,402.4 | -1,754.5 | -2,044.9 | -2,383.3 | -2,777.7 | -3,237.4 |
| Capital Expenditure, % | -14.28 | -13.48 | -10.43 | -6.52 | -10.24 | -10.99 | -10.99 | -10.99 | -10.99 | -10.99 |
| Tax Rate, % | 12.14 | 12.14 | 12.14 | 12.14 | 12.14 | 12.14 | 12.14 | 12.14 | 12.14 | 12.14 |
| EBITAT | -851.8 | -1,851.0 | 1,773.0 | 2,775.8 | 1,331.0 | 859.2 | 1,001.4 | 1,167.1 | 1,360.2 | 1,585.3 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -2,480.1 | -1,867.0 | 350.2 | 1,807.3 | 1,481.3 | 472.8 | 118.8 | 138.5 | 161.4 | 188.1 |
| WACC, % | 8.53 | 8.82 | 8.39 | 8.46 | 8.62 | 8.57 | 8.57 | 8.57 | 8.57 | 8.57 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 885.4 | |||||||||
| Long Term Growth Rate, % | 0.50 | |||||||||
| Free cash flow (T + 1) | 189 | |||||||||
| Terminal Value | 2,344 | |||||||||
| Present Terminal Value | 1,554 | |||||||||
| Enterprise Value | 2,439 | |||||||||
| Net Debt | 3,646 | |||||||||
| Equity Value | -1,207 | |||||||||
| Diluted Shares Outstanding, MM | 333 | |||||||||
| Equity Value Per Share | -3.62 |
What You Will Get
- Real Mosaic Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for The Mosaic Company (MOS).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates specific to The Mosaic Company (MOS).
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on The Mosaic Company’s (MOS) fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections for The Mosaic Company (MOS).
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility for The Mosaic Company (MOS).
Key Features
- Comprehensive Data: The Mosaic Company’s historical financial statements and pre-filled forecasts.
- Customizable Inputs: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Results: Observe The Mosaic Company’s intrinsic value recalculating instantly.
- Intuitive Visual Outputs: Dashboard charts present valuation results and essential metrics clearly.
- Designed for Precision: A professional-grade tool for analysts, investors, and finance professionals.
How It Works
- 1. Access the Template: Download and open the Excel file containing Mosaic Company's (MOS) preloaded data.
- 2. Adjust Key Inputs: Modify essential parameters such as growth rates, WACC, and capital expenditures.
- 3. Instant Results: The DCF model automatically calculates the intrinsic value and NPV based on your inputs.
- 4. Explore Scenarios: Evaluate various forecasts to understand different valuation possibilities.
- 5. Present with Assurance: Share professional valuation insights to bolster your decision-making process.
Why Choose The Mosaic Company (MOS)?
- Proven Track Record: Established leader in the agriculture industry with a history of success.
- Innovative Solutions: Cutting-edge products that enhance crop yield and sustainability.
- Global Reach: Operations and partnerships that span across multiple continents.
- Expert Support: Access to knowledgeable professionals dedicated to customer success.
- Commitment to Sustainability: Focused on environmentally responsible practices and products.
Who Should Use This Product?
- Finance Students: Explore valuation methodologies and practice with real-world data specific to The Mosaic Company (MOS).
- Academics: Integrate advanced financial models into your studies or research focused on The Mosaic Company (MOS).
- Investors: Evaluate your investment strategies and assess valuation results for The Mosaic Company (MOS) stock.
- Analysts: Enhance your analysis process with a ready-to-use, adaptable DCF model tailored for The Mosaic Company (MOS).
- Small Business Owners: Understand the analytical approaches used for large public entities like The Mosaic Company (MOS).
What the Template Contains
- Pre-Filled DCF Model: The Mosaic Company’s (MOS) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital specific to The Mosaic Company (MOS).
- Financial Ratios: Evaluate The Mosaic Company’s (MOS) profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios for The Mosaic Company (MOS).
- Financial Statements: Annual and quarterly reports to support detailed analysis of The Mosaic Company (MOS).
- Interactive Dashboard: Easily visualize key valuation metrics and results for The Mosaic Company (MOS).