Safety Insurance Group, Inc. (SAFT) 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
Safety Insurance Group, Inc. (SAFT) Bundle
Whether you're an investor or an analyst, this (SAFT) DCF Calculator is your go-to resource for accurate valuation. Equipped with real data from Safety Insurance Group, Inc., you can adjust forecasts and observe the effects in real-time.
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 | 875.8 | 840.4 | 864.7 | 785.1 | 931.0 | 950.1 | 969.6 | 989.6 | 1,009.9 | 1,030.6 |
Revenue Growth, % | 0 | -4.04 | 2.89 | -9.21 | 18.58 | 2.06 | 2.06 | 2.06 | 2.06 | 2.06 |
EBITDA | 129.3 | 182.7 | 171.7 | .0 | 28.4 | 112.9 | 115.2 | 117.6 | 120.0 | 122.4 |
EBITDA, % | 14.76 | 21.74 | 19.85 | 0 | 3.05 | 11.88 | 11.88 | 11.88 | 11.88 | 11.88 |
Depreciation | 5.5 | 7.5 | 6.9 | 7.9 | 8.7 | 8.1 | 8.2 | 8.4 | 8.6 | 8.8 |
Depreciation, % | 0.62627 | 0.89564 | 0.79748 | 1 | 0.9298 | 0.85049 | 0.85049 | 0.85049 | 0.85049 | 0.85049 |
EBIT | 123.8 | 175.2 | 164.8 | -7.9 | 19.7 | 104.8 | 106.9 | 109.1 | 111.4 | 113.7 |
EBIT, % | 14.13 | 20.85 | 19.06 | -1 | 2.12 | 11.03 | 11.03 | 11.03 | 11.03 | 11.03 |
Total Cash | 1,272.4 | 1,310.9 | 1,281.9 | 1,075.5 | 38.2 | 767.9 | 783.6 | 799.8 | 816.2 | 833.0 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 329.8 | 300.5 | 290.6 | 299.8 | .0 | 275.9 | 281.6 | 287.4 | 293.3 | 299.3 |
Account Receivables, % | 37.66 | 35.75 | 33.61 | 38.19 | 0 | 29.04 | 29.04 | 29.04 | 29.04 | 29.04 |
Inventories | -296.1 | -351.6 | -298.6 | 14.2 | .0 | -205.9 | -210.2 | -214.5 | -218.9 | -223.4 |
Inventories, % | -33.81 | -41.83 | -34.53 | 1.8 | 0 | -21.67 | -21.67 | -21.67 | -21.67 | -21.67 |
Accounts Payable | 87.9 | 87.7 | 85.8 | 85.3 | 80.2 | 94.8 | 96.7 | 98.7 | 100.7 | 102.8 |
Accounts Payable, % | 10.04 | 10.44 | 9.92 | 10.87 | 8.61 | 9.98 | 9.98 | 9.98 | 9.98 | 9.98 |
Capital Expenditure | -9.6 | -9.9 | -8.2 | -2.1 | -1.8 | -7.0 | -7.2 | -7.3 | -7.4 | -7.6 |
Capital Expenditure, % | -1.1 | -1.18 | -0.95118 | -0.26648 | -0.19152 | -0.73762 | -0.73762 | -0.73762 | -0.73762 | -0.73762 |
Tax Rate, % | 22.71 | 22.71 | 22.71 | 22.71 | 22.71 | 22.71 | 22.71 | 22.71 | 22.71 | 22.71 |
EBITAT | 99.7 | 138.6 | 131.1 | -6.2 | 15.2 | 82.7 | 84.4 | 86.1 | 87.9 | 89.7 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 149.8 | 220.8 | 84.7 | -322.7 | 330.9 | 28.4 | 86.0 | 87.8 | 89.6 | 91.4 |
WACC, % | 5.32 | 5.32 | 5.32 | 5.32 | 5.32 | 5.32 | 5.32 | 5.32 | 5.32 | 5.32 |
PV UFCF | ||||||||||
SUM PV UFCF | 323.0 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 93 | |||||||||
Terminal Value | 2,809 | |||||||||
Present Terminal Value | 2,168 | |||||||||
Enterprise Value | 2,491 | |||||||||
Net Debt | 12 | |||||||||
Equity Value | 2,479 | |||||||||
Diluted Shares Outstanding, MM | 15 | |||||||||
Equity Value Per Share | 168.55 |
What You Will Get
- Pre-Filled Financial Model: Safety Insurance Group’s actual data provides an accurate DCF valuation.
- Full Forecast Control: Modify revenue growth, profit margins, WACC, and other essential metrics.
- Instant Calculations: Real-time updates allow you to see results immediately as adjustments are made.
- Investor-Ready Template: A polished Excel file crafted for professional-level valuation.
- Customizable and Reusable: Designed for adaptability, enabling repeated use for comprehensive forecasts.
Key Features
- Comprehensive Risk Assessment: Access detailed pre-loaded historical data and future risk projections specific to Safety Insurance Group, Inc. (SAFT).
- Tailored Coverage Options: Modify highlighted fields to adjust policy parameters and coverage limits.
- Real-Time Data Analysis: Instant updates to risk metrics, premium calculations, and loss projections.
- User-Friendly Interface: Intuitive charts and summaries designed to help you understand your insurance portfolio.
- Suitable for All Users: A straightforward design catering to both seasoned professionals and those new to insurance.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review Safety Insurance Group, Inc.'s (SAFT) pre-filled financial data and forecasts.
- Step 3: Modify critical inputs like revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Watch the DCF model update instantly as you tweak assumptions.
- Step 5: Analyze the outputs and use the results for investment decisions.
Why Choose Safety Insurance Group, Inc. (SAFT)?
- Reliability: Trustworthy data sourced from actual Safety Insurance financials.
- Adaptability: Built for users to easily adjust and experiment with inputs.
- Efficiency: Eliminate the need to create a financial model from the ground up.
- Expert-Level: Crafted with the precision and usability expected by industry professionals.
- Intuitive: User-friendly interface suitable for individuals with varying levels of financial expertise.
Who Should Use This Product?
- Insurance Professionals: Develop comprehensive risk assessment models for client portfolios.
- Corporate Risk Management Teams: Evaluate insurance scenarios to inform business decisions.
- Consultants and Advisors: Offer clients precise insights into the valuation of Safety Insurance Group, Inc. (SAFT).
- Students and Educators: Utilize real-world data to learn and teach about the insurance industry.
- Financial Analysts: Gain an understanding of how insurance companies like Safety Insurance Group, Inc. (SAFT) are valued in the market.
What the Template Contains
- Preloaded SAFT Data: Historical and projected financial data, including premiums earned, loss ratios, and operating expenses.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting premium growth, claims ratios, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, underwriting, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.