WESCO International, Inc. (WCC) 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
WESCO International, Inc. (WCC) Bundle
Explore the financial outlook of WESCO International, Inc. (WCC) with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to calculate the intrinsic value of WESCO International, Inc. (WCC) and enhance your investment decisions.
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,358.9 | 12,326.0 | 18,217.5 | 21,420.1 | 22,385.2 | 28,952.0 | 37,445.2 | 48,430.0 | 62,637.2 | 81,012.1 |
Revenue Growth, % | 0 | 47.46 | 47.8 | 17.58 | 4.51 | 29.34 | 29.34 | 29.34 | 29.34 | 29.34 |
EBITDA | 408.3 | 471.0 | 1,048.5 | 1,610.1 | 1,562.6 | 1,676.9 | 2,168.8 | 2,805.0 | 3,627.8 | 4,692.1 |
EBITDA, % | 4.88 | 3.82 | 5.76 | 7.52 | 6.98 | 5.79 | 5.79 | 5.79 | 5.79 | 5.79 |
Depreciation | 62.1 | 121.6 | 198.6 | 179.0 | 181.3 | 258.5 | 334.4 | 432.5 | 559.4 | 723.5 |
Depreciation, % | 0.743 | 0.98653 | 1.09 | 0.83573 | 0.80991 | 0.89302 | 0.89302 | 0.89302 | 0.89302 | 0.89302 |
EBIT | 346.2 | 349.4 | 850.0 | 1,431.1 | 1,381.3 | 1,418.3 | 1,834.4 | 2,372.5 | 3,068.5 | 3,968.6 |
EBIT, % | 4.14 | 2.83 | 4.67 | 6.68 | 6.17 | 4.9 | 4.9 | 4.9 | 4.9 | 4.9 |
Total Cash | 150.9 | 449.1 | 212.6 | 527.3 | 524.1 | 661.2 | 855.2 | 1,106.1 | 1,430.5 | 1,850.2 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 1,187.4 | 2,466.9 | 2,991.0 | 4,098.4 | 4,070.0 | 5,092.8 | 6,586.8 | 8,519.0 | 11,018.1 | 14,250.3 |
Account Receivables, % | 14.2 | 20.01 | 16.42 | 19.13 | 18.18 | 17.59 | 17.59 | 17.59 | 17.59 | 17.59 |
Inventories | 1,011.7 | 2,163.6 | 2,666.2 | 3,498.8 | 3,572.1 | 4,434.5 | 5,735.4 | 7,417.9 | 9,593.9 | 12,408.4 |
Inventories, % | 12.1 | 17.55 | 14.64 | 16.33 | 15.96 | 15.32 | 15.32 | 15.32 | 15.32 | 15.32 |
Accounts Payable | 830.5 | 1,707.3 | 2,140.3 | 2,728.2 | 2,431.5 | 3,424.1 | 4,428.5 | 5,727.7 | 7,407.9 | 9,581.1 |
Accounts Payable, % | 9.94 | 13.85 | 11.75 | 12.74 | 10.86 | 11.83 | 11.83 | 11.83 | 11.83 | 11.83 |
Capital Expenditure | -44.1 | -56.7 | -54.7 | -99.4 | -92.3 | -125.3 | -162.1 | -209.6 | -271.1 | -350.6 |
Capital Expenditure, % | -0.52719 | -0.45977 | -0.30051 | -0.46411 | -0.41233 | -0.43278 | -0.43278 | -0.43278 | -0.43278 | -0.43278 |
Tax Rate, % | 22.83 | 22.83 | 22.83 | 22.83 | 22.83 | 22.83 | 22.83 | 22.83 | 22.83 | 22.83 |
EBITAT | 274.2 | 286.1 | 679.8 | 1,083.4 | 1,065.9 | 1,117.4 | 1,445.2 | 1,869.2 | 2,417.5 | 3,126.7 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -1,076.3 | -1,203.7 | 229.8 | -189.1 | 813.3 | 358.1 | -172.9 | -223.6 | -289.1 | -374.0 |
WACC, % | 10.52 | 10.59 | 10.54 | 10.43 | 10.47 | 10.51 | 10.51 | 10.51 | 10.51 | 10.51 |
PV UFCF | ||||||||||
SUM PV UFCF | -403.9 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -381 | |||||||||
Terminal Value | -4,481 | |||||||||
Present Terminal Value | -2,718 | |||||||||
Enterprise Value | -3,122 | |||||||||
Net Debt | 5,439 | |||||||||
Equity Value | -8,561 | |||||||||
Diluted Shares Outstanding, MM | 52 | |||||||||
Equity Value Per Share | -163.70 |
What You Will Receive
- Authentic WESCO Data: Preloaded financials – encompassing revenue to EBIT – based on actual and forecasted figures.
- Comprehensive Customization: Modify all essential parameters (yellow cells) such as WACC, growth %, and tax rates.
- Immediate Valuation Adjustments: Automatic recalibrations to assess the effects of changes on WESCO’s fair value.
- Flexible Excel Template: Designed for quick modifications, scenario analysis, and in-depth projections.
- Efficient and Precise: Eliminate the need to construct models from the ground up while ensuring accuracy and adaptability.
Key Features
- Customizable Financial Assumptions: Adjust key metrics such as revenue projections, operating margins, and capital investments.
- Instant DCF Valuation: Automatically computes intrinsic value, net present value (NPV), and additional financial metrics.
- High-Precision Accuracy: Incorporates WESCO International's real-time financial data for credible valuation results.
- Effortless Scenario Analysis: Evaluate various assumptions and analyze results with ease.
- Efficiency Booster: Avoid the hassle of constructing intricate valuation models from the ground up.
How It Works
- Step 1: Download the prebuilt Excel template featuring WESCO International, Inc. (WCC) data.
- Step 2: Navigate through the pre-filled sheets to familiarize yourself with the key performance indicators.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly see the recalculated results, including WESCO's intrinsic value.
- Step 5: Utilize the outputs to make informed investment choices or create detailed reports.
Why Choose WESCO International, Inc. (WCC)?
- Comprehensive Solutions: A wide range of products and services to meet all your electrical and industrial needs.
- Enhanced Efficiency: Streamlined processes and expert support help optimize your operations.
- Customizable Offerings: Tailor our solutions to fit your specific business requirements and objectives.
- User-Friendly Experience: Intuitive tools and resources make it easy to navigate and find what you need.
- Industry Expertise: Backed by years of experience, we deliver reliable service that professionals trust.
Who Should Use This Product?
- Investors: Accurately estimate WESCO International’s fair value before making investment decisions.
- CFOs: Utilize a professional-grade DCF model for financial reporting and analysis specific to WESCO (WCC).
- Consultants: Quickly customize the template for valuation reports tailored to WESCO (WCC) clients.
- Entrepreneurs: Acquire insights into financial modeling practices used by leading companies like WESCO (WCC).
- Educators: Employ it as a teaching resource to illustrate valuation methodologies relevant to WESCO (WCC).
What the Template Contains
- Pre-Filled Data: Includes WESCO International’s historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze WESCO International’s profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.