CDW (CDW) Financial Forecast Calculator
Interactive 5-year forecast and DCF for CDW. Adjust revenue growth, gross margin, capex intensity, WACC, and terminal growth - see revenue, free cash flow, and enterprise value update in real time. Seeded from CDW’s most recent SEC filings.
Assumptions
Need this as an Excel model?
Keep iterating on the CDW forecast in Excel. The downloadable sample has every assumption you see here plus a fully integrated income statement, balance sheet, cash flow, and debt schedule - five years of SEC historicals and live formulas in a fully editable workbook.
Other Technology forecasts
Run the same calculator on a peer.
Frequently asked
What kind of company is CDW Corporation and what services does it provide?+
CDW Corporation is a leading multi-brand provider of information technology solutions to business, government, education, and healthcare customers. The company acts as a critical intermediary, advising on, procuring, and integrating technology products and services from over 1,000 vendor partners.
How does CDW Corporation generate its revenue across different customer segments?+
CDW generates revenue primarily through its Corporate, Public, and Small Business segments, with growth influenced by factors like corporate IT budget cycles, federal and state budgets, and healthcare digitization. The Public segment, for instance, sees strong seasonality in Q3 due to government fiscal year-end and back-to-school season.
What are the key assumptions regarding CDW's operational efficiency and capital expenditure in the financial model?+
The financial model assumes a COGS as a percentage of revenue of approximately 81.4% and Selling, General, & Administrative (SGA) expenses around 11.6% of revenue. Capital expenditure is modeled as a low percentage of revenue, approximately 0.78%, reflecting CDW's asset-light business model.
What specific aspects of CDW's business model are crucial for its equity valuation and cash flow analysis?+
The equity valuation and cash flow generation capacity of CDW are heavily influenced by product mix shifts, specifically the proportion of hardware versus software/services, which impacts gross margins. Additionally, the working capital intensity of its distribution business model is a critical factor in cash flow analysis.
Is there a downloadable financial model available for CDW Corporation, and what is its forecast horizon?+
Yes, a downloadable Excel financial model is available for CDW Corporation, designed to help equity research analysts determine a target price. This model provides a forecast horizon spanning from FY2026 through FY2030.
How does CDW's working capital profile impact its financial model and cash flow?+
CDW's working capital profile, characterized by efficient Days Inventory Outstanding (15-20 days) due to its drop-ship model, is crucial for the financial model. Net working capital is typically 8% to 10% of revenue, and the company requires working capital to grow, as accounts receivable can spike faster than payables, consuming cash.
Have more financial modelling questions? Contact us
