SiriusPoint Ltd. (SPNT) 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
SiriusPoint Ltd. (SPNT) Bundle
Whether you’re an investor or analyst, this (SPNT) DCF Calculator is your go-to resource for accurate valuation. Filled with real data from SiriusPoint Ltd., 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 | 979.1 | 884.6 | 2,224.7 | 66.0 | 2,737.3 | 3,375.9 | 4,163.4 | 5,134.7 | 6,332.6 | 7,809.9 |
| Revenue Growth, % | 0 | -9.65 | 151.5 | -97.03 | 4047.42 | 23.33 | 23.33 | 23.33 | 23.33 | 23.33 |
| EBITDA | .0 | .0 | 4,638.2 | -370.2 | 393.9 | 97.2 | 119.8 | 147.8 | 182.3 | 224.8 |
| EBITDA, % | 0 | 0 | 208.49 | -560.91 | 14.39 | 2.88 | 2.88 | 2.88 | 2.88 | 2.88 |
| Depreciation | -213.1 | -165.3 | 12.0 | 13.9 | 11.1 | -124.6 | -153.6 | -189.4 | -233.6 | -288.1 |
| Depreciation, % | -21.77 | -18.69 | 0.5394 | 21.06 | 0.40551 | -3.69 | -3.69 | -3.69 | -3.69 | -3.69 |
| EBIT | 213.1 | 165.3 | 4,626.2 | -384.1 | 382.8 | 367.5 | 453.3 | 559.0 | 689.5 | 850.3 |
| EBIT, % | 21.77 | 18.69 | 207.95 | -581.97 | 13.98 | 10.89 | 10.89 | 10.89 | 10.89 | 10.89 |
| Total Cash | 639.4 | 526.0 | 2,075.6 | 4,325.4 | 969.2 | 2,386.6 | 2,943.3 | 3,630.0 | 4,476.8 | 5,521.2 |
| 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 | -1,656.1 | -2,352.9 | -5,006.6 | -6,336.1 | .0 | -2,700.7 | -3,330.7 | -4,107.8 | -5,066.1 | -6,247.9 |
| Inventories, % | -169.15 | -265.99 | -225.05 | -9600.15 | 0 | -80 | -80 | -80 | -80 | -80 |
| Accounts Payable | 99.8 | 95.7 | 924.6 | 1,080.2 | 2,021.0 | 1,596.1 | 1,968.5 | 2,427.7 | 2,994.0 | 3,692.5 |
| Accounts Payable, % | 10.19 | 10.82 | 41.56 | 1636.67 | 73.83 | 47.28 | 47.28 | 47.28 | 47.28 | 47.28 |
| Capital Expenditure | .0 | .0 | .0 | -.8 | .0 | -8.2 | -10.1 | -12.4 | -15.4 | -18.9 |
| Capital Expenditure, % | 0 | 0 | 0 | -1.21 | 0 | -0.24242 | -0.24242 | -0.24242 | -0.24242 | -0.24242 |
| Tax Rate, % | -11.33 | -11.33 | -11.33 | -11.33 | -11.33 | -11.33 | -11.33 | -11.33 | -11.33 | -11.33 |
| EBITAT | 212.3 | 156.4 | 5,959.7 | -350.8 | 426.2 | 357.0 | 440.2 | 542.9 | 669.6 | 825.8 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 1,755.1 | 683.8 | 9,454.3 | 1,147.4 | -4,958.0 | 2,500.0 | 1,278.9 | 1,577.3 | 1,945.2 | 2,399.0 |
| WACC, % | 8.72 | 8.62 | 8.73 | 8.55 | 8.73 | 8.67 | 8.67 | 8.67 | 8.67 | 8.67 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 7,590.5 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 2,447 | |||||||||
| Terminal Value | 36,687 | |||||||||
| Present Terminal Value | 24,208 | |||||||||
| Enterprise Value | 31,799 | |||||||||
| Net Debt | -183 | |||||||||
| Equity Value | 31,982 | |||||||||
| Diluted Shares Outstanding, MM | 170 | |||||||||
| Equity Value Per Share | 188.56 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real SPNT financials.
- Real-World Data: Historical data and forward-looking estimates (as highlighted in the yellow cells).
- Forecast Flexibility: Modify forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe the effects of your inputs on SiriusPoint’s valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and convenience, complete with step-by-step instructions.
Key Features
- Comprehensive SiriusPoint Financials: Gain access to precise pre-loaded historical data and future forecasts.
- Adjustable Forecast Parameters: Modify highlighted cells to personalize WACC, growth rates, and margins.
- Real-Time Calculations: Automatic updates for DCF, Net Present Value (NPV), and cash flow analysis.
- User-Friendly Dashboard: Clear charts and summaries for easy visualization of your valuation results.
- Designed for All Levels: An intuitive layout tailored for investors, CFOs, and consultants alike.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review SiriusPoint Ltd.'s (SPNT) pre-filled financial data and forecasts.
- Step 3: Modify key inputs such as premium growth, loss ratios, and expense ratios (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you adjust your assumptions.
- Step 5: Evaluate the outputs and leverage the results for your investment strategies.
Why Choose SiriusPoint Ltd. (SPNT)?
- Time Efficiency: Skip the hassle of building financial models from the ground up – our solutions are ready to go.
- Enhanced Accuracy: Dependable financial information and calculations minimize valuation errors.
- Completely Customizable: Adjust the model to align with your specific assumptions and forecasts.
- User-Friendly: Intuitive charts and outputs facilitate straightforward analysis of results.
- Preferred by Professionals: Crafted for industry experts who prioritize accuracy and functionality.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for analyzing SiriusPoint Ltd. (SPNT).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within their organization.
- Consultants and Advisors: Deliver precise valuation insights to clients interested in SiriusPoint Ltd. (SPNT).
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
- Insurance Industry Professionals: Gain insights into the valuation of insurance and reinsurance companies like SiriusPoint Ltd. (SPNT).
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled SiriusPoint Ltd. (SPNT) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for SiriusPoint Ltd. (SPNT).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.