Leslie's, Inc. (LESL) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
Leslie's, Inc. (LESL) Bundle
Whether you’re an investor or analyst, this (LESL) DCF Calculator is your go-to resource for accurate valuation. With real data from Leslie's, Inc., you can adjust forecasts and observe the effects immediately.
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,112.2 | 1,342.9 | 1,562.1 | 1,451.2 | 1,330.1 | 1,402.0 | 1,477.8 | 1,557.7 | 1,641.9 | 1,730.6 |
Revenue Growth, % | 0 | 20.74 | 16.32 | -7.1 | -8.34 | 5.4 | 5.4 | 5.4 | 5.4 | 5.4 |
EBITDA | 176.8 | 224.1 | 269.1 | 136.3 | 57.1 | 178.1 | 187.7 | 197.8 | 208.5 | 219.8 |
EBITDA, % | 15.9 | 16.69 | 17.23 | 9.39 | 4.29 | 12.7 | 12.7 | 12.7 | 12.7 | 12.7 |
Depreciation | 31.5 | 26.6 | 30.8 | 34.1 | .0 | 25.6 | 27.0 | 28.5 | 30.0 | 31.6 |
Depreciation, % | 2.83 | 1.98 | 1.97 | 2.35 | 0 | 1.83 | 1.83 | 1.83 | 1.83 | 1.83 |
EBIT | 145.3 | 197.5 | 238.4 | 102.2 | 57.1 | 152.4 | 160.7 | 169.4 | 178.5 | 188.2 |
EBIT, % | 13.06 | 14.71 | 15.26 | 7.04 | 4.29 | 10.87 | 10.87 | 10.87 | 10.87 | 10.87 |
Total Cash | 157.1 | 345.1 | 112.3 | 55.4 | 108.5 | 165.4 | 174.3 | 183.7 | 193.7 | 204.1 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 31.5 | 38.9 | 45.3 | 29.4 | 45.5 | 39.4 | 41.6 | 43.8 | 46.2 | 48.7 |
Account Receivables, % | 2.83 | 2.89 | 2.9 | 2.03 | 3.42 | 2.81 | 2.81 | 2.81 | 2.81 | 2.81 |
Inventories | 149.0 | 198.8 | 361.7 | 311.8 | 234.3 | 253.6 | 267.3 | 281.8 | 297.0 | 313.1 |
Inventories, % | 13.39 | 14.8 | 23.15 | 21.49 | 17.61 | 18.09 | 18.09 | 18.09 | 18.09 | 18.09 |
Accounts Payable | 92.4 | 101.0 | 156.5 | 58.6 | 67.6 | 98.0 | 103.3 | 108.9 | 114.8 | 121.0 |
Accounts Payable, % | 8.31 | 7.52 | 10.02 | 4.03 | 5.08 | 6.99 | 6.99 | 6.99 | 6.99 | 6.99 |
Capital Expenditure | -20.6 | -28.9 | -31.7 | -38.6 | -47.2 | -34.4 | -36.2 | -38.2 | -40.2 | -42.4 |
Capital Expenditure, % | -1.85 | -2.15 | -2.03 | -2.66 | -3.55 | -2.45 | -2.45 | -2.45 | -2.45 | -2.45 |
Tax Rate, % | -76.07 | -76.07 | -76.07 | -76.07 | -76.07 | -76.07 | -76.07 | -76.07 | -76.07 | -76.07 |
EBITAT | 139.0 | 153.3 | 182.1 | 75.8 | 100.6 | 129.2 | 136.2 | 143.6 | 151.3 | 159.5 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 61.9 | 102.4 | 67.3 | 39.2 | 123.9 | 137.6 | 116.5 | 122.8 | 129.4 | 136.4 |
WACC, % | 15.72 | 13.88 | 13.76 | 13.53 | 16.16 | 14.61 | 14.61 | 14.61 | 14.61 | 14.61 |
PV UFCF | ||||||||||
SUM PV UFCF | 434.3 | |||||||||
Long Term Growth Rate, % | 0.50 | |||||||||
Free cash flow (T + 1) | 137 | |||||||||
Terminal Value | 972 | |||||||||
Present Terminal Value | 491 | |||||||||
Enterprise Value | 926 | |||||||||
Net Debt | 172 | |||||||||
Equity Value | 754 | |||||||||
Diluted Shares Outstanding, MM | 185 | |||||||||
Equity Value Per Share | 4.08 |
What You Will Receive
- Genuine LESL Financial Data: Pre-filled with Leslie's historical and forecasted data for accurate analysis.
- Completely Customizable Template: Easily adjust key inputs such as revenue growth, WACC, and EBITDA %.
- Instant Calculations: Watch Leslie's intrinsic value update in real-time as you make changes.
- Expert Valuation Tool: Tailored for investors, analysts, and consultants aiming for precise DCF results.
- Intuitive Design: Streamlined layout and straightforward instructions suitable for all skill levels.
Key Features
- Pre-Loaded Data: Leslie's, 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 Leslie's intrinsic value recalculating in real time.
- Clear Visual Outputs: Dashboard charts illustrate valuation results and key metrics.
- Built for Accuracy: A professional tool tailored for analysts, investors, and finance experts.
How It Works
- Step 1: Download the prebuilt Excel template featuring Leslie's, Inc. (LESL) data.
- Step 2: Navigate through the pre-filled sheets to familiarize yourself with key performance indicators.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly view updated results, including Leslie's, Inc. (LESL) intrinsic value.
- Step 5: Utilize the outputs to make informed investment choices or create detailed reports.
Why Choose This Calculator?
- Accurate Data: Real Leslie's, Inc. (LESL) financials ensure reliable valuation results.
- Customizable: Adjust key parameters like growth rates, WACC, and tax rates to match your projections.
- Time-Saving: Pre-built calculations eliminate the need to start from scratch.
- Professional-Grade Tool: Designed for investors, analysts, and consultants.
- User-Friendly: Intuitive layout and step-by-step instructions make it easy for all users.
Who Should Use This Product?
- Finance Students: Master financial modeling techniques and apply them to real-world data.
- Academics: Utilize comprehensive models for teaching or research purposes.
- Investors: Validate your investment strategies and assess valuation results for Leslie's, Inc. (LESL).
- Analysts: Enhance your analysis process with a ready-to-use, customizable DCF model.
- Small Business Owners: Understand the valuation methods used for large public companies like Leslie's, Inc. (LESL).
What the Template Contains
- Preloaded LESL Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.