Spire Global, Inc. (SPIR) DCF Valuation
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
Spire Global, Inc. (SPIR) Bundle
Explore the financial potential of Spire Global, Inc. (SPIR) with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to determine the intrinsic value of Spire Global, Inc. (SPIR) and enhance your investment strategy.
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 | 18.5 | 28.5 | 43.4 | 80.3 | 105.7 | 164.6 | 256.5 | 399.5 | 622.3 | 969.3 |
Revenue Growth, % | 0 | 54.07 | 52.25 | 85.06 | 31.69 | 55.77 | 55.77 | 55.77 | 55.77 | 55.77 |
EBITDA | -17.0 | -19.9 | -17.0 | -54.4 | -23.7 | -96.0 | -149.5 | -232.9 | -362.8 | -565.1 |
EBITDA, % | -92.13 | -69.92 | -39.2 | -67.83 | -22.41 | -58.3 | -58.3 | -58.3 | -58.3 | -58.3 |
Depreciation | 10.0 | 5.4 | 9.2 | 20.7 | 21.2 | 46.2 | 71.9 | 112.0 | 174.5 | 271.8 |
Depreciation, % | 54.29 | 18.99 | 21.15 | 25.77 | 20.01 | 28.04 | 28.04 | 28.04 | 28.04 | 28.04 |
EBIT | -27.1 | -25.3 | -26.2 | -75.1 | -44.8 | -126.9 | -197.6 | -307.8 | -479.5 | -746.9 |
EBIT, % | -146.42 | -88.91 | -60.35 | -93.6 | -42.43 | -77.06 | -77.06 | -77.06 | -77.06 | -77.06 |
Total Cash | 23.9 | 15.6 | 109.3 | 70.3 | 40.9 | 125.4 | 195.4 | 304.3 | 474.0 | 738.4 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 3.6 | 5.0 | 12.2 | 18.3 | 21.9 | 35.8 | 55.7 | 86.8 | 135.3 | 210.7 |
Account Receivables, % | 19.37 | 17.55 | 28.24 | 22.85 | 20.68 | 21.74 | 21.74 | 21.74 | 21.74 | 21.74 |
Inventories | .0 | .7 | .0 | 3.0 | .0 | 2.1 | 3.2 | 5.1 | 7.9 | 12.3 |
Inventories, % | 0 | 2.54 | 0 | 3.78 | 0 | 1.26 | 1.26 | 1.26 | 1.26 | 1.26 |
Accounts Payable | .6 | 1.8 | 5.8 | 4.8 | 8.0 | 12.0 | 18.7 | 29.1 | 45.4 | 70.7 |
Accounts Payable, % | 3.24 | 6.23 | 13.43 | 5.98 | 7.58 | 7.29 | 7.29 | 7.29 | 7.29 | 7.29 |
Capital Expenditure | -9.3 | -10.4 | -15.6 | -18.9 | -30.0 | -57.6 | -89.8 | -139.8 | -217.8 | -339.3 |
Capital Expenditure, % | -50.53 | -36.56 | -35.94 | -23.56 | -28.42 | -35 | -35 | -35 | -35 | -35 |
Tax Rate, % | -0.1127 | -0.1127 | -0.1127 | -0.1127 | -0.1127 | -0.1127 | -0.1127 | -0.1127 | -0.1127 | -0.1127 |
EBITAT | -27.4 | -25.6 | -26.9 | -75.4 | -44.9 | -126.9 | -197.6 | -307.8 | -479.5 | -746.9 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -29.6 | -31.6 | -35.8 | -83.8 | -51.1 | -150.3 | -229.9 | -358.1 | -557.8 | -868.9 |
WACC, % | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 |
PV UFCF | ||||||||||
SUM PV UFCF | -1,331.9 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -886 | |||||||||
Terminal Value | -7,384 | |||||||||
Present Terminal Value | -3,835 | |||||||||
Enterprise Value | -5,166 | |||||||||
Net Debt | 102 | |||||||||
Equity Value | -5,268 | |||||||||
Diluted Shares Outstanding, MM | 20 | |||||||||
Equity Value Per Share | -269.05 |
What You Will Get
- Real SPIR Financial Data: Pre-filled with Spire Global’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 Spire Global’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
- Accurate Spire Financials: Gain access to reliable pre-loaded historical data and future forecasts for Spire Global, Inc. (SPIR).
- Adjustable Forecast Assumptions: Modify highlighted cells for key metrics such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Automatic adjustments to DCF, Net Present Value (NPV), and cash flow assessments.
- User-Friendly Dashboard: Clear charts and summaries to help you easily interpret your valuation findings.
- Designed for All Levels: An intuitive layout suitable for investors, CFOs, and consultants alike.
How It Works
- Step 1: Download the prebuilt Excel template containing Spire Global, Inc.'s (SPIR) data.
- Step 2: Review the pre-filled sheets to familiarize yourself with the essential metrics.
- Step 3: Adjust forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly view updated results, including Spire Global, Inc.'s (SPIR) intrinsic value.
- Step 5: Make well-informed investment decisions or create reports based on the outputs.
Why Choose This Calculator for Spire Global, Inc. (SPIR)?
- Comprehensive Tool: Integrates DCF, WACC, and financial ratio analyses tailored for Spire Global.
- Customizable Inputs: Modify yellow-highlighted cells to explore different financial scenarios.
- Detailed Insights: Automatically computes Spire Global’s intrinsic value and Net Present Value.
- Preloaded Data: Access historical and forecasted data for accurate analysis.
- Professional Quality: Perfect for financial analysts, investors, and business consultants focused on Spire Global.
Who Should Use Spire Global, Inc. (SPIR)?
- Investors: Gain insights into the satellite data industry with advanced analytics tools.
- Data Analysts: Streamline your workflow with customizable data visualization templates.
- Consultants: Tailor reports and presentations quickly using Spire's comprehensive datasets.
- Space Enthusiasts: Explore the intricacies of satellite technology and its applications in various sectors.
- Educators and Students: Utilize it as an engaging resource for learning about space and data analytics.
What the Template Contains
- Preloaded SPIR 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.