|
Herbalife Nutrition Ltd. (HLF) DCF Valuation
US | Consumer Defensive | Packaged Foods | NYSE
|
- ✓ 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
Herbalife Nutrition Ltd. (HLF) Bundle
Evaluate Herbalife Nutrition Ltd.'s (HLF) financial outlook like a professional! This (HLF) DCF Calculator comes with pre-filled financial data and offers full flexibility to modify revenue growth, WACC, margins, and other essential assumptions to align with your projections.
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 | 4,877.1 | 5,541.8 | 5,802.8 | 5,204.4 | 5,062.4 | 5,129.5 | 5,197.4 | 5,266.2 | 5,336.0 | 5,406.7 |
| Revenue Growth, % | 0 | 13.63 | 4.71 | -10.31 | -2.73 | 1.32 | 1.32 | 1.32 | 1.32 | 1.32 |
| EBITDA | 678.8 | 740.9 | 854.6 | 672.7 | 482.2 | 661.3 | 670.1 | 679.0 | 688.0 | 697.1 |
| EBITDA, % | 13.92 | 13.37 | 14.73 | 12.93 | 9.53 | 12.89 | 12.89 | 12.89 | 12.89 | 12.89 |
| Depreciation | 97.7 | 100.3 | 107.6 | 115.4 | 113.3 | 103.8 | 105.2 | 106.6 | 108.0 | 109.5 |
| Depreciation, % | 2 | 1.81 | 1.85 | 2.22 | 2.24 | 2.02 | 2.02 | 2.02 | 2.02 | 2.02 |
| EBIT | 581.1 | 640.6 | 747.0 | 557.3 | 368.9 | 557.5 | 564.9 | 572.4 | 579.9 | 587.6 |
| EBIT, % | 11.91 | 11.56 | 12.87 | 10.71 | 7.29 | 10.87 | 10.87 | 10.87 | 10.87 | 10.87 |
| Total Cash | 839.4 | 1,045.4 | 601.5 | 508.0 | 575.2 | 693.1 | 702.3 | 711.6 | 721.0 | 730.6 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 79.7 | 83.3 | 66.9 | 70.6 | 81.2 | 74.4 | 75.4 | 76.4 | 77.4 | 78.4 |
| Account Receivables, % | 1.63 | 1.5 | 1.15 | 1.36 | 1.6 | 1.45 | 1.45 | 1.45 | 1.45 | 1.45 |
| Inventories | 436.2 | 501.4 | 575.7 | 580.7 | 505.2 | 503.2 | 509.9 | 516.6 | 523.5 | 530.4 |
| Inventories, % | 8.94 | 9.05 | 9.92 | 11.16 | 9.98 | 9.81 | 9.81 | 9.81 | 9.81 | 9.81 |
| Accounts Payable | 81.6 | 88.7 | 92.0 | 89.8 | 84.0 | 84.6 | 85.7 | 86.8 | 88.0 | 89.1 |
| Accounts Payable, % | 1.67 | 1.6 | 1.59 | 1.73 | 1.66 | 1.65 | 1.65 | 1.65 | 1.65 | 1.65 |
| Capital Expenditure | -106.1 | -112.0 | -151.4 | -156.4 | -135.0 | -128.0 | -129.7 | -131.4 | -133.2 | -134.9 |
| Capital Expenditure, % | -2.18 | -2.02 | -2.61 | -3.01 | -2.67 | -2.5 | -2.5 | -2.5 | -2.5 | -2.5 |
| Tax Rate, % | 29.95 | 29.95 | 29.95 | 29.95 | 29.95 | 29.95 | 29.95 | 29.95 | 29.95 | 29.95 |
| EBITAT | 400.4 | 462.2 | 595.7 | 421.5 | 258.4 | 408.6 | 414.0 | 419.5 | 425.1 | 430.7 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -42.3 | 388.8 | 497.3 | 369.6 | 295.8 | 393.9 | 383.0 | 388.1 | 393.2 | 398.4 |
| WACC, % | 5.27 | 5.43 | 5.8 | 5.6 | 5.33 | 5.49 | 5.49 | 5.49 | 5.49 | 5.49 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 1,670.9 | |||||||||
| Long Term Growth Rate, % | 0.50 | |||||||||
| Free cash flow (T + 1) | 400 | |||||||||
| Terminal Value | 8,031 | |||||||||
| Present Terminal Value | 6,149 | |||||||||
| Enterprise Value | 7,820 | |||||||||
| Net Debt | 2,194 | |||||||||
| Equity Value | 5,626 | |||||||||
| Diluted Shares Outstanding, MM | 100 | |||||||||
| Equity Value Per Share | 56.14 |
What You Will Receive
- Pre-Filled Financial Model: Herbalife Nutrition Ltd.'s (HLF) actual data provides an accurate DCF valuation.
- Comprehensive Forecast Control: Modify revenue growth, profit margins, WACC, and other essential drivers.
- Real-Time Calculations: Automatic updates allow you to view results instantly as adjustments are made.
- Investor-Ready Template: A polished Excel file crafted for high-quality valuation presentations.
- Customizable and Reusable: Designed for adaptability, enabling repeated use for in-depth forecasting.
Key Features
- Customizable Nutritional Metrics: Adjust essential inputs such as product sales growth, profit margins, and marketing expenses.
- Instant Nutritional Valuation: Quickly calculates intrinsic value, NPV, and other key financial indicators.
- High-Precision Analytics: Utilizes Herbalife’s actual financial data for accurate valuation results.
- Effortless Scenario Testing: Easily evaluate various assumptions and analyze the resulting outcomes.
- Efficiency Booster: Avoid the hassle of developing intricate valuation models from the ground up.
How It Works
- Download the Template: Gain immediate access to the Excel-based HLF DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model automatically recalculates Herbalife’s intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the outcomes to inform your investment or financial strategy.
Why Choose Herbalife Nutrition Ltd. (HLF)?
- Boost Your Wellness: Access a range of nutritional products designed to support a healthy lifestyle.
- Proven Quality: Our products undergo rigorous testing to ensure safety and effectiveness.
- Personalized Solutions: Tailor your nutrition plan to meet your individual health goals.
- Community Support: Join a global network of wellness coaches and customers for motivation and guidance.
- Expert Backing: Developed by nutritionists and health professionals to provide trusted solutions.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Herbalife Nutrition Ltd. (HLF) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for Herbalife Nutrition Ltd. (HLF).
- Consultants: Deliver professional valuation insights on Herbalife Nutrition Ltd. (HLF) to clients quickly and accurately.
- Business Owners: Understand how companies like Herbalife Nutrition Ltd. (HLF) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to Herbalife Nutrition Ltd. (HLF).
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Herbalife Nutrition Ltd. (HLF) 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 Herbalife Nutrition Ltd. (HLF).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.