L3Harris Technologies, Inc. (LHX) DCF Valuation
- ✓ 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
L3Harris Technologies, Inc. (LHX) Bundle
Looking to calculate the intrinsic value of L3Harris Technologies, Inc.? Our LHX DCF Calculator integrates real-world data with extensive customization features, enabling you to adjust projections and enhance your investment strategies.
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 | 18,526.0 | 18,194.0 | 17,814.0 | 17,062.0 | 19,419.0 | 19,696.3 | 19,977.6 | 20,262.9 | 20,552.3 | 20,845.7 |
| Revenue Growth, % | 0 | -1.79 | -2.09 | -4.22 | 13.81 | 1.43 | 1.43 | 1.43 | 1.43 | 1.43 |
| EBITDA | 2,980.0 | 2,639.0 | 3,518.0 | 2,499.0 | 2,932.0 | 3,154.7 | 3,199.8 | 3,245.5 | 3,291.8 | 3,338.8 |
| EBITDA, % | 16.09 | 14.5 | 19.75 | 14.65 | 15.1 | 16.02 | 16.02 | 16.02 | 16.02 | 16.02 |
| Depreciation | 894.0 | 1,047.0 | 970.0 | 947.0 | 1,166.0 | 1,086.5 | 1,102.0 | 1,117.7 | 1,133.7 | 1,149.9 |
| Depreciation, % | 4.83 | 5.75 | 5.45 | 5.55 | 6 | 5.52 | 5.52 | 5.52 | 5.52 | 5.52 |
| EBIT | 2,086.0 | 1,592.0 | 2,548.0 | 1,552.0 | 1,766.0 | 2,068.3 | 2,097.8 | 2,127.8 | 2,158.1 | 2,189.0 |
| EBIT, % | 11.26 | 8.75 | 14.3 | 9.1 | 9.09 | 10.5 | 10.5 | 10.5 | 10.5 | 10.5 |
| Total Cash | 824.0 | 1,276.0 | 941.0 | 880.0 | 560.0 | 976.3 | 990.3 | 1,004.4 | 1,018.8 | 1,033.3 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 3,675.0 | 4,076.0 | 4,164.0 | 1,251.0 | 4,426.0 | 3,771.4 | 3,825.3 | 3,879.9 | 3,935.3 | 3,991.5 |
| Account Receivables, % | 19.84 | 22.4 | 23.37 | 7.33 | 22.79 | 19.15 | 19.15 | 19.15 | 19.15 | 19.15 |
| Inventories | 1,219.0 | 973.0 | 982.0 | 1,291.0 | 1,472.0 | 1,283.7 | 1,302.0 | 1,320.6 | 1,339.5 | 1,358.6 |
| Inventories, % | 6.58 | 5.35 | 5.51 | 7.57 | 7.58 | 6.52 | 6.52 | 6.52 | 6.52 | 6.52 |
| Accounts Payable | 1,261.0 | 1,406.0 | 1,767.0 | 1,945.0 | 2,106.0 | 1,839.6 | 1,865.8 | 1,892.5 | 1,919.5 | 1,946.9 |
| Accounts Payable, % | 6.81 | 7.73 | 9.92 | 11.4 | 10.85 | 9.34 | 9.34 | 9.34 | 9.34 | 9.34 |
| Capital Expenditure | -173.0 | -368.0 | -342.0 | -252.0 | -449.0 | -341.4 | -346.2 | -351.2 | -356.2 | -361.3 |
| Capital Expenditure, % | -0.93382 | -2.02 | -1.92 | -1.48 | -2.31 | -1.73 | -1.73 | -1.73 | -1.73 | -1.73 |
| Tax Rate, % | -0.4914 | -0.4914 | -0.4914 | -0.4914 | -0.4914 | -0.4914 | -0.4914 | -0.4914 | -0.4914 | -0.4914 |
| EBITAT | 1,888.4 | 1,347.5 | 2,060.3 | 1,294.8 | 1,774.7 | 1,817.8 | 1,843.8 | 1,870.1 | 1,896.8 | 1,923.9 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -1,023.6 | 2,016.5 | 2,952.3 | 4,771.8 | -703.3 | 3,139.4 | 2,553.6 | 2,590.1 | 2,627.1 | 2,664.6 |
| WACC, % | 6.89 | 6.82 | 6.78 | 6.81 | 7 | 6.86 | 6.86 | 6.86 | 6.86 | 6.86 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 11,223.6 | |||||||||
| Long Term Growth Rate, % | 3.00 | |||||||||
| Free cash flow (T + 1) | 2,745 | |||||||||
| Terminal Value | 71,095 | |||||||||
| Present Terminal Value | 51,022 | |||||||||
| Enterprise Value | 62,246 | |||||||||
| Net Debt | 13,390 | |||||||||
| Equity Value | 48,856 | |||||||||
| Diluted Shares Outstanding, MM | 191 | |||||||||
| Equity Value Per Share | 256.33 |
What You Will Get
- Real LHX Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Automatic Calculations: Dynamic calculations for intrinsic value and NPV.
- Scenario Analysis: Evaluate various scenarios to assess L3Harris's future performance.
- User-Friendly Design: Designed for professionals while remaining approachable for newcomers.
Key Features
- Customizable Financial Inputs: Adjust essential metrics such as revenue growth, EBITDA %, and capital expenditures with ease.
- Instant DCF Valuation: Provides immediate calculations for intrinsic value, NPV, and additional financial outputs.
- High-Precision Results: Leverages L3Harris Technologies' real-world financial data for accurate valuation assessments.
- Effortless Scenario Analysis: Easily explore varying assumptions and analyze different outcomes side by side.
- Efficiency Booster: Streamlines the valuation process, removing the need to create intricate models from the ground up.
How It Works
- Download the Template: Gain immediate access to the Excel-based L3Harris DCF Calculator for [LHX].
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, profit margins, and more.
- Instant Calculations: The model automatically recalculates L3Harris's intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Leverage the results to inform your investment or financial decisions.
Why Choose L3Harris Technologies, Inc. (LHX)?
- Innovative Solutions: Cutting-edge technology that meets the evolving needs of defense and aerospace.
- Proven Expertise: Decades of experience in delivering reliable and high-performance systems.
- Commitment to Quality: Rigorous testing and quality assurance ensure top-notch products.
- Global Reach: A strong presence in international markets with a diverse customer base.
- Collaborative Approach: Partnering with clients to develop tailored solutions that drive success.
Who Should Use L3Harris Technologies, Inc. (LHX)?
- Investors: Make informed investment choices with insights from a leading defense and technology company.
- Defense Analysts: Streamline your research with comprehensive reports and data on L3Harris' performance.
- Consultants: Tailor presentations or analyses based on L3Harris' innovative solutions and market strategies.
- Technology Enthusiasts: Explore cutting-edge advancements in communication and electronic systems through L3Harris' offerings.
- Educators and Students: Utilize L3Harris as a case study in engineering and technology courses.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled L3Harris Technologies 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 L3Harris Technologies.
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.