|
Lockheed Martin Corporation (LMT) DCF Valoración
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
Lockheed Martin Corporation (LMT) Bundle
¡Mejore sus estrategias de inversión con la calculadora DCF de Lockheed Martin Corporation (LMT)! Explore los datos financieros reales, ajuste las tasas y gastos de crecimiento proyectados, y observe instantáneamente cómo estos cambios afectan el valor intrínseco de Lockheed Martin Corporation (LMT).
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 | 59,812.0 | 65,398.0 | 67,044.0 | 65,984.0 | 67,571.0 | 69,713.0 | 71,923.0 | 74,203.0 | 76,555.3 | 78,982.1 |
| Revenue Growth, % | 0 | 9.34 | 2.52 | -1.58 | 2.41 | 3.17 | 3.17 | 3.17 | 3.17 | 3.17 |
| EBITDA | 9,083.0 | 10,116.0 | 9,483.0 | 8,707.0 | 10,444.0 | 10,240.9 | 10,565.6 | 10,900.5 | 11,246.1 | 11,602.6 |
| EBITDA, % | 15.19 | 15.47 | 14.14 | 13.2 | 15.46 | 14.69 | 14.69 | 14.69 | 14.69 | 14.69 |
| Depreciation | 1,189.0 | 1,290.0 | 1,364.0 | 1,404.0 | 1,430.0 | 1,427.6 | 1,472.8 | 1,519.5 | 1,567.7 | 1,617.4 |
| Depreciation, % | 1.99 | 1.97 | 2.03 | 2.13 | 2.12 | 2.05 | 2.05 | 2.05 | 2.05 | 2.05 |
| EBIT | 7,894.0 | 8,826.0 | 8,119.0 | 7,303.0 | 9,014.0 | 8,813.4 | 9,092.7 | 9,381.0 | 9,678.4 | 9,985.2 |
| EBIT, % | 13.2 | 13.5 | 12.11 | 11.07 | 13.34 | 12.64 | 12.64 | 12.64 | 12.64 | 12.64 |
| Total Cash | 1,514.0 | 3,160.0 | 3,604.0 | 2,547.0 | 1,442.0 | 2,611.9 | 2,694.6 | 2,780.1 | 2,868.2 | 2,959.1 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 11,431.0 | 11,523.0 | 12,542.0 | 14,823.0 | 15,315.0 | 14,021.8 | 14,466.3 | 14,924.9 | 15,398.0 | 15,886.2 |
| Account Receivables, % | 19.11 | 17.62 | 18.71 | 22.46 | 22.67 | 20.11 | 20.11 | 20.11 | 20.11 | 20.11 |
| Inventories | 3,619.0 | 3,545.0 | 2,981.0 | 3,088.0 | 3,132.0 | 3,518.1 | 3,629.6 | 3,744.7 | 3,863.4 | 3,985.9 |
| Inventories, % | 6.05 | 5.42 | 4.45 | 4.68 | 4.64 | 5.05 | 5.05 | 5.05 | 5.05 | 5.05 |
| Accounts Payable | 1,281.0 | 880.0 | 780.0 | 2,117.0 | 2,312.0 | 1,572.8 | 1,622.7 | 1,674.1 | 1,727.2 | 1,781.9 |
| Accounts Payable, % | 2.14 | 1.35 | 1.16 | 3.21 | 3.42 | 2.26 | 2.26 | 2.26 | 2.26 | 2.26 |
| Capital Expenditure | -1,484.0 | -1,766.0 | -1,522.0 | -1,670.0 | -1,691.0 | -1,740.8 | -1,795.9 | -1,852.9 | -1,911.6 | -1,972.2 |
| Capital Expenditure, % | -2.48 | -2.7 | -2.27 | -2.53 | -2.5 | -2.5 | -2.5 | -2.5 | -2.5 | -2.5 |
| Tax Rate, % | 14.55 | 14.55 | 14.55 | 14.55 | 14.55 | 14.55 | 14.55 | 14.55 | 14.55 | 14.55 |
| EBITAT | 6,791.8 | 7,323.4 | 6,790.9 | 6,266.6 | 7,702.8 | 7,472.3 | 7,709.1 | 7,953.5 | 8,205.7 | 8,465.8 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -7,272.2 | 6,428.4 | 6,077.9 | 4,949.6 | 7,100.8 | 7,327.0 | 6,879.9 | 7,098.0 | 7,323.0 | 7,555.1 |
| WACC, % | 6.45 | 6.43 | 6.43 | 6.44 | 6.44 | 6.44 | 6.44 | 6.44 | 6.44 | 6.44 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 30,079.3 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 7,706 | |||||||||
| Terminal Value | 173,659 | |||||||||
| Present Terminal Value | 127,123 | |||||||||
| Enterprise Value | 157,202 | |||||||||
| Net Debt | 16,017 | |||||||||
| Equity Value | 141,185 | |||||||||
| Diluted Shares Outstanding, MM | 251 | |||||||||
| Equity Value Per Share | 562.04 |
What You Will Get
- Real Lockheed Martin Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures.
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Lockheed Martin’s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections.
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility.
Key Features
- Comprehensive Data: Lockheed Martin’s historical financial reports and pre-filled projections.
- Customizable Inputs: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Insights: Monitor Lockheed Martin’s intrinsic value recalculating instantly.
- Visual Data Presentation: Interactive dashboard charts showcase valuation outcomes and essential metrics.
- Designed for Precision: A reliable tool tailored for analysts, investors, and finance professionals.
How It Works
- Download: Obtain the ready-to-use Excel file containing Lockheed Martin Corporation’s (LMT) financial data.
- Customize: Tailor forecasts, such as revenue growth, EBITDA %, and WACC to your specifications.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Generate various projections and instantly compare their outcomes.
- Make Decisions: Leverage the valuation results to inform your investment strategy.
Why Choose This Calculator for Lockheed Martin Corporation (LMT)?
- Accurate Data: Reliable financial information from Lockheed Martin ensures trustworthy valuation outcomes.
- Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to fit your forecasts.
- Time-Saving: Built-in calculations save you the effort of starting from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants in the defense industry.
- User-Friendly: An intuitive design and clear instructions make it accessible for all users.
Who Should Use This Product?
- Investors: Evaluate Lockheed Martin’s valuation prior to making investment decisions.
- CFOs and Financial Analysts: Enhance valuation methodologies and assess financial forecasts.
- Defense Industry Leaders: Understand how large defense contractors like Lockheed Martin are appraised.
- Consultants: Provide comprehensive valuation reports for clients in the aerospace and defense sectors.
- Students and Educators: Utilize current data to learn and teach valuation practices in finance.
What the Template Contains
- Comprehensive DCF Model: Editable template with detailed valuation calculations tailored for Lockheed Martin Corporation (LMT).
- Real-World Data: Lockheed Martin’s historical and projected financials preloaded for thorough analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into performance.
- Key Ratios: Integrated analysis for assessing profitability, efficiency, and leverage specific to Lockheed Martin (LMT).
- Dashboard with Visual Outputs: Charts and tables designed for clear, actionable results regarding Lockheed Martin Corporation (LMT).