Globe Life Inc. (GL) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
Globe Life Inc. (GL) Bundle
Designed for accuracy, our Globe Life Inc. (GL) DCF Calculator enables you to evaluate Globe Life Inc. valuation using real-world financial data, providing the flexibility to modify all essential parameters for improved 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 | 4,527.5 | 4,737.9 | 5,112.9 | 5,214.9 | 5,447.5 | 5,706.5 | 5,977.8 | 6,262.0 | 6,559.7 | 6,871.6 |
Revenue Growth, % | 0 | 4.65 | 7.91 | 2 | 4.46 | 4.75 | 4.75 | 4.75 | 4.75 | 4.75 |
EBITDA | .0 | .0 | 1,015.9 | .0 | .0 | 226.8 | 237.5 | 248.8 | 260.7 | 273.1 |
EBITDA, % | 0 | 0 | 19.87 | 0 | 0 | 3.97 | 3.97 | 3.97 | 3.97 | 3.97 |
Depreciation | 16.0 | 17.0 | 20.0 | 21.0 | .0 | 17.2 | 18.0 | 18.9 | 19.8 | 20.7 |
Depreciation, % | 0.35339 | 0.35881 | 0.39117 | 0.40269 | 0 | 0.30121 | 0.30121 | 0.30121 | 0.30121 | 0.30121 |
EBIT | -16.0 | -17.0 | 995.9 | -21.0 | .0 | 209.6 | 219.5 | 230.0 | 240.9 | 252.4 |
EBIT, % | -0.35339 | -0.35881 | 19.48 | -0.40269 | 0 | 3.67 | 3.67 | 3.67 | 3.67 | 3.67 |
Total Cash | 19,021.4 | 21,416.1 | 21,466.6 | 16,710.0 | 103.2 | 4,586.8 | 4,804.9 | 5,033.3 | 5,272.6 | 5,523.3 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 441.7 | 474.2 | 487.4 | .0 | 630.2 | 466.4 | 488.6 | 511.8 | 536.1 | 561.6 |
Account Receivables, % | 9.76 | 10.01 | 9.53 | 0 | 11.57 | 8.17 | 8.17 | 8.17 | 8.17 | 8.17 |
Inventories | -887.8 | -998.2 | -999.8 | -18,104.5 | .0 | -1,828.7 | -1,915.7 | -2,006.8 | -2,102.2 | -2,202.1 |
Inventories, % | -19.61 | -21.07 | -19.55 | -347.17 | 0 | -32.05 | -32.05 | -32.05 | -32.05 | -32.05 |
Accounts Payable | .0 | 399.5 | 412.9 | 509.4 | 514.9 | 407.8 | 427.1 | 447.5 | 468.7 | 491.0 |
Accounts Payable, % | 0 | 8.43 | 8.08 | 9.77 | 9.45 | 7.15 | 7.15 | 7.15 | 7.15 | 7.15 |
Capital Expenditure | -42.2 | -41.8 | -38.2 | -27.9 | -49.6 | -45.7 | -47.9 | -50.2 | -52.6 | -55.1 |
Capital Expenditure, % | -0.93214 | -0.88131 | -0.74799 | -0.53556 | -0.90964 | -0.80133 | -0.80133 | -0.80133 | -0.80133 | -0.80133 |
Tax Rate, % | 18.72 | 18.72 | 18.72 | 18.72 | 18.72 | 18.72 | 18.72 | 18.72 | 18.72 | 18.72 |
EBITAT | -13.1 | -13.9 | 813.1 | -20.7 | .0 | 178.1 | 186.6 | 195.4 | 204.7 | 214.5 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 406.9 | 438.7 | 796.7 | 17,660.9 | -18,778.7 | 2,035.0 | 240.8 | 252.3 | 264.3 | 276.8 |
WACC, % | 7.54 | 7.54 | 7.54 | 7.68 | 7.54 | 7.57 | 7.57 | 7.57 | 7.57 | 7.57 |
PV UFCF | ||||||||||
SUM PV UFCF | 2,692.4 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 282 | |||||||||
Terminal Value | 5,073 | |||||||||
Present Terminal Value | 3,523 | |||||||||
Enterprise Value | 6,215 | |||||||||
Net Debt | 2,013 | |||||||||
Equity Value | 4,203 | |||||||||
Diluted Shares Outstanding, MM | 96 | |||||||||
Equity Value Per Share | 43.61 |
What You Will Receive
- Pre-Filled Financial Model: Globe Life Inc.'s (GL) actual data allows for accurate DCF valuation.
- Comprehensive Forecast Control: Modify revenue growth, margins, WACC, and other essential factors.
- Instantaneous Calculations: Automatic updates provide real-time results as you make adjustments.
- Investor-Ready Template: A polished Excel file crafted for high-quality valuation.
- Customizable and Reusable: Designed for adaptability, enabling repeated use for in-depth forecasts.
Key Features
- Comprehensive DCF Calculator: Features both unlevered and levered DCF valuation models tailored for Globe Life Inc. (GL).
- WACC Calculator: Ready-to-use Weighted Average Cost of Capital sheet with adjustable parameters.
- Customizable Forecast Assumptions: Adjust growth projections, capital expenditures, and discount rates as needed.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specific to Globe Life Inc. (GL).
- Interactive Dashboard and Charts: Visual representations that highlight essential valuation metrics for straightforward analysis.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review Globe Life Inc.’s pre-filled financial data and forecasts.
- Step 3: Modify critical inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Watch the DCF model update instantly as you adjust your assumptions.
- Step 5: Analyze the outputs and utilize the results for your investment decisions.
Why Choose Globe Life Inc. (GL) Calculator?
- Accuracy: Utilizes real Globe Life financial data for precise calculations.
- Flexibility: Allows users to easily adjust and test various inputs.
- Time-Saving: Eliminate the need to create a financial model from the ground up.
- Professional-Grade: Crafted with the expertise and precision expected at the CFO level.
- User-Friendly: Intuitive design makes it accessible for users without extensive financial modeling skills.
Who Should Use Globe Life Inc. (GL)?
- Insurance Students: Understand underwriting principles and apply them using real-world data.
- Academics: Integrate industry models into your curriculum or scholarly research.
- Investors: Evaluate your investment strategies and analyze the financial performance of Globe Life Inc. (GL).
- Financial Analysts: Enhance your analysis with a customizable financial model tailored to insurance companies.
- Small Business Owners: Learn how large insurance firms like Globe Life Inc. (GL) manage risk and profitability.
What the Template Contains
- Historical Data: Includes Globe Life Inc.’s past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Globe Life Inc.’s 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 Globe Life Inc.’s financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.