Kohl's Corporation (KSS) 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
Kohl's Corporation (KSS) Bundle
Engineered for accuracy, our Kohl's Corporation (KSS) DCF Calculator enables you to assess the valuation of Kohl's with up-to-date financial data and complete flexibility to modify all key parameters for enhanced projections.
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,974.0 | 15,955.0 | 19,433.0 | 18,098.0 | 17,476.0 | 17,099.0 | 16,730.1 | 16,369.2 | 16,016.1 | 15,670.6 |
| Revenue Growth, % | 0 | -20.12 | 21.8 | -6.87 | -3.44 | -2.16 | -2.16 | -2.16 | -2.16 | -2.16 |
| EBITDA | 2,025.0 | 612.0 | 2,317.0 | 1,054.0 | 1,466.0 | 1,371.7 | 1,342.1 | 1,313.1 | 1,284.8 | 1,257.1 |
| EBITDA, % | 10.14 | 3.84 | 11.92 | 5.82 | 8.39 | 8.02 | 8.02 | 8.02 | 8.02 | 8.02 |
| Depreciation | 917.0 | 874.0 | 838.0 | 808.0 | 749.0 | 791.1 | 774.0 | 757.3 | 741.0 | 725.0 |
| Depreciation, % | 4.59 | 5.48 | 4.31 | 4.46 | 4.29 | 4.63 | 4.63 | 4.63 | 4.63 | 4.63 |
| EBIT | 1,108.0 | -262.0 | 1,479.0 | 246.0 | 717.0 | 580.6 | 568.1 | 555.8 | 543.8 | 532.1 |
| EBIT, % | 5.55 | -1.64 | 7.61 | 1.36 | 4.1 | 3.4 | 3.4 | 3.4 | 3.4 | 3.4 |
| Total Cash | 723.0 | 2,271.0 | 1,587.0 | 153.0 | 183.0 | 954.6 | 934.0 | 913.8 | 894.1 | 874.8 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 15.0 | 789.0 | 190.0 | 210.0 | 167.0 | 277.5 | 271.5 | 265.6 | 259.9 | 254.3 |
| Account Receivables, % | 0.07509763 | 4.95 | 0.97772 | 1.16 | 0.9556 | 1.62 | 1.62 | 1.62 | 1.62 | 1.62 |
| Inventories | 3,537.0 | 2,590.0 | 3,067.0 | 3,189.0 | 2,880.0 | 2,866.6 | 2,804.8 | 2,744.3 | 2,685.1 | 2,627.1 |
| Inventories, % | 17.71 | 16.23 | 15.78 | 17.62 | 16.48 | 16.76 | 16.76 | 16.76 | 16.76 | 16.76 |
| Accounts Payable | 1,206.0 | 1,476.0 | 1,683.0 | 1,330.0 | 1,134.0 | 1,292.2 | 1,264.4 | 1,237.1 | 1,210.4 | 1,184.3 |
| Accounts Payable, % | 6.04 | 9.25 | 8.66 | 7.35 | 6.49 | 7.56 | 7.56 | 7.56 | 7.56 | 7.56 |
| Capital Expenditure | -855.0 | -334.0 | -605.0 | -826.0 | -577.0 | -593.4 | -580.6 | -568.1 | -555.9 | -543.9 |
| Capital Expenditure, % | -4.28 | -2.09 | -3.11 | -4.56 | -3.3 | -3.47 | -3.47 | -3.47 | -3.47 | -3.47 |
| Tax Rate, % | 15.01 | 15.01 | 15.01 | 15.01 | 15.01 | 15.01 | 15.01 | 15.01 | 15.01 | 15.01 |
| EBITAT | 849.8 | -78.2 | 1,138.1 | 80.6 | 609.4 | 349.8 | 342.3 | 334.9 | 327.7 | 320.6 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -1,434.2 | 904.8 | 1,700.1 | -432.4 | 937.4 | 608.6 | 575.6 | 563.1 | 551.0 | 539.1 |
| WACC, % | 5.39 | 3.59 | 5.39 | 3.7 | 5.7 | 4.75 | 4.75 | 4.75 | 4.75 | 4.75 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 2,480.3 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 550 | |||||||||
| Terminal Value | 19,964 | |||||||||
| Present Terminal Value | 15,826 | |||||||||
| Enterprise Value | 18,307 | |||||||||
| Net Debt | 7,193 | |||||||||
| Equity Value | 11,114 | |||||||||
| Diluted Shares Outstanding, MM | 111 | |||||||||
| Equity Value Per Share | 100.12 |
What You Will Get
- Real Kohl's Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Kohl's Corporation (KSS).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates to fit your analysis.
- Instant Valuation Updates: Automatic recalculations to assess the impact of changes on Kohl's fair value.
- Versatile Excel Template: Designed for quick edits, scenario testing, and comprehensive projections relevant to Kohl's Corporation (KSS).
- Time-Saving and Accurate: Eliminate the need to build models from scratch while ensuring precision and flexibility in your financial analysis.
Key Features
- Comprehensive DCF Model: Features both unlevered and levered DCF valuation frameworks tailored for Kohl's Corporation (KSS).
- WACC Analysis Tool: Pre-configured Weighted Average Cost of Capital sheet with adjustable parameters.
- Customizable Forecast Inputs: Easily alter growth projections, capital investments, and discount rates.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specific to Kohl's Corporation (KSS).
- Interactive Dashboard and Visuals: Graphical representations highlight essential valuation metrics for streamlined analysis.
How It Works
- Download: Access the ready-to-use Excel file with Kohl's Corporation's (KSS) financial data.
- Customize: Adjust forecasts, including revenue growth, EBITDA %, and WACC.
- Update Automatically: The intrinsic value and NPV calculations update in real-time.
- Test Scenarios: Create multiple projections and compare outcomes instantly.
- Make Decisions: Use the valuation results to guide your investment strategy.
Why Choose This Calculator for Kohl's Corporation (KSS)?
- Designed for Experts: A sophisticated tool utilized by financial analysts, CFOs, and industry consultants.
- Accurate Financial Data: Kohl's historical and projected financials are preloaded for precise calculations.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly Interface: Step-by-step guidance ensures a smooth calculation experience.
Who Should Use This Product?
- Retail Investors: Gain insights into Kohl's Corporation (KSS) and make informed investment choices.
- Market Analysts: Utilize comprehensive data to streamline your analysis of Kohl's Corporation (KSS).
- Consultants: Easily modify reports and presentations tailored to Kohl's Corporation (KSS) for your clients.
- Retail Industry Enthusiasts: Enhance your knowledge of retail market dynamics through Kohl's Corporation (KSS) case studies.
- Students and Educators: Incorporate real-world examples from Kohl's Corporation (KSS) into finance and business curricula.
What the Template Contains
- Historical Data: Includes Kohl's Corporation’s (KSS) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Kohl's Corporation’s (KSS) intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of Kohl's Corporation’s (KSS) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.