The Lovesac Company (LOVE) 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
The Lovesac Company (LOVE) Bundle
Explore The Lovesac Company's (LOVE) financial potential with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to uncover The Lovesac Company's (LOVE) intrinsic value and inform your investment decisions.
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 | 233.4 | 320.7 | 498.2 | 651.5 | 700.3 | 929.6 | 1,234.1 | 1,638.4 | 2,175.1 | 2,887.5 |
Revenue Growth, % | 0 | 37.43 | 55.34 | 30.77 | 7.48 | 32.76 | 32.76 | 32.76 | 32.76 | 32.76 |
EBITDA | -10.0 | 21.5 | 46.3 | 47.8 | 42.7 | 46.7 | 62.1 | 82.4 | 109.4 | 145.2 |
EBITDA, % | -4.29 | 6.7 | 9.29 | 7.34 | 6.09 | 5.03 | 5.03 | 5.03 | 5.03 | 5.03 |
Depreciation | 5.2 | 6.6 | 7.9 | 10.8 | 12.6 | 17.3 | 23.0 | 30.5 | 40.5 | 53.8 |
Depreciation, % | 2.21 | 2.06 | 1.58 | 1.66 | 1.8 | 1.86 | 1.86 | 1.86 | 1.86 | 1.86 |
EBIT | -15.2 | 14.9 | 38.4 | 37.0 | 30.1 | 29.4 | 39.1 | 51.9 | 68.8 | 91.4 |
EBIT, % | -6.5 | 4.64 | 7.72 | 5.67 | 4.29 | 3.17 | 3.17 | 3.17 | 3.17 | 3.17 |
Total Cash | 48.5 | 78.3 | 92.4 | 43.5 | 87.0 | 154.1 | 204.6 | 271.6 | 360.5 | 478.6 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 7.2 | 6.0 | 8.5 | 9.1 | 13.5 | 18.6 | 24.6 | 32.7 | 43.4 | 57.6 |
Account Receivables, % | 3.08 | 1.86 | 1.72 | 1.4 | 1.92 | 2 | 2 | 2 | 2 | 2 |
Inventories | 36.4 | 50.4 | 108.5 | 120.0 | 98.4 | 159.1 | 211.2 | 280.4 | 372.2 | 494.1 |
Inventories, % | 15.6 | 15.72 | 21.78 | 18.41 | 14.06 | 17.11 | 17.11 | 17.11 | 17.11 | 17.11 |
Accounts Payable | 19.9 | 24.3 | 33.2 | 24.6 | 28.8 | 57.0 | 75.7 | 100.5 | 133.4 | 177.1 |
Accounts Payable, % | 8.52 | 7.58 | 6.67 | 3.77 | 4.12 | 6.13 | 6.13 | 6.13 | 6.13 | 6.13 |
Capital Expenditure | -10.2 | -9.1 | -16.5 | -25.5 | -29.2 | -34.6 | -45.9 | -60.9 | -80.9 | -107.4 |
Capital Expenditure, % | -4.37 | -2.82 | -3.31 | -3.92 | -4.17 | -3.72 | -3.72 | -3.72 | -3.72 | -3.72 |
Tax Rate, % | 25.02 | 25.02 | 25.02 | 25.02 | 25.02 | 25.02 | 25.02 | 25.02 | 25.02 | 25.02 |
EBITAT | -15.2 | 14.8 | 47.7 | 25.2 | 22.6 | 26.0 | 34.6 | 45.9 | 60.9 | 80.9 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -44.0 | 4.0 | -12.6 | -10.2 | 27.4 | -28.8 | -27.9 | -37.0 | -49.1 | -65.2 |
WACC, % | 14.01 | 14.01 | 14.01 | 13.58 | 13.67 | 13.86 | 13.86 | 13.86 | 13.86 | 13.86 |
PV UFCF | ||||||||||
SUM PV UFCF | -135.1 | |||||||||
Long Term Growth Rate, % | 3.00 | |||||||||
Free cash flow (T + 1) | -67 | |||||||||
Terminal Value | -618 | |||||||||
Present Terminal Value | -323 | |||||||||
Enterprise Value | -458 | |||||||||
Net Debt | 88 | |||||||||
Equity Value | -547 | |||||||||
Diluted Shares Outstanding, MM | 16 | |||||||||
Equity Value Per Share | -33.21 |
What You Will Get
- Real Lovesac Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures.
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Lovesac’s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections.
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility.
Key Features
- Customizable Financial Inputs: Adjust essential metrics such as sales growth, gross margin %, and operating expenses.
- Instant DCF Valuation: Automatically computes intrinsic value, NPV, and additional financial metrics.
- High-Precision Estimations: Incorporates The Lovesac Company's actual financial data for accurate valuation results.
- Effortless Scenario Testing: Explore various assumptions and analyze results with ease.
- Efficiency Booster: Avoid the hassle of creating intricate valuation models from the ground up.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Lovesac data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Lovesac’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for The Lovesac Company (LOVE)?
- Accuracy: Utilizes real Lovesac financial data to ensure precise calculations.
- Flexibility: Allows users to easily test and adjust inputs as needed.
- Time-Saving: Eliminates the need to construct a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and usability expected at the CFO level.
- User-Friendly: Intuitive design makes it accessible for users without extensive financial modeling skills.
Who Should Use This Product?
- Investors: Make informed investment choices with a top-tier valuation tool tailored for The Lovesac Company (LOVE).
- Financial Analysts: Streamline your workflow with a customizable DCF model specifically designed for The Lovesac Company (LOVE).
- Consultants: Effortlessly modify the template for engaging client presentations or comprehensive reports about The Lovesac Company (LOVE).
- Finance Enthusiasts: Enhance your knowledge of valuation methods through practical examples related to The Lovesac Company (LOVE).
- Educators and Students: Leverage this tool as a hands-on resource in finance courses focusing on The Lovesac Company (LOVE).
What the Template Contains
- Historical Data: Includes The Lovesac Company's past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate The Lovesac Company's intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of The Lovesac Company's financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.