WESCO International, Inc. (WCC) DCF Valuation

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

DCF model
Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

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
Account Receivables, % 14.2 20.01 16.42 19.13 18.18
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.

No products were found matching.