PLBY Group, Inc. (PLBY) DCF Valuation

PLBY Group, Inc. (PLBY) DCF Valuation

US | Consumer Cyclical | Leisure | NASDAQ
PLBY Group, Inc. (PLBY) 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

PLBY Group, Inc. (PLBY) Bundle

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

TOTAL:

Looking to assess the intrinsic value of PLBY Group, Inc.? Our PLBY DCF Calculator integrates real-world data with comprehensive customization features, allowing you to refine your forecasts and enhance your investment strategies.


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 78.1 147.7 246.6 266.9 143.0 185.1 239.6 310.2 401.5 519.8
Revenue Growth, % 0 89.04 66.99 8.26 -46.45 29.46 29.46 29.46 29.46 29.46
EBITDA .0 15.9 -53.4 -270.5 -164.1 -78.1 -101.1 -130.8 -169.4 -219.3
EBITDA, % -0.000629880937 10.75 -21.65 -101.34 -114.78 -42.18 -42.18 -42.18 -42.18 -42.18
Depreciation 3.1 2.3 13.8 18.2 12.8 9.9 12.9 16.7 21.6 27.9
Depreciation, % 3.96 1.53 5.58 6.8 8.98 5.37 5.37 5.37 5.37 5.37
EBIT -3.1 13.6 -67.1 -288.7 -176.9 -82.2 -106.4 -137.7 -178.3 -230.8
EBIT, % -3.96 9.22 -27.23 -108.15 -123.77 -44.39 -44.39 -44.39 -44.39 -44.39
Total Cash 27.7 13.4 69.2 31.6 28.1 38.6 49.9 64.7 83.7 108.4
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 6.8 7.8 14.2 16.8 10.7
Account Receivables, % 8.66 5.26 5.76 6.28 7.47
Inventories 11.8 11.8 39.9 33.1 13.0 22.5 29.1 37.6 48.7 63.1
Inventories, % 15.04 7.98 16.17 12.4 9.09 12.14 12.14 12.14 12.14 12.14
Accounts Payable 7.9 8.7 20.6 13.6 14.5 14.6 18.9 24.5 31.7 41.1
Accounts Payable, % 10.06 5.88 8.35 5.11 10.14 7.91 7.91 7.91 7.91 7.91
Capital Expenditure -4.2 -.9 -17.5 -8.0 -3.5 -6.9 -8.9 -11.5 -14.9 -19.3
Capital Expenditure, % -5.41 -0.59866 -7.1 -3.02 -2.48 -3.72 -3.72 -3.72 -3.72 -3.72
Tax Rate, % 9.89 9.89 9.89 9.89 9.89 9.89 9.89 9.89 9.89 9.89
EBITAT -3.1 -39.8 -65.9 -238.8 -159.4 -61.0 -78.9 -102.2 -132.3 -171.2
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -14.9 -38.7 -92.3 -231.4 -123.1 -68.9 -80.9 -104.8 -135.6 -175.6
WACC, % 11.89 4.81 11.76 10.66 11.19 10.06 10.06 10.06 10.06 10.06
PV UFCF
SUM PV UFCF -409.2
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) -179
Terminal Value -2,222
Present Terminal Value -1,376
Enterprise Value -1,785
Net Debt 194
Equity Value -1,979
Diluted Shares Outstanding, MM 71
Equity Value Per Share -27.74

What You Will Get

  • Real PLBY Financial Data: Pre-filled with PLBY Group’s historical and projected data for precise analysis.
  • Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
  • Automatic Calculations: See PLBY Group’s intrinsic value update instantly based on your changes.
  • Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
  • User-Friendly Design: Simple structure and clear instructions for all experience levels.

Key Features

  • Pre-Loaded Data: PLBY Group’s historical financial statements and pre-filled forecasts.
  • Fully Adjustable Inputs: Edit WACC, tax rates, revenue growth, and EBITDA margins.
  • Instant Results: See PLBY Group’s intrinsic value recalculate in real time.
  • Clear Visual Outputs: Dashboard charts display valuation results and key metrics.
  • Built for Accuracy: A professional tool for analysts, investors, and finance experts.

How It Works

  1. Download the Template: Gain immediate access to the Excel-based PLBY DCF Calculator.
  2. Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
  3. Instant Calculations: The model automatically recalculates PLBY Group’s intrinsic value.
  4. Test Scenarios: Experiment with different assumptions to assess potential changes in valuation.
  5. Analyze and Decide: Utilize the results to inform your investment or financial strategy.

Why Choose This Calculator for PLBY Group, Inc. (PLBY)?

  • Designed for Experts: A sophisticated tool utilized by financial analysts, CFOs, and industry consultants.
  • Accurate Financial Data: PLBY Group’s historical and projected financial figures preloaded for precision.
  • Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
  • Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
  • User-Friendly Interface: Step-by-step guidance ensures a smooth experience throughout the calculation process.

Who Should Use This Product?

  • Investors: Evaluate PLBY Group, Inc.'s (PLBY) market performance before making investment decisions.
  • CFOs and Financial Analysts: Optimize valuation methodologies and assess financial forecasts for PLBY.
  • Startup Founders: Gain insights into how companies like PLBY Group, Inc. are appraised in the market.
  • Consultants: Provide clients with comprehensive valuation analyses related to PLBY.
  • Students and Educators: Utilize current market data to explore and teach valuation principles using PLBY as a case study.

What the Template Contains

  • Pre-Filled Data: Includes PLBY Group, 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 PLBY Group, 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.