LG Display Co., Ltd. (LPL) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
LG Display Co., Ltd. (LPL) Bundle
Streamline your analysis and improve precision with our [LPL] DCF Calculator! Utilizing actual data from LG Display Co., Ltd. and customizable assumptions, this tool empowers you to forecast, analyze, and value [Company] like a seasoned investor.
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 | 15,942.9 | 16,455.3 | 20,291.0 | 17,760.4 | 14,486.3 | 14,327.6 | 14,170.6 | 14,015.4 | 13,861.8 | 13,710.0 |
| Revenue Growth, % | 0 | 3.21 | 23.31 | -12.47 | -18.43 | -1.1 | -1.1 | -1.1 | -1.1 | -1.1 |
| EBITDA | 1.2 | 2,650.0 | 4,302.9 | .4 | 1,085.1 | 1,284.0 | 1,270.0 | 1,256.1 | 1,242.3 | 1,228.7 |
| EBITDA, % | 0.00725861 | 16.1 | 21.21 | 0.0024396 | 7.49 | 8.96 | 8.96 | 8.96 | 8.96 | 8.96 |
| Depreciation | 2,509.4 | 2,807.5 | 3,056.5 | 3,094.5 | 2,861.7 | 2,436.9 | 2,410.2 | 2,383.8 | 2,357.7 | 2,331.9 |
| Depreciation, % | 15.74 | 17.06 | 15.06 | 17.42 | 19.75 | 17.01 | 17.01 | 17.01 | 17.01 | 17.01 |
| EBIT | -2,508.2 | -157.5 | 1,246.3 | -3,094.1 | -1,776.6 | -1,152.9 | -1,140.3 | -1,127.8 | -1,115.4 | -1,103.2 |
| EBIT, % | -15.73 | -0.95735 | 6.14 | -17.42 | -12.26 | -8.05 | -8.05 | -8.05 | -8.05 | -8.05 |
| Total Cash | 2,273.1 | 2,871.8 | 2,424.1 | 1,426.7 | 1,627.6 | 1,803.1 | 1,783.4 | 1,763.8 | 1,744.5 | 1,725.4 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 2,145.9 | 2,392.9 | 3,111.5 | 1,606.7 | 2,188.3 | 1,933.9 | 1,912.7 | 1,891.8 | 1,871.0 | 1,850.5 |
| Account Receivables, % | 13.46 | 14.54 | 15.33 | 9.05 | 15.11 | 13.5 | 13.5 | 13.5 | 13.5 | 13.5 |
| Inventories | 1,393.0 | 1,474.1 | 2,275.3 | 1,951.1 | 1,716.6 | 1,482.8 | 1,466.5 | 1,450.5 | 1,434.6 | 1,418.8 |
| Inventories, % | 8.74 | 8.96 | 11.21 | 10.99 | 11.85 | 10.35 | 10.35 | 10.35 | 10.35 | 10.35 |
| Accounts Payable | 1,778.1 | 2,566.6 | 3,269.4 | 2,757.6 | 2,833.7 | 2,233.7 | 2,209.2 | 2,185.0 | 2,161.1 | 2,137.4 |
| Accounts Payable, % | 11.15 | 15.6 | 16.11 | 15.53 | 19.56 | 15.59 | 15.59 | 15.59 | 15.59 | 15.59 |
| Capital Expenditure | -5,071.7 | -2,008.1 | -2,565.2 | -4,013.5 | -2,816.6 | -2,828.2 | -2,797.2 | -2,766.6 | -2,736.3 | -2,706.3 |
| Capital Expenditure, % | -31.81 | -12.2 | -12.64 | -22.6 | -19.44 | -19.74 | -19.74 | -19.74 | -19.74 | -19.74 |
| Tax Rate, % | 18.14 | 18.14 | 18.14 | 18.14 | 18.14 | 18.14 | 18.14 | 18.14 | 18.14 | 18.14 |
| EBITAT | -2,154.1 | -18.7 | 860.1 | -2,879.8 | -1,454.4 | -787.9 | -779.2 | -770.7 | -762.3 | -753.9 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -6,477.2 | 1,241.1 | 534.3 | -2,481.5 | -1,680.4 | -1,290.9 | -1,153.3 | -1,140.7 | -1,128.2 | -1,115.8 |
| WACC, % | 4.34 | 1.35 | 3.66 | 4.63 | 4.18 | 3.63 | 3.63 | 3.63 | 3.63 | 3.63 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -5,255.9 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -1,138 | |||||||||
| Terminal Value | -69,687 | |||||||||
| Present Terminal Value | -58,298 | |||||||||
| Enterprise Value | -63,554 | |||||||||
| Net Debt | 9,742 | |||||||||
| Equity Value | -73,296 | |||||||||
| Diluted Shares Outstanding, MM | 358 | |||||||||
| Equity Value Per Share | -204.84 |
What You Will Get
- Real LPL Financials: Access to both historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are computed in real-time.
- Scenario Analysis: Evaluate various scenarios to assess LG Display’s future performance.
- User-Friendly Design: Designed for professionals while remaining approachable for newcomers.
Key Features
- Real-Life LPL Data: Pre-filled with LG Display’s historical financials and forward-looking projections.
- Fully Customizable Inputs: Adjust revenue growth, margins, WACC, tax rates, and capital expenditures.
- Dynamic Valuation Model: Automatic updates to Net Present Value (NPV) and intrinsic value based on your inputs.
- Scenario Testing: Create multiple forecast scenarios to analyze different valuation outcomes.
- User-Friendly Design: Simple, structured, and designed for professionals and beginners alike.
How It Works
- 1. Access the Template: Download and open the Excel file featuring LG Display Co., Ltd.'s (LPL) preloaded data.
- 2. Modify Assumptions: Adjust key parameters such as growth rates, WACC, and capital expenditures as needed.
- 3. Analyze Results in Real-Time: The DCF model automatically computes intrinsic value and NPV for you.
- 4. Explore Different Scenarios: Evaluate various forecasts to assess different valuation scenarios.
- 5. Present with Assurance: Deliver professional valuation insights to back up your strategic decisions.
Why Choose LG Display Co., Ltd. (LPL)?
- Innovative Technology: Benefit from cutting-edge display solutions that enhance visual experiences.
- Proven Reliability: With a strong track record, LG Display ensures high-quality products and services.
- Custom Solutions: Tailor-made display technologies to meet diverse industry needs.
- Global Expertise: Backed by a team of professionals with extensive knowledge in display technology.
- Commitment to Sustainability: Focused on eco-friendly practices and reducing environmental impact.
Who Should Use This Product?
- Investors: Accurately estimate LG Display Co., Ltd.’s (LPL) fair value before making investment decisions.
- CFOs: Utilize a professional-grade DCF model for financial reporting and analysis specific to LG Display Co., Ltd. (LPL).
- Consultants: Efficiently customize the template for valuation reports tailored to clients in the display technology sector.
- Entrepreneurs: Acquire insights into financial modeling practices employed by leading companies like LG Display Co., Ltd. (LPL).
- Educators: Employ it as a teaching resource to illustrate valuation methodologies relevant to the technology industry.
What the Template Contains
- Pre-Filled DCF Model: LG Display’s financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate LG Display’s profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.