Solo Brands, Inc. (DTC) DCF Valuation

Solo Brands, Inc. (DTC) 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

Solo Brands, Inc. (DTC) Bundle

DCF model
Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

Explore Solo Brands, Inc. (DTC) financial potential with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to determine the intrinsic value of Solo Brands, Inc. (DTC) and refine 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 39.9 133.4 403.7 517.6 494.8 771.6 1,203.3 1,876.6 2,926.5 4,563.9
Revenue Growth, % 0 234.81 202.57 28.22 -4.41 55.95 55.95 55.95 55.95 55.95
EBITDA -28.2 -15.2 87.1 58.4 48.5 -60.9 -95.0 -148.2 -231.1 -360.4
EBITDA, % -70.73 -11.41 21.57 11.29 9.8 -7.9 -7.9 -7.9 -7.9 -7.9
Depreciation .8 5.7 18.2 24.6 27.3 32.6 50.8 79.2 123.6 192.7
Depreciation, % 2.07 4.25 4.52 4.75 5.53 4.22 4.22 4.22 4.22 4.22
EBIT -29.0 -20.9 68.9 33.9 21.1 -93.5 -145.8 -227.4 -354.7 -553.1
EBIT, % -72.8 -15.66 17.06 6.54 4.27 -12.12 -12.12 -12.12 -12.12 -12.12
Total Cash 5.0 32.8 25.1 23.3 19.8 80.1 124.9 194.7 303.7 473.6
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 1.3 4.2 21.5 26.2 53.5
Account Receivables, % 3.21 3.12 5.33 5.06 10.81
Inventories 5.8 14.3 102.3 133.0 116.6 154.3 240.7 375.3 585.3 912.8
Inventories, % 14.65 10.75 25.35 25.69 23.56 20 20 20 20 20
Accounts Payable .1 1.4 11.8 11.8 21.8 16.7 26.1 40.6 63.4 98.8
Accounts Payable, % 0.1882 1.03 2.92 2.28 4.42 2.17 2.17 2.17 2.17 2.17
Capital Expenditure -.1 -1.0 -10.6 -9.2 -9.1 -11.2 -17.5 -27.3 -42.6 -66.4
Capital Expenditure, % -0.2961 -0.71799 -2.64 -1.79 -1.84 -1.45 -1.45 -1.45 -1.45 -1.45
Tax Rate, % 51.91 51.91 51.91 51.91 51.91 51.91 51.91 51.91 51.91 51.91
EBITAT -29.0 -21.0 57.3 39.0 10.2 -80.6 -125.8 -196.1 -305.9 -477.0
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -35.4 -26.4 -30.1 19.0 27.6 -91.2 -193.2 -301.4 -470.0 -732.9
WACC, % 8.87 8.87 8.12 8.87 6.58 8.26 8.26 8.26 8.26 8.26
PV UFCF
SUM PV UFCF -1,321.6
Long Term Growth Rate, % 4.00
Free cash flow (T + 1) -762
Terminal Value -17,890
Present Terminal Value -12,030
Enterprise Value -13,351
Net Debt 163
Equity Value -13,514
Diluted Shares Outstanding, MM 61
Equity Value Per Share -223.37

What You Will Receive

  • Genuine DTC Financial Data: Pre-loaded with Solo Brands’ historical and forecasted data for accurate analysis.
  • Completely Customizable Template: Easily adjust key inputs such as revenue growth, WACC, and EBITDA %.
  • Instant Calculations: Watch Solo Brands’ intrinsic value refresh automatically based on your modifications.
  • Expert Valuation Tool: Tailored for investors, analysts, and consultants aiming for precise DCF outcomes.
  • Intuitive Design: Straightforward layout and clear guidelines suitable for all skill levels.

Key Features

  • Genuine Solo Brands Financials: Gain access to precise pre-loaded historical data and future forecasts.
  • Adjustable Forecast Parameters: Modify yellow-highlighted cells such as WACC, growth rates, and profit margins.
  • Real-time Calculations: Automatic updates for DCF, Net Present Value (NPV), and cash flow assessments.
  • Interactive Dashboard: User-friendly charts and summaries to help visualize your valuation outcomes.
  • Designed for All Skill Levels: A straightforward, intuitive layout tailored for investors, CFOs, and consultants alike.

How It Works

  1. Step 1: Download the Excel file for Solo Brands, Inc. (DTC) [DTC].
  2. Step 2: Review Solo Brands' pre-filled financial data and forecasts.
  3. Step 3: Modify key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
  4. Step 4: Observe the DCF model update in real-time as you adjust your assumptions.
  5. Step 5: Analyze the outputs and leverage the results for your investment decisions.

Why Choose This Calculator for Solo Brands, Inc. (DTC)?

  • User-Friendly Interface: Perfectly crafted for both novices and seasoned users.
  • Customizable Inputs: Easily adjust parameters to suit your financial analysis needs.
  • Real-Time Feedback: Instantly observe changes in Solo Brands’ valuation as you modify inputs.
  • Pre-Loaded Data: Comes equipped with Solo Brands’ actual financial metrics for swift evaluations.
  • Relied Upon by Experts: A favorite tool among investors and analysts for making strategic decisions.

Who Should Use This Product?

  • Retail Investors: Create comprehensive and accurate valuation models for Solo Brands, Inc. (DTC).
  • Corporate Strategy Teams: Evaluate valuation scenarios to inform business strategy and decision-making.
  • Financial Consultants: Offer clients precise valuation assessments for Solo Brands, Inc. (DTC).
  • Students and Instructors: Utilize real market data to enhance learning and practice in financial modeling.
  • Outdoor Enthusiasts: Gain insights into how companies like Solo Brands, Inc. (DTC) are valued within the outdoor retail sector.

What the Template Contains

  • Pre-Filled Data: Includes Solo Brands, Inc.'s (DTC) historical financials and projections.
  • Discounted Cash Flow Model: Editable DCF valuation model featuring automatic calculations.
  • Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on tailored inputs.
  • Key Financial Ratios: Evaluate Solo Brands, Inc.'s (DTC) profitability, efficiency, and leverage metrics.
  • Customizable Inputs: Easily modify revenue growth, margins, and tax rates.
  • Clear Dashboard: Visuals and tables summarizing essential valuation outcomes.

No products were found matching.