|
Sirius XM Holdings Inc. (SIRI) DCF Valuation
US | Communication Services | Entertainment | NASDAQ
|
- ✓ 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
Sirius XM Holdings Inc. (SIRI) Bundle
Evaluate Sirius XM Holdings Inc.’s financial prospects like an expert! This (SIRI) DCF Calculator provides you with pre-filled financial data and full flexibility to modify revenue growth, WACC, margins, and other essential assumptions to align with your predictions.
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 | 7,794.0 | 8,040.0 | 8,696.0 | 9,003.0 | 8,953.0 | 9,272.9 | 9,604.1 | 9,947.3 | 10,302.6 | 10,670.7 |
Revenue Growth, % | 0 | 3.16 | 8.16 | 3.53 | -0.55537 | 3.57 | 3.57 | 3.57 | 3.57 | 3.57 |
EBITDA | 2,055.0 | 1,386.0 | 2,524.0 | 2,612.0 | 2,540.0 | 2,411.2 | 2,497.3 | 2,586.5 | 2,679.0 | 2,774.7 |
EBITDA, % | 26.37 | 17.24 | 29.02 | 29.01 | 28.37 | 26 | 26 | 26 | 26 | 26 |
Depreciation | 468.0 | 562.0 | 583.0 | 585.0 | 599.0 | 609.9 | 631.7 | 654.3 | 677.7 | 701.9 |
Depreciation, % | 6 | 6.99 | 6.7 | 6.5 | 6.69 | 6.58 | 6.58 | 6.58 | 6.58 | 6.58 |
EBIT | 1,587.0 | 824.0 | 1,941.0 | 2,027.0 | 1,941.0 | 1,801.3 | 1,865.6 | 1,932.3 | 2,001.3 | 2,072.8 |
EBIT, % | 20.36 | 10.25 | 22.32 | 22.51 | 21.68 | 19.43 | 19.43 | 19.43 | 19.43 | 19.43 |
Total Cash | 106.0 | 71.0 | 191.0 | 57.0 | 216.0 | 138.8 | 143.8 | 148.9 | 154.2 | 159.7 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 670.0 | 672.0 | 722.0 | 655.0 | 709.0 | 750.2 | 777.0 | 804.8 | 833.5 | 863.3 |
Account Receivables, % | 8.6 | 8.36 | 8.3 | 7.28 | 7.92 | 8.09 | 8.09 | 8.09 | 8.09 | 8.09 |
Inventories | 11.0 | 10.0 | 246.0 | .0 | .0 | 57.4 | 59.4 | 61.6 | 63.8 | 66.0 |
Inventories, % | 0.14113 | 0.12438 | 2.83 | 0 | 0 | 0.61888 | 0.61888 | 0.61888 | 0.61888 | 0.61888 |
Accounts Payable | 1,151.0 | 1,223.0 | 1,299.0 | 1,248.0 | 1,306.0 | 1,360.6 | 1,409.2 | 1,459.6 | 1,511.7 | 1,565.7 |
Accounts Payable, % | 14.77 | 15.21 | 14.94 | 13.86 | 14.59 | 14.67 | 14.67 | 14.67 | 14.67 | 14.67 |
Capital Expenditure | -363.0 | -350.0 | -388.0 | -426.0 | -650.0 | -472.3 | -489.1 | -506.6 | -524.7 | -543.4 |
Capital Expenditure, % | -4.66 | -4.35 | -4.46 | -4.73 | -7.26 | -5.09 | -5.09 | -5.09 | -5.09 | -5.09 |
Tax Rate, % | 17.13 | 17.13 | 17.13 | 17.13 | 17.13 | 17.13 | 17.13 | 17.13 | 17.13 | 17.13 |
EBITAT | 1,211.8 | 251.0 | 1,671.3 | 1,531.9 | 1,608.5 | 1,265.9 | 1,311.1 | 1,357.9 | 1,406.4 | 1,456.7 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 1,786.8 | 534.0 | 1,656.3 | 1,952.9 | 1,561.5 | 1,359.6 | 1,473.4 | 1,526.1 | 1,580.6 | 1,637.0 |
WACC, % | 6.31 | 5.26 | 6.54 | 6.3 | 6.46 | 6.18 | 6.18 | 6.18 | 6.18 | 6.18 |
PV UFCF | ||||||||||
SUM PV UFCF | 6,319.4 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 1,670 | |||||||||
Terminal Value | 39,994 | |||||||||
Present Terminal Value | 29,640 | |||||||||
Enterprise Value | 35,959 | |||||||||
Net Debt | 9,317 | |||||||||
Equity Value | 26,642 | |||||||||
Diluted Shares Outstanding, MM | 389 | |||||||||
Equity Value Per Share | 68.52 |
What You Will Receive
- Accurate SIRI Financial Data: Pre-populated with Sirius XM’s historical and projected figures for thorough analysis.
- Customizable Template: Easily adjust essential inputs such as revenue growth, WACC, and EBITDA %.
- Instant Calculations: Observe real-time updates of Sirius XM’s intrinsic value as you make changes.
- Expert Valuation Tool: Tailored for investors, analysts, and consultants aiming for precise DCF outcomes.
- Intuitive Design: User-friendly layout and straightforward instructions suitable for all skill levels.
Key Features
- Customizable Subscription Metrics: Adjust essential inputs such as subscriber growth, ARPU, and content costs.
- Instant Revenue Projections: Quickly generates forecasts for revenue, EBITDA, and other financial metrics.
- Industry-Leading Precision: Utilizes Sirius XM's actual performance data for accurate valuation results.
- Effortless Scenario Testing: Easily experiment with various assumptions and analyze different outcomes.
- Efficiency Booster: Avoid the hassle of creating intricate valuation models from the ground up.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Sirius XM data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Sirius XM’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Sirius XM Holdings Inc. (SIRI)?
- Accurate Data: Up-to-date Sirius XM financials provide dependable valuation outcomes.
- Customizable: Modify essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-configured calculations save you the hassle of building from the ground up.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants focused on Sirius XM.
- User-Friendly: Easy-to-navigate design and clear instructions ensure accessibility for all users.
Who Should Use This Product?
- Investors: Assess Sirius XM's valuation prior to making stock transactions.
- CFOs and Financial Analysts: Optimize valuation workflows and evaluate financial forecasts.
- Startup Founders: Understand the valuation methods applied to leading companies like Sirius XM.
- Consultants: Create detailed valuation reports for your clients.
- Students and Educators: Utilize current data to learn and teach valuation strategies.
What the Template Contains
- Pre-Filled DCF Model: Sirius XM Holdings Inc.’s (SIRI) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Sirius XM’s (SIRI) 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.