Kronos Worldwide, Inc. (KRO) 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
Kronos Worldwide, Inc. (KRO) Bundle
Streamline your analysis and improve precision with our [KRO] DCF Calculator! Equipped with real data from Kronos Worldwide, Inc. and customizable assumptions, this tool enables you to forecast, analyze, and evaluate [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 | 1,731.1 | 1,638.8 | 1,939.4 | 1,930.2 | 1,666.5 | 1,661.8 | 1,657.1 | 1,652.5 | 1,647.8 | 1,643.2 |
| Revenue Growth, % | 0 | -5.33 | 18.34 | -0.47437 | -13.66 | -0.28134 | -0.28134 | -0.28134 | -0.28134 | -0.28134 |
| EBITDA | 194.7 | 163.6 | 230.9 | 207.0 | -2.7 | 145.2 | 144.8 | 144.4 | 144.0 | 143.6 |
| EBITDA, % | 11.25 | 9.98 | 11.91 | 10.72 | -0.16202 | 8.74 | 8.74 | 8.74 | 8.74 | 8.74 |
| Depreciation | 54.9 | 64.6 | 57.9 | 56.2 | 53.1 | 53.8 | 53.7 | 53.5 | 53.4 | 53.2 |
| Depreciation, % | 3.17 | 3.94 | 2.99 | 2.91 | 3.19 | 3.24 | 3.24 | 3.24 | 3.24 | 3.24 |
| EBIT | 139.8 | 99.0 | 173.0 | 150.8 | -55.8 | 91.4 | 91.1 | 90.9 | 90.6 | 90.4 |
| EBIT, % | 8.08 | 6.04 | 8.92 | 7.81 | -3.35 | 5.5 | 5.5 | 5.5 | 5.5 | 5.5 |
| Total Cash | 390.8 | 355.3 | 406.0 | 327.8 | 194.7 | 311.9 | 311.1 | 310.2 | 309.3 | 308.4 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 309.4 | 323.0 | 379.1 | 255.1 | 312.5 | 296.1 | 295.3 | 294.5 | 293.6 | 292.8 |
| Account Receivables, % | 17.87 | 19.71 | 19.55 | 13.22 | 18.75 | 17.82 | 17.82 | 17.82 | 17.82 | 17.82 |
| Inventories | 503.0 | 519.0 | 432.3 | 608.7 | 564.6 | 493.3 | 491.9 | 490.6 | 489.2 | 487.8 |
| Inventories, % | 29.06 | 31.67 | 22.29 | 31.54 | 33.88 | 29.69 | 29.69 | 29.69 | 29.69 | 29.69 |
| Accounts Payable | 137.2 | 111.0 | 143.6 | 177.2 | 218.7 | 147.6 | 147.2 | 146.8 | 146.3 | 145.9 |
| Accounts Payable, % | 7.93 | 6.77 | 7.4 | 9.18 | 13.12 | 8.88 | 8.88 | 8.88 | 8.88 | 8.88 |
| Capital Expenditure | -55.1 | -62.8 | -58.6 | -63.2 | -47.4 | -53.7 | -53.5 | -53.4 | -53.2 | -53.1 |
| Capital Expenditure, % | -3.18 | -3.83 | -3.02 | -3.27 | -2.84 | -3.23 | -3.23 | -3.23 | -3.23 | -3.23 |
| Tax Rate, % | 32.65 | 32.65 | 32.65 | 32.65 | 32.65 | 32.65 | 32.65 | 32.65 | 32.65 | 32.65 |
| EBITAT | 100.5 | 79.1 | 127.3 | 117.7 | -37.6 | 67.8 | 67.6 | 67.4 | 67.2 | 67.0 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -574.9 | 25.1 | 189.8 | 91.9 | -3.7 | 84.5 | 69.5 | 69.3 | 69.1 | 69.0 |
| WACC, % | 7.87 | 7.98 | 7.89 | 7.95 | 7.81 | 7.9 | 7.9 | 7.9 | 7.9 | 7.9 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 291.4 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 70 | |||||||||
| Terminal Value | 1,192 | |||||||||
| Present Terminal Value | 815 | |||||||||
| Enterprise Value | 1,106 | |||||||||
| Net Debt | 269 | |||||||||
| Equity Value | 838 | |||||||||
| Diluted Shares Outstanding, MM | 115 | |||||||||
| Equity Value Per Share | 7.28 |
What You Will Get
- Real KRO Financial Data: Pre-filled with Kronos Worldwide’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 Kronos Worldwide’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
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Kronos Worldwide, Inc. (KRO).
- WACC Calculator: Pre-designed Weighted Average Cost of Capital sheet with adjustable inputs specific to KRO.
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates to fit KRO's financial outlook.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios pertinent to Kronos Worldwide, Inc. (KRO).
- Visual Dashboard and Charts: Graphical representations summarize essential valuation metrics for straightforward analysis of KRO.
How It Works
- Step 1: Download the prebuilt Excel template containing Kronos Worldwide, Inc. (KRO) data.
- Step 2: Navigate through the pre-filled sheets to familiarize yourself with the essential metrics.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth rates, profit margins).
- Step 4: Instantly see the updated results, including the intrinsic value of Kronos Worldwide, Inc. (KRO).
- Step 5: Use the outputs to make well-informed investment choices or to create detailed reports.
Why Choose Kronos Worldwide, Inc. (KRO)?
- Save Time: Utilize our pre-built models without the hassle of starting from scratch.
- Enhance Accuracy: Access dependable financial metrics and formulas to minimize valuation errors.
- Completely Customizable: Adjust the model to align with your specific assumptions and forecasts.
- Simple to Understand: Intuitive charts and outputs facilitate easy analysis of results.
- Endorsed by Professionals: Crafted for experts who prioritize both accuracy and functionality.
Who Should Use Kronos Worldwide, Inc. (KRO)?
- Investors: Make informed investment choices with comprehensive insights into titanium dioxide markets.
- Financial Analysts: Enhance your analysis with tailored reports on KRO's financial performance and market trends.
- Consultants: Utilize KRO's data for impactful presentations and strategic recommendations for clients.
- Industry Professionals: Gain a deeper understanding of the chemical manufacturing sector through KRO's operational insights.
- Students and Educators: Explore real-world applications of chemical industry concepts in academic settings.
What the Template Contains
- Preloaded KRO Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.