Lear Corporation (LEA) DCF Valuation
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
Lear Corporation (LEA) Bundle
Whether you're an investor or analyst, this Lear Corporation (LEA) DCF Calculator is your go-to resource for accurate valuation. Loaded with real data from Lear Corporation, you can adjust forecasts and observe the effects in real time.
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 | 19,810.3 | 17,045.5 | 19,263.1 | 20,891.5 | 23,466.9 | 24,630.5 | 25,851.9 | 27,133.8 | 28,479.2 | 29,891.4 |
Revenue Growth, % | 0 | -13.96 | 13.01 | 8.45 | 12.33 | 4.96 | 4.96 | 4.96 | 4.96 | 4.96 |
EBITDA | 1,767.9 | 1,133.3 | 1,246.8 | 1,182.0 | 1,656.5 | 1,712.4 | 1,797.3 | 1,886.4 | 1,980.0 | 2,078.2 |
EBITDA, % | 8.92 | 6.65 | 6.47 | 5.66 | 7.06 | 6.95 | 6.95 | 6.95 | 6.95 | 6.95 |
Depreciation | 509.9 | 539.9 | 573.9 | 576.5 | 602.5 | 692.0 | 726.3 | 762.3 | 800.1 | 839.8 |
Depreciation, % | 2.57 | 3.17 | 2.98 | 2.76 | 2.57 | 2.81 | 2.81 | 2.81 | 2.81 | 2.81 |
EBIT | 1,258.0 | 593.4 | 672.9 | 605.5 | 1,054.0 | 1,020.4 | 1,071.0 | 1,124.1 | 1,179.9 | 1,238.4 |
EBIT, % | 6.35 | 3.48 | 3.49 | 2.9 | 4.49 | 4.14 | 4.14 | 4.14 | 4.14 | 4.14 |
Total Cash | 1,487.7 | 1,306.7 | 1,318.3 | 1,114.9 | 1,196.3 | 1,598.7 | 1,678.0 | 1,761.2 | 1,848.5 | 1,940.2 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 2,982.6 | 3,269.2 | 3,041.5 | 3,451.9 | 3,681.2 | 4,050.9 | 4,251.8 | 4,462.6 | 4,683.9 | 4,916.2 |
Account Receivables, % | 15.06 | 19.18 | 15.79 | 16.52 | 15.69 | 16.45 | 16.45 | 16.45 | 16.45 | 16.45 |
Inventories | 1,258.2 | 1,401.1 | 1,571.9 | 1,573.6 | 1,758.0 | 1,859.8 | 1,952.1 | 2,048.9 | 2,150.5 | 2,257.1 |
Inventories, % | 6.35 | 8.22 | 8.16 | 7.53 | 7.49 | 7.55 | 7.55 | 7.55 | 7.55 | 7.55 |
Accounts Payable | 2,821.7 | 2,735.5 | 2,513.9 | 2,755.6 | 3,434.2 | 3,505.7 | 3,679.6 | 3,862.0 | 4,053.5 | 4,254.5 |
Accounts Payable, % | 14.24 | 16.05 | 13.05 | 13.19 | 14.63 | 14.23 | 14.23 | 14.23 | 14.23 | 14.23 |
Capital Expenditure | -603.9 | -452.3 | -585.1 | -638.2 | -626.5 | -712.5 | -747.8 | -784.9 | -823.8 | -864.7 |
Capital Expenditure, % | -3.05 | -2.65 | -3.04 | -3.05 | -2.67 | -2.89 | -2.89 | -2.89 | -2.89 | -2.89 |
Tax Rate, % | 26.34 | 26.34 | 26.34 | 26.34 | 26.34 | 26.34 | 26.34 | 26.34 | 26.34 | 26.34 |
EBITAT | 994.2 | 314.2 | 431.2 | 389.6 | 776.4 | 681.8 | 715.6 | 751.1 | 788.3 | 827.4 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -518.9 | -113.9 | 255.3 | 157.5 | 1,017.3 | 261.2 | 574.8 | 603.3 | 633.2 | 664.6 |
WACC, % | 8.69 | 8.29 | 8.46 | 8.46 | 8.6 | 8.5 | 8.5 | 8.5 | 8.5 | 8.5 |
PV UFCF | ||||||||||
SUM PV UFCF | 2,100.3 | |||||||||
Long Term Growth Rate, % | 3.00 | |||||||||
Free cash flow (T + 1) | 685 | |||||||||
Terminal Value | 12,447 | |||||||||
Present Terminal Value | 8,278 | |||||||||
Enterprise Value | 10,378 | |||||||||
Net Debt | 1,726 | |||||||||
Equity Value | 8,652 | |||||||||
Diluted Shares Outstanding, MM | 59 | |||||||||
Equity Value Per Share | 146.35 |
What You Will Get
- Real LEA Financial Data: Pre-filled with Lear Corporation’s historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See Lear Corporation’s intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- 🔍 Real-Life LEA Financials: Pre-filled historical and projected data for Lear Corporation (LEA).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Lear’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Lear’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- 1. Access the Template: Download and open the Excel file featuring Lear Corporation’s (LEA) preloaded data.
- 2. Modify Assumptions: Adjust essential inputs such as growth rates, WACC, and capital expenditures.
- 3. View Results Instantly: The DCF model automatically calculates the intrinsic value and NPV.
- 4. Explore Scenarios: Evaluate various forecasts to assess different valuation outcomes.
- 5. Use with Assurance: Present expert valuation insights to bolster your decision-making process.
Why Choose This Calculator for Lear Corporation (LEA)?
- User-Friendly Interface: Perfectly crafted for both novices and seasoned professionals.
- Customizable Inputs: Effortlessly adjust parameters to suit your financial analysis.
- Real-Time Feedback: Observe immediate updates to Lear Corporation’s valuation as you modify inputs.
- Pre-Configured Data: Comes equipped with Lear Corporation’s actual financial metrics for swift evaluation.
- Preferred by Experts: Favored by investors and analysts for making well-informed choices.
Who Should Use This Product?
- Investors: Evaluate Lear Corporation’s (LEA) valuation prior to making investment decisions.
- CFOs and Financial Analysts: Optimize valuation methodologies and assess financial forecasts.
- Startup Founders: Discover how established firms like Lear Corporation (LEA) are appraised in the market.
- Consultants: Provide expert valuation analyses and reports for your clients.
- Students and Educators: Utilize current data to learn and teach valuation strategies effectively.
What the Template Contains
- Pre-Filled Data: Contains Lear Corporation’s historical financials and projections.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Evaluate Lear Corporation’s profitability, efficiency, and leverage.
- Customizable Inputs: Easily edit revenue growth, margins, and tax rates.
- Clear Dashboard: Visuals and tables summarizing key valuation outcomes.