|
Riverview Bancorp, Inc. (RVSB) Valoración de DCF
US | Financial Services | Banks - Regional | NASDAQ
|
- ✓ 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
Riverview Bancorp, Inc. (RVSB) Bundle
¡Descubra el verdadero valor de Riverview Bancorp, Inc. (RVSB) con nuestra calculadora DCF avanzada! Ajuste los supuestos clave, explore varios escenarios y evalúe cómo los cambios afectan la valoración de Riverview Bancorp, todo dentro de una conveniente plantilla de Excel.
Discounted Cash Flow (DCF) - (USD MM)
Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
AY5 2024 |
FY1 2025 |
FY2 2026 |
FY3 2027 |
FY4 2028 |
FY5 2029 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue | 58.1 | 56.0 | 60.4 | 63.8 | 48.3 | 46.6 | 44.9 | 43.3 | 41.8 | 40.3 |
Revenue Growth, % | 0 | -3.59 | 7.79 | 5.68 | -24.25 | -3.59 | -3.59 | -3.59 | -3.59 | -3.59 |
EBITDA | 23.5 | 16.7 | 31.8 | 26.4 | 7.4 | 16.7 | 16.1 | 15.5 | 15.0 | 14.5 |
EBITDA, % | 40.52 | 29.76 | 52.67 | 41.34 | 15.23 | 35.9 | 35.9 | 35.9 | 35.9 | 35.9 |
Depreciation | 3.0 | 3.2 | 3.5 | 2.7 | 2.8 | 2.5 | 2.4 | 2.3 | 2.2 | 2.1 |
Depreciation, % | 5.1 | 5.73 | 5.83 | 4.22 | 5.71 | 5.32 | 5.32 | 5.32 | 5.32 | 5.32 |
EBIT | 20.6 | 13.5 | 28.3 | 23.7 | 4.6 | 14.2 | 13.7 | 13.2 | 12.8 | 12.3 |
EBIT, % | 35.42 | 24.02 | 46.84 | 37.11 | 9.52 | 30.58 | 30.58 | 30.58 | 30.58 | 30.58 |
Total Cash | 190.5 | 482.0 | 407.5 | 233.8 | 23.6 | 41.8 | 40.3 | 38.9 | 37.5 | 36.1 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .0 | .0 | 4.7 | .0 | .0 | .7 | .7 | .7 | .6 | .6 |
Account Receivables, % | 0 | 0 | 7.7 | 0 | 0 | 1.54 | 1.54 | 1.54 | 1.54 | 1.54 |
Inventories | -18.1 | -16.7 | .0 | -16.7 | .0 | -8.1 | -7.8 | -7.5 | -7.3 | -7.0 |
Inventories, % | -31.08 | -29.8 | 0 | -26.15 | 0 | -17.41 | -17.41 | -17.41 | -17.41 | -17.41 |
Accounts Payable | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Accounts Payable, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Capital Expenditure | -3.0 | -3.6 | -3.3 | -5.0 | -5.6 | -3.4 | -3.3 | -3.1 | -3.0 | -2.9 |
Capital Expenditure, % | -5.08 | -6.34 | -5.39 | -7.78 | -11.61 | -7.24 | -7.24 | -7.24 | -7.24 | -7.24 |
Tax Rate, % | 17.43 | 17.43 | 17.43 | 17.43 | 17.43 | 17.43 | 17.43 | 17.43 | 17.43 | 17.43 |
EBITAT | 15.7 | 10.5 | 21.8 | 18.1 | 3.8 | 11.1 | 10.7 | 10.3 | 10.0 | 9.6 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 33.8 | 8.8 | .7 | 37.1 | -15.7 | 17.6 | 9.6 | 9.3 | 8.9 | 8.6 |
WACC, % | 9.99 | 10.09 | 10.04 | 9.98 | 10.46 | 10.11 | 10.11 | 10.11 | 10.11 | 10.11 |
PV UFCF | ||||||||||
SUM PV UFCF | 42.2 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 9 | |||||||||
Terminal Value | 108 | |||||||||
Present Terminal Value | 67 | |||||||||
Enterprise Value | 109 | |||||||||
Net Debt | 94 | |||||||||
Equity Value | 15 | |||||||||
Diluted Shares Outstanding, MM | 21 | |||||||||
Equity Value Per Share | 0.72 |
What You Will Get
- Real RVSB Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are computed in real-time.
- Scenario Analysis: Evaluate various scenarios to assess Riverview Bancorp's future performance.
- User-Friendly Design: Designed for professionals while remaining approachable for newcomers.
Key Features
- Comprehensive Financial Data: Gain access to precise historical information and future forecasts for Riverview Bancorp, Inc. (RVSB).
- Adjustable Forecast Parameters: Modify highlighted fields such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Automatic recalculations for DCF, Net Present Value (NPV), and cash flow assessments.
- User-Friendly Dashboard: Intuitive charts and summaries to easily interpret your valuation findings.
- Designed for All Skill Levels: An accessible and straightforward layout tailored for investors, CFOs, and consultants alike.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Riverview Bancorp, Inc. (RVSB) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Riverview Bancorp, Inc. (RVSB)’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Riverview Bancorp, Inc. (RVSB)?
- Accuracy: Utilizes real Riverview Bancorp financials for precise data.
- Flexibility: Tailored for users to easily adjust and experiment with inputs.
- Time-Saving: Eliminate the need to create a financial model from the ground up.
- Professional-Grade: Crafted with the expertise and usability expected by CFOs.
- User-Friendly: Simple to navigate, even for those without extensive financial modeling skills.
Who Should Use This Product?
- Investors: Evaluate Riverview Bancorp, Inc.'s (RVSB) financial health before making investment decisions.
- CFOs and Financial Analysts: Optimize valuation methodologies and validate financial forecasts for Riverview Bancorp, Inc. (RVSB).
- Startup Founders: Gain insights into how community banks like Riverview Bancorp, Inc. (RVSB) are assessed in the market.
- Consultants: Provide comprehensive valuation analyses and reports to clients in the banking sector.
- Students and Educators: Utilize real-time data from Riverview Bancorp, Inc. (RVSB) to teach and practice financial valuation skills.
What the Template Contains
- Preloaded RVSB Data: Historical and projected financial data, including revenue, net income, and loan performance metrics.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting interest rates, growth assumptions, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, liquidity, and asset management ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and key financial assumptions.