POSCO Holdings Inc. (PKX) 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
POSCO Holdings Inc. (PKX) Bundle
Explore the financial future of POSCO Holdings Inc. (PKX) with our user-friendly DCF Calculator! Enter your assumptions regarding growth, margins, and costs to calculate the intrinsic value of POSCO Holdings Inc. (PKX) and enhance your investment strategy.
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 | 43,713.2 | 39,248.6 | 51,839.3 | 57,556.1 | 52,331.1 | 55,446.9 | 58,748.2 | 62,246.0 | 65,952.1 | 69,878.9 |
Revenue Growth, % | 0 | -10.21 | 32.08 | 11.03 | -9.08 | 5.95 | 5.95 | 5.95 | 5.95 | 5.95 |
EBITDA | 4,777.9 | 4,199.8 | 8,683.2 | 5,795.5 | 4,929.9 | 6,417.5 | 6,799.6 | 7,204.4 | 7,633.4 | 8,087.9 |
EBITDA, % | 10.93 | 10.7 | 16.75 | 10.07 | 9.42 | 11.57 | 11.57 | 11.57 | 11.57 | 11.57 |
Depreciation | 2,350.5 | 2,459.6 | 2,430.9 | 2,508.4 | 2,611.0 | 2,847.8 | 3,017.4 | 3,197.1 | 3,387.4 | 3,589.1 |
Depreciation, % | 5.38 | 6.27 | 4.69 | 4.36 | 4.99 | 5.14 | 5.14 | 5.14 | 5.14 | 5.14 |
EBIT | 2,427.3 | 1,740.2 | 6,252.3 | 3,287.1 | 2,318.9 | 3,569.7 | 3,782.2 | 4,007.4 | 4,246.0 | 4,498.8 |
EBIT, % | 5.55 | 4.43 | 12.06 | 5.71 | 4.43 | 6.44 | 6.44 | 6.44 | 6.44 | 6.44 |
Total Cash | 8,464.2 | 11,181.0 | 12,330.4 | 12,726.3 | 12,161.2 | 12,973.1 | 13,745.5 | 14,563.9 | 15,431.1 | 16,349.8 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 7,260.7 | 6,567.0 | 8,274.1 | 8,226.0 | 8,643.0 | 8,883.8 | 9,412.7 | 9,973.2 | 10,567.0 | 11,196.1 |
Account Receivables, % | 16.61 | 16.73 | 15.96 | 14.29 | 16.52 | 16.02 | 16.02 | 16.02 | 16.02 | 16.02 |
Inventories | 7,416.3 | 6,147.3 | 10,333.0 | 10,507.7 | 9,886.3 | 9,948.2 | 10,540.5 | 11,168.1 | 11,833.0 | 12,537.6 |
Inventories, % | 16.97 | 15.66 | 19.93 | 18.26 | 18.89 | 17.94 | 17.94 | 17.94 | 17.94 | 17.94 |
Accounts Payable | 2,890.2 | 3,094.1 | 4,416.4 | 4,716.0 | 4,724.6 | 4,462.0 | 4,727.6 | 5,009.1 | 5,307.3 | 5,623.3 |
Accounts Payable, % | 6.61 | 7.88 | 8.52 | 8.19 | 9.03 | 8.05 | 8.05 | 8.05 | 8.05 | 8.05 |
Capital Expenditure | -1,879.1 | -2,375.3 | -2,384.3 | -3,681.2 | -4,908.1 | -3,407.2 | -3,610.1 | -3,825.0 | -4,052.7 | -4,294.0 |
Capital Expenditure, % | -4.3 | -6.05 | -4.6 | -6.4 | -9.38 | -6.14 | -6.14 | -6.14 | -6.14 | -6.14 |
Tax Rate, % | 35.56 | 35.56 | 35.56 | 35.56 | 35.56 | 35.56 | 35.56 | 35.56 | 35.56 | 35.56 |
EBITAT | 1,458.9 | 1,358.8 | 4,386.9 | 2,585.5 | 1,494.3 | 2,509.1 | 2,658.4 | 2,816.7 | 2,984.4 | 3,162.1 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -9,856.5 | 3,609.6 | -137.0 | 1,585.8 | -589.8 | 1,384.4 | 1,210.2 | 1,282.3 | 1,358.6 | 1,439.5 |
WACC, % | 3.98 | 4.66 | 4.36 | 4.68 | 4.15 | 4.36 | 4.36 | 4.36 | 4.36 | 4.36 |
PV UFCF | ||||||||||
SUM PV UFCF | 5,873.4 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 1,468 | |||||||||
Terminal Value | 62,091 | |||||||||
Present Terminal Value | 50,149 | |||||||||
Enterprise Value | 56,022 | |||||||||
Net Debt | 13,062 | |||||||||
Equity Value | 42,960 | |||||||||
Diluted Shares Outstanding, MM | 76 | |||||||||
Equity Value Per Share | 566.24 |
What You Will Receive
- Adjustable Forecast Parameters: Easily modify assumptions (growth %, margins, WACC) to generate various scenarios.
- Comprehensive Data: POSCO Holdings Inc.'s financial data pre-loaded to facilitate your analysis.
- Automated DCF Calculations: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Tailored and Professional Design: A sleek Excel model that conforms to your valuation requirements.
- Designed for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.
Key Features
- 🔍 Real-Life POSCO Financials: Pre-filled historical and projected data for POSCO Holdings Inc. (PKX).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate POSCO’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize POSCO’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Download: Obtain the pre-prepared Excel file containing POSCO Holdings Inc.'s (PKX) financial data.
- Customize: Modify projections, including revenue growth, EBITDA %, and WACC.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop various projections and instantly compare their results.
- Make Decisions: Leverage the valuation outcomes to inform your investment strategy.
Why Choose This Calculator for POSCO Holdings Inc. (PKX)?
- User-Friendly Interface: Tailored for both novices and seasoned professionals.
- Customizable Inputs: Adjust variables easily to suit your financial analysis.
- Real-Time Feedback: Observe immediate updates to POSCO’s valuation as you change inputs.
- Pre-Loaded Data: Comes with POSCO’s actual financial figures for swift evaluations.
- Preferred by Experts: Utilized by investors and analysts for strategic decision-making.
Who Should Use This Product?
- Finance Students: Explore advanced valuation methods and apply them to real-world data.
- Academics: Integrate industry-standard models into your teaching or research projects.
- Investors: Validate your investment hypotheses and evaluate the valuation metrics for POSCO Holdings Inc. (PKX).
- Analysts: Enhance your analysis process with a customizable DCF model tailored for your needs.
- Small Business Owners: Understand the analytical approaches used for assessing large corporations like POSCO Holdings Inc. (PKX).
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations tailored for POSCO Holdings Inc. (PKX).
- Real-World Data: POSCO Holdings Inc.’s historical and projected financials preloaded for in-depth analysis.
- Customizable Parameters: Modify 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 metrics.
- Dashboard with Visual Outputs: Engaging charts and tables providing clear, actionable results.