DICK'S Sporting Goods, Inc. (DKS) DCF Valuation
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
DICK'S Sporting Goods, Inc. (DKS) Bundle
Designed for accuracy, our (DKS) DCF Calculator enables you to assess the valuation of DICK'S Sporting Goods, Inc. with real-world financial data and complete flexibility to modify all essential parameters for improved 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 | 8,750.7 | 9,584.0 | 12,293.4 | 12,368.2 | 12,984.4 | 14,392.6 | 15,953.6 | 17,683.9 | 19,601.8 | 21,727.8 |
| Revenue Growth, % | 0 | 9.52 | 28.27 | 0.6087 | 4.98 | 10.85 | 10.85 | 10.85 | 10.85 | 10.85 |
| EBITDA | 745.8 | 1,046.3 | 2,371.7 | 1,813.7 | 1,731.5 | 1,920.9 | 2,129.2 | 2,360.1 | 2,616.1 | 2,899.8 |
| EBITDA, % | 8.52 | 10.92 | 19.29 | 14.66 | 13.34 | 13.35 | 13.35 | 13.35 | 13.35 | 13.35 |
| Depreciation | 312.5 | 285.8 | 319.4 | 334.7 | 355.3 | 420.1 | 465.6 | 516.1 | 572.1 | 634.2 |
| Depreciation, % | 3.57 | 2.98 | 2.6 | 2.71 | 2.74 | 2.92 | 2.92 | 2.92 | 2.92 | 2.92 |
| EBIT | 433.3 | 760.5 | 2,052.3 | 1,479.0 | 1,376.2 | 1,500.8 | 1,663.6 | 1,844.0 | 2,044.0 | 2,265.7 |
| EBIT, % | 4.95 | 7.94 | 16.69 | 11.96 | 10.6 | 10.43 | 10.43 | 10.43 | 10.43 | 10.43 |
| Total Cash | 69.3 | 1,658.1 | 2,643.2 | 1,924.4 | 1,801.2 | 1,986.9 | 2,202.4 | 2,441.3 | 2,706.0 | 2,999.5 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 58.9 | 59.5 | 70.2 | 79.5 | 119.0 | 98.6 | 109.3 | 121.1 | 134.3 | 148.8 |
| Account Receivables, % | 0.67349 | 0.62129 | 0.57137 | 0.64256 | 0.91637 | 0.68502 | 0.68502 | 0.68502 | 0.68502 | 0.68502 |
| Inventories | 2,202.3 | 1,953.6 | 2,297.6 | 2,830.9 | 2,848.8 | 3,139.6 | 3,480.1 | 3,857.5 | 4,275.9 | 4,739.7 |
| Inventories, % | 25.17 | 20.38 | 18.69 | 22.89 | 21.94 | 21.81 | 21.81 | 21.81 | 21.81 | 21.81 |
| Accounts Payable | 1,001.6 | 1,258.1 | 1,281.3 | 1,206.1 | 1,288.7 | 1,573.8 | 1,744.4 | 1,933.6 | 2,143.3 | 2,375.8 |
| Accounts Payable, % | 11.45 | 13.13 | 10.42 | 9.75 | 9.93 | 10.93 | 10.93 | 10.93 | 10.93 | 10.93 |
| Capital Expenditure | -217.5 | -224.0 | -308.3 | -364.1 | -587.4 | -426.0 | -472.2 | -523.4 | -580.1 | -643.0 |
| Capital Expenditure, % | -2.49 | -2.34 | -2.51 | -2.94 | -4.52 | -2.96 | -2.96 | -2.96 | -2.96 | -2.96 |
| Tax Rate, % | 20.61 | 20.61 | 20.61 | 20.61 | 20.61 | 20.61 | 20.61 | 20.61 | 20.61 | 20.61 |
| EBITAT | 316.1 | 566.6 | 1,563.9 | 1,114.9 | 1,092.6 | 1,135.9 | 1,259.1 | 1,395.7 | 1,547.1 | 1,714.9 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -848.4 | 1,132.9 | 1,243.6 | 467.7 | 885.7 | 1,144.7 | 1,072.1 | 1,188.4 | 1,317.3 | 1,460.1 |
| WACC, % | 10.73 | 10.74 | 10.76 | 10.75 | 10.78 | 10.75 | 10.75 | 10.75 | 10.75 | 10.75 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 4,534.1 | |||||||||
| Long Term Growth Rate, % | 0.50 | |||||||||
| Free cash flow (T + 1) | 1,467 | |||||||||
| Terminal Value | 14,313 | |||||||||
| Present Terminal Value | 8,589 | |||||||||
| Enterprise Value | 13,123 | |||||||||
| Net Debt | 2,463 | |||||||||
| Equity Value | 10,661 | |||||||||
| Diluted Shares Outstanding, MM | 86 | |||||||||
| Equity Value Per Share | 124.07 |
What You Will Get
- Pre-Filled Financial Model: DICK'S Sporting Goods' actual data facilitates accurate DCF valuation.
- Full Forecast Control: Modify revenue growth, profit margins, WACC, and other essential drivers.
- Instant Calculations: Automatic updates provide real-time results as you make adjustments.
- Investor-Ready Template: A polished Excel file crafted for professional-standard valuation.
- Customizable and Reusable: Designed for adaptability, allowing repeated usage for comprehensive forecasts.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for DICK'S Sporting Goods, Inc. (DKS).
- WACC Calculator: Ready-to-use Weighted Average Cost of Capital sheet with adjustable parameters.
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates to fit DICK'S Sporting Goods' strategy.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specifically for DICK'S Sporting Goods, Inc. (DKS).
- Interactive Dashboard and Charts: Visual representations highlight key valuation metrics for straightforward analysis.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review DICK'S Sporting Goods' pre-filled financial data and forecasts.
- Step 3: Adjust key inputs such as sales growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you modify your assumptions.
- Step 5: Evaluate the outputs and leverage the results for your investment strategies.
Why Choose This Calculator?
- Accurate Data: Real DICK'S Sporting Goods 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?
- Investors: Evaluate DICK'S Sporting Goods' (DKS) performance before making investment decisions.
- CFOs and Financial Analysts: Optimize valuation methodologies and assess financial forecasts.
- Retail Entrepreneurs: Understand the valuation strategies of successful retail companies like DICK'S Sporting Goods.
- Consultants: Create comprehensive valuation analyses for retail clients.
- Students and Educators: Utilize current market data to explore and teach valuation principles.
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations tailored for DICK'S Sporting Goods, Inc. (DKS).
- Real-World Data: DICK'S Sporting Goods’ historical and projected financials preloaded for thorough analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into DICK'S Sporting Goods, Inc. (DKS).
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage specific to DICK'S Sporting Goods, Inc. (DKS).
- Dashboard with Visual Outputs: Engaging charts and tables for clear, actionable results regarding DICK'S Sporting Goods, Inc. (DKS).