Reed's, Inc. (REED) DCF Valuation

Reed's, Inc. (REED) DCF Valuation
  • ✓ 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

Reed's, Inc. (REED) 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:

Enhance your investment strategies with the Reed's, Inc. (REED) DCF Calculator! Utilize real financial data from Reed's, adjust growth projections and expenses, and instantly view how these modifications affect the intrinsic value of Reed's, Inc. (REED).


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 33.8 41.6 49.6 53.0 44.7 48.5 52.5 56.9 61.7 66.8
Revenue Growth, % 0 23.05 19.19 6.94 -15.7 8.37 8.37 8.37 8.37 8.37
EBITDA -14.7 -8.7 -15.0 -14.7 -9.3 -13.8 -15.0 -16.3 -17.6 -19.1
EBITDA, % -43.39 -20.82 -30.16 -27.76 -20.74 -28.58 -28.58 -28.58 -28.58 -28.58
Depreciation .2 .2 .2 .2 .1 .2 .2 .2 .3 .3
Depreciation, % 0.44944 0.49021 0.48993 0.4242 0.3176 0.43427 0.43427 0.43427 0.43427 0.43427
EBIT -14.8 -8.9 -15.2 -15.0 -9.4 -14.1 -15.2 -16.5 -17.9 -19.4
EBIT, % -43.84 -21.31 -30.65 -28.19 -21.06 -29.01 -29.01 -29.01 -29.01 -29.01
Total Cash .9 .6 .0 .5 .6 .6 .7 .7 .8 .9
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 2.1 5.4 6.1 5.7 5.0
Account Receivables, % 6.21 12.98 12.33 10.69 11.29
Inventories 10.5 11.1 17.0 16.2 11.3 14.3 15.5 16.8 18.2 19.8
Inventories, % 31.07 26.72 34.37 30.5 25.27 29.59 29.59 29.59 29.59 29.59
Accounts Payable 5.5 6.7 10.4 9.8 9.1 9.0 9.7 10.5 11.4 12.4
Accounts Payable, % 16.38 16.21 21.04 18.49 20.43 18.51 18.51 18.51 18.51 18.51
Capital Expenditure -.3 -.2 -.3 .0 -.1 -.2 -.2 -.3 -.3 -.3
Capital Expenditure, % -0.9521 -0.38688 -0.67542 -0.00377067 -0.19682 -0.443 -0.443 -0.443 -0.443 -0.443
Tax Rate, % 0 0 0 0 0 0 0 0 0 0
EBITAT -16.0 -10.0 -16.3 -14.9 -9.4 -14.0 -15.2 -16.5 -17.9 -19.4
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -23.2 -12.7 -19.4 -14.0 -4.5 -17.4 -16.1 -17.4 -18.9 -20.5
WACC, % 21.14 21.14 21.14 21.03 21.14 21.12 21.12 21.12 21.12 21.12
PV UFCF
SUM PV UFCF -51.8
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) -21
Terminal Value -109
Present Terminal Value -42
Enterprise Value -94
Net Debt 27
Equity Value -121
Diluted Shares Outstanding, MM 4
Equity Value Per Share -34.12

What You Will Get

  • Editable Forecast Inputs: Effortlessly adjust assumptions (growth %, margins, WACC) to explore various scenarios.
  • Real-World Data: Reed's, Inc. (REED) financial data pre-loaded to kickstart your analysis.
  • Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value for you.
  • Customizable and Professional: A sleek Excel model that caters to your valuation requirements.
  • Built for Analysts and Investors: Perfect for testing projections, validating strategies, and enhancing efficiency.

Key Features

  • Real-Life REED Data: Pre-filled with Reed's, Inc.'s historical financials and forward-looking projections.
  • Fully Customizable Inputs: Modify revenue growth, 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 outcomes.
  • User-Friendly Design: Intuitive, organized, and tailored for both professionals and novices.

How It Works

  1. Download the Template: Gain immediate access to the Excel-based REED DCF Calculator.
  2. Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and additional parameters.
  3. Instant Calculations: The model will automatically compute Reed's intrinsic value.
  4. Test Scenarios: Experiment with various assumptions to assess potential valuation shifts.
  5. Analyze and Decide: Leverage the results to inform your investment or financial analysis.

Why Choose Reed's, Inc. (REED)?

  • Time Efficiency: Skip the lengthy research – our insights are readily available.
  • Enhanced Precision: Dependable market data and analytics minimize valuation discrepancies.
  • Completely Adaptable: Adjust the framework to align with your specific forecasts and assumptions.
  • User-Friendly: Intuitive graphs and outputs simplify result interpretation.
  • Endorsed by Professionals: Crafted for industry experts who prioritize accuracy and functionality.

Who Should Use This Product?

  • Finance Students: Explore financial modeling techniques and apply them to real-world data, particularly for Reed's, Inc. (REED).
  • Academics: Integrate advanced valuation models into your research or teaching focused on the beverage industry.
  • Investors: Validate your investment strategies and evaluate the performance metrics of Reed's, Inc. (REED).
  • Analysts: Enhance your analysis process with a customizable financial model tailored for Reed's, Inc. (REED).
  • Small Business Owners: Understand how publicly traded companies like Reed's, Inc. (REED) are assessed and valued in the market.

What the Template Contains

  • Pre-Filled Data: Includes Reed's, Inc.'s historical financials and forecasts.
  • Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
  • Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
  • Key Financial Ratios: Analyze Reed's, Inc.'s profitability, efficiency, and leverage.
  • Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
  • Clear Dashboard: Charts and tables summarizing key valuation results.

No products were found matching.