Planet Labs PBC (PL) 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
Planet Labs PBC (PL) Bundle
Explore Planet Labs PBC's (PL) financial prospects with our user-friendly DCF Calculator! Enter your assumptions for growth, margins, and expenses to calculate Planet Labs PBC's (PL) intrinsic value and refine your investment strategy.
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 | 95.7 | 113.2 | 131.2 | 191.3 | 220.7 | 273.3 | 338.4 | 419.0 | 518.9 | 642.5 |
Revenue Growth, % | 0 | 18.21 | 15.94 | 45.76 | 15.39 | 23.83 | 23.83 | 23.83 | 23.83 | 23.83 |
EBITDA | -39.0 | -54.4 | -81.1 | -117.8 | -92.1 | -138.8 | -171.9 | -212.8 | -263.6 | -326.4 |
EBITDA, % | -40.78 | -48.06 | -61.84 | -61.59 | -41.71 | -50.79 | -50.79 | -50.79 | -50.79 | -50.79 |
Depreciation | 77.6 | 62.2 | 45.1 | 43.3 | 47.6 | 117.3 | 145.3 | 179.9 | 222.7 | 275.8 |
Depreciation, % | 81.06 | 54.96 | 34.37 | 22.66 | 21.59 | 42.93 | 42.93 | 42.93 | 42.93 | 42.93 |
EBIT | -116.6 | -116.6 | -126.2 | -161.1 | -139.7 | -242.5 | -300.3 | -371.9 | -460.5 | -570.2 |
EBIT, % | -121.83 | -103.02 | -96.21 | -84.24 | -63.3 | -88.75 | -88.75 | -88.75 | -88.75 | -88.75 |
Total Cash | 21.7 | 71.2 | 490.8 | 408.8 | 307.3 | 210.7 | 260.9 | 323.1 | 400.1 | 495.4 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 27.7 | 47.1 | 44.4 | 39.0 | 43.3 | 78.9 | 97.7 | 121.0 | 149.9 | 185.6 |
Account Receivables, % | 28.96 | 41.63 | 33.82 | 20.37 | 19.63 | 28.88 | 28.88 | 28.88 | 28.88 | 28.88 |
Inventories | .8 | .0 | .0 | .0 | .0 | .4 | .5 | .7 | .8 | 1.0 |
Inventories, % | 0.79072 | 0.000000884 | 0.000000762 | 0.000000523 | 0 | 0.15814 | 0.15814 | 0.15814 | 0.15814 | 0.15814 |
Accounts Payable | 2.1 | 1.4 | 2.9 | 6.9 | 2.6 | 5.7 | 7.1 | 8.8 | 10.8 | 13.4 |
Accounts Payable, % | 2.21 | 1.28 | 2.17 | 3.61 | 1.18 | 2.09 | 2.09 | 2.09 | 2.09 | 2.09 |
Capital Expenditure | -24.1 | -30.1 | -14.9 | -12.8 | -42.4 | -48.7 | -60.3 | -74.6 | -92.4 | -114.4 |
Capital Expenditure, % | -25.17 | -26.62 | -11.38 | -6.67 | -19.22 | -17.81 | -17.81 | -17.81 | -17.81 | -17.81 |
Tax Rate, % | -0.58342 | -0.58342 | -0.58342 | -0.58342 | -0.58342 | -0.58342 | -0.58342 | -0.58342 | -0.58342 | -0.58342 |
EBITAT | -116.8 | -117.6 | -128.2 | -162.0 | -140.5 | -242.5 | -300.3 | -371.9 | -460.5 | -570.2 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -89.6 | -104.8 | -93.9 | -121.9 | -143.9 | -206.8 | -232.9 | -288.4 | -357.1 | -442.2 |
WACC, % | 8.94 | 8.94 | 8.94 | 8.94 | 8.94 | 8.94 | 8.94 | 8.94 | 8.94 | 8.94 |
PV UFCF | ||||||||||
SUM PV UFCF | -1,151.0 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -451 | |||||||||
Terminal Value | -6,502 | |||||||||
Present Terminal Value | -4,238 | |||||||||
Enterprise Value | -5,389 | |||||||||
Net Debt | -59 | |||||||||
Equity Value | -5,330 | |||||||||
Diluted Shares Outstanding, MM | 280 | |||||||||
Equity Value Per Share | -19.06 |
What You Will Receive
- Authentic PL Financial Data: Pre-filled with Planet Labs’ historical and projected data for thorough analysis.
- Completely Customizable Template: Easily adjust key inputs such as revenue growth, WACC, and EBITDA %.
- Instant Calculations: Watch Planet Labs’ intrinsic value update in real-time as you make changes.
- Expert Valuation Tool: Tailored for investors, analysts, and consultants aiming for precise DCF outcomes.
- Intuitive Design: Straightforward layout and clear guidance suitable for all skill levels.
Key Features
- Real-Time PL Data: Pre-loaded with Planet Labs' historical metrics and future projections.
- Comprehensive Input Options: Modify growth rates, profit margins, discount rates, tax implications, and capital investments.
- Adaptive Valuation Framework: Automatic recalculations of Net Present Value (NPV) and intrinsic value based on user-defined parameters.
- Scenario Analysis: Generate various forecasting scenarios to explore different valuation results.
- Intuitive Interface: Clean, organized layout suitable for both industry experts and newcomers.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Planet Labs PBC (PL) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Planet Labs PBC’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose Planet Labs PBC (PL)?
- Innovative Technology: Leverage cutting-edge satellite imagery for accurate insights.
- Real-Time Data: Access timely information to support informed decision-making.
- Scalable Solutions: Flexible services that grow with your organization's needs.
- User-Friendly Interface: Intuitive platform design for easy navigation and analysis.
- Backed by Experts: A team of professionals dedicated to delivering high-quality results.
Who Should Use This Product?
- Individual Investors: Gain insights to make informed decisions about buying or selling Planet Labs PBC (PL) stock.
- Financial Analysts: Enhance valuation processes with comprehensive financial models tailored for Planet Labs PBC (PL).
- Consultants: Provide clients with accurate and timely valuation insights regarding Planet Labs PBC (PL).
- Business Owners: Learn how companies like Planet Labs PBC (PL) are valued to inform your own business strategies.
- Finance Students: Explore valuation methodologies using real-world data from Planet Labs PBC (PL).
What the Template Contains
- Pre-Filled Data: Includes Planet Labs PBC’s historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze Planet Labs PBC’s profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.