Levi Strauss & Co. (LEVI) 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
Levi Strauss & Co. (LEVI) Bundle
Simplify Levi Strauss & Co. (LEVI) valuation with this customizable DCF Calculator! Featuring real Levi Strauss & Co. (LEVI) financials and adjustable forecast inputs, you can test scenarios and uncover Levi Strauss & Co. (LEVI) fair value in minutes.
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 | 5,763.1 | 4,452.6 | 5,763.9 | 6,168.6 | 6,179.0 | 6,393.7 | 6,615.9 | 6,845.8 | 7,083.8 | 7,329.9 |
Revenue Growth, % | 0 | -22.74 | 29.45 | 7.02 | 0.1686 | 3.48 | 3.48 | 3.48 | 3.48 | 3.48 |
EBITDA | 667.8 | 34.2 | 796.3 | 834.2 | 476.4 | 606.2 | 627.2 | 649.0 | 671.6 | 694.9 |
EBITDA, % | 11.59 | 0.76813 | 13.82 | 13.52 | 7.71 | 9.48 | 9.48 | 9.48 | 9.48 | 9.48 |
Depreciation | 123.9 | 141.8 | 143.2 | 158.9 | 165.3 | 167.1 | 172.9 | 179.0 | 185.2 | 191.6 |
Depreciation, % | 2.15 | 3.18 | 2.48 | 2.58 | 2.68 | 2.61 | 2.61 | 2.61 | 2.61 | 2.61 |
EBIT | 543.8 | -107.6 | 653.1 | 675.3 | 311.1 | 439.0 | 454.3 | 470.1 | 486.4 | 503.3 |
EBIT, % | 9.44 | -2.42 | 11.33 | 10.95 | 5.03 | 6.87 | 6.87 | 6.87 | 6.87 | 6.87 |
Total Cash | 1,015.0 | 1,593.7 | 901.8 | 500.2 | 398.8 | 1,069.2 | 1,106.4 | 1,144.8 | 1,184.6 | 1,225.7 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 782.8 | 540.2 | 707.6 | 697.0 | 752.7 | 786.1 | 813.4 | 841.7 | 870.9 | 901.2 |
Account Receivables, % | 13.58 | 12.13 | 12.28 | 11.3 | 12.18 | 12.29 | 12.29 | 12.29 | 12.29 | 12.29 |
Inventories | 884.2 | 817.7 | 898.0 | 1,416.8 | 1,290.1 | 1,190.9 | 1,232.3 | 1,275.1 | 1,319.4 | 1,365.3 |
Inventories, % | 15.34 | 18.36 | 15.58 | 22.97 | 20.88 | 18.63 | 18.63 | 18.63 | 18.63 | 18.63 |
Accounts Payable | 360.3 | 375.5 | 524.8 | 657.2 | 567.9 | 558.0 | 577.4 | 597.4 | 618.2 | 639.7 |
Accounts Payable, % | 6.25 | 8.43 | 9.1 | 10.65 | 9.19 | 8.73 | 8.73 | 8.73 | 8.73 | 8.73 |
Capital Expenditure | -175.4 | -130.4 | -166.9 | -267.1 | -315.5 | -234.1 | -242.2 | -250.6 | -259.3 | -268.3 |
Capital Expenditure, % | -3.04 | -2.93 | -2.9 | -4.33 | -5.11 | -3.66 | -3.66 | -3.66 | -3.66 | -3.66 |
Tax Rate, % | 5.88 | 5.88 | 5.88 | 5.88 | 5.88 | 5.88 | 5.88 | 5.88 | 5.88 | 5.88 |
EBITAT | 449.4 | -72.1 | 623.1 | 591.6 | 292.8 | 374.7 | 387.7 | 401.2 | 415.2 | 429.6 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -908.8 | 263.6 | 501.0 | 107.6 | 124.3 | 363.6 | 269.2 | 278.5 | 288.2 | 298.2 |
WACC, % | 8.47 | 8.31 | 8.61 | 8.53 | 8.6 | 8.5 | 8.5 | 8.5 | 8.5 | 8.5 |
PV UFCF | ||||||||||
SUM PV UFCF | 1,188.1 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 304 | |||||||||
Terminal Value | 4,679 | |||||||||
Present Terminal Value | 3,111 | |||||||||
Enterprise Value | 4,300 | |||||||||
Net Debt | 1,782 | |||||||||
Equity Value | 2,518 | |||||||||
Diluted Shares Outstanding, MM | 402 | |||||||||
Equity Value Per Share | 6.27 |
What You Will Get
- Real LEVI Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are computed in real-time.
- Scenario Analysis: Explore various scenarios to assess Levi Strauss & Co.'s future performance.
- User-Friendly Interface: Designed for professionals but easy for newcomers to navigate.
Key Features
- Comprehensive Historical Data: Access Levi Strauss & Co.'s (LEVI) past financial statements and pre-filled projections.
- Customizable Assumptions: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Insights: Observe the recalculation of Levi's intrinsic value instantly.
- Intuitive Visualizations: Dashboard graphs present valuation outcomes and essential metrics clearly.
- Designed for Precision: A reliable tool tailored for analysts, investors, and finance professionals.
How It Works
- Step 1: Download the prebuilt Excel template with Levi Strauss & Co.'s (LEVI) data included.
- Step 2: Explore the pre-filled sheets and familiarize yourself with the key performance indicators.
- Step 3: Update forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly view recalculated results, including Levi Strauss & Co.'s (LEVI) intrinsic value.
- Step 5: Make informed investment decisions or generate reports using the outputs.
Why Choose This Calculator for Levi Strauss & Co. (LEVI)?
- Designed for Industry Experts: A sophisticated tool tailored for analysts, CFOs, and financial consultants.
- Accurate Financial Data: Levi Strauss & Co.’s historical and projected financials are preloaded for precision.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Comprehensive Outputs: Automatically calculates intrinsic value, NPV, and essential metrics.
- User-Friendly Interface: Step-by-step guidance makes the process straightforward.
Who Should Use This Product?
- Fashion Students: Explore industry trends and apply them using real market data.
- Researchers: Integrate established models into academic projects or studies.
- Investors: Evaluate your own strategies and analyze valuation outcomes for Levi Strauss & Co. (LEVI).
- Market Analysts: Enhance your analysis with a ready-to-use, customizable financial model.
- Entrepreneurs: Understand how major apparel brands like Levi Strauss & Co. (LEVI) are assessed in the market.
What the Template Contains
- Pre-Filled DCF Model: Levi Strauss & Co.’s financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Levi Strauss & Co.’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.