Greenlight Capital Re, Ltd. (GLRE) 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
Greenlight Capital Re, Ltd. (GLRE) Bundle
Looking to assess the intrinsic value of Greenlight Capital Re, Ltd.? Our (GLRE) DCF Calculator integrates real-world data with extensive customization options, allowing you to refine forecasts and enhance your investment choices.
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 | 492.1 | 479.7 | 571.3 | 414.6 | 624.3 | 686.3 | 754.4 | 829.3 | 911.7 | 1,002.2 |
Revenue Growth, % | 0 | -2.53 | 19.11 | -27.43 | 50.56 | 9.93 | 9.93 | 9.93 | 9.93 | 9.93 |
EBITDA | -41.6 | 5.3 | 39.3 | .0 | .0 | -.7 | -.7 | -.8 | -.9 | -1.0 |
EBITDA, % | -8.46 | 1.11 | 6.87 | 0 | 0 | -0.0966615 | -0.0966615 | -0.0966615 | -0.0966615 | -0.0966615 |
Depreciation | .0 | .0 | .0 | .1 | .0 | .0 | .0 | .1 | .1 | .1 |
Depreciation, % | 0.00426745 | 0.00437809 | 0.00280041 | 0.01905299 | 0 | 0.00609979 | 0.00609979 | 0.00609979 | 0.00609979 | 0.00609979 |
EBIT | -41.7 | 5.3 | 39.2 | -.1 | .0 | -.7 | -.8 | -.9 | -.9 | -1.0 |
EBIT, % | -8.47 | 1.1 | 6.87 | -0.01905299 | 0 | -0.10276 | -0.10276 | -0.10276 | -0.10276 | -0.10276 |
Total Cash | 25.8 | 8.9 | 76.3 | 38.2 | 51.1 | 52.0 | 57.1 | 62.8 | 69.0 | 75.9 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 278.1 | 353.2 | .0 | .0 | 645.1 | 315.9 | 347.3 | 381.7 | 419.6 | 461.3 |
Account Receivables, % | 56.52 | 73.63 | 0 | 0 | 103.33 | 46.03 | 46.03 | 46.03 | 46.03 | 46.03 |
Inventories | -1,018.5 | -1,090.6 | -1,116.5 | -1,047.1 | .0 | -549.0 | -603.5 | -663.5 | -729.3 | -801.8 |
Inventories, % | -206.97 | -227.38 | -195.41 | -252.55 | 0 | -80 | -80 | -80 | -80 | -80 |
Accounts Payable | 122.7 | 92.2 | 91.2 | 105.1 | 69.0 | 132.5 | 145.6 | 160.1 | 176.0 | 193.5 |
Accounts Payable, % | 24.93 | 19.23 | 15.97 | 25.36 | 11.05 | 19.31 | 19.31 | 19.31 | 19.31 | 19.31 |
Capital Expenditure | .0 | .0 | -1.2 | -107.3 | .0 | -35.8 | -39.4 | -43.3 | -47.6 | -52.3 |
Capital Expenditure, % | 0 | 0 | -0.21546 | -25.87 | 0 | -5.22 | -5.22 | -5.22 | -5.22 | -5.22 |
Tax Rate, % | 0.11504 | 0.11504 | 0.11504 | 0.11504 | 0.11504 | 0.11504 | 0.11504 | 0.11504 | 0.11504 | 0.11504 |
EBITAT | -47.4 | 4.8 | 32.3 | -.1 | .0 | -.7 | -.7 | -.8 | -.9 | -1.0 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 815.6 | -28.5 | 409.1 | -162.7 | -1,728.4 | 905.3 | -3.7 | -4.1 | -4.5 | -5.0 |
WACC, % | 8.81 | 8.67 | 8.55 | 8.81 | 8.81 | 8.73 | 8.73 | 8.73 | 8.73 | 8.73 |
PV UFCF | ||||||||||
SUM PV UFCF | 819.8 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -5 | |||||||||
Terminal Value | -75 | |||||||||
Present Terminal Value | -49 | |||||||||
Enterprise Value | 770 | |||||||||
Net Debt | -581 | |||||||||
Equity Value | 1,351 | |||||||||
Diluted Shares Outstanding, MM | 35 | |||||||||
Equity Value Per Share | 38.83 |
What You Will Get
- Editable Forecast Inputs: Easily adjust key assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: Greenlight Capital Re, Ltd. (GLRE) financial data pre-loaded to facilitate your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Customizable and Professional: A sleek Excel model that can be tailored to your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.
Key Features
- Customizable Investment Metrics: Adjust essential factors such as underwriting performance, combined ratio, and asset allocation.
- Instant Risk Assessment: Provides real-time analysis of risk exposure and potential returns.
- Industry-Leading Precision: Leverages Greenlight Capital Re’s actual financial data for accurate investment evaluations.
- Effortless Scenario Planning: Experiment with various market conditions and assess their impact effortlessly.
- Efficiency Booster: Streamline the investment analysis process without the hassle of creating detailed models from the ground up.
How It Works
- Download the Template: Gain immediate access to the Excel-based GLRE DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other inputs.
- Instant Calculations: The model automatically recalculates Greenlight Capital Re's intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the outcomes to inform your investment or financial analysis.
Why Choose This Calculator for Greenlight Capital Re, Ltd. (GLRE)?
- User-Friendly Interface: Perfect for both novice users and seasoned investors.
- Customizable Inputs: Adjust parameters easily to suit your investment analysis.
- Real-Time Feedback: Observe immediate changes in Greenlight Capital's valuation as you modify inputs.
- Preloaded Data: Comes with Greenlight Capital's historical financial information for rapid evaluation.
- Relied Upon by Experts: Utilized by financial professionals to guide strategic investment decisions.
Who Should Use This Product?
- Individual Investors: Gain insights for making informed decisions about investing in Greenlight Capital Re, Ltd. (GLRE).
- Financial Analysts: Enhance your analysis with comprehensive financial models tailored for GLRE.
- Consultants: Provide clients with expert valuation assessments of Greenlight Capital Re, Ltd. (GLRE) efficiently.
- Business Owners: Learn about the valuation of reinsurance companies like GLRE to inform your own business strategies.
- Finance Students: Explore real-world valuation methods using data from Greenlight Capital Re, Ltd. (GLRE).
What the Template Contains
- Pre-Filled DCF Model: Greenlight Capital Re’s (GLRE) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Greenlight Capital Re’s profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.