|
The Goodyear Tire & Rubber Company (GT) DCF Valuation
US | Consumer Cyclical | Auto - Parts | NASDAQ
|
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
The Goodyear Tire & Rubber Company (GT) Bundle
Designed for accuracy, our (GT) DCF Calculator enables you to evaluate The Goodyear Tire & Rubber Company's valuation using real-world financial data and offers complete flexibility to modify all key parameters for improved projections.
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,745.0 | 12,321.0 | 17,478.0 | 20,805.0 | 20,066.0 | 22,117.7 | 24,379.2 | 26,871.9 | 29,619.5 | 32,648.1 |
| Revenue Growth, % | 0 | -16.44 | 41.86 | 19.04 | -3.55 | 10.22 | 10.22 | 10.22 | 10.22 | 10.22 |
| EBITDA | 1,346.0 | 69.0 | 1,822.0 | 1,854.0 | 856.0 | 1,472.6 | 1,623.2 | 1,789.1 | 1,972.1 | 2,173.7 |
| EBITDA, % | 9.13 | 0.56002 | 10.42 | 8.91 | 4.27 | 6.66 | 6.66 | 6.66 | 6.66 | 6.66 |
| Depreciation | 795.0 | 859.0 | 883.0 | 964.0 | 1,001.0 | 1,196.0 | 1,318.3 | 1,453.1 | 1,601.7 | 1,765.5 |
| Depreciation, % | 5.39 | 6.97 | 5.05 | 4.63 | 4.99 | 5.41 | 5.41 | 5.41 | 5.41 | 5.41 |
| EBIT | 551.0 | -790.0 | 939.0 | 890.0 | -145.0 | 276.6 | 304.9 | 336.0 | 370.4 | 408.3 |
| EBIT, % | 3.74 | -6.41 | 5.37 | 4.28 | -0.72262 | 1.25 | 1.25 | 1.25 | 1.25 | 1.25 |
| Total Cash | 908.0 | 1,539.0 | 1,088.0 | 1,227.0 | 902.0 | 1,560.0 | 1,719.5 | 1,895.4 | 2,089.2 | 2,302.8 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 1,941.0 | 1,691.0 | 2,387.0 | 2,610.0 | 2,731.0 | 2,950.5 | 3,252.2 | 3,584.7 | 3,951.3 | 4,355.3 |
| Account Receivables, % | 13.16 | 13.72 | 13.66 | 12.55 | 13.61 | 13.34 | 13.34 | 13.34 | 13.34 | 13.34 |
| Inventories | 2,851.0 | 2,153.0 | 3,594.0 | 4,571.0 | 3,698.0 | 4,325.0 | 4,767.2 | 5,254.7 | 5,791.9 | 6,384.2 |
| Inventories, % | 19.34 | 17.47 | 20.56 | 21.97 | 18.43 | 19.55 | 19.55 | 19.55 | 19.55 | 19.55 |
| Accounts Payable | 2,908.0 | 2,945.0 | 4,148.0 | 4,803.0 | 4,326.0 | 4,954.4 | 5,461.0 | 6,019.4 | 6,634.9 | 7,313.3 |
| Accounts Payable, % | 19.72 | 23.9 | 23.73 | 23.09 | 21.56 | 22.4 | 22.4 | 22.4 | 22.4 | 22.4 |
| Capital Expenditure | -770.0 | -647.0 | -981.0 | -1,061.0 | -1,050.0 | -1,168.6 | -1,288.1 | -1,419.8 | -1,565.0 | -1,725.0 |
| Capital Expenditure, % | -5.22 | -5.25 | -5.61 | -5.1 | -5.23 | -5.28 | -5.28 | -5.28 | -5.28 | -5.28 |
| Tax Rate, % | -1.77 | -1.77 | -1.77 | -1.77 | -1.77 | -1.77 | -1.77 | -1.77 | -1.77 | -1.77 |
| EBITAT | -924.6 | -866.2 | 1,398.4 | 450.6 | -147.6 | 194.0 | 213.8 | 235.7 | 259.7 | 286.3 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -2,783.6 | 330.8 | 366.4 | -191.4 | 78.4 | 3.2 | 6.6 | 7.3 | 8.1 | 8.9 |
| WACC, % | 2.82 | 7.58 | 7.58 | 5.23 | 7.58 | 6.15 | 6.15 | 6.15 | 6.15 | 6.15 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 28.0 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 9 | |||||||||
| Terminal Value | 219 | |||||||||
| Present Terminal Value | 162 | |||||||||
| Enterprise Value | 190 | |||||||||
| Net Debt | 7,747 | |||||||||
| Equity Value | -7,557 | |||||||||
| Diluted Shares Outstanding, MM | 285 | |||||||||
| Equity Value Per Share | -26.52 |
What You Will Get
- Real GT Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are calculated in real-time.
- Scenario Analysis: Explore various scenarios to assess Goodyear’s future performance.
- User-Friendly Design: Designed for professionals while remaining approachable for newcomers.
Key Features
- Customizable Tire Specifications: Adjust key parameters such as tread depth, rubber composition, and performance metrics.
- Instant Tire Performance Analysis: Evaluates tire durability, fuel efficiency, and handling characteristics in real-time.
- Industry-Leading Precision: Incorporates Goodyear’s extensive testing data for accurate performance predictions.
- Comprehensive Scenario Testing: Explore various driving conditions and compare tire performance effortlessly.
- Efficiency Booster: Streamline the process of tire selection without the hassle of complex calculations.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Goodyear data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Goodyear’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Goodyear Tire & Rubber Company (GT)?
- Accurate Data: Up-to-date Goodyear financials provide trustworthy 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 having to build from the ground up.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants in the tire industry.
- User-Friendly: Easy-to-navigate design and clear instructions ensure accessibility for all users.
Who Should Use This Product?
- Automotive Students: Understand tire technology and apply concepts using real-world data.
- Researchers: Utilize industry models in academic projects or studies related to tire manufacturing.
- Investors: Evaluate your investment strategies and analyze valuation metrics for Goodyear Tire & Rubber Company (GT).
- Market Analysts: Enhance your analysis with a customizable model specific to the tire industry.
- Fleet Managers: Learn how large corporations like Goodyear assess tire performance and durability.
What the Template Contains
- Comprehensive DCF Model: Editable template with detailed valuation calculations tailored for The Goodyear Tire & Rubber Company (GT).
- Real-World Data: Goodyear’s historical and projected financials preloaded for analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to test various scenarios.
- Financial Statements: Full annual and quarterly breakdowns for deeper insights into Goodyear's performance.
- Key Ratios: Built-in analysis for profitability, efficiency, and leverage specific to Goodyear.
- Dashboard with Visual Outputs: Charts and tables for clear, actionable results related to Goodyear's financial health.