Hanesbrands Inc. (HBI) DCF Valuation

Hanesbrands Inc. (HBI) 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

Hanesbrands Inc. (HBI) 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:

Gain insights into your Hanesbrands Inc. (HBI) valuation analysis using our sophisticated DCF Calculator! Featuring real (HBI) data preloaded, this Excel template enables you to customize forecasts and assumptions to accurately determine the intrinsic value of Hanesbrands Inc. (HBI).


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 6,966.9 6,664.4 6,801.2 6,233.7 5,636.5 5,351.7 5,081.2 4,824.5 4,580.7 4,349.2
Revenue Growth, % 0 -4.34 2.05 -8.35 -9.58 -5.05 -5.05 -5.05 -5.05 -5.05
EBITDA 1,024.2 156.3 860.7 700.6 363.4 507.2 481.6 457.2 434.1 412.2
EBITDA, % 14.7 2.34 12.66 11.24 6.45 9.48 9.48 9.48 9.48 9.48
Depreciation 131.0 126.6 112.7 106.3 105.0 96.4 91.5 86.9 82.5 78.3
Depreciation, % 1.88 1.9 1.66 1.7 1.86 1.8 1.8 1.8 1.8 1.8
EBIT 893.2 29.6 748.0 594.3 258.3 410.8 390.0 370.3 351.6 333.8
EBIT, % 12.82 0.44487 11 9.53 4.58 7.68 7.68 7.68 7.68 7.68
Total Cash 328.9 909.4 536.3 238.4 205.5 360.9 342.7 325.4 308.9 293.3
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 815.2 768.2 894.2 721.4 557.7
Account Receivables, % 11.7 11.53 13.15 11.57 9.89
Inventories 1,905.8 1,491.1 1,584.0 1,979.7 1,368.0 1,381.3 1,311.5 1,245.2 1,182.3 1,122.5
Inventories, % 27.36 22.37 23.29 31.76 24.27 25.81 25.81 25.81 25.81 25.81
Accounts Payable 959.0 891.9 1,214.8 917.5 736.3 779.1 739.7 702.4 666.9 633.2
Accounts Payable, % 13.77 13.38 17.86 14.72 13.06 14.56 14.56 14.56 14.56 14.56
Capital Expenditure -101.1 -53.7 -69.3 -215.1 -44.1 -80.4 -76.3 -72.4 -68.8 -65.3
Capital Expenditure, % -1.45 -0.80631 -1.02 -3.45 -0.78162 -1.5 -1.5 -1.5 -1.5 -1.5
Tax Rate, % 29.36 29.36 29.36 29.36 29.36 29.36 29.36 29.36 29.36 29.36
EBITAT 789.4 12.2 670.6 -221.0 182.5 238.2 226.2 214.8 203.9 193.6
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -942.8 479.7 818.2 -850.1 837.6 222.5 303.1 287.8 273.3 259.4
WACC, % 8.83 6.88 8.88 5.17 8.1 7.57 7.57 7.57 7.57 7.57
PV UFCF
SUM PV UFCF 1,084.1
Long Term Growth Rate, % 0.50
Free cash flow (T + 1) 261
Terminal Value 3,686
Present Terminal Value 2,559
Enterprise Value 3,643
Net Debt 3,560
Equity Value 83
Diluted Shares Outstanding, MM 351
Equity Value Per Share 0.24

What You Will Get

  • Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to explore various scenarios.
  • Real-World Data: Hanesbrands Inc. (HBI)’s financial data pre-filled to kickstart your analysis.
  • Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value for you.
  • Customizable and Professional: A refined Excel model that customizes to your valuation requirements.
  • Built for Analysts and Investors: Perfect for testing forecasts, validating strategies, and enhancing efficiency.

Key Features

  • Real-Time HBI Data: Pre-loaded with Hanesbrands Inc.'s historical financials and future projections.
  • Customizable Inputs: Modify revenue growth, profit margins, WACC, tax rates, and capital expenditures to suit your analysis.
  • Interactive Valuation Model: Automatically refreshes Net Present Value (NPV) and intrinsic value based on your adjustments.
  • Scenario Analysis: Develop various forecast scenarios to explore different valuation possibilities.
  • Intuitive Design: Easy to navigate, structured for both professionals and newcomers to finance.

How It Works

  1. Step 1: Download the Excel file for Hanesbrands Inc. (HBI).
  2. Step 2: Review Hanesbrands’ 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 assumptions.
  5. Step 5: Analyze the outputs and leverage the results for your investment decisions.

Why Choose This Calculator for Hanesbrands Inc. (HBI)?

  • All-in-One Solution: Integrates DCF, WACC, and key financial ratios for a comprehensive analysis.
  • Flexible Inputs: Modify the highlighted fields to explore different financial scenarios.
  • In-Depth Analysis: Automatically computes Hanesbrands’ intrinsic value and Net Present Value.
  • Preloaded Information: Access historical and projected data for precise calculations.
  • High-Quality Standards: Perfect for financial analysts, investors, and business advisors.

Who Should Use This Product?

  • Professional Investors: Develop comprehensive valuation models for analyzing Hanesbrands Inc. (HBI) stock.
  • Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions for Hanesbrands Inc. (HBI).
  • Consultants and Advisors: Offer clients precise valuation insights regarding Hanesbrands Inc. (HBI).
  • Students and Educators: Utilize real-world data to enhance financial modeling skills related to Hanesbrands Inc. (HBI).
  • Apparel Industry Enthusiasts: Gain insights into how companies like Hanesbrands Inc. (HBI) are valued within the market.

What the Template Contains

  • Pre-Filled DCF Model: Hanesbrands Inc. (HBI)’s financial data preloaded for immediate use.
  • WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
  • Financial Ratios: Evaluate Hanesbrands Inc. (HBI)’s profitability, leverage, and efficiency.
  • Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
  • Financial Statements: Annual and quarterly reports to support detailed analysis.
  • Interactive Dashboard: Easily visualize key valuation metrics and results.

No products were found matching.