Upstart Holdings, Inc. (UPST) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
Upstart Holdings, Inc. (UPST) Bundle
Evaluate Upstart Holdings, Inc. (UPST)'s financial outlook like an expert! This (UPST) DCF Calculator provides pre-filled financial data while offering the flexibility to modify revenue growth, WACC, margins, and other critical 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 | 190.7 | 241.4 | 851.9 | 853.3 | 513.6 | 625.2 | 761.2 | 926.7 | 1,128.2 | 1,373.5 |
Revenue Growth, % | 0 | 26.63 | 252.82 | 0.16716 | -39.81 | 21.74 | 21.74 | 21.74 | 21.74 | 21.74 |
EBITDA | .0 | 11.8 | 140.9 | -89.5 | -215.1 | -38.7 | -47.1 | -57.4 | -69.9 | -85.1 |
EBITDA, % | 0 | 4.87 | 16.54 | -10.49 | -41.89 | -6.19 | -6.19 | -6.19 | -6.19 | -6.19 |
Depreciation | .8 | 2.3 | 7.5 | 13.5 | 24.9 | 10.8 | 13.2 | 16.1 | 19.6 | 23.8 |
Depreciation, % | 0.40593 | 0.9435 | 0.88524 | 1.58 | 4.85 | 1.73 | 1.73 | 1.73 | 1.73 | 1.73 |
EBIT | -.8 | 9.5 | 133.3 | -103.0 | -240.0 | -49.6 | -60.3 | -73.5 | -89.4 | -108.9 |
EBIT, % | -0.40593 | 3.93 | 15.65 | -12.07 | -46.74 | -7.93 | -7.93 | -7.93 | -7.93 | -7.93 |
Total Cash | 44.4 | 250.8 | 986.6 | 422.4 | 368.4 | 430.8 | 524.5 | 638.5 | 777.4 | 946.4 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Inventories | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Inventories, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Accounts Payable | 6.6 | 13.8 | 6.6 | 18.7 | 12.6 | 18.2 | 22.2 | 27.0 | 32.9 | 40.0 |
Accounts Payable, % | 3.44 | 5.71 | 0.77043 | 2.19 | 2.46 | 2.91 | 2.91 | 2.91 | 2.91 | 2.91 |
Capital Expenditure | -5.3 | -5.6 | -15.1 | -22.9 | -1.5 | -12.3 | -15.0 | -18.3 | -22.2 | -27.1 |
Capital Expenditure, % | -2.77 | -2.32 | -1.77 | -2.69 | -0.29734 | -1.97 | -1.97 | -1.97 | -1.97 | -1.97 |
Tax Rate, % | -0.04457869 | -0.04457869 | -0.04457869 | -0.04457869 | -0.04457869 | -0.04457869 | -0.04457869 | -0.04457869 | -0.04457869 | -0.04457869 |
EBITAT | -.1 | 9.5 | 135.0 | -102.6 | -240.1 | -40.5 | -49.4 | -60.1 | -73.2 | -89.1 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 2.0 | 13.4 | 120.3 | -99.9 | -222.9 | -36.4 | -47.2 | -57.5 | -70.0 | -85.2 |
WACC, % | 11.41 | 12.12 | 12.12 | 12.12 | 12.12 | 11.98 | 11.98 | 11.98 | 11.98 | 11.98 |
PV UFCF | ||||||||||
SUM PV UFCF | -204.0 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -87 | |||||||||
Terminal Value | -871 | |||||||||
Present Terminal Value | -495 | |||||||||
Enterprise Value | -699 | |||||||||
Net Debt | 861 | |||||||||
Equity Value | -1,559 | |||||||||
Diluted Shares Outstanding, MM | 84 | |||||||||
Equity Value Per Share | -18.62 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real UPST financials.
- Real-World Data: Historical data and forward-looking estimates (as indicated in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe how your inputs affect Upstart’s valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.
Key Features
- Comprehensive Data Access: Upstart's historical financial statements and pre-filled projections.
- Customizable Parameters: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Insights: Monitor Upstart’s intrinsic value updates instantly.
- Intuitive Visualizations: Dashboard graphs showcase valuation outcomes and essential metrics.
- Designed for Precision: A robust tool tailored for analysts, investors, and financial professionals.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Upstart Holdings, Inc. (UPST) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Upstart Holdings, Inc. (UPST)’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Upstart Holdings, Inc. (UPST)?
- All-in-One Solution: Features DCF, WACC, and financial ratio analyses tailored for Upstart Holdings, Inc. (UPST).
- Flexible Inputs: Modify the yellow-highlighted cells to explore different financial scenarios.
- In-Depth Analysis: Automatically computes Upstart's intrinsic value and Net Present Value.
- Data Ready: Comes with historical and projected data for precise calculations.
- High-Caliber Tool: Perfect for financial analysts, investors, and business advisors focused on Upstart Holdings, Inc. (UPST).
Who Should Use This Product?
- Investors: Evaluate Upstart's valuation before making investment decisions.
- CFOs and Financial Analysts: Optimize valuation methodologies and assess financial forecasts.
- Startup Founders: Understand the valuation strategies of innovative companies like Upstart.
- Consultants: Provide comprehensive valuation analyses for clients in the fintech space.
- Students and Educators: Utilize real-time data to enhance learning and application of valuation principles.
What the Template Contains
- Preloaded UPST 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.