|
Valoración de DCF de FMC Corporation (FMC)
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
FMC Corporation (FMC) Bundle
¡Simplifique la valoración de FMC Corporation (FMC) con esta calculadora DCF personalizable! Con la Real FMC Corporation (FMC) financieras y las entradas de pronóstico ajustables, puede probar escenarios y descubrir el valor razonable de FMC Corporation (FMC) 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 | 4,609.8 | 4,642.1 | 5,045.2 | 5,802.3 | 4,486.8 | 4,506.1 | 4,525.4 | 4,544.9 | 4,564.4 | 4,584.0 |
Revenue Growth, % | 0 | 0.70068 | 8.68 | 15.01 | -22.67 | 0.42964 | 0.42964 | 0.42964 | 0.42964 | 0.42964 |
EBITDA | 1,055.7 | 1,036.7 | 1,185.3 | 1,298.1 | 786.2 | 978.9 | 983.1 | 987.3 | 991.6 | 995.9 |
EBITDA, % | 22.9 | 22.33 | 23.49 | 22.37 | 17.52 | 21.72 | 21.72 | 21.72 | 21.72 | 21.72 |
Depreciation | 241.0 | 158.3 | 160.6 | 166.4 | 251.2 | 182.8 | 183.6 | 184.4 | 185.2 | 186.0 |
Depreciation, % | 5.23 | 3.41 | 3.18 | 2.87 | 5.6 | 4.06 | 4.06 | 4.06 | 4.06 | 4.06 |
EBIT | 814.7 | 878.4 | 1,024.7 | 1,131.7 | 535.0 | 796.1 | 799.5 | 802.9 | 806.4 | 809.9 |
EBIT, % | 17.67 | 18.92 | 20.31 | 19.5 | 11.92 | 17.67 | 17.67 | 17.67 | 17.67 | 17.67 |
Total Cash | 339.1 | 568.9 | 516.8 | 572.0 | 302.4 | 418.6 | 420.4 | 422.2 | 424.1 | 425.9 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 2,231.2 | 2,330.3 | 2,583.7 | 2,871.4 | 2,945.1 | 2,387.7 | 2,397.9 | 2,408.2 | 2,418.6 | 2,429.0 |
Account Receivables, % | 48.4 | 50.2 | 51.21 | 49.49 | 65.64 | 52.99 | 52.99 | 52.99 | 52.99 | 52.99 |
Inventories | 1,017.0 | 1,095.6 | 1,405.7 | 1,651.6 | 1,724.6 | 1,265.5 | 1,271.0 | 1,276.4 | 1,281.9 | 1,287.4 |
Inventories, % | 22.06 | 23.6 | 27.86 | 28.46 | 38.44 | 28.09 | 28.09 | 28.09 | 28.09 | 28.09 |
Accounts Payable | 900.1 | 946.7 | 1,135.0 | 1,252.2 | 602.4 | 878.0 | 881.8 | 885.6 | 889.4 | 893.2 |
Accounts Payable, % | 19.53 | 20.39 | 22.5 | 21.58 | 13.43 | 19.48 | 19.48 | 19.48 | 19.48 | 19.48 |
Capital Expenditure | -93.9 | -67.2 | -100.1 | -142.3 | -133.9 | -98.3 | -98.7 | -99.1 | -99.6 | -100.0 |
Capital Expenditure, % | -2.04 | -1.45 | -1.98 | -2.45 | -2.98 | -2.18 | -2.18 | -2.18 | -2.18 | -2.18 |
Tax Rate, % | -339.31 | -339.31 | -339.31 | -339.31 | -339.31 | -339.31 | -339.31 | -339.31 | -339.31 | -339.31 |
EBITAT | 593.8 | 664.9 | 847.9 | 847.1 | 2,350.3 | 646.7 | 649.5 | 652.3 | 655.1 | 657.9 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -1,607.2 | 624.9 | 533.2 | 454.8 | 1,671.1 | 2,023.3 | 722.5 | 725.6 | 728.7 | 731.8 |
WACC, % | 6.77 | 6.83 | 7 | 6.81 | 7.4 | 6.96 | 6.96 | 6.96 | 6.96 | 6.96 |
PV UFCF | ||||||||||
SUM PV UFCF | 4,195.4 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 746 | |||||||||
Terminal Value | 15,042 | |||||||||
Present Terminal Value | 10,744 | |||||||||
Enterprise Value | 14,939 | |||||||||
Net Debt | 3,803 | |||||||||
Equity Value | 11,137 | |||||||||
Diluted Shares Outstanding, MM | 126 | |||||||||
Equity Value Per Share | 88.71 |
What You Will Get
- Real FMC Financials: Includes historical and forecasted data for precise valuation.
- Adjustable Inputs: Modify WACC, tax rates, revenue growth, and capital expenditures.
- Automatic Calculations: Intrinsic value and NPV are calculated dynamically.
- Scenario Analysis: Test multiple scenarios to evaluate FMC’s future performance.
- Clear and Intuitive Design: Built for professionals yet accessible for beginners.
Key Features
- Comprehensive FMC Financials: Gain access to precise pre-loaded historical data and future forecasts for FMC Corporation (FMC).
- Adjustable Forecast Parameters: Modify highlighted cells such as WACC, growth rates, and margins to fit your analysis.
- Real-Time Calculations: Enjoy automatic updates to DCF, Net Present Value (NPV), and cash flow assessments.
- Interactive Visual Dashboard: Utilize clear charts and summaries to effectively visualize your valuation outcomes.
- Suitable for All Users: Designed with a user-friendly structure for investors, CFOs, and consultants alike.
How It Works
- Download: Obtain the pre-formatted Excel file containing FMC Corporation's (FMC) financial data.
- Customize: Modify projections, such as revenue growth, EBITDA %, and WACC.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Generate various forecasts and instantly analyze the results.
- Make Decisions: Utilize the valuation findings to inform your investment approach.
Why Choose This Calculator for FMC Corporation (FMC)?
- Accuracy: Utilizes real FMC financials to ensure precise data.
- Flexibility: Built for users to easily test and adjust inputs as needed.
- Time-Saving: Eliminate the complexity of constructing a DCF model from the ground up.
- Professional-Grade: Crafted with the precision and usability expected at the CFO level.
- User-Friendly: Intuitive design makes it accessible for users without extensive financial modeling expertise.
Who Should Use This Product?
- Investors: Accurately assess FMC Corporation’s fair value before making investment choices.
- CFOs: Utilize a professional-grade DCF model for FMC’s financial reporting and analysis.
- Consultants: Easily customize the template for valuation reports tailored to FMC clients.
- Entrepreneurs: Acquire knowledge on financial modeling practices employed by leading companies like FMC.
- Educators: Employ it as a teaching resource to illustrate valuation techniques relevant to FMC.
What the Template Contains
- Pre-Filled Data: Includes FMC Corporation’s historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze FMC Corporation’s profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.