J.Jill, Inc. (JILL) DCF Valuation
- ✓ 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
J.Jill, Inc. (JILL) Bundle
Looking to assess J.Jill, Inc.'s intrinsic value? Our J.Jill (JILL) DCF Calculator integrates real-world data with extensive customization features, enabling you to refine your forecasts and enhance your investment choices.
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 | 691.3 | 421.3 | 585.2 | 615.3 | 604.7 | 609.6 | 614.6 | 619.6 | 624.6 | 629.7 |
Revenue Growth, % | 0 | -39.07 | 38.92 | 5.14 | -1.72 | 0.81602 | 0.81602 | 0.81602 | 0.81602 | 0.81602 |
EBITDA | -74.1 | -135.7 | 28.2 | 104.5 | 99.1 | -5.8 | -5.8 | -5.9 | -5.9 | -6.0 |
EBITDA, % | -10.72 | -32.2 | 4.82 | 16.98 | 16.38 | -0.94626 | -0.94626 | -0.94626 | -0.94626 | -0.94626 |
Depreciation | 37.9 | 33.7 | 29.3 | 25.8 | 22.9 | 32.3 | 32.5 | 32.8 | 33.1 | 33.3 |
Depreciation, % | 5.48 | 8 | 5 | 4.19 | 3.79 | 5.29 | 5.29 | 5.29 | 5.29 | 5.29 |
EBIT | -112.0 | -169.3 | -1.0 | 78.7 | 76.1 | -38.0 | -38.3 | -38.6 | -39.0 | -39.3 |
EBIT, % | -16.2 | -40.2 | -0.17754 | 12.8 | 12.59 | -6.24 | -6.24 | -6.24 | -6.24 | -6.24 |
Total Cash | 21.5 | 4.4 | 36.0 | 87.1 | 62.2 | 42.3 | 42.7 | 43.0 | 43.4 | 43.7 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 7.4 | 7.8 | 5.8 | 7.0 | 6.8 | 7.5 | 7.6 | 7.7 | 7.7 | 7.8 |
Account Receivables, % | 1.07 | 1.85 | 0.99298 | 1.14 | 1.13 | 1.24 | 1.24 | 1.24 | 1.24 | 1.24 |
Inventories | 72.6 | 58.0 | 56.0 | 50.6 | 53.3 | 62.0 | 62.5 | 63.0 | 63.6 | 64.1 |
Inventories, % | 10.5 | 13.78 | 9.57 | 8.22 | 8.81 | 10.18 | 10.18 | 10.18 | 10.18 | 10.18 |
Accounts Payable | 43.1 | 56.3 | 49.9 | 39.3 | 41.1 | 50.4 | 50.8 | 51.2 | 51.6 | 52.0 |
Accounts Payable, % | 6.23 | 13.36 | 8.53 | 6.39 | 6.8 | 8.26 | 8.26 | 8.26 | 8.26 | 8.26 |
Capital Expenditure | -18.2 | -3.8 | -5.5 | -15.1 | -16.9 | -11.9 | -12.0 | -12.0 | -12.1 | -12.2 |
Capital Expenditure, % | -2.64 | -0.90324 | -0.9354 | -2.45 | -2.8 | -1.94 | -1.94 | -1.94 | -1.94 | -1.94 |
Tax Rate, % | 26.67 | 26.67 | 26.67 | 26.67 | 26.67 | 26.67 | 26.67 | 26.67 | 26.67 | 26.67 |
EBITAT | -109.4 | -125.8 | -1.5 | 56.6 | 55.8 | -31.7 | -32.0 | -32.2 | -32.5 | -32.8 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -126.7 | -68.6 | 20.0 | 60.9 | 61.2 | -11.6 | -11.6 | -11.7 | -11.8 | -11.9 |
WACC, % | 7.6 | 6.78 | 7.68 | 6.69 | 6.74 | 7.1 | 7.1 | 7.1 | 7.1 | 7.1 |
PV UFCF | ||||||||||
SUM PV UFCF | -47.8 | |||||||||
Long Term Growth Rate, % | 0.50 | |||||||||
Free cash flow (T + 1) | -12 | |||||||||
Terminal Value | -181 | |||||||||
Present Terminal Value | -128 | |||||||||
Enterprise Value | -176 | |||||||||
Net Debt | 233 | |||||||||
Equity Value | -409 | |||||||||
Diluted Shares Outstanding, MM | 14 | |||||||||
Equity Value Per Share | -28.40 |
What You Will Receive
- Comprehensive Financial Model: J.Jill’s actual data provides an accurate DCF valuation.
- Complete Forecast Control: Modify revenue growth, profit margins, WACC, and other essential factors.
- Real-Time Calculations: Automatic updates allow you to view outcomes instantly as adjustments are made.
- Professional-Grade Template: A polished Excel file crafted for high-quality valuation presentations.
- Flexible and Reusable: Designed for adaptability, enabling repeated use for in-depth forecasting.
Key Features
- 🔍 Real-Life J.Jill Financials: Pre-filled historical and projected data for J.Jill, Inc. (JILL).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate J.Jill’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize J.Jill’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- 1. Open the Template: Download and launch the Excel file featuring J.Jill, Inc.'s (JILL) preloaded data.
- 2. Edit Assumptions: Adjust key parameters such as growth rates, WACC, and capital expenditures.
- 3. View Results Instantly: The DCF model will automatically compute intrinsic value and NPV.
- 4. Test Scenarios: Evaluate various forecasts to explore different valuation results.
- 5. Use with Confidence: Deliver professional valuation insights to bolster your decision-making.
Why Choose This Calculator for J.Jill, Inc. (JILL)?
- Accurate Data: Access to real J.Jill financials guarantees dependable valuation outcomes.
- Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-configured calculations save you from starting from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants in the retail sector.
- User-Friendly: Easy-to-navigate design and clear instructions cater to users of all experience levels.
Who Should Use This Product?
- Fashion Retail Investors: Create comprehensive and accurate valuation models for J.Jill, Inc. (JILL) stock analysis.
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the retail sector.
- Consultants and Advisors: Deliver precise valuation insights to clients interested in J.Jill, Inc. (JILL).
- Students and Educators: Utilize real-world data to learn and teach financial modeling in the fashion industry.
- Brand Enthusiasts: Gain insights into how fashion retailers like J.Jill, Inc. (JILL) are valued in the marketplace.
What the Template Contains
- Historical Data: Includes J.Jill, Inc.'s past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate J.Jill, Inc.'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 J.Jill, Inc.'s financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.