W.W. Grainger, Inc. (GWW) 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
W.W. Grainger, Inc. (GWW) Bundle
Evaluate W.W. Grainger, Inc.'s financial prospects like an expert! This (GWW) DCF Calculator provides pre-filled financial data and the flexibility to modify revenue growth, WACC, margins, and other crucial assumptions to align with your predictions.
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 | 11,486.0 | 11,797.0 | 13,022.0 | 15,228.0 | 16,478.0 | 18,053.3 | 19,779.3 | 21,670.2 | 23,741.9 | 26,011.7 |
Revenue Growth, % | 0 | 2.71 | 10.38 | 16.94 | 8.21 | 9.56 | 9.56 | 9.56 | 9.56 | 9.56 |
EBITDA | 1,516.0 | 1,216.0 | 1,738.0 | 2,404.0 | 2,807.0 | 2,515.7 | 2,756.2 | 3,019.7 | 3,308.4 | 3,624.7 |
EBITDA, % | 13.2 | 10.31 | 13.35 | 15.79 | 17.03 | 13.93 | 13.93 | 13.93 | 13.93 | 13.93 |
Depreciation | 228.0 | 176.0 | 186.0 | 200.0 | 214.0 | 271.4 | 297.4 | 325.8 | 357.0 | 391.1 |
Depreciation, % | 1.99 | 1.49 | 1.43 | 1.31 | 1.3 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 |
EBIT | 1,288.0 | 1,040.0 | 1,552.0 | 2,204.0 | 2,593.0 | 2,244.3 | 2,458.8 | 2,693.9 | 2,951.5 | 3,233.6 |
EBIT, % | 11.21 | 8.82 | 11.92 | 14.47 | 15.74 | 12.43 | 12.43 | 12.43 | 12.43 | 12.43 |
Total Cash | 360.0 | 585.0 | 241.0 | 325.0 | 660.0 | 580.7 | 636.2 | 697.1 | 763.7 | 836.7 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 1,425.0 | 1,474.0 | 1,754.0 | 2,133.0 | 2,192.0 | 2,371.5 | 2,598.2 | 2,846.6 | 3,118.8 | 3,416.9 |
Account Receivables, % | 12.41 | 12.49 | 13.47 | 14.01 | 13.3 | 13.14 | 13.14 | 13.14 | 13.14 | 13.14 |
Inventories | 1,655.0 | 1,733.0 | 1,870.0 | 2,253.0 | 2,266.0 | 2,599.9 | 2,848.5 | 3,120.8 | 3,419.1 | 3,746.0 |
Inventories, % | 14.41 | 14.69 | 14.36 | 14.8 | 13.75 | 14.4 | 14.4 | 14.4 | 14.4 | 14.4 |
Accounts Payable | 719.0 | 779.0 | 816.0 | 1,047.0 | 954.0 | 1,148.0 | 1,257.7 | 1,378.0 | 1,509.7 | 1,654.1 |
Accounts Payable, % | 6.26 | 6.6 | 6.27 | 6.88 | 5.79 | 6.36 | 6.36 | 6.36 | 6.36 | 6.36 |
Capital Expenditure | -221.0 | -197.0 | -255.0 | -256.0 | -445.0 | -358.7 | -393.0 | -430.5 | -471.7 | -516.8 |
Capital Expenditure, % | -1.92 | -1.67 | -1.96 | -1.68 | -2.7 | -1.99 | -1.99 | -1.99 | -1.99 | -1.99 |
Tax Rate, % | 26.84 | 26.84 | 26.84 | 26.84 | 26.84 | 26.84 | 26.84 | 26.84 | 26.84 | 26.84 |
EBITAT | 904.5 | 763.3 | 1,090.1 | 1,588.8 | 1,897.0 | 1,611.8 | 1,765.9 | 1,934.8 | 2,119.7 | 2,322.4 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -1,449.5 | 675.3 | 641.1 | 1,001.8 | 1,501.0 | 1,205.2 | 1,304.8 | 1,429.5 | 1,566.2 | 1,715.9 |
WACC, % | 9.55 | 9.56 | 9.55 | 9.56 | 9.56 | 9.56 | 9.56 | 9.56 | 9.56 | 9.56 |
PV UFCF | ||||||||||
SUM PV UFCF | 5,448.8 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 1,750 | |||||||||
Terminal Value | 23,164 | |||||||||
Present Terminal Value | 14,677 | |||||||||
Enterprise Value | 20,126 | |||||||||
Net Debt | 2,092 | |||||||||
Equity Value | 18,034 | |||||||||
Diluted Shares Outstanding, MM | 50 | |||||||||
Equity Value Per Share | 359.96 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real GWW financials.
- Real-World Data: Historical data and forward-looking estimates (as highlighted in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe how your inputs affect W.W. Grainger's valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.
Key Features
- Comprehensive GWW Financials: Gain access to precise pre-loaded historical data and future forecasts.
- Adjustable Projection Inputs: Modify highlighted cells for metrics such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Instant updates for DCF, Net Present Value (NPV), and cash flow assessments.
- User-Friendly Dashboard: Clear charts and summaries designed to help visualize your valuation outcomes.
- Designed for All Skill Levels: An easy-to-navigate format suitable for investors, CFOs, and consultants alike.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered W.W. Grainger, Inc. (GWW) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for W.W. Grainger, Inc. (GWW)'s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for W.W. Grainger, Inc. (GWW)?
- Accurate Data: Utilize real financials from W.W. Grainger, Inc. for dependable valuation outcomes.
- Customizable: Modify essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-configured calculations save you from starting from the ground up.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants in the industry.
- User-Friendly: An intuitive design and clear, step-by-step guidance make it accessible for all users.
Who Should Use This Product?
- Investors: Evaluate W.W. Grainger’s valuation before making investment decisions.
- CFOs and Financial Analysts: Optimize valuation procedures and assess financial forecasts.
- Startup Founders: Discover how leading public companies like W.W. Grainger are appraised.
- Consultants: Provide comprehensive valuation reports for your clients.
- Students and Educators: Utilize real-time data to practice and teach valuation methodologies.
What the Template Contains
- Pre-Filled DCF Model: W.W. Grainger, Inc.'s (GWW) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital specific to W.W. Grainger, Inc. (GWW).
- Financial Ratios: Evaluate W.W. Grainger, Inc.'s (GWW) profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios for W.W. Grainger, Inc. (GWW).
- Financial Statements: Annual and quarterly reports to support detailed analysis of W.W. Grainger, Inc. (GWW).
- Interactive Dashboard: Easily visualize key valuation metrics and results for W.W. Grainger, Inc. (GWW).