James River Group Holdings, Ltd. (JRVR) 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
James River Group Holdings, Ltd. (JRVR) Bundle
Engineered for accuracy, our JRVR (James River Group Holdings, Ltd.) DCF Calculator enables you to evaluate the valuation of JRVR with up-to-date financial data and complete flexibility to modify all essential parameters for improved forecasting.
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 | 907.1 | 668.7 | 772.9 | 813.7 | 812.0 | 800.6 | 789.3 | 778.2 | 767.3 | 756.5 |
| Revenue Growth, % | 0 | -26.28 | 15.58 | 5.28 | -0.20733 | -1.41 | -1.41 | -1.41 | -1.41 | -1.41 |
| EBITDA | 65.5 | 27.0 | -94.5 | 1,083.9 | 111.1 | 180.5 | 177.9 | 175.4 | 172.9 | 170.5 |
| EBITDA, % | 7.22 | 4.04 | -12.23 | 133.21 | 13.68 | 22.54 | 22.54 | 22.54 | 22.54 | 22.54 |
| Depreciation | 4.1 | 5.0 | 4.7 | 1.8 | -.5 | 3.2 | 3.1 | 3.1 | 3.0 | 3.0 |
| Depreciation, % | 0.4479 | 0.75057 | 0.61006 | 0.21802 | -0.05849689 | 0.39361 | 0.39361 | 0.39361 | 0.39361 | 0.39361 |
| EBIT | 61.4 | 22.0 | -99.2 | 1,082.1 | 111.5 | 177.7 | 175.2 | 172.7 | 170.3 | 167.9 |
| EBIT, % | 6.77 | 3.29 | -12.84 | 132.99 | 13.74 | 22.19 | 22.19 | 22.19 | 22.19 | 22.19 |
| Total Cash | 1,797.5 | 2,076.2 | 2,004.2 | 2,064.4 | 2.0 | 640.9 | 631.8 | 622.9 | 614.2 | 605.5 |
| 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 | -2,028.1 | -1,653.9 | -924.0 | -791.4 | .0 | -636.1 | -627.1 | -618.3 | -609.6 | -601.0 |
| Inventories, % | -223.58 | -247.33 | -119.55 | -97.26 | 0 | -79.45 | -79.45 | -79.45 | -79.45 | -79.45 |
| Accounts Payable | 108.1 | 110.4 | 135.6 | 123.1 | 158.7 | 129.1 | 127.3 | 125.5 | 123.8 | 122.0 |
| Accounts Payable, % | 11.91 | 16.51 | 17.55 | 15.13 | 19.54 | 16.13 | 16.13 | 16.13 | 16.13 | 16.13 |
| Capital Expenditure | -.5 | -.5 | -6.3 | -8.2 | -6.4 | -4.4 | -4.4 | -4.3 | -4.2 | -4.2 |
| Capital Expenditure, % | -0.05721372 | -0.08210095 | -0.81552 | -1.01 | -0.79236 | -0.55145 | -0.55145 | -0.55145 | -0.55145 | -0.55145 |
| Tax Rate, % | 223.9 | 223.9 | 223.9 | 223.9 | 223.9 | 223.9 | 223.9 | 223.9 | 223.9 | 223.9 |
| EBITAT | 45.4 | 8.9 | -87.4 | 678.7 | -138.2 | 94.2 | 92.9 | 91.6 | 90.3 | 89.0 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 2,185.1 | -358.5 | -793.7 | 527.1 | -900.9 | 699.5 | 80.9 | 79.7 | 78.6 | 77.5 |
| WACC, % | 5.51 | 3.89 | 6.2 | 4.97 | 1.94 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 941.4 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 79 | |||||||||
| Terminal Value | 3,160 | |||||||||
| Present Terminal Value | 2,535 | |||||||||
| Enterprise Value | 3,477 | |||||||||
| Net Debt | 52 | |||||||||
| Equity Value | 3,425 | |||||||||
| Diluted Shares Outstanding, MM | 38 | |||||||||
| Equity Value Per Share | 90.57 |
What You Will Get
- Authentic JRVR Data: Preloaded financials – encompassing revenue to EBIT – based on actual and projected figures for James River Group Holdings, Ltd. (JRVR).
- Comprehensive Customization: Modify all essential parameters (yellow cells) such as WACC, growth %, and tax rates to fit your analysis.
- Immediate Valuation Updates: Automatic recalculations to assess the effects of changes on JRVR’s fair value.
- Flexible Excel Template: Designed for easy edits, scenario testing, and thorough projections specific to JRVR.
- Efficient and Precise: Eliminate the need to build models from the ground up while ensuring accuracy and adaptability.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for James River Group Holdings, Ltd. (JRVR).
- WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with adjustable inputs specific to JRVR.
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates according to your analysis needs.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios for James River Group Holdings, Ltd. (JRVR).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered James River Group Holdings, Ltd. (JRVR) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for James River Group Holdings, Ltd. (JRVR)’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for James River Group Holdings, Ltd. (JRVR)?
- Accuracy: Utilizes real James River financials for precise data representation.
- Flexibility: Tailored for users to easily test and adjust inputs as needed.
- Time-Saving: Avoid the complexity of constructing a DCF model from the ground up.
- Professional-Grade: Created with the expertise and usability expected at the CFO level.
- User-Friendly: Intuitive design makes it accessible for users without extensive financial modeling skills.
Who Should Use This Product?
- Investors: Effectively assess James River Group Holdings, Ltd.'s (JRVR) intrinsic value prior to making investment choices.
- CFOs: Utilize a top-tier DCF model for comprehensive financial reporting and analysis.
- Consultants: Easily customize the template for client valuation reports related to JRVR.
- Entrepreneurs: Acquire knowledge on financial modeling practices adopted by leading companies like JRVR.
- Educators: Employ this resource as a teaching aid to illustrate various valuation techniques.
What the Template Contains
- Pre-Filled DCF Model: James River Group Holdings, Ltd. (JRVR)’s financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate James River Group Holdings, Ltd. (JRVR)’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.