Illinois Tool Works Inc. (ITW) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
Illinois Tool Works Inc. (ITW) Bundle
As an investor or analyst, this (ITW) DCF Calculator is your go-to resource for accurate valuation. Loaded with real data from Illinois Tool Works Inc., you can easily adjust forecasts and instantly observe the effects.
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 | 14,109.0 | 12,574.0 | 14,455.0 | 15,932.0 | 16,107.0 | 16,727.0 | 17,370.8 | 18,039.4 | 18,733.8 | 19,454.8 |
Revenue Growth, % | 0 | -10.88 | 14.96 | 10.22 | 1.1 | 3.85 | 3.85 | 3.85 | 3.85 | 3.85 |
EBITDA | 3,852.0 | 3,322.0 | 3,910.0 | 4,241.0 | 4,484.0 | 4,523.9 | 4,698.1 | 4,878.9 | 5,066.7 | 5,261.7 |
EBITDA, % | 27.3 | 26.42 | 27.05 | 26.62 | 27.84 | 27.05 | 27.05 | 27.05 | 27.05 | 27.05 |
Depreciation | 426.0 | 427.0 | 410.0 | 410.0 | 395.0 | 477.6 | 496.0 | 515.1 | 534.9 | 555.5 |
Depreciation, % | 3.02 | 3.4 | 2.84 | 2.57 | 2.45 | 2.86 | 2.86 | 2.86 | 2.86 | 2.86 |
EBIT | 3,426.0 | 2,895.0 | 3,500.0 | 3,831.0 | 4,089.0 | 4,046.3 | 4,202.0 | 4,363.8 | 4,531.8 | 4,706.2 |
EBIT, % | 24.28 | 23.02 | 24.21 | 24.05 | 25.39 | 24.19 | 24.19 | 24.19 | 24.19 | 24.19 |
Total Cash | 1,981.0 | 2,564.0 | 1,527.0 | 708.0 | 1,065.0 | 1,875.1 | 1,947.3 | 2,022.3 | 2,100.1 | 2,181.0 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .0 | .0 | .0 | .0 | 3,251.0 | 675.2 | 701.2 | 728.2 | 756.2 | 785.3 |
Account Receivables, % | 0 | 0 | 0 | 0 | 20.18 | 4.04 | 4.04 | 4.04 | 4.04 | 4.04 |
Inventories | 1,164.0 | 1,189.0 | 1,694.0 | 2,054.0 | 1,707.0 | 1,770.2 | 1,838.4 | 1,909.1 | 1,982.6 | 2,058.9 |
Inventories, % | 8.25 | 9.46 | 11.72 | 12.89 | 10.6 | 10.58 | 10.58 | 10.58 | 10.58 | 10.58 |
Accounts Payable | 472.0 | 534.0 | 585.0 | 594.0 | 581.0 | 634.8 | 659.2 | 684.6 | 710.9 | 738.3 |
Accounts Payable, % | 3.35 | 4.25 | 4.05 | 3.73 | 3.61 | 3.79 | 3.79 | 3.79 | 3.79 | 3.79 |
Capital Expenditure | -326.0 | -236.0 | -296.0 | -412.0 | -455.0 | -389.6 | -404.6 | -420.2 | -436.3 | -453.1 |
Capital Expenditure, % | -2.31 | -1.88 | -2.05 | -2.59 | -2.82 | -2.33 | -2.33 | -2.33 | -2.33 | -2.33 |
Tax Rate, % | 22.65 | 22.65 | 22.65 | 22.65 | 22.65 | 22.65 | 22.65 | 22.65 | 22.65 | 22.65 |
EBITAT | 2,626.8 | 2,258.0 | 2,834.9 | 3,025.3 | 3,162.7 | 3,172.2 | 3,294.3 | 3,421.1 | 3,552.7 | 3,689.5 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 2,034.8 | 2,486.0 | 2,494.9 | 2,672.3 | 185.7 | 5,826.5 | 3,316.0 | 3,443.6 | 3,576.2 | 3,713.8 |
WACC, % | 9.08 | 9.08 | 9.09 | 9.09 | 9.08 | 9.08 | 9.08 | 9.08 | 9.08 | 9.08 |
PV UFCF | ||||||||||
SUM PV UFCF | 15,711.4 | |||||||||
Long Term Growth Rate, % | 3.50 | |||||||||
Free cash flow (T + 1) | 3,844 | |||||||||
Terminal Value | 68,845 | |||||||||
Present Terminal Value | 44,574 | |||||||||
Enterprise Value | 60,285 | |||||||||
Net Debt | 7,305 | |||||||||
Equity Value | 52,980 | |||||||||
Diluted Shares Outstanding, MM | 304 | |||||||||
Equity Value Per Share | 174.51 |
What You Will Get
- Editable Forecast Inputs: Seamlessly adjust assumptions (growth %, margins, WACC) to generate various scenarios.
- Real-World Data: Illinois Tool Works Inc. (ITW) financial data pre-loaded to facilitate your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value for you.
- Customizable and Professional: A refined Excel model that caters to your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.
Key Features
- Comprehensive ITW Financials: Gain access to precise historical data and forward-looking projections for Illinois Tool Works Inc. (ITW).
- Adjustable Forecast Parameters: Modify highlighted fields such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Automatic updates for DCF, Net Present Value (NPV), and cash flow assessments.
- Interactive Dashboard: User-friendly charts and summaries to effectively visualize your valuation outcomes.
- Designed for All Users: An intuitive layout tailored for investors, CFOs, and consultants, whether seasoned or new.
How It Works
- Download: Get the pre-prepared Excel file containing Illinois Tool Works Inc.'s (ITW) financial data.
- Customize: Modify projections, such as revenue growth, EBITDA %, and WACC.
- Update Automatically: Watch as intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop various forecasts and instantly compare the results.
- Make Decisions: Leverage the valuation outcomes to inform your investment approach.
Why Choose This Calculator for Illinois Tool Works Inc. (ITW)?
- Accurate Data: Utilize real financials from Illinois Tool Works Inc. (ITW) for trustworthy valuation outcomes.
- Customizable: Tailor key metrics such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Built-in calculations streamline the process, saving you from starting from scratch.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants working with Illinois Tool Works Inc. (ITW).
- User-Friendly: A straightforward design and guided instructions ensure accessibility for all users.
Who Should Use This Product?
- Investors: Evaluate Illinois Tool Works Inc. (ITW)'s valuation before making stock transactions.
- CFOs and Financial Analysts: Enhance valuation workflows and assess financial forecasts.
- Startup Founders: Understand the valuation methods used for established companies like Illinois Tool Works Inc. (ITW).
- Consultants: Create detailed valuation reports for your clients based on Illinois Tool Works Inc. (ITW).
- Students and Educators: Utilize real-life data from Illinois Tool Works Inc. (ITW) to learn and teach valuation strategies.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Illinois Tool Works Inc. (ITW) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Illinois Tool Works Inc. (ITW).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.