Lear Corporation (LEA) DCF Valuation

Lear Corporation (LEA) DCF Valuation
  • 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

Lear Corporation (LEA) Bundle

DCF model
Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

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
Account Receivables, % 15.06 19.18 15.79 16.52 15.69
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.