Lennox International Inc. (LII) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
Lennox International Inc. (LII) Bundle
Evaluate the financial prospects of Lennox International Inc. (LII) like an expert! This (LII) DCF Calculator provides you with pre-filled financial data and the flexibility to modify revenue growth, WACC, margins, and other essential assumptions to align with your predictions.
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 | 3,807.2 | 3,634.1 | 4,194.1 | 4,718.4 | 4,981.9 | 5,342.4 | 5,729.1 | 6,143.7 | 6,588.3 | 7,065.1 |
| Revenue Growth, % | 0 | -4.55 | 15.41 | 12.5 | 5.58 | 7.24 | 7.24 | 7.24 | 7.24 | 7.24 |
| EBITDA | 633.3 | 553.9 | 652.5 | 729.0 | 879.5 | 860.5 | 922.8 | 989.6 | 1,061.2 | 1,138.0 |
| EBITDA, % | 16.63 | 15.24 | 15.56 | 15.45 | 17.65 | 16.11 | 16.11 | 16.11 | 16.11 | 16.11 |
| Depreciation | 76.8 | 72.6 | 72.4 | 77.9 | 86.0 | 97.4 | 104.5 | 112.0 | 120.2 | 128.8 |
| Depreciation, % | 2.02 | 2 | 1.73 | 1.65 | 1.73 | 1.82 | 1.82 | 1.82 | 1.82 | 1.82 |
| EBIT | 556.5 | 481.3 | 580.1 | 651.1 | 793.5 | 763.1 | 818.3 | 877.6 | 941.1 | 1,009.2 |
| EBIT, % | 14.62 | 13.24 | 13.83 | 13.8 | 15.93 | 14.28 | 14.28 | 14.28 | 14.28 | 14.28 |
| Total Cash | 40.2 | 129.0 | 36.5 | 61.1 | 69.1 | 87.2 | 93.5 | 100.2 | 107.5 | 115.3 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 477.8 | 448.3 | 508.3 | 608.5 | 594.6 | 660.7 | 708.5 | 759.8 | 814.8 | 873.8 |
| Account Receivables, % | 12.55 | 12.34 | 12.12 | 12.9 | 11.94 | 12.37 | 12.37 | 12.37 | 12.37 | 12.37 |
| Inventories | 544.1 | 439.4 | 510.9 | 753.0 | 699.1 | 732.5 | 785.5 | 842.4 | 903.3 | 968.7 |
| Inventories, % | 14.29 | 12.09 | 12.18 | 15.96 | 14.03 | 13.71 | 13.71 | 13.71 | 13.71 | 13.71 |
| Accounts Payable | 372.4 | 340.3 | 402.1 | 427.3 | 374.7 | 484.1 | 519.2 | 556.7 | 597.0 | 640.2 |
| Accounts Payable, % | 9.78 | 9.36 | 9.59 | 9.06 | 7.52 | 9.06 | 9.06 | 9.06 | 9.06 | 9.06 |
| Capital Expenditure | -105.6 | -78.5 | -106.8 | -101.1 | -250.2 | -156.5 | -167.8 | -179.9 | -193.0 | -206.9 |
| Capital Expenditure, % | -2.77 | -2.16 | -2.55 | -2.14 | -5.02 | -2.93 | -2.93 | -2.93 | -2.93 | -2.93 |
| Tax Rate, % | 19.99 | 19.99 | 19.99 | 19.99 | 19.99 | 19.99 | 19.99 | 19.99 | 19.99 | 19.99 |
| EBITAT | 447.8 | 385.2 | 480.6 | 525.6 | 634.9 | 616.7 | 661.3 | 709.2 | 760.5 | 815.6 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -230.5 | 481.4 | 376.5 | 185.3 | 485.9 | 567.6 | 532.2 | 570.7 | 612.1 | 656.3 |
| WACC, % | 9.15 | 9.15 | 9.16 | 9.15 | 9.15 | 9.15 | 9.15 | 9.15 | 9.15 | 9.15 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 2,260.2 | |||||||||
| Long Term Growth Rate, % | 3.50 | |||||||||
| Free cash flow (T + 1) | 679 | |||||||||
| Terminal Value | 12,013 | |||||||||
| Present Terminal Value | 7,753 | |||||||||
| Enterprise Value | 10,013 | |||||||||
| Net Debt | 1,467 | |||||||||
| Equity Value | 8,546 | |||||||||
| Diluted Shares Outstanding, MM | 36 | |||||||||
| Equity Value Per Share | 239.39 |
What You Will Get
- Real LII Financial Data: Pre-filled with Lennox International’s historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See Lennox International’s intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- Pre-Loaded Data: Lennox International Inc.'s historical financial statements and pre-filled forecasts.
- Fully Adjustable Inputs: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Instant Results: View Lennox's intrinsic value recalculating in real time.
- Clear Visual Outputs: Dashboard charts illustrate valuation results and essential metrics.
- Built for Accuracy: A professional tool tailored for analysts, investors, and finance professionals.
How It Works
- Download: Get the ready-to-use Excel file featuring Lennox International Inc.'s (LII) financial data.
- Customize: Tailor your forecasts, including revenue growth, EBITDA %, and WACC.
- Update Automatically: Watch as the intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Generate various projections and instantly compare the results.
- Make Decisions: Leverage the valuation outcomes to inform your investment strategy.
Why Choose This Calculator for Lennox International Inc. (LII)?
- Designed for Experts: A sophisticated tool tailored for analysts, CFOs, and industry consultants.
- Accurate Financial Data: Historical and projected financials for Lennox preloaded for precision.
- Versatile Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly Interface: Step-by-step guidance ensures a smooth calculation process.
Who Should Use This Product?
- Investors: Evaluate Lennox International Inc.’s (LII) market position before making investment decisions.
- CFOs and Financial Analysts: Optimize financial assessments and validate forecasts for Lennox International Inc. (LII).
- Startup Founders: Understand the valuation methodologies applied to established companies like Lennox International Inc. (LII).
- Consultants: Create detailed valuation reports tailored for clients involving Lennox International Inc. (LII).
- Students and Educators: Utilize real data from Lennox International Inc. (LII) to practice and teach valuation strategies.
What the Lennox Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations.
- Real-World Data: Lennox International Inc.’s historical and projected financials preloaded for analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights.
- Key Ratios: Integrated analysis covering profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Visualizations and tables providing clear, actionable insights.