Ulta Beauty, Inc. (ULTA) 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
Ulta Beauty, Inc. (ULTA) Bundle
Evaluate Ulta Beauty, Inc.'s (ULTA) financial outlook like an expert! This (ULTA) DCF Calculator comes with pre-filled financial data and allows you to seamlessly modify revenue growth, WACC, margins, and other crucial assumptions to align with your projections.
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 | 7,398.1 | 6,152.0 | 8,630.9 | 10,208.6 | 11,207.3 | 12,650.6 | 14,279.9 | 16,118.9 | 18,194.8 | 20,538.0 |
| Revenue Growth, % | 0 | -16.84 | 40.3 | 18.28 | 9.78 | 12.88 | 12.88 | 12.88 | 12.88 | 12.88 |
| EBITDA | 1,196.7 | 534.6 | 1,566.0 | 1,880.0 | 1,939.5 | 1,992.0 | 2,248.5 | 2,538.1 | 2,865.0 | 3,233.9 |
| EBITDA, % | 16.18 | 8.69 | 18.14 | 18.42 | 17.31 | 15.75 | 15.75 | 15.75 | 15.75 | 15.75 |
| Depreciation | 295.6 | 297.8 | 268.5 | 241.4 | 243.8 | 417.1 | 470.8 | 531.5 | 599.9 | 677.2 |
| Depreciation, % | 4 | 4.84 | 3.11 | 2.36 | 2.18 | 3.3 | 3.3 | 3.3 | 3.3 | 3.3 |
| EBIT | 901.1 | 236.8 | 1,297.5 | 1,638.6 | 1,695.7 | 1,574.9 | 1,777.7 | 2,006.6 | 2,265.0 | 2,556.7 |
| EBIT, % | 12.18 | 3.85 | 15.03 | 16.05 | 15.13 | 12.45 | 12.45 | 12.45 | 12.45 | 12.45 |
| Total Cash | 502.3 | 1,046.1 | 431.6 | 737.9 | 766.6 | 1,084.5 | 1,224.1 | 1,381.8 | 1,559.7 | 1,760.6 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 139.3 | 193.1 | 233.7 | 199.4 | 207.9 | 291.9 | 329.5 | 372.0 | 419.9 | 474.0 |
| Account Receivables, % | 1.88 | 3.14 | 2.71 | 1.95 | 1.86 | 2.31 | 2.31 | 2.31 | 2.31 | 2.31 |
| Inventories | 1,293.7 | 1,168.2 | 1,499.2 | 1,603.5 | 1,742.1 | 2,153.1 | 2,430.4 | 2,743.4 | 3,096.7 | 3,495.5 |
| Inventories, % | 17.49 | 18.99 | 17.37 | 15.71 | 15.54 | 17.02 | 17.02 | 17.02 | 17.02 | 17.02 |
| Accounts Payable | 414.0 | 477.1 | 552.7 | 559.5 | 544.0 | 761.3 | 859.4 | 970.0 | 1,094.9 | 1,236.0 |
| Accounts Payable, % | 5.6 | 7.75 | 6.4 | 5.48 | 4.85 | 6.02 | 6.02 | 6.02 | 6.02 | 6.02 |
| Capital Expenditure | -298.5 | -151.9 | -172.2 | -312.1 | -435.3 | -390.7 | -441.0 | -497.8 | -561.9 | -634.2 |
| Capital Expenditure, % | -4.04 | -2.47 | -2 | -3.06 | -3.88 | -3.09 | -3.09 | -3.09 | -3.09 | -3.09 |
| Tax Rate, % | 23.86 | 23.86 | 23.86 | 23.86 | 23.86 | 23.86 | 23.86 | 23.86 | 23.86 | 23.86 |
| EBITAT | 702.0 | 180.2 | 987.1 | 1,238.7 | 1,291.0 | 1,202.6 | 1,357.4 | 1,532.3 | 1,729.6 | 1,952.3 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -320.0 | 460.9 | 787.5 | 1,104.7 | 936.9 | 951.4 | 1,170.5 | 1,321.2 | 1,491.4 | 1,683.4 |
| WACC, % | 10.13 | 10.12 | 10.12 | 10.12 | 10.12 | 10.12 | 10.12 | 10.12 | 10.12 | 10.12 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 4,872.0 | |||||||||
| Long Term Growth Rate, % | 3.00 | |||||||||
| Free cash flow (T + 1) | 1,734 | |||||||||
| Terminal Value | 24,344 | |||||||||
| Present Terminal Value | 15,032 | |||||||||
| Enterprise Value | 19,904 | |||||||||
| Net Debt | 1,144 | |||||||||
| Equity Value | 18,759 | |||||||||
| Diluted Shares Outstanding, MM | 50 | |||||||||
| Equity Value Per Share | 378.24 |
What You Will Get
- Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: Ulta Beauty’s financial data pre-loaded to facilitate your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Customizable and Professional: A refined Excel model that caters to your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Ulta Beauty, Inc. (ULTA).
- WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with adjustable inputs specific to the beauty industry.
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates to fit Ulta Beauty, Inc. (ULTA)'s financial outlook.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to Ulta Beauty, Inc. (ULTA).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for quick and effective analysis.
How It Works
- 1. Access the Template: Download and open the Excel file featuring Ulta Beauty's preloaded data.
- 2. Modify Assumptions: Adjust key inputs such as growth rates, WACC, and capital expenditures.
- 3. View Results Instantly: The DCF model automatically calculates intrinsic value and NPV.
- 4. Explore Scenarios: Analyze various forecasts to evaluate different valuation outcomes.
- 5. Present with Confidence: Share professional valuation insights to enhance your decision-making.
Why Choose This Calculator?
- Designed for Beauty Professionals: A specialized tool tailored for analysts, beauty executives, and consultants.
- Comprehensive Data: Ulta Beauty’s historical and projected financials preloaded for precision.
- Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Clear Results: Automatically calculates intrinsic value, NPV, and essential metrics.
- User-Friendly: Step-by-step instructions lead you through the calculation process.
Who Should Use This Product?
- Investors: Accurately evaluate Ulta Beauty's fair value before making investment decisions.
- CFOs: Utilize a professional-grade DCF model for financial reporting and analysis specific to Ulta Beauty, Inc. (ULTA).
- Consultants: Seamlessly adapt the template for valuation reports tailored to Ulta Beauty clients.
- Entrepreneurs: Acquire insights into financial modeling practices used by leading beauty retailers.
- Educators: Employ it as a teaching resource to illustrate valuation methodologies in the beauty industry.
What the Template Contains
- Comprehensive DCF Model: Editable template with detailed valuation calculations tailored for Ulta Beauty, Inc. (ULTA).
- Real-World Data: Ulta Beauty’s historical and projected financials preloaded for analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to test various scenarios.
- Financial Statements: Full annual and quarterly breakdowns for deeper insights into Ulta Beauty’s performance.
- Key Ratios: Built-in analysis for profitability, efficiency, and leverage specific to Ulta Beauty, Inc. (ULTA).
- Dashboard with Visual Outputs: Charts and tables for clear, actionable results related to Ulta Beauty’s financials.