Columbia Sportswear Company (COLM) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
Columbia Sportswear Company (COLM) Bundle
Designed for accuracy, our (COLM) DCF Calculator enables you to assess the valuation of Columbia Sportswear Company using real-world financial data, providing 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 | 3,042.5 | 2,501.6 | 3,126.4 | 3,464.2 | 3,487.2 | 3,649.9 | 3,820.3 | 3,998.6 | 4,185.2 | 4,380.5 |
| Revenue Growth, % | 0 | -17.78 | 24.98 | 10.8 | 0.66542 | 4.67 | 4.67 | 4.67 | 4.67 | 4.67 |
| EBITDA | 516.7 | 283.7 | 566.1 | 546.9 | 462.3 | 550.9 | 576.7 | 603.6 | 631.7 | 661.2 |
| EBITDA, % | 16.98 | 11.34 | 18.11 | 15.79 | 13.26 | 15.09 | 15.09 | 15.09 | 15.09 | 15.09 |
| Depreciation | 121.7 | 146.6 | 115.6 | 117.4 | 127.1 | 150.3 | 157.3 | 164.7 | 172.3 | 180.4 |
| Depreciation, % | 4 | 5.86 | 3.7 | 3.39 | 3.64 | 4.12 | 4.12 | 4.12 | 4.12 | 4.12 |
| EBIT | 395.0 | 137.0 | 450.5 | 429.5 | 335.3 | 400.6 | 419.3 | 438.9 | 459.4 | 480.8 |
| EBIT, % | 12.98 | 5.48 | 14.41 | 12.4 | 9.61 | 10.98 | 10.98 | 10.98 | 10.98 | 10.98 |
| Total Cash | 687.7 | 791.9 | 894.5 | 431.0 | 764.5 | 855.8 | 895.8 | 937.6 | 981.3 | 1,027.1 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 488.2 | 452.9 | 487.8 | 547.6 | 423.1 | 567.2 | 593.6 | 621.3 | 650.3 | 680.7 |
| Account Receivables, % | 16.05 | 18.11 | 15.6 | 15.81 | 12.13 | 15.54 | 15.54 | 15.54 | 15.54 | 15.54 |
| Inventories | 606.0 | 556.5 | 645.4 | 1,028.5 | 746.3 | 831.5 | 870.3 | 910.9 | 953.4 | 997.9 |
| Inventories, % | 19.92 | 22.25 | 20.64 | 29.69 | 21.4 | 22.78 | 22.78 | 22.78 | 22.78 | 22.78 |
| Accounts Payable | 255.4 | 206.7 | 283.3 | 322.5 | 235.9 | 305.1 | 319.3 | 334.2 | 349.8 | 366.2 |
| Accounts Payable, % | 8.39 | 8.26 | 9.06 | 9.31 | 6.77 | 8.36 | 8.36 | 8.36 | 8.36 | 8.36 |
| Capital Expenditure | -123.5 | -28.8 | -34.7 | -58.5 | -54.6 | -69.9 | -73.2 | -76.6 | -80.1 | -83.9 |
| Capital Expenditure, % | -4.06 | -1.15 | -1.11 | -1.69 | -1.57 | -1.91 | -1.91 | -1.91 | -1.91 | -1.91 |
| Tax Rate, % | 22.93 | 22.93 | 22.93 | 22.93 | 22.93 | 22.93 | 22.93 | 22.93 | 22.93 | 22.93 |
| EBITAT | 322.0 | 106.1 | 353.3 | 336.6 | 258.4 | 314.7 | 329.4 | 344.8 | 360.9 | 377.7 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -518.7 | 260.0 | 387.1 | -8.3 | 651.0 | 235.1 | 362.6 | 379.5 | 397.2 | 415.7 |
| WACC, % | 8.44 | 8.43 | 8.43 | 8.43 | 8.43 | 8.43 | 8.43 | 8.43 | 8.43 | 8.43 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 1,387.4 | |||||||||
| Long Term Growth Rate, % | 3.00 | |||||||||
| Free cash flow (T + 1) | 428 | |||||||||
| Terminal Value | 7,881 | |||||||||
| Present Terminal Value | 5,257 | |||||||||
| Enterprise Value | 6,644 | |||||||||
| Net Debt | 58 | |||||||||
| Equity Value | 6,587 | |||||||||
| Diluted Shares Outstanding, MM | 61 | |||||||||
| Equity Value Per Share | 107.24 |
What You Will Receive
- Customizable Excel Template: A fully adjustable Excel-based DCF Calculator featuring pre-filled real COLM financials.
- Authentic Data: Historical figures and projected estimates (highlighted in the yellow cells).
- Assumption Flexibility: Modify forecast parameters such as revenue growth, EBITDA %, and WACC.
- Instant Calculations: Quickly observe how your inputs affect Columbia Sportswear's valuation.
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Layout: Organized for clarity and ease of navigation, complete with step-by-step guidance.
Key Features
- Customizable Performance Metrics: Adjust essential inputs such as sales growth, gross margin %, and operating expenses.
- Instant DCF Valuation: Quickly computes intrinsic value, net present value (NPV), and other financial metrics.
- High-Precision Accuracy: Leverages Columbia Sportswear's actual financial data for credible valuation results.
- Effortless Scenario Analysis: Evaluate various assumptions and analyze results with ease.
- Efficiency Booster: Remove the hassle of constructing intricate valuation models from the ground up.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Columbia Sportswear Company (COLM) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Columbia Sportswear Company’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Columbia Sportswear Company (COLM)?
- Accurate Data: Utilize real Columbia Sportswear financials for 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 building from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants focused on Columbia Sportswear.
- User-Friendly: Simple design and guided instructions ensure ease of use for everyone.
Who Should Use This Product?
- Outdoor Enthusiasts: Discover how to evaluate gear performance and durability using real-world data.
- Students in Fashion and Design: Integrate industry-leading apparel models into your projects and presentations.
- Investors: Validate your investment strategies and assess valuation metrics for Columbia Sportswear (COLM).
- Market Analysts: Enhance your analysis with a ready-to-use, customizable financial model specific to outdoor apparel.
- Retail Business Owners: Learn from the strategies used by successful companies like Columbia Sportswear (COLM).
What the Template Contains
- Pre-Filled DCF Model: Columbia Sportswear Company’s financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Columbia Sportswear Company’s profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.