Berry Global Group, Inc. (BERY) DCF Valuation

Berry Global Group, Inc. (BERY) DCF Valuation
  • ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
  • ✓ Design Profissional: Modelos Confiáveis ​​E Padrão Da Indústria
  • ✓ Pré-Construídos Para Uso Rápido E Eficiente
  • ✓ Não É Necessária Experiência; Fácil De Seguir

Berry Global Group, Inc. (BERY) 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:

Simplify Berry Global Group, Inc. (BERY) valuation with this customizable DCF Calculator! Featuring real Berry Global Group, Inc. (BERY) financials and adjustable forecast inputs, you can test scenarios and uncover Berry Global Group, Inc. (BERY) fair value in minutes.


Discounted Cash Flow (DCF) - (USD MM)

Year AY1
2020		 AY2
2021		 AY3
2022		 AY4
2023		 AY5
2024		 FY1
2025		 FY2
2026		 FY3
2027		 FY4
2028		 FY5
2029
Revenue 11,709.0 13,850.0 14,495.0 12,664.0 12,258.0 12,475.7 12,697.3 12,922.8 13,152.3 13,385.9
Revenue Growth, % 0 18.29 4.66 -12.63 -3.21 1.78 1.78 1.78 1.78 1.78
EBITDA 2,118.0 2,197.0 2,020.0 1,966.0 937.0 1,772.9 1,804.4 1,836.5 1,869.1 1,902.3
EBITDA, % 18.09 15.86 13.94 15.52 7.64 14.21 14.21 14.21 14.21 14.21
Depreciation 845.0 854.0 819.0 818.0 .0 636.1 647.4 658.9 670.6 682.5
Depreciation, % 7.22 6.17 5.65 6.46 0 5.1 5.1 5.1 5.1 5.1
EBIT 1,273.0 1,343.0 1,201.0 1,148.0 937.0 1,136.9 1,157.1 1,177.6 1,198.5 1,219.8
EBIT, % 10.87 9.7 8.29 9.07 7.64 9.11 9.11 9.11 9.11 9.11
Total Cash 750.0 1,091.0 1,410.0 1,203.0 1,095.0 1,059.0 1,077.8 1,096.9 1,116.4 1,136.3
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 1,469.0 1,879.0 1,777.0 1,568.0 1,604.0
Account Receivables, % 12.55 13.57 12.26 12.38 13.09
Inventories 1,268.0 1,907.0 1,802.0 1,557.0 1,631.0 1,562.7 1,590.5 1,618.7 1,647.5 1,676.7
Inventories, % 10.83 13.77 12.43 12.29 13.31 12.53 12.53 12.53 12.53 12.53
Accounts Payable 1,115.0 2,041.0 1,795.0 1,528.0 1,766.0 1,574.8 1,602.8 1,631.3 1,660.2 1,689.7
Accounts Payable, % 9.52 14.74 12.38 12.07 14.41 12.62 12.62 12.62 12.62 12.62
Capital Expenditure -583.0 -676.0 -687.0 -689.0 -551.0 -612.2 -623.1 -634.1 -645.4 -656.9
Capital Expenditure, % -4.98 -4.88 -4.74 -5.44 -4.5 -4.91 -4.91 -4.91 -4.91 -4.91
Tax Rate, % 15.55 15.55 15.55 15.55 15.55 15.55 15.55 15.55 15.55 15.55
EBITAT 998.0 1,087.8 985.0 942.2 791.3 927.5 944.0 960.8 977.8 995.2
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -362.0 1,142.8 1,078.0 1,258.2 368.3 839.6 940.2 956.9 973.9 991.2
WACC, % 6.41 6.48 6.5 6.5 6.56 6.49 6.49 6.49 6.49 6.49
PV UFCF
SUM PV UFCF 3,891.1
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 1,011
Terminal Value 22,515
Present Terminal Value 16,440
Enterprise Value 20,331
Net Debt 7,754
Equity Value 12,577
Diluted Shares Outstanding, MM 118
Equity Value Per Share 106.86

What You Will Get

  • Real BERY Financial Data: Pre-filled with Berry Global’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 Berry Global’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

  • Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Berry Global Group, Inc. (BERY).
  • WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with adjustable inputs specific to Berry Global.
  • Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates as per your analysis needs.
  • Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios pertinent to Berry Global Group, Inc. (BERY).
  • Interactive Dashboard and Charts: Visual representations of key valuation metrics facilitate straightforward analysis.

How It Works

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

Why Choose This Calculator for Berry Global Group, Inc. (BERY)?

  • Comprehensive Tool: Combines DCF, WACC, and financial ratio analyses tailored for Berry Global Group.
  • Customizable Inputs: Modify yellow-highlighted cells to explore different financial scenarios.
  • Detailed Insights: Automatically computes Berry Global’s intrinsic value and Net Present Value.
  • Preloaded Data: Features historical and projected data for accurate analysis.
  • Professional Quality: Perfect for financial analysts, investors, and business consultants focusing on Berry Global Group.

Who Should Use This Product?

  • Professional Investors: Construct comprehensive and trustworthy valuation models for portfolio assessment of Berry Global Group, Inc. (BERY).
  • Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
  • Consultants and Advisors: Deliver precise valuation insights to clients investing in Berry Global Group, Inc. (BERY).
  • Students and Educators: Utilize real-time data to enhance learning and practice in financial modeling.
  • Manufacturing Sector Enthusiasts: Gain insights into how companies like Berry Global Group, Inc. (BERY) are appraised in the industry.

What the Template Contains

  • Comprehensive DCF Model: Editable template featuring in-depth valuation calculations.
  • Real-World Data: Berry Global Group, Inc.'s (BERY) historical and projected financials preloaded for analysis.
  • Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore various scenarios.
  • Financial Statements: Complete annual and quarterly breakdowns for enhanced insights.
  • Key Ratios: Integrated analysis for profitability, efficiency, and leverage metrics.
  • Dashboard with Visual Outputs: Visualizations including charts and tables for clear, actionable results.

No products were found matching.