Viasat, Inc. (VSAT) 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
Viasat, Inc. (VSAT) Bundle
Evaluate Viasat, Inc.'s (VSAT) financial prospects like a seasoned expert! This (VSAT) DCF Calculator provides pre-filled financial data and the flexibility to modify revenue growth, WACC, margins, and other crucial 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 | 2,309.2 | 2,256.1 | 2,787.6 | 2,556.2 | 4,283.8 | 5,146.3 | 6,182.5 | 7,427.4 | 8,922.9 | 10,719.5 |
| Revenue Growth, % | 0 | -2.3 | 23.56 | -8.3 | 67.59 | 20.14 | 20.14 | 20.14 | 20.14 | 20.14 |
| EBITDA | 382.2 | 351.6 | 386.9 | 365.0 | 364.0 | 708.1 | 850.6 | 1,021.9 | 1,227.7 | 1,474.9 |
| EBITDA, % | 16.55 | 15.58 | 13.88 | 14.28 | 8.5 | 13.76 | 13.76 | 13.76 | 13.76 | 13.76 |
| Depreciation | 342.2 | 397.1 | 495.4 | 500.4 | 1,157.5 | 996.2 | 1,196.8 | 1,437.8 | 1,727.3 | 2,075.1 |
| Depreciation, % | 14.82 | 17.6 | 17.77 | 19.58 | 27.02 | 19.36 | 19.36 | 19.36 | 19.36 | 19.36 |
| EBIT | 40.1 | -45.5 | -108.5 | -135.3 | -793.5 | -288.1 | -346.2 | -415.9 | -499.6 | -600.2 |
| EBIT, % | 1.74 | -2.02 | -3.89 | -5.29 | -18.52 | -5.6 | -5.6 | -5.6 | -5.6 | -5.6 |
| Total Cash | 304.3 | 295.9 | 310.5 | 1,348.9 | 1,901.0 | 1,385.2 | 1,664.1 | 1,999.1 | 2,401.7 | 2,885.3 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 330.7 | 238.7 | 312.2 | 419.9 | 939.7 | 766.4 | 920.7 | 1,106.1 | 1,328.8 | 1,596.4 |
| Account Receivables, % | 14.32 | 10.58 | 11.2 | 16.43 | 21.94 | 14.89 | 14.89 | 14.89 | 14.89 | 14.89 |
| Inventories | 294.4 | 336.7 | 341.9 | 268.6 | 317.9 | 595.6 | 715.5 | 859.6 | 1,032.6 | 1,240.5 |
| Inventories, % | 12.75 | 14.92 | 12.26 | 10.51 | 7.42 | 11.57 | 11.57 | 11.57 | 11.57 | 11.57 |
| Accounts Payable | 183.6 | 145.1 | 200.7 | 271.5 | 287.2 | 400.5 | 481.1 | 578.0 | 694.4 | 834.2 |
| Accounts Payable, % | 7.95 | 6.43 | 7.2 | 10.62 | 6.7 | 7.78 | 7.78 | 7.78 | 7.78 | 7.78 |
| Capital Expenditure | -761.1 | -885.3 | -990.3 | -1,164.3 | -1,539.4 | -1,947.4 | -2,339.5 | -2,810.6 | -3,376.5 | -4,056.4 |
| Capital Expenditure, % | -32.96 | -39.24 | -35.53 | -45.55 | -35.94 | -37.84 | -37.84 | -37.84 | -37.84 | -37.84 |
| Tax Rate, % | 10.47 | 10.47 | 10.47 | 10.47 | 10.47 | 10.47 | 10.47 | 10.47 | 10.47 | 10.47 |
| EBITAT | 262.2 | -29.0 | -14.5 | -176.6 | -710.4 | -211.3 | -253.8 | -304.9 | -366.3 | -440.0 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -598.3 | -505.8 | -532.6 | -804.1 | -1,645.7 | -1,153.6 | -1,590.1 | -1,910.3 | -2,295.0 | -2,757.1 |
| WACC, % | 5.93 | 4.25 | 1.93 | 5.93 | 5.44 | 4.7 | 4.7 | 4.7 | 4.7 | 4.7 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -8,319.0 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -2,812 | |||||||||
| Terminal Value | -104,297 | |||||||||
| Present Terminal Value | -82,912 | |||||||||
| Enterprise Value | -91,230 | |||||||||
| Net Debt | 5,737 | |||||||||
| Equity Value | -96,968 | |||||||||
| Diluted Shares Outstanding, MM | 117 | |||||||||
| Equity Value Per Share | -827.45 |
What You Will Get
- Real VSAT Financial Data: Pre-filled with Viasat’s historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See Viasat’s intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- Customizable Forecast Inputs: Adjust essential factors such as revenue growth, EBITDA %, and capital expenditures.
- Instant DCF Valuation: Quickly computes intrinsic value, NPV, and other financial metrics.
- High-Precision Accuracy: Leverages Viasat’s real-world financial data for dependable valuation results.
- Effortless Scenario Analysis: Easily evaluate various assumptions and analyze results side by side.
- Efficiency Booster: Streamline the valuation process without the hassle of creating intricate models from the ground up.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Viasat, Inc. (VSAT) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Viasat, Inc. (VSAT)’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose Viasat, Inc. (VSAT)?
- Save Time: Instantly access comprehensive satellite communication solutions without starting from scratch.
- Enhance Connectivity: Reliable technology ensures consistent and high-quality internet services.
- Fully Customizable: Adapt services to meet specific needs and requirements of your business.
- User-Friendly Interface: Intuitive design makes it easy to navigate and manage your connectivity options.
- Backed by Expertise: Trusted by industry leaders for innovative solutions and exceptional customer support.
Who Should Use Viasat, Inc. (VSAT)?
- Investors: Gain insights and make informed decisions with Viasat's innovative communication solutions.
- Telecommunications Analysts: Streamline your analysis with comprehensive data on satellite technology and market trends.
- Consultants: Easily modify presentations or reports to highlight Viasat's competitive advantages in the industry.
- Technology Enthusiasts: Enhance your knowledge of satellite communications through Viasat's cutting-edge advancements.
- Educators and Students: Utilize Viasat's resources as a hands-on learning tool in technology and telecommunications courses.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Viasat, Inc. (VSAT) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), featuring parameters such as Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models displaying intrinsic value with comprehensive calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to facilitate analysis.
- Key Ratios: Incorporates profitability, leverage, and efficiency ratios for Viasat, Inc. (VSAT).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions for easy result analysis.