|
Valoración de DCF de LSB Industries, Inc. (LXU)
US | Basic Materials | Chemicals | 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
LSB Industries, Inc. (LXU) Bundle
¡Optimice su tiempo y mejore la precisión con nuestra calculadora DCF (LXU)! Utilizando datos reales de LSB Industries, Inc. y supuestos personalizables, esta herramienta le permite pronosticar, analizar y evaluar LSB Industries, Inc. como un inversor experto.
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 | 365.1 | 351.3 | 556.2 | 901.7 | 593.7 | 716.2 | 863.9 | 1,042.1 | 1,257.1 | 1,516.4 |
Revenue Growth, % | 0 | -3.77 | 58.33 | 62.11 | -34.16 | 20.63 | 20.63 | 20.63 | 20.63 | 20.63 |
EBITDA | 31.6 | 55.3 | 171.0 | 378.6 | 120.7 | 168.2 | 203.0 | 244.8 | 295.3 | 356.2 |
EBITDA, % | 8.66 | 15.74 | 30.74 | 41.99 | 20.33 | 23.49 | 23.49 | 23.49 | 23.49 | 23.49 |
Depreciation | 69.6 | 70.8 | 69.9 | 68.0 | 68.9 | 101.6 | 122.6 | 147.9 | 178.4 | 215.2 |
Depreciation, % | 19.06 | 20.16 | 12.57 | 7.54 | 11.61 | 14.19 | 14.19 | 14.19 | 14.19 | 14.19 |
EBIT | -38.0 | -15.5 | 101.0 | 310.6 | 51.8 | 66.6 | 80.4 | 96.9 | 116.9 | 141.1 |
EBIT, % | -10.4 | -4.42 | 18.17 | 34.44 | 8.72 | 9.3 | 9.3 | 9.3 | 9.3 | 9.3 |
Total Cash | 22.8 | 16.3 | 82.1 | 394.3 | 305.9 | 173.2 | 208.9 | 252.0 | 304.0 | 366.7 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 39.9 | 42.6 | 86.4 | 74.8 | 40.4 | 76.9 | 92.8 | 111.9 | 135.0 | 162.8 |
Account Receivables, % | 10.94 | 12.11 | 15.54 | 8.29 | 6.8 | 10.74 | 10.74 | 10.74 | 10.74 | 10.74 |
Inventories | 48.0 | 51.6 | 58.1 | 71.7 | 70.7 | 83.3 | 100.5 | 121.2 | 146.2 | 176.4 |
Inventories, % | 13.15 | 14.7 | 10.44 | 7.95 | 11.91 | 11.63 | 11.63 | 11.63 | 11.63 | 11.63 |
Accounts Payable | 58.5 | 46.6 | 49.5 | 78.2 | 68.3 | 83.6 | 100.8 | 121.6 | 146.7 | 176.9 |
Accounts Payable, % | 16.02 | 13.25 | 8.89 | 8.67 | 11.51 | 11.67 | 11.67 | 11.67 | 11.67 | 11.67 |
Capital Expenditure | -36.1 | -30.5 | -35.1 | -45.8 | -67.6 | -59.2 | -71.4 | -86.2 | -103.9 | -125.4 |
Capital Expenditure, % | -9.88 | -8.67 | -6.32 | -5.08 | -11.39 | -8.27 | -8.27 | -8.27 | -8.27 | -8.27 |
Tax Rate, % | 17.62 | 17.62 | 17.62 | 17.62 | 17.62 | 17.62 | 17.62 | 17.62 | 17.62 | 17.62 |
EBITAT | -28.5 | -14.4 | 112.9 | 265.4 | 42.7 | 58.1 | 70.1 | 84.5 | 102.0 | 123.0 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -24.5 | 7.8 | 100.3 | 314.4 | 69.5 | 66.6 | 105.4 | 127.2 | 153.4 | 185.0 |
WACC, % | 6.63 | 7.25 | 7.49 | 6.99 | 6.88 | 7.05 | 7.05 | 7.05 | 7.05 | 7.05 |
PV UFCF | ||||||||||
SUM PV UFCF | 506.3 | |||||||||
Long Term Growth Rate, % | 0.50 | |||||||||
Free cash flow (T + 1) | 186 | |||||||||
Terminal Value | 2,840 | |||||||||
Present Terminal Value | 2,020 | |||||||||
Enterprise Value | 2,527 | |||||||||
Net Debt | 513 | |||||||||
Equity Value | 2,014 | |||||||||
Diluted Shares Outstanding, MM | 75 | |||||||||
Equity Value Per Share | 26.82 |
What You Will Receive
- Comprehensive Financial Model: LSB Industries’ actual data facilitates accurate DCF valuation.
- Complete Forecast Control: Modify revenue growth, profit margins, WACC, and other essential factors.
- Real-Time Calculations: Automatic updates provide immediate results as adjustments are made.
- Professional-Grade Template: A polished Excel file crafted for high-quality valuation.
- Flexible and Reusable: Designed for adaptability, enabling repeated use for in-depth forecasts.
Key Features
- 🔍 Real-Life LXU Financials: Pre-filled historical and projected data for LSB Industries, Inc.
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate LSB Industries’ intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize LSB Industries’ valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- 1. Access the Template: Download and open the Excel file containing LSB Industries, Inc. (LXU) preloaded data.
- 2. Modify Assumptions: Adjust key parameters such as growth rates, WACC, and capital expenditures.
- 3. View Results in Real-Time: The DCF model automatically computes intrinsic value and NPV based on your inputs.
- 4. Explore Different Scenarios: Evaluate various forecasts to assess different valuation results.
- 5. Utilize with Assurance: Deliver expert valuation insights to enhance your decision-making process.
Why Choose This Calculator for LSB Industries, Inc. (LXU)?
- All-in-One Solution: Features DCF, WACC, and financial ratio analyses tailored for LSB Industries, Inc. (LXU).
- Flexible Inputs: Modify yellow-highlighted cells to explore different financial scenarios.
- In-Depth Analysis: Automatically computes LSB Industries, Inc. (LXU)'s intrinsic value and Net Present Value.
- Data-Rich Environment: Access historical and projected data for precise calculations.
- Expert-Level Tool: Perfect for financial analysts, investors, and business advisors focusing on LSB Industries, Inc. (LXU).
Who Should Use This Product?
- Investors: Accurately assess LSB Industries, Inc. (LXU)’s fair value prior to making investment choices.
- CFOs: Utilize a professional-grade DCF model for financial reporting and analysis specific to LSB Industries, Inc. (LXU).
- Consultants: Effortlessly customize the template for valuation reports tailored to LSB Industries, Inc. (LXU) clients.
- Entrepreneurs: Acquire insights into financial modeling practices employed by leading companies, including LSB Industries, Inc. (LXU).
- Educators: Implement it as an educational resource to illustrate valuation methodologies relevant to LSB Industries, Inc. (LXU).
What the Template Contains
- Comprehensive DCF Model: Editable template with detailed valuation calculations for LSB Industries, Inc. (LXU).
- Real-World Data: LSB Industries’ historical and projected financials preloaded for analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to test various scenarios.
- Financial Statements: Full annual and quarterly breakdowns for deeper insights into LSB Industries, Inc. (LXU).
- Key Ratios: Built-in analysis for profitability, efficiency, and leverage specific to LSB Industries, Inc. (LXU).
- Dashboard with Visual Outputs: Charts and tables for clear, actionable results related to LSB Industries, Inc. (LXU).