Deckers Outdoor Corporation (DECK) 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
Deckers Outdoor Corporation (DECK) Bundle
Gain insight into your Deckers Outdoor Corporation (DECK) valuation analysis with our state-of-the-art DCF Calculator! Preloaded with real (DECK) data, this Excel template enables you to adjust forecasts and assumptions to accurately determine the intrinsic value of Deckers Outdoor Corporation.
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 | 2,132.7 | 2,545.6 | 3,150.3 | 3,627.3 | 4,287.8 | 5,107.4 | 6,083.8 | 7,246.8 | 8,632.1 | 10,282.2 |
Revenue Growth, % | 0 | 19.36 | 23.75 | 15.14 | 18.21 | 19.12 | 19.12 | 19.12 | 19.12 | 19.12 |
EBITDA | 384.8 | 548.8 | 611.2 | 719.5 | 1,041.2 | 1,053.4 | 1,254.7 | 1,494.6 | 1,780.3 | 2,120.6 |
EBITDA, % | 18.04 | 21.56 | 19.4 | 19.84 | 24.28 | 20.62 | 20.62 | 20.62 | 20.62 | 20.62 |
Depreciation | 38.9 | 41.3 | 44.4 | 50.0 | 59.7 | 77.9 | 92.8 | 110.5 | 131.7 | 156.8 |
Depreciation, % | 1.82 | 1.62 | 1.41 | 1.38 | 1.39 | 1.53 | 1.53 | 1.53 | 1.53 | 1.53 |
EBIT | 345.9 | 507.5 | 566.7 | 669.5 | 981.5 | 975.5 | 1,161.9 | 1,384.1 | 1,648.6 | 1,963.8 |
EBIT, % | 16.22 | 19.94 | 17.99 | 18.46 | 22.89 | 19.1 | 19.1 | 19.1 | 19.1 | 19.1 |
Total Cash | 649.4 | 1,089.4 | 843.5 | 981.8 | 1,502.1 | 1,656.0 | 1,972.6 | 2,349.7 | 2,798.8 | 3,333.9 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 185.6 | 215.7 | 302.7 | 322.0 | 296.6 | 434.9 | 518.1 | 617.1 | 735.1 | 875.6 |
Account Receivables, % | 8.7 | 8.47 | 9.61 | 8.88 | 6.92 | 8.52 | 8.52 | 8.52 | 8.52 | 8.52 |
Inventories | 311.6 | 278.2 | 506.8 | 532.9 | 474.3 | 688.3 | 819.9 | 976.6 | 1,163.3 | 1,385.7 |
Inventories, % | 14.61 | 10.93 | 16.09 | 14.69 | 11.06 | 13.48 | 13.48 | 13.48 | 13.48 | 13.48 |
Accounts Payable | 147.9 | 231.6 | 327.5 | 265.6 | 378.5 | 434.9 | 518.1 | 617.1 | 735.1 | 875.6 |
Accounts Payable, % | 6.93 | 9.1 | 10.4 | 7.32 | 8.83 | 8.52 | 8.52 | 8.52 | 8.52 | 8.52 |
Capital Expenditure | -32.5 | -32.2 | -51.0 | -81.0 | -89.4 | -89.1 | -106.2 | -126.5 | -150.6 | -179.4 |
Capital Expenditure, % | -1.52 | -1.27 | -1.62 | -2.23 | -2.08 | -1.74 | -1.74 | -1.74 | -1.74 | -1.74 |
Tax Rate, % | 22.41 | 22.41 | 22.41 | 22.41 | 22.41 | 22.41 | 22.41 | 22.41 | 22.41 | 22.41 |
EBITAT | 280.2 | 387.2 | 453.6 | 519.5 | 761.6 | 765.8 | 912.2 | 1,086.5 | 1,294.3 | 1,541.7 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -62.6 | 483.2 | 227.4 | 381.2 | 928.7 | 458.7 | 767.2 | 913.9 | 1,088.6 | 1,296.7 |
WACC, % | 9.37 | 9.37 | 9.37 | 9.37 | 9.37 | 9.37 | 9.37 | 9.37 | 9.37 | 9.37 |
PV UFCF | ||||||||||
SUM PV UFCF | 3,348.6 | |||||||||
Long Term Growth Rate, % | 3.00 | |||||||||
Free cash flow (T + 1) | 1,336 | |||||||||
Terminal Value | 20,961 | |||||||||
Present Terminal Value | 13,394 | |||||||||
Enterprise Value | 16,742 | |||||||||
Net Debt | -1,235 | |||||||||
Equity Value | 17,977 | |||||||||
Diluted Shares Outstanding, MM | 156 | |||||||||
Equity Value Per Share | 115.03 |
What You Will Get
- Real DECK Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are computed automatically.
- Scenario Analysis: Evaluate various scenarios to assess Deckers Outdoor Corporation's future performance.
- User-Friendly Design: Designed for professionals while remaining approachable for newcomers.
Key Features
- Accurate Deckers Financials: Access reliable pre-loaded historical data and future projections for Deckers Outdoor Corporation (DECK).
- Customizable Forecast Assumptions: Modify highlighted cells such as WACC, growth rates, and profit margins to fit your analysis.
- Dynamic Calculations: Automatic updates for DCF, Net Present Value (NPV), and cash flow assessments.
- Visual Dashboard: User-friendly charts and summaries to easily visualize your valuation outcomes.
- For All Skill Levels: An intuitive design tailored for investors, CFOs, and consultants alike.
How It Works
- Step 1: Download the prebuilt Excel template featuring Deckers Outdoor Corporation's (DECK) data.
- Step 2: Navigate through the pre-filled sheets to familiarize yourself with the essential metrics.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly see the recalculated results, including Deckers Outdoor Corporation's (DECK) intrinsic value.
- Step 5: Make well-informed investment decisions or create reports based on the outputs.
Why Choose This Calculator for Deckers Outdoor Corporation (DECK)?
- Accurate Data: Access to real financials of Deckers ensures trustworthy valuation outcomes.
- Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to fit your forecasts.
- Time-Saving: Pre-configured calculations save you the hassle of starting from the ground up.
- Professional-Grade Tool: Created for investors, analysts, and consultants focused on Deckers.
- User-Friendly: An intuitive design and step-by-step guidance make it accessible for all users.
Who Should Use This Product?
- Investors: Evaluate Deckers Outdoor Corporation’s valuation before making stock transactions.
- CFOs and Financial Analysts: Optimize valuation methodologies and assess financial forecasts.
- Startup Founders: Understand the valuation strategies of leading companies like Deckers Outdoor Corporation.
- Consultants: Provide expert valuation analyses and reports for clients in the industry.
- Students and Educators: Utilize real-time data to learn and teach valuation principles.
What the Template Contains
- Pre-Filled DCF Model: Deckers Outdoor Corporation’s (DECK) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital tailored for Deckers Outdoor Corporation.
- Financial Ratios: Evaluate Deckers Outdoor Corporation’s profitability, leverage, and efficiency metrics.
- Editable Inputs: Change assumptions such as growth rates, profit margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support a comprehensive analysis of Deckers Outdoor Corporation.
- Interactive Dashboard: Easily visualize key valuation metrics and results specific to Deckers Outdoor Corporation.