Primerica, Inc. (PRI) 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
Primerica, Inc. (PRI) Bundle
Enhance your investment choices with the Primerica, Inc. (PRI) DCF Calculator! Utilize real Primerica financials, adjust growth projections and expenses, and observe how these modifications affect the intrinsic value of Primerica instantly.
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 | 2,052.5 | 2,217.5 | 2,709.7 | 2,720.1 | 2,815.7 | 3,056.0 | 3,316.7 | 3,599.8 | 3,906.9 | 4,240.3 |
Revenue Growth, % | 0 | 8.04 | 22.2 | 0.38384 | 3.51 | 8.53 | 8.53 | 8.53 | 8.53 | 8.53 |
EBITDA | 524.2 | 553.3 | 704.0 | 681.4 | 2,596.4 | 1,184.1 | 1,285.1 | 1,394.8 | 1,513.8 | 1,643.0 |
EBITDA, % | 25.54 | 24.95 | 25.98 | 25.05 | 92.21 | 38.75 | 38.75 | 38.75 | 38.75 | 38.75 |
Depreciation | 18.3 | 17.7 | 29.8 | 34.2 | 32.0 | 31.7 | 34.4 | 37.3 | 40.5 | 43.9 |
Depreciation, % | 0.89159 | 0.79805 | 1.1 | 1.26 | 1.14 | 1.04 | 1.04 | 1.04 | 1.04 | 1.04 |
EBIT | 505.9 | 535.6 | 674.1 | 647.2 | 2,564.4 | 1,152.4 | 1,250.7 | 1,357.5 | 1,473.3 | 1,599.0 |
EBIT, % | 24.65 | 24.15 | 24.88 | 23.79 | 91.08 | 37.71 | 37.71 | 37.71 | 37.71 | 37.71 |
Total Cash | 2,613.9 | 3,012.2 | 3,180.3 | 3,054.1 | 1,617.1 | 2,795.8 | 3,034.4 | 3,293.3 | 3,574.3 | 3,879.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 | -709.8 | -1,009.6 | -1,235.6 | -5,838.6 | .0 | -1,379.5 | -1,497.2 | -1,625.0 | -1,763.7 | -1,914.2 |
Inventories, % | -34.58 | -45.53 | -45.6 | -214.65 | 0 | -45.14 | -45.14 | -45.14 | -45.14 | -45.14 |
Accounts Payable | 340.0 | 519.7 | 585.4 | 538.3 | .0 | 497.4 | 539.9 | 586.0 | 636.0 | 690.2 |
Accounts Payable, % | 16.56 | 23.44 | 21.6 | 19.79 | 0 | 16.28 | 16.28 | 16.28 | 16.28 | 16.28 |
Capital Expenditure | -25.4 | -27.6 | -24.7 | -25.8 | -33.9 | -33.9 | -36.8 | -39.9 | -43.4 | -47.1 |
Capital Expenditure, % | -1.24 | -1.25 | -0.91109 | -0.94867 | -1.2 | -1.11 | -1.11 | -1.11 | -1.11 | -1.11 |
Tax Rate, % | 23.29 | 23.29 | 23.29 | 23.29 | 23.29 | 23.29 | 23.29 | 23.29 | 23.29 | 23.29 |
EBITAT | 388.5 | 408.1 | 492.4 | 489.0 | 1,967.1 | 871.9 | 946.3 | 1,027.0 | 1,114.7 | 1,209.8 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 1,431.2 | 877.8 | 789.2 | 5,053.3 | -4,411.7 | 2,746.6 | 1,104.0 | 1,198.2 | 1,300.5 | 1,411.5 |
WACC, % | 8.5 | 8.49 | 8.47 | 8.49 | 8.5 | 8.49 | 8.49 | 8.49 | 8.49 | 8.49 |
PV UFCF | ||||||||||
SUM PV UFCF | 6,286.1 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 1,440 | |||||||||
Terminal Value | 22,187 | |||||||||
Present Terminal Value | 14,763 | |||||||||
Enterprise Value | 21,049 | |||||||||
Net Debt | 1,429 | |||||||||
Equity Value | 19,620 | |||||||||
Diluted Shares Outstanding, MM | 36 | |||||||||
Equity Value Per Share | 544.59 |
What You Will Get
- Real Primerica Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Primerica, Inc. (PRI).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates specifically for Primerica, Inc. (PRI).
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Primerica, Inc.'s (PRI) fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections for Primerica, Inc. (PRI).
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility for Primerica, Inc. (PRI).
Key Features
- Comprehensive DCF Calculator: Offers both unlevered and levered DCF valuation models tailored for Primerica, Inc. (PRI).
- WACC Calculator: Features a pre-configured Weighted Average Cost of Capital sheet with adjustable parameters.
- Customizable Forecast Assumptions: Easily alter growth rates, capital expenditures, and discount rates to fit your analysis.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specifically for Primerica, Inc. (PRI).
- Interactive Dashboard and Charts: Visual representations that highlight essential valuation metrics for straightforward analysis.
How It Works
- Download the Template: Gain immediate access to the Excel-based PRI Financial Model.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, discount rates, expenses, and more.
- Instant Calculations: The model automatically recalculates Primerica’s intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential valuation variations.
- Analyze and Decide: Utilize the results to inform your investment or financial strategy.
Why Choose This Calculator for Primerica, Inc. (PRI)?
- Accuracy: Utilizes real Primerica financial data to ensure precise calculations.
- Flexibility: Allows users to easily adjust and explore various input scenarios.
- Time-Saving: Eliminates 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 interface designed for users of all financial backgrounds.
Who Should Use This Product?
- Individual Investors: Gain insights to make informed decisions about investing in Primerica, Inc. (PRI).
- Financial Analysts: Enhance analysis with comprehensive financial models tailored for Primerica, Inc. (PRI).
- Consultants: Provide clients with accurate and timely valuation assessments of Primerica, Inc. (PRI).
- Business Owners: Learn from the valuation strategies of Primerica, Inc. (PRI) to inform your own business decisions.
- Finance Students: Explore real-world valuation practices through the financial data of Primerica, Inc. (PRI).
What the Template Contains
- Pre-Filled DCF Model: Primerica, Inc.'s (PRI) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Primerica, Inc.'s (PRI) 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.