|
Valoración de DCF Industries LCI (LCII)
US | Consumer Cyclical | Auto - Recreational Vehicles | 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
LCI Industries (LCII) Bundle
¡Descubra el verdadero potencial de las industrias LCI (LCII) con nuestra calculadora DCF avanzada! Ajuste los supuestos clave, explore varios escenarios y vea cómo los diferentes cambios afectan la valoración de las industrias LCI (LCII), todo dentro de una plantilla de Excel fácil de usar.
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 | 2,371.5 | 2,796.2 | 4,472.7 | 5,207.1 | 3,784.8 | 4,418.5 | 5,158.3 | 6,021.9 | 7,030.2 | 8,207.2 |
| Revenue Growth, % | 0 | 17.91 | 59.96 | 16.42 | -27.32 | 16.74 | 16.74 | 16.74 | 16.74 | 16.74 |
| EBITDA | 275.6 | 320.9 | 510.7 | 682.2 | 255.2 | 480.4 | 560.8 | 654.7 | 764.3 | 892.3 |
| EBITDA, % | 11.62 | 11.48 | 11.42 | 13.1 | 6.74 | 10.87 | 10.87 | 10.87 | 10.87 | 10.87 |
| Depreciation | 75.4 | 98.0 | 112.3 | 129.2 | 131.8 | 133.9 | 156.4 | 182.5 | 213.1 | 248.8 |
| Depreciation, % | 3.18 | 3.5 | 2.51 | 2.48 | 3.48 | 3.03 | 3.03 | 3.03 | 3.03 | 3.03 |
| EBIT | 200.2 | 222.9 | 398.4 | 553.0 | 123.4 | 346.5 | 404.5 | 472.2 | 551.2 | 643.5 |
| EBIT, % | 8.44 | 7.97 | 8.91 | 10.62 | 3.26 | 7.84 | 7.84 | 7.84 | 7.84 | 7.84 |
| Total Cash | 35.4 | 51.8 | 62.9 | 47.5 | 66.2 | 65.5 | 76.5 | 89.3 | 104.2 | 121.6 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 200.0 | 268.6 | 319.8 | 214.3 | 214.7 | 309.1 | 360.8 | 421.3 | 491.8 | 574.1 |
| Account Receivables, % | 8.43 | 9.61 | 7.15 | 4.11 | 5.67 | 7 | 7 | 7 | 7 | 7 |
| Inventories | 393.6 | 493.9 | 1,095.9 | 1,029.7 | 768.4 | 873.5 | 1,019.7 | 1,190.4 | 1,389.7 | 1,622.4 |
| Inventories, % | 16.6 | 17.66 | 24.5 | 19.77 | 20.3 | 19.77 | 19.77 | 19.77 | 19.77 | 19.77 |
| Accounts Payable | 99.3 | 184.9 | 282.2 | 143.5 | 183.7 | 218.4 | 255.0 | 297.7 | 347.5 | 405.7 |
| Accounts Payable, % | 4.19 | 6.61 | 6.31 | 2.76 | 4.85 | 4.94 | 4.94 | 4.94 | 4.94 | 4.94 |
| Capital Expenditure | -58.2 | -57.3 | -98.5 | -130.6 | -62.2 | -96.0 | -112.0 | -130.8 | -152.7 | -178.3 |
| Capital Expenditure, % | -2.45 | -2.05 | -2.2 | -2.51 | -1.64 | -2.17 | -2.17 | -2.17 | -2.17 | -2.17 |
| Tax Rate, % | 22.66 | 22.66 | 22.66 | 22.66 | 22.66 | 22.66 | 22.66 | 22.66 | 22.66 | 22.66 |
| EBITAT | 153.2 | 168.6 | 300.1 | 415.7 | 95.5 | 263.3 | 307.4 | 358.9 | 418.9 | 489.1 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -323.9 | 126.0 | -242.1 | 447.3 | 466.0 | 136.6 | 190.3 | 222.1 | 259.3 | 302.7 |
| WACC, % | 8.86 | 8.85 | 8.84 | 8.84 | 8.87 | 8.85 | 8.85 | 8.85 | 8.85 | 8.85 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 841.1 | |||||||||
| Long Term Growth Rate, % | 1.00 | |||||||||
| Free cash flow (T + 1) | 306 | |||||||||
| Terminal Value | 3,893 | |||||||||
| Present Terminal Value | 2,548 | |||||||||
| Enterprise Value | 3,389 | |||||||||
| Net Debt | 1,040 | |||||||||
| Equity Value | 2,348 | |||||||||
| Diluted Shares Outstanding, MM | 25 | |||||||||
| Equity Value Per Share | 92.32 |
What You Will Get
- Editable Forecast Inputs: Effortlessly modify key assumptions (growth %, margins, WACC) to generate various scenarios.
- Real-World Data: LCI Industries’ financial data pre-loaded to facilitate your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically for you.
- Customizable and Professional: A sleek Excel model tailored to meet your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.
Key Features
- Comprehensive Historical Data: LCI Industries’ (LCII) past financial statements and pre-populated forecasts.
- Customizable Parameters: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Calculations: View LCI Industries’ (LCII) intrinsic value update instantly.
- Intuitive Visualizations: Dashboard graphs showcase valuation results and essential metrics.
- Designed for Precision: A reliable tool for analysts, investors, and finance professionals.
How It Works
- Step 1: Download the Excel file for LCI Industries (LCII).
- Step 2: Review LCI Industries’ pre-filled financial data and forecasts.
- Step 3: Modify key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you adjust your assumptions.
- Step 5: Analyze the outputs and leverage the results for your investment decisions.
Why Choose LCI Industries (LCII)?
- Save Time: Skip the hassle of building a model from the ground up – it’s ready for immediate use.
- Enhance Accuracy: Dependable financial data and formulas minimize valuation errors.
- Completely Customizable: Adjust the model to mirror your own assumptions and forecasts.
- User-Friendly: Intuitive charts and outputs simplify result analysis.
- Endorsed by Professionals: Crafted for experts who prioritize accuracy and functionality.
Who Should Use This Product?
- Investors: Evaluate LCI Industries’ (LCII) valuation before making investment decisions.
- CFOs and Financial Analysts: Enhance valuation processes and assess financial forecasts.
- Startup Founders: Understand the valuation methods of established companies like LCI Industries.
- Consultants: Provide comprehensive valuation reports for your clients regarding LCI Industries.
- Students and Educators: Utilize real-time data to learn and teach valuation methodologies.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled LCI Industries 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 LCI Industries (LCII).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.