|
Reservoir Media, Inc. (RSVR) Valoración de DCF
US | Communication Services | Entertainment | 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
Reservoir Media, Inc. (RSVR) Bundle
¡Mejore sus opciones de inversión con la calculadora DCF de Reservoir Media, Inc. (RSVR)! Utilice datos financieros auténticos, ajuste las proyecciones y gastos de crecimiento, y observe instantáneamente cómo estas modificaciones afectan el valor intrínseco de Reservoir Media, Inc. (RSVR).
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 | 63.2 | 80.2 | 107.8 | 122.3 | 144.9 | 178.6 | 220.2 | 271.4 | 334.6 | 412.5 |
Revenue Growth, % | 0 | 26.89 | 34.39 | 13.4 | 18.46 | 23.28 | 23.28 | 23.28 | 23.28 | 23.28 |
EBITDA | 23.9 | 32.4 | 38.4 | 43.1 | 47.2 | 64.9 | 80.0 | 98.6 | 121.6 | 149.9 |
EBITDA, % | 37.79 | 40.38 | 35.59 | 35.27 | 32.62 | 36.33 | 36.33 | 36.33 | 36.33 | 36.33 |
Depreciation | 8.4 | 14.1 | 19.0 | 22.1 | 25.0 | 29.9 | 36.9 | 45.5 | 56.1 | 69.1 |
Depreciation, % | 13.32 | 17.54 | 17.64 | 18.05 | 17.25 | 16.76 | 16.76 | 16.76 | 16.76 | 16.76 |
EBIT | 15.5 | 18.3 | 19.4 | 21.1 | 22.3 | 34.9 | 43.1 | 53.1 | 65.5 | 80.7 |
EBIT, % | 24.47 | 22.84 | 17.95 | 17.22 | 15.37 | 19.57 | 19.57 | 19.57 | 19.57 | 19.57 |
Total Cash | .0 | 9.2 | 17.8 | 14.9 | 18.1 | 18.8 | 23.2 | 28.6 | 35.3 | 43.5 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 9.7 | 15.8 | 25.2 | 31.3 | 33.2 | 38.2 | 47.1 | 58.1 | 71.6 | 88.3 |
Account Receivables, % | 15.41 | 19.71 | 23.38 | 25.56 | 22.94 | 21.4 | 21.4 | 21.4 | 21.4 | 21.4 |
Inventories | .4 | 1.4 | 4.0 | 5.5 | 6.3 | 5.4 | 6.6 | 8.1 | 10.0 | 12.4 |
Inventories, % | 0.68159 | 1.75 | 3.75 | 4.46 | 4.35 | 3 | 3 | 3 | 3 | 3 |
Accounts Payable | .9 | 3.3 | 4.4 | 6.7 | 9.0 | 7.6 | 9.4 | 11.6 | 14.3 | 17.6 |
Accounts Payable, % | 1.39 | 4.13 | 4.11 | 5.46 | 6.22 | 4.26 | 4.26 | 4.26 | 4.26 | 4.26 |
Capital Expenditure | -.5 | -118.6 | -194.4 | -72.2 | -50.4 | -105.2 | -129.7 | -160.0 | -197.2 | -243.1 |
Capital Expenditure, % | -0.83802 | -147.8 | -180.23 | -59.07 | -34.76 | -58.93 | -58.93 | -58.93 | -58.93 | -58.93 |
Tax Rate, % | 44.97 | 44.97 | 44.97 | 44.97 | 44.97 | 44.97 | 44.97 | 44.97 | 44.97 | 44.97 |
EBITAT | 7.2 | 14.8 | 14.6 | 6.4 | 12.2 | 20.1 | 24.8 | 30.6 | 37.7 | 46.5 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 5.8 | -94.3 | -171.7 | -49.0 | -13.6 | -60.6 | -76.4 | -94.2 | -116.1 | -143.2 |
WACC, % | 6.54 | 7.33 | 7.2 | 6.17 | 6.74 | 6.8 | 6.8 | 6.8 | 6.8 | 6.8 |
PV UFCF | ||||||||||
SUM PV UFCF | -393.4 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -146 | |||||||||
Terminal Value | -3,044 | |||||||||
Present Terminal Value | -2,191 | |||||||||
Enterprise Value | -2,585 | |||||||||
Net Debt | 319 | |||||||||
Equity Value | -2,904 | |||||||||
Diluted Shares Outstanding, MM | 65 | |||||||||
Equity Value Per Share | -44.50 |
What You Will Get
- Real Reservoir Media Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Reservoir Media, Inc. (RSVR).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates specific to Reservoir Media.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Reservoir Media’s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections for Reservoir Media, Inc. (RSVR).
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility tailored to Reservoir Media.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Reservoir Media, Inc. (RSVR).
- WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with adjustable parameters.
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates as needed.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specifically for Reservoir Media, Inc. (RSVR).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis.
How It Works
- Step 1: Download the prebuilt Excel template with Reservoir Media’s data included.
- Step 2: Explore the pre-filled sheets and understand the key metrics.
- Step 3: Update forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly view recalculated results, including Reservoir Media’s intrinsic value.
- Step 5: Make informed investment decisions or generate reports using the outputs.
Why Choose This Calculator for Reservoir Media, Inc. (RSVR)?
- Accurate Data: Up-to-date financials for Reservoir Media ensure dependable valuation outcomes.
- Customizable: Tailor essential parameters like growth rates, WACC, and tax rates to fit your forecasts.
- Time-Saving: Built-in calculations remove the hassle of starting from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants in the media industry.
- User-Friendly: Easy-to-navigate design and clear instructions make it accessible for all users.
Who Should Use Reservoir Media, Inc. (RSVR)?
- Investors: Gain insights into the media industry with a comprehensive valuation model.
- Financial Analysts: Streamline your analysis with a customizable DCF model tailored for media assets.
- Consultants: Effortlessly modify the template for client engagements and presentations.
- Media Enthusiasts: Enhance your knowledge of the media landscape through practical examples.
- Educators and Students: Utilize it as a hands-on resource in media finance courses.
What the Template Contains
- Preloaded RSVR Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.