|
Valoración de DCF Fastly, Inc. (FSLY)
US | Technology | Software - Application | NYSE
|
- ✓ 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
Fastly, Inc. (FSLY) Bundle
¡Descubra el verdadero valor de Fastly, Inc. (FSLY) con nuestra calculadora DCF avanzada! Ajuste los supuestos clave, explore varios escenarios y evalúe cómo los cambios influyen Fastly, Inc. (FSLY) valoración, todo dentro de una sola plantilla de Excel.
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 | 200.5 | 290.9 | 354.3 | 432.7 | 506.0 | 640.0 | 809.6 | 1,024.1 | 1,295.4 | 1,638.6 |
Revenue Growth, % | 0 | 45.1 | 21.82 | 22.12 | 16.93 | 26.49 | 26.49 | 26.49 | 26.49 | 26.49 |
EBITDA | -27.0 | -77.3 | -167.3 | -81.8 | -19.0 | -140.7 | -178.0 | -225.1 | -284.8 | -360.2 |
EBITDA, % | -13.45 | -26.57 | -47.23 | -18.91 | -3.76 | -21.98 | -21.98 | -21.98 | -21.98 | -21.98 |
Depreciation | 18.9 | 28.6 | 56.3 | 102.9 | 110.3 | 103.3 | 130.7 | 165.3 | 209.1 | 264.5 |
Depreciation, % | 9.4 | 9.82 | 15.9 | 23.79 | 21.79 | 16.14 | 16.14 | 16.14 | 16.14 | 16.14 |
EBIT | -45.8 | -105.9 | -223.7 | -184.8 | -129.3 | -244.0 | -308.7 | -390.4 | -493.9 | -624.7 |
EBIT, % | -22.86 | -36.39 | -63.13 | -42.7 | -25.55 | -38.13 | -38.13 | -38.13 | -38.13 | -38.13 |
Total Cash | 131.1 | 194.2 | 527.9 | 518.0 | 322.7 | 506.8 | 641.1 | 811.0 | 1,025.8 | 1,297.6 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 37.1 | 50.3 | 64.6 | 89.6 | 120.5 | 126.2 | 159.6 | 201.9 | 255.3 | 323.0 |
Account Receivables, % | 18.53 | 17.28 | 18.24 | 20.7 | 23.81 | 19.71 | 19.71 | 19.71 | 19.71 | 19.71 |
Inventories | 2.5 | .0 | .0 | .0 | .0 | 1.6 | 2.0 | 2.6 | 3.2 | 4.1 |
Inventories, % | 1.25 | 0 | 0 | 0.000000231 | 0 | 0.25062 | 0.25062 | 0.25062 | 0.25062 | 0.25062 |
Accounts Payable | 4.6 | 9.2 | 9.3 | 4.8 | 5.6 | 13.1 | 16.6 | 21.0 | 26.6 | 33.7 |
Accounts Payable, % | 2.3 | 3.15 | 2.61 | 1.11 | 1.11 | 2.05 | 2.05 | 2.05 | 2.05 | 2.05 |
Capital Expenditure | -20.1 | -39.2 | -50.4 | -80.3 | -32.3 | -80.2 | -101.4 | -128.3 | -162.3 | -205.3 |
Capital Expenditure, % | -10.03 | -13.47 | -14.22 | -18.56 | -6.38 | -12.53 | -12.53 | -12.53 | -12.53 | -12.53 |
Tax Rate, % | 0.16578 | 0.16578 | 0.16578 | 0.16578 | 0.16578 | 0.16578 | 0.16578 | 0.16578 | 0.16578 | 0.16578 |
EBITAT | -46.3 | -94.5 | -223.7 | -184.9 | -129.0 | -238.7 | -302.0 | -382.0 | -483.2 | -611.2 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -82.6 | -111.2 | -232.1 | -191.7 | -81.2 | -215.3 | -303.1 | -383.4 | -485.0 | -613.5 |
WACC, % | 8.75 | 8.63 | 8.75 | 8.75 | 8.75 | 8.73 | 8.73 | 8.73 | 8.73 | 8.73 |
PV UFCF | ||||||||||
SUM PV UFCF | -1,503.5 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -626 | |||||||||
Terminal Value | -9,302 | |||||||||
Present Terminal Value | -6,122 | |||||||||
Enterprise Value | -7,625 | |||||||||
Net Debt | 325 | |||||||||
Equity Value | -7,951 | |||||||||
Diluted Shares Outstanding, MM | 129 | |||||||||
Equity Value Per Share | -61.74 |
What You Will Get
- Real FSLY Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are computed automatically.
- Scenario Analysis: Explore various scenarios to assess Fastly’s future performance.
- User-Friendly Design: Designed for professionals while remaining approachable for newcomers.
Key Features
- Pre-Loaded Data: Fastly, Inc.'s historical financial statements and pre-filled forecasts.
- Fully Adjustable Inputs: Customize WACC, tax rates, revenue growth, and EBITDA margins.
- Instant Results: Watch Fastly, Inc.'s intrinsic value recalculate in real time.
- Clear Visual Outputs: Dashboard charts showcase valuation results and key metrics.
- Built for Accuracy: A professional tool designed for analysts, investors, and finance experts.
How It Works
- 1. Access the Model: Download and open the Excel file containing Fastly, Inc.'s (FSLY) preloaded data.
- 2. Adjust Key Inputs: Modify essential parameters such as growth rates, WACC, and capital expenditures.
- 3. Analyze Results Immediately: The DCF model automatically computes intrinsic value and NPV.
- 4. Explore Different Scenarios: Evaluate various forecasts to understand diverse valuation possibilities.
- 5. Present with Assurance: Deliver expert valuation insights to enhance your decision-making process.
Why Choose the Fastly Calculator?
- Precision: Up-to-date Fastly financials guarantee reliable data.
- Adaptability: Built for users to easily experiment with and adjust inputs.
- Efficiency: Avoid the complexities of creating a DCF model from the ground up.
- Expert-Level: Crafted with the accuracy and functionality expected by CFOs.
- Intuitive: Simple to navigate, even for those lacking advanced financial modeling skills.
Who Should Use This Product?
- Investors: Evaluate Fastly’s valuation before making stock transactions.
- CFOs and Financial Analysts: Enhance valuation workflows and assess financial forecasts.
- Startup Founders: Understand the valuation methods of prominent public companies like Fastly.
- Consultants: Provide expert valuation reports for your clients.
- Students and Educators: Utilize actual data to practice and teach valuation methodologies.
What the Template Contains
- Historical Data: Includes Fastly’s past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Fastly’s intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of Fastly’s financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.