|
Valoración de DCF LA-Z-Boy Incorporated (LZB)
US | Consumer Cyclical | Furnishings, Fixtures & Appliances | 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
La-Z-Boy Incorporated (LZB) Bundle
Ya sea que sea un inversor o analista, esta calculadora DCF (LZB) es su herramienta de referencia para una valoración precisa. Antes de los datos reales de LA-Z-Boy Incorporated, puede ajustar los pronósticos e inmediatamente observar los efectos.
Discounted Cash Flow (DCF) - (USD MM)
Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
AY5 2024 |
FY1 2025 |
FY2 2026 |
FY3 2027 |
FY4 2028 |
FY5 2029 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue | 1,704.0 | 1,734.2 | 2,356.8 | 2,349.4 | 2,047.0 | 2,172.4 | 2,305.4 | 2,446.5 | 2,596.3 | 2,755.2 |
Revenue Growth, % | 0 | 1.78 | 35.9 | -0.31305 | -12.87 | 6.12 | 6.12 | 6.12 | 6.12 | 6.12 |
EBITDA | 215.3 | 169.4 | 318.7 | 322.8 | 290.8 | 277.5 | 294.5 | 312.5 | 331.7 | 352.0 |
EBITDA, % | 12.64 | 9.77 | 13.52 | 13.74 | 14.2 | 12.77 | 12.77 | 12.77 | 12.77 | 12.77 |
Depreciation | 98.9 | 33.0 | 112.3 | 116.5 | 124.5 | 102.2 | 108.4 | 115.1 | 122.1 | 129.6 |
Depreciation, % | 5.8 | 1.9 | 4.76 | 4.96 | 6.08 | 4.7 | 4.7 | 4.7 | 4.7 | 4.7 |
EBIT | 116.5 | 136.4 | 206.4 | 206.3 | 166.2 | 175.3 | 186.1 | 197.5 | 209.6 | 222.4 |
EBIT, % | 6.83 | 7.86 | 8.76 | 8.78 | 8.12 | 8.07 | 8.07 | 8.07 | 8.07 | 8.07 |
Total Cash | 261.6 | 391.2 | 245.6 | 343.4 | 347.9 | 347.3 | 368.6 | 391.1 | 415.1 | 440.5 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 99.4 | 139.3 | 322.8 | 170.5 | 174.7 | 188.3 | 199.9 | 212.1 | 225.1 | 238.9 |
Account Receivables, % | 5.83 | 8.03 | 13.69 | 7.26 | 8.54 | 8.67 | 8.67 | 8.67 | 8.67 | 8.67 |
Inventories | 181.6 | 226.1 | 303.2 | 276.3 | 263.2 | 265.8 | 282.1 | 299.4 | 317.7 | 337.1 |
Inventories, % | 10.66 | 13.04 | 12.86 | 11.76 | 12.86 | 12.24 | 12.24 | 12.24 | 12.24 | 12.24 |
Accounts Payable | 55.5 | 94.2 | 104.0 | 107.5 | 96.5 | 97.3 | 103.2 | 109.5 | 116.3 | 123.4 |
Accounts Payable, % | 3.26 | 5.43 | 4.41 | 4.57 | 4.71 | 4.48 | 4.48 | 4.48 | 4.48 | 4.48 |
Capital Expenditure | -46.0 | -38.0 | -76.6 | -68.8 | -53.6 | -59.5 | -63.1 | -67.0 | -71.1 | -75.4 |
Capital Expenditure, % | -2.7 | -2.19 | -3.25 | -2.93 | -2.62 | -2.74 | -2.74 | -2.74 | -2.74 | -2.74 |
Tax Rate, % | 26.02 | 26.02 | 26.02 | 26.02 | 26.02 | 26.02 | 26.02 | 26.02 | 26.02 | 26.02 |
EBITAT | 78.3 | 99.5 | 150.7 | 151.1 | 123.0 | 126.4 | 134.1 | 142.3 | 151.1 | 160.3 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -94.3 | 48.7 | -64.2 | 381.4 | 191.8 | 153.7 | 157.6 | 167.3 | 177.5 | 188.4 |
WACC, % | 9.04 | 9.09 | 9.09 | 9.1 | 9.1 | 9.09 | 9.09 | 9.09 | 9.09 | 9.09 |
PV UFCF | ||||||||||
SUM PV UFCF | 649.5 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 192 | |||||||||
Terminal Value | 2,712 | |||||||||
Present Terminal Value | 1,756 | |||||||||
Enterprise Value | 2,405 | |||||||||
Net Debt | 141 | |||||||||
Equity Value | 2,264 | |||||||||
Diluted Shares Outstanding, MM | 43 | |||||||||
Equity Value Per Share | 52.32 |
What You Will Get
- Real La-Z-Boy Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for La-Z-Boy Incorporated (LZB).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates specific to La-Z-Boy Incorporated (LZB).
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on La-Z-Boy Incorporated’s (LZB) fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections for La-Z-Boy Incorporated (LZB).
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility for La-Z-Boy Incorporated (LZB).
Key Features
- 🔍 Real-Life LZB Financials: Pre-filled historical and projected data for La-Z-Boy Incorporated (LZB).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate La-Z-Boy’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize La-Z-Boy’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 prebuilt Excel template containing La-Z-Boy Incorporated’s (LZB) data.
- Step 2: Navigate through the pre-filled sheets to familiarize yourself with the key performance indicators.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly see the recalculated results, including La-Z-Boy Incorporated’s (LZB) intrinsic value.
- Step 5: Utilize the outputs to make informed investment decisions or create detailed reports.
Why Choose This Calculator?
- Designed for Experts: A sophisticated tool utilized by financial analysts, CFOs, and consultants.
- Accurate Data: La-Z-Boy's historical and projected financials are preloaded for precision.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Comprehensive Outputs: Automatically calculates intrinsic value, NPV, and essential metrics.
- User-Friendly: Step-by-step guidance helps you navigate the process seamlessly.
Who Should Use This Product?
- Interior Design Students: Explore furniture design principles and apply them using real-world examples from La-Z-Boy Incorporated (LZB).
- Academics: Integrate industry-leading models into your curriculum or research focused on furniture manufacturing.
- Investors: Validate your investment strategies and assess the market performance of La-Z-Boy Incorporated (LZB).
- Market Analysts: Enhance your analysis with a customizable financial model tailored for La-Z-Boy Incorporated (LZB).
- Homeowners: Understand how large furniture companies like La-Z-Boy Incorporated (LZB) are evaluated in the market.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled La-Z-Boy Incorporated (LZB) 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 La-Z-Boy Incorporated (LZB).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.