James River Group Holdings, Ltd. (JRVR) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
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.