Sonder Holdings Inc. (SOND) 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
Sonder Holdings Inc. (SOND) Bundle
Explore the financial prospects of Sonder Holdings Inc. (SOND) with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to determine the intrinsic value of Sonder Holdings Inc. (SOND) and shape your investment approach.
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 | 142.9 | 115.7 | 232.9 | 461.1 | 602.1 | 917.3 | 1,397.7 | 2,129.6 | 3,244.7 | 4,943.8 |
Revenue Growth, % | 0 | -19.06 | 101.37 | 97.94 | 30.58 | 52.36 | 52.36 | 52.36 | 52.36 | 52.36 |
EBITDA | -165.9 | -226.9 | -232.3 | -56.6 | -64.3 | -592.0 | -902.1 | -1,374.4 | -2,094.2 | -3,190.8 |
EBITDA, % | -116.12 | -196.11 | -99.74 | -12.28 | -10.68 | -64.54 | -64.54 | -64.54 | -64.54 | -64.54 |
Depreciation | 11.2 | 17.0 | 17.7 | 169.2 | 206.9 | 185.5 | 282.7 | 430.8 | 656.3 | 1,000.0 |
Depreciation, % | 7.81 | 14.67 | 7.6 | 36.69 | 34.36 | 20.23 | 20.23 | 20.23 | 20.23 | 20.23 |
EBIT | -177.1 | -243.8 | -250.1 | -225.8 | -271.2 | -722.9 | -1,101.4 | -1,678.1 | -2,556.9 | -3,895.8 |
EBIT, % | -123.94 | -210.78 | -107.35 | -48.96 | -45.04 | -78.8 | -78.8 | -78.8 | -78.8 | -78.8 |
Total Cash | 110.9 | 121.5 | .3 | 246.6 | 95.8 | 453.4 | 690.8 | 1,052.5 | 1,603.7 | 2,443.4 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 6.0 | 1.8 | 4.6 | 6.5 | 8.0 | 19.2 | 29.2 | 44.5 | 67.8 | 103.3 |
Account Receivables, % | 4.19 | 1.53 | 1.99 | 1.4 | 1.33 | 2.09 | 2.09 | 2.09 | 2.09 | 2.09 |
Inventories | 20.9 | 14.7 | -11.4 | 51.6 | .0 | 61.6 | 93.9 | 143.0 | 217.9 | 332.0 |
Inventories, % | 14.6 | 12.67 | -4.88 | 11.18 | 0 | 6.72 | 6.72 | 6.72 | 6.72 | 6.72 |
Accounts Payable | 7.1 | 10.9 | 19.1 | 16.5 | 23.6 | 55.2 | 84.1 | 128.2 | 195.3 | 297.6 |
Accounts Payable, % | 4.98 | 9.44 | 8.2 | 3.57 | 3.91 | 6.02 | 6.02 | 6.02 | 6.02 | 6.02 |
Capital Expenditure | -24.3 | -14.9 | -21.6 | -31.0 | -12.4 | -87.8 | -133.8 | -203.8 | -310.5 | -473.2 |
Capital Expenditure, % | -16.97 | -12.84 | -9.27 | -6.72 | -2.05 | -9.57 | -9.57 | -9.57 | -9.57 | -9.57 |
Tax Rate, % | 0.31456 | 0.31456 | 0.31456 | 0.31456 | 0.31456 | 0.31456 | 0.31456 | 0.31456 | 0.31456 | 0.31456 |
EBITAT | -172.3 | -244.1 | -248.6 | -226.5 | -270.3 | -717.6 | -1,093.4 | -1,665.9 | -2,538.2 | -3,867.4 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -205.1 | -227.8 | -221.1 | -155.7 | -18.7 | -661.0 | -957.8 | -1,459.3 | -2,223.5 | -3,387.9 |
WACC, % | 4.47 | 4.59 | 4.57 | 4.59 | 4.58 | 4.56 | 4.56 | 4.56 | 4.56 | 4.56 |
PV UFCF | ||||||||||
SUM PV UFCF | -7,355.3 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -3,456 | |||||||||
Terminal Value | -134,863 | |||||||||
Present Terminal Value | -107,899 | |||||||||
Enterprise Value | -115,254 | |||||||||
Net Debt | 1,663 | |||||||||
Equity Value | -116,918 | |||||||||
Diluted Shares Outstanding, MM | 11 | |||||||||
Equity Value Per Share | -10,693.91 |
What You Will Receive
- Adjustable Forecast Parameters: Effortlessly modify key assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Insights: Sonder Holdings Inc.’s financial data pre-loaded to facilitate your analysis.
- Automated DCF Calculations: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Customizable and Professional Design: A refined Excel model tailored to meet your valuation requirements.
- Designed for Analysts and Investors: Perfect for evaluating projections, validating strategies, and enhancing efficiency.
Key Features
- 🔍 Real-Life SOND Financials: Pre-filled historical and projected data for Sonder Holdings Inc.
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Sonder’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Sonder’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Sonder Holdings Inc. (SOND) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Sonder Holdings Inc.'s (SOND) intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Sonder Holdings Inc. (SOND)?
- Accurate Data: Up-to-date Sonder Holdings financials provide trustworthy valuation outcomes.
- Customizable: Modify essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-configured calculations save you the effort of starting from scratch.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants in the real estate sector.
- User-Friendly: Clear layout and guided instructions ensure accessibility for all users.
Who Should Use Sonder Holdings Inc. (SOND)?
- Real Estate Investors: Leverage innovative technology to make informed investment choices.
- Market Analysts: Streamline your analysis with comprehensive data on short-term rental markets.
- Hospitality Consultants: Easily customize reports for clients in the hospitality sector.
- Travel Enthusiasts: Enhance your knowledge of the evolving rental landscape with practical insights.
- Educators and Students: Utilize it as a hands-on resource in courses related to real estate and hospitality management.
What the Template Contains
- Preloaded SOND 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.