Ranpak Holdings Corp. (PACK) DCF Valuation

Ranpak Holdings Corp. (PACK) 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

Ranpak Holdings Corp. (PACK) 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:

Discover the true potential of Ranpak Holdings Corp. (PACK) with our advanced DCF Calculator! Adjust essential assumptions, explore various scenarios, and evaluate how fluctuations affect Ranpak Holdings Corp. (PACK) valuation – all within one comprehensive Excel template.


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 269.5 298.2 383.9 326.5 336.3 359.4 384.0 410.4 438.5 468.6
Revenue Growth, % 0 10.65 28.74 -14.95 3 6.86 6.86 6.86 6.86 6.86
EBITDA 55.4 79.3 87.6 31.7 55.4 69.1 73.9 78.9 84.3 90.1
EBITDA, % 20.56 26.59 22.82 9.71 16.47 19.23 19.23 19.23 19.23 19.23
Depreciation 58.3 62.7 73.6 69.0 69.6 74.5 79.6 85.1 90.9 97.2
Depreciation, % 21.64 21.03 19.17 21.13 20.7 20.73 20.73 20.73 20.73 20.73
EBIT -2.9 16.6 14.0 -37.3 -14.2 -5.4 -5.8 -6.2 -6.6 -7.0
EBIT, % -1.08 5.57 3.65 -11.42 -4.22 -1.5 -1.5 -1.5 -1.5 -1.5
Total Cash 19.7 48.5 103.9 62.8 62.0 63.5 67.8 72.5 77.4 82.8
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 37.6 39.2 46.4 35.1 32.5
Account Receivables, % 13.95 13.15 12.09 10.75 9.66
Inventories 11.6 16.1 32.9 25.0 17.3 22.3 23.9 25.5 27.3 29.1
Inventories, % 4.3 5.4 8.57 7.66 5.14 6.21 6.21 6.21 6.21 6.21
Accounts Payable 12.3 24.9 33.5 24.3 17.6 24.7 26.4 28.2 30.1 32.2
Accounts Payable, % 4.56 8.35 8.73 7.44 5.23 6.86 6.86 6.86 6.86 6.86
Capital Expenditure -30.4 -33.2 -55.7 -45.4 -55.3 -48.4 -51.7 -55.2 -59.0 -63.0
Capital Expenditure, % -11.28 -11.13 -14.51 -13.91 -16.44 -13.45 -13.45 -13.45 -13.45 -13.45
Tax Rate, % 13.42 13.42 13.42 13.42 13.42 13.42 13.42 13.42 13.42 13.42
EBITAT -2.4 15.8 8.0 -27.2 -12.3 -4.3 -4.6 -4.9 -5.2 -5.6
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -11.4 51.8 10.5 6.4 5.6 13.6 20.6 22.0 23.5 25.1
WACC, % 11 11.27 10.35 10.73 11.06 10.88 10.88 10.88 10.88 10.88
PV UFCF
SUM PV UFCF 75.7
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 26
Terminal Value 289
Present Terminal Value 172
Enterprise Value 248
Net Debt 367
Equity Value -119
Diluted Shares Outstanding, MM 82
Equity Value Per Share -1.44

What You Will Get

  • Real PACK Financials: Access to historical and projected data for precise valuation.
  • Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
  • Instant Calculations: Intrinsic value and NPV are computed in real-time.
  • Scenario Analysis: Evaluate various scenarios to assess Ranpak's future performance.
  • User-Friendly Design: Designed for professionals while remaining approachable for newcomers.

Key Features

  • Real-Life PACK Data: Pre-filled with Ranpak Holdings Corp.'s historical financials and future projections.
  • Fully Customizable Inputs: Modify revenue growth, profit margins, WACC, tax rates, and capital expenditures to fit your analysis.
  • Dynamic Valuation Model: Automatic recalculations of Net Present Value (NPV) and intrinsic value based on your specifications.
  • Scenario Testing: Develop various forecast scenarios to evaluate different valuation possibilities.
  • User-Friendly Design: Intuitive, organized, and crafted for both professionals and novices.

How It Works

  1. Step 1: Download the Excel file.
  2. Step 2: Review Ranpak Holdings Corp.'s pre-filled financial data and forecasts.
  3. Step 3: Modify critical inputs like revenue growth, WACC, and tax rates (highlighted cells).
  4. Step 4: Watch the DCF model update instantly as you tweak assumptions.
  5. Step 5: Analyze the outputs and use the results for investment decisions regarding Ranpak Holdings Corp. (PACK).

Why Choose Ranpak Holdings Corp. (PACK) Solutions?

  • Enhance Efficiency: Streamlined packaging solutions that save time and resources.
  • Boost Sustainability: Eco-friendly materials that support your green initiatives.
  • Fully Adaptable: Customize packaging options to meet your specific needs and requirements.
  • User-Friendly: Intuitive designs and easy implementation for seamless integration.
  • Backed by Industry Leaders: Trusted by experts in the packaging sector for quality and innovation.

Who Should Use This Product?

  • Individual Investors: Make informed decisions about buying or selling Ranpak Holdings Corp. (PACK) stock.
  • Financial Analysts: Streamline valuation processes with ready-to-use financial models for Ranpak Holdings Corp. (PACK).
  • Consultants: Deliver professional valuation insights on Ranpak Holdings Corp. (PACK) to clients quickly and accurately.
  • Business Owners: Understand how companies like Ranpak Holdings Corp. (PACK) are valued to guide your own strategy.
  • Finance Students: Learn valuation techniques using real-world data and scenarios related to Ranpak Holdings Corp. (PACK).

What the Template Contains

  • Operating and Balance Sheet Data: Pre-filled Ranpak Holdings Corp. (PACK) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
  • WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
  • DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
  • Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
  • Key Ratios: Includes profitability, leverage, and efficiency ratios for Ranpak Holdings Corp. (PACK).
  • Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.

No products were found matching.