Kemper Corporation (KMPR) 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
Kemper Corporation (KMPR) Bundle
Designed for accuracy, our KMPR (Kemper Corporation) DCF Calculator enables you to evaluate Kemper Corporation's valuation using actual financial data and provides 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 | 5,039.2 | 5,200.8 | 5,793.0 | 5,576.8 | 4,914.7 | 4,902.3 | 4,889.9 | 4,877.5 | 4,865.2 | 4,852.9 |
Revenue Growth, % | 0 | 3.21 | 11.39 | -3.73 | -11.87 | -0.25273 | -0.25273 | -0.25273 | -0.25273 | -0.25273 |
EBITDA | 766.6 | 601.1 | -105.7 | -245.4 | -232.4 | 155.1 | 154.7 | 154.3 | 153.9 | 153.5 |
EBITDA, % | 15.21 | 11.56 | -1.82 | -4.4 | -4.73 | 3.16 | 3.16 | 3.16 | 3.16 | 3.16 |
Depreciation | 62.5 | 55.0 | 100.0 | 70.9 | 58.6 | 63.6 | 63.4 | 63.3 | 63.1 | 63.0 |
Depreciation, % | 1.24 | 1.06 | 1.73 | 1.27 | 1.19 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 |
EBIT | 704.1 | 546.1 | -205.7 | -316.3 | -291.0 | 91.5 | 91.2 | 91.0 | 90.8 | 90.5 |
EBIT, % | 13.97 | 10.5 | -3.55 | -5.67 | -5.92 | 1.87 | 1.87 | 1.87 | 1.87 | 1.87 |
Total Cash | 7,529.8 | 8,687.4 | 8,419.2 | 7,385.6 | 587.0 | 4,038.9 | 4,028.7 | 4,018.5 | 4,008.4 | 3,998.3 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Inventories | -2,074.3 | -2,615.3 | -2,342.8 | -10,618.0 | .0 | -2,273.6 | -2,267.8 | -2,262.1 | -2,256.4 | -2,250.7 |
Inventories, % | -41.16 | -50.29 | -40.44 | -190.4 | 0 | -46.38 | -46.38 | -46.38 | -46.38 | -46.38 |
Accounts Payable | .0 | .0 | .0 | -449.3 | .0 | -79.0 | -78.8 | -78.6 | -78.4 | -78.2 |
Accounts Payable, % | 0 | 0 | 0 | -8.06 | 0 | -1.61 | -1.61 | -1.61 | -1.61 | -1.61 |
Capital Expenditure | -83.9 | -53.4 | -57.8 | -30.8 | -53.8 | -52.3 | -52.2 | -52.1 | -51.9 | -51.8 |
Capital Expenditure, % | -1.66 | -1.03 | -0.99776 | -0.55229 | -1.09 | -1.07 | -1.07 | -1.07 | -1.07 | -1.07 |
Tax Rate, % | 21.61 | 21.61 | 21.61 | 21.61 | 21.61 | 21.61 | 21.61 | 21.61 | 21.61 | 21.61 |
EBITAT | 565.2 | 438.8 | -101.0 | -244.6 | -228.1 | 66.9 | 66.7 | 66.5 | 66.4 | 66.2 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 2,618.1 | 981.4 | -331.3 | 7,621.4 | -10,392.0 | 2,272.8 | 72.4 | 72.2 | 72.0 | 71.9 |
WACC, % | 7.22 | 7.22 | 6.87 | 7.18 | 7.2 | 7.14 | 7.14 | 7.14 | 7.14 | 7.14 |
PV UFCF | ||||||||||
SUM PV UFCF | 2,348.8 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 73 | |||||||||
Terminal Value | 1,427 | |||||||||
Present Terminal Value | 1,011 | |||||||||
Enterprise Value | 3,360 | |||||||||
Net Debt | 1,325 | |||||||||
Equity Value | 2,035 | |||||||||
Diluted Shares Outstanding, MM | 64 | |||||||||
Equity Value Per Share | 31.78 |
What You Will Get
- Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to generate various scenarios.
- Real-World Data: Kemper Corporation’s financial data pre-filled to kickstart your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value for you.
- Customizable and Professional: A sleek Excel model that adjusts to your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and saving time.
Key Features
- Comprehensive DCF Calculator: Offers in-depth unlevered and levered DCF valuation models tailored for Kemper Corporation (KMPR).
- WACC Estimator: Features a pre-configured Weighted Average Cost of Capital sheet with adjustable inputs.
- Customizable Forecast Parameters: Easily alter growth projections, capital expenditures, and discount rates.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specific to Kemper Corporation (KMPR).
- Interactive Dashboard and Visuals: Graphical representations summarize essential valuation metrics for straightforward analysis.
How It Works
- Step 1: Download the prebuilt Excel template featuring Kemper Corporation’s (KMPR) 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, margins).
- Step 4: Instantly see the recalculated results, including Kemper Corporation’s (KMPR) intrinsic value.
- Step 5: Make well-informed investment choices or create reports based on the outputs.
Why Choose Kemper Corporation's Calculator?
- All-in-One Solution: Features DCF, WACC, and financial ratio analyses tailored for Kemper Corporation (KMPR).
- Flexible Inputs: Modify the highlighted fields to explore different financial scenarios.
- In-Depth Analysis: Automatically computes Kemper's intrinsic value and Net Present Value.
- Preloaded Information: Utilizes historical and projected data for precise calculations.
- Expert-Level Tool: Perfect for financial analysts, investors, and business advisors focused on Kemper Corporation (KMPR).
Who Should Use This Product?
- Professional Investors: Develop comprehensive and dependable valuation models for analyzing portfolios involving Kemper Corporation (KMPR).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
- Consultants and Advisors: Deliver precise valuation insights to clients considering investments in Kemper Corporation (KMPR).
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
- Insurance Analysts: Gain insights into how insurance companies like Kemper Corporation (KMPR) are valued in the financial landscape.
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations specific to Kemper Corporation (KMPR).
- Real-World Data: Kemper’s historical and projected financials preloaded for thorough analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Charts and tables designed for clear, actionable results.