|
Valoración de DCF de General Electric Company (GE)
US | Industrials | Aerospace & Defense | NYSE
|
- ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
- ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
- ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
- ✓ No Se Necesita Experiencia; Fáciles De Seguir
General Electric Company (GE) Bundle
¡Optimice su tiempo y mejore la precisión con nuestra calculadora DCF (GE)! Con datos eléctricos generales reales y supuestos personalizables, esta herramienta le permite pronosticar, analizar y evaluar (GE) al igual que un inversor experimentado.
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 | 95,215.0 | 75,834.0 | 56,469.0 | 58,099.0 | 67,954.0 | 63,529.8 | 59,393.7 | 55,526.9 | 51,911.8 | 48,532.1 |
| Revenue Growth, % | 0 | -20.35 | -25.54 | 2.89 | 16.96 | -6.51 | -6.51 | -6.51 | -6.51 | -6.51 |
| EBITDA | 11,068.0 | 2,832.0 | 3,382.0 | 3,541.0 | 13,378.0 | 5,988.3 | 5,598.4 | 5,233.9 | 4,893.1 | 4,574.6 |
| EBITDA, % | 11.62 | 3.73 | 5.99 | 6.09 | 19.69 | 9.43 | 9.43 | 9.43 | 9.43 | 9.43 |
| Depreciation | 5,595.0 | 3,464.0 | 2,360.0 | 2,902.0 | 2,079.0 | 2,881.4 | 2,693.8 | 2,518.4 | 2,354.5 | 2,201.2 |
| Depreciation, % | 5.88 | 4.57 | 4.18 | 4.99 | 3.06 | 4.54 | 4.54 | 4.54 | 4.54 | 4.54 |
| EBIT | 5,473.0 | -632.0 | 1,022.0 | 639.0 | 11,299.0 | 3,106.8 | 2,904.6 | 2,715.5 | 2,538.7 | 2,373.4 |
| EBIT, % | 5.75 | -0.8334 | 1.81 | 1.1 | 16.63 | 4.89 | 4.89 | 4.89 | 4.89 | 4.89 |
| Total Cash | 84,900.0 | 43,949.0 | 28,067.0 | 23,419.0 | 22,673.0 | 34,369.4 | 32,131.8 | 30,039.8 | 28,084.1 | 26,255.7 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 27,670.0 | 23,720.0 | 20,501.0 | 17,298.0 | 16,966.0 | 19,234.9 | 17,982.6 | 16,811.8 | 15,717.3 | 14,694.0 |
| Account Receivables, % | 29.06 | 31.28 | 36.3 | 29.77 | 24.97 | 30.28 | 30.28 | 30.28 | 30.28 | 30.28 |
| Inventories | 14,100.0 | 15,890.0 | 15,847.0 | 14,891.0 | 16,528.0 | 14,456.6 | 13,515.4 | 12,635.5 | 11,812.9 | 11,043.8 |
| Inventories, % | 14.81 | 20.95 | 28.06 | 25.63 | 24.32 | 22.76 | 22.76 | 22.76 | 22.76 | 22.76 |
| Accounts Payable | 17,357.0 | 16,458.0 | 16,243.0 | 10,033.0 | 10,678.0 | 12,919.3 | 12,078.2 | 11,291.8 | 10,556.7 | 9,869.4 |
| Accounts Payable, % | 18.23 | 21.7 | 28.76 | 17.27 | 15.71 | 20.34 | 20.34 | 20.34 | 20.34 | 20.34 |
| Capital Expenditure | -6,095.0 | -3,403.0 | -1,361.0 | -1,174.0 | -1,595.0 | -2,244.7 | -2,098.6 | -1,962.0 | -1,834.2 | -1,714.8 |
| Capital Expenditure, % | -6.4 | -4.49 | -2.41 | -2.02 | -2.35 | -3.53 | -3.53 | -3.53 | -3.53 | -3.53 |
| Tax Rate, % | 6.97 | 6.97 | 6.97 | 6.97 | 6.97 | 6.97 | 6.97 | 6.97 | 6.97 | 6.97 |
| EBITAT | -23,716.3 | -603.8 | 1,137.2 | -271.1 | 10,511.8 | 1,793.1 | 1,676.4 | 1,567.2 | 1,465.2 | 1,369.8 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -48,629.3 | 718.2 | 5,183.2 | -594.1 | 10,335.8 | 4,473.6 | 3,624.0 | 3,388.1 | 3,167.5 | 2,961.3 |
| WACC, % | 8.96 | 9.47 | 9.49 | 8.96 | 9.45 | 9.27 | 9.27 | 9.27 | 9.27 | 9.27 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 13,850.4 | |||||||||
| Long Term Growth Rate, % | 3.50 | |||||||||
| Free cash flow (T + 1) | 3,065 | |||||||||
| Terminal Value | 53,159 | |||||||||
| Present Terminal Value | 34,132 | |||||||||
| Enterprise Value | 47,982 | |||||||||
| Net Debt | 5,970 | |||||||||
| Equity Value | 42,012 | |||||||||
| Diluted Shares Outstanding, MM | 1,099 | |||||||||
| Equity Value Per Share | 38.23 |
What You Will Get
- Accurate GE Financials: Access both historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures to fit your analysis.
- Real-Time Calculations: Intrinsic value and NPV are computed automatically and updated instantly.
- Comprehensive Scenario Analysis: Evaluate various scenarios to assess General Electric's future performance.
- User-Friendly Design: Designed for professionals while remaining approachable for newcomers.
Key Features
- Comprehensive GE Financials: Gain access to precise historical data and future forecasts tailored for General Electric (GE).
- Adjustable Forecast Parameters: Modify highlighted cells for WACC, growth rates, and profit margins as needed.
- Real-Time Calculations: Instantaneous updates for DCF, Net Present Value (NPV), and cash flow assessments.
- Interactive Dashboard: User-friendly charts and summaries to clearly present your valuation findings.
- Designed for All Users: An easy-to-navigate layout suitable for investors, CFOs, and consultants alike.
How It Works
- Step 1: Download the prebuilt Excel template featuring General Electric Company’s (GE) data.
- Step 2: Navigate through the pre-filled sheets to grasp the essential metrics.
- Step 3: Adjust forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly view the recalibrated results, including General Electric’s (GE) intrinsic value.
- Step 5: Make well-informed investment choices or create reports based on the results.
Why Choose This Calculator for General Electric Company (GE)?
- User-Friendly Interface: Perfect for both novices and seasoned professionals.
- Customizable Inputs: Adjust parameters easily to suit your financial analysis.
- Real-Time Valuation: Observe immediate updates to General Electric's valuation as you change inputs.
- Preloaded Data: Comes with General Electric's actual financial statistics for swift evaluations.
- Relied Upon by Experts: Favored by investors and analysts for making well-informed choices.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling General Electric Company (GE) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for General Electric Company (GE).
- Consultants: Deliver professional valuation insights on General Electric Company (GE) to clients quickly and accurately.
- Business Owners: Understand how large companies like General Electric Company (GE) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to General Electric Company (GE).
What the Template Contains
- Preloaded GE Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.