SoFi Technologies, Inc. (SOFI) 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
SoFi Technologies, Inc. (SOFI) Bundle
Assess SoFi Technologies, Inc. (SOFI) financial outlook like an expert! This (SOFI) 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 projections.
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 | 442.7 | 565.5 | 977.3 | 1,519.2 | 2,067.8 | 3,061.1 | 4,531.4 | 6,708.0 | 9,930.0 | 14,699.7 |
Revenue Growth, % | 0 | 27.76 | 72.81 | 55.45 | 36.11 | 48.03 | 48.03 | 48.03 | 48.03 | 48.03 |
EBITDA | -252.6 | -281.0 | -371.4 | -240.1 | 11.9 | -979.5 | -1,449.9 | -2,146.4 | -3,177.3 | -4,703.5 |
EBITDA, % | -57.07 | -49.69 | -38 | -15.8 | 0.57582 | -32 | -32 | -32 | -32 | -32 |
Depreciation | 16.0 | 69.8 | 101.6 | 151.4 | 201.4 | 281.9 | 417.3 | 617.8 | 914.5 | 1,353.8 |
Depreciation, % | 3.6 | 12.35 | 10.39 | 9.96 | 9.74 | 9.21 | 9.21 | 9.21 | 9.21 | 9.21 |
EBIT | -268.6 | -350.8 | -473.0 | -391.4 | -189.5 | -1,261.4 | -1,867.3 | -2,764.2 | -4,091.9 | -6,057.3 |
EBIT, % | -60.68 | -62.03 | -48.39 | -25.77 | -9.16 | -41.21 | -41.21 | -41.21 | -41.21 | -41.21 |
Total Cash | 499.5 | 872.6 | 689.6 | 1,818.7 | 3,787.0 | 2,880.9 | 4,264.6 | 6,313.1 | 9,345.4 | 13,834.3 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 21.3 | 17.9 | .0 | .0 | .0 | 48.9 | 72.4 | 107.1 | 158.6 | 234.8 |
Account Receivables, % | 4.82 | 3.17 | 0 | 0 | 0 | 1.6 | 1.6 | 1.6 | 1.6 | 1.6 |
Inventories | 711.5 | 1,382.6 | 727.2 | 1,877.1 | .0 | 2,292.2 | 3,393.2 | 5,023.1 | 7,435.8 | 11,007.4 |
Inventories, % | 160.74 | 244.47 | 74.41 | 123.56 | 0 | 74.88 | 74.88 | 74.88 | 74.88 | 74.88 |
Accounts Payable | 103.6 | 452.9 | 158.1 | 144.6 | 159.9 | 838.2 | 1,240.8 | 1,836.8 | 2,719.1 | 4,025.1 |
Accounts Payable, % | 23.4 | 80.09 | 16.17 | 9.52 | 7.73 | 27.38 | 27.38 | 27.38 | 27.38 | 27.38 |
Capital Expenditure | -37.6 | -24.5 | -52.3 | -103.7 | -121.2 | -189.0 | -279.8 | -414.1 | -613.1 | -907.5 |
Capital Expenditure, % | -8.49 | -4.34 | -5.35 | -6.83 | -5.86 | -6.17 | -6.17 | -6.17 | -6.17 | -6.17 |
Tax Rate, % | 0.13813 | 0.13813 | 0.13813 | 0.13813 | 0.13813 | 0.13813 | 0.13813 | 0.13813 | 0.13813 | 0.13813 |
EBITAT | -268.7 | -239.3 | -475.7 | -393.5 | -189.2 | -1,180.8 | -1,748.0 | -2,587.6 | -3,830.5 | -5,670.4 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -919.6 | -512.3 | -47.9 | -1,509.2 | 1,783.4 | -2,750.7 | -2,332.3 | -3,452.6 | -5,111.0 | -7,565.9 |
WACC, % | 12.76 | 11.53 | 12.76 | 12.76 | 12.75 | 12.51 | 12.51 | 12.51 | 12.51 | 12.51 |
PV UFCF | ||||||||||
SUM PV UFCF | -14,096.6 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -7,717 | |||||||||
Terminal Value | -73,407 | |||||||||
Present Terminal Value | -40,712 | |||||||||
Enterprise Value | -54,809 | |||||||||
Net Debt | 2,278 | |||||||||
Equity Value | -57,087 | |||||||||
Diluted Shares Outstanding, MM | 945 | |||||||||
Equity Value Per Share | -60.41 |
What You Will Get
- Real SOFI Financials: Includes historical and forecasted data for precise valuation.
- Adjustable Inputs: Customize WACC, tax rates, revenue growth, and capital expenditures.
- Automatic Calculations: Intrinsic value and NPV are computed dynamically.
- Scenario Analysis: Evaluate various scenarios to assess SoFi's future performance.
- Clear and Intuitive Design: Designed for professionals while remaining user-friendly for beginners.
Key Features
- Real-Life SOFI Data: Pre-filled with SoFi Technologies’ historical financials and future growth projections.
- Fully Customizable Inputs: Modify revenue growth rates, profit margins, WACC, tax rates, and capital expenditures.
- Dynamic Valuation Model: Automatic updates to Net Present Value (NPV) and intrinsic value based on your inputs.
- Scenario Testing: Develop multiple forecasting scenarios to evaluate different valuation results.
- User-Friendly Design: Intuitive, organized, and tailored for both professionals and novices.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review SoFi Technologies, Inc.'s (SOFI) pre-filled financial data and forecasts.
- Step 3: Modify key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Watch the DCF model update in real-time as you adjust assumptions.
- Step 5: Analyze the outputs and leverage the results for your investment decisions.
Why Choose SoFi Technologies, Inc. (SOFI)?
- Streamlined Experience: Access a comprehensive platform without the hassle of complex setups.
- Enhanced Accuracy: Utilize dependable financial tools and data to minimize valuation errors.
- Fully Adaptable: Customize features to align with your financial strategies and goals.
- User-Friendly Interface: Intuitive designs and visuals make it simple to understand your financial insights.
- Endorsed by Professionals: Built for users who prioritize accuracy and a seamless experience.
Who Should Use This Product?
- Investors: Accurately estimate SoFi Technologies, Inc.'s (SOFI) fair value before making investment decisions.
- CFOs: Utilize a professional-grade DCF model for financial reporting and analysis specific to SoFi Technologies, Inc. (SOFI).
- Consultants: Quickly adapt the template for valuation reports tailored for clients focusing on SoFi Technologies, Inc. (SOFI).
- Entrepreneurs: Gain insights into financial modeling practices employed by leading fintech companies like SoFi Technologies, Inc. (SOFI).
- Educators: Use it as a teaching tool to illustrate valuation methodologies relevant to SoFi Technologies, Inc. (SOFI).
What the Template Contains
- Historical Data: Includes SoFi’s past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate SoFi’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 SoFi’s financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.