Bath & Body Works, Inc. (BBWI) 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
Bath & Body Works, Inc. (BBWI) Bundle
Explore Bath & Body Works, Inc. (BBWI) financial prospects with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to calculate the intrinsic value of Bath & Body Works, Inc. (BBWI) and enhance your investment strategy.
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,405.0 | 6,434.0 | 7,882.0 | 7,560.0 | 7,429.0 | 8,092.5 | 8,815.3 | 9,602.6 | 10,460.2 | 11,394.5 |
| Revenue Growth, % | 0 | 19.04 | 22.51 | -4.09 | -1.73 | 8.93 | 8.93 | 8.93 | 8.93 | 8.93 |
| EBITDA | 2,641.0 | 2,075.0 | 2,174.0 | 1,614.0 | 1,552.0 | 2,442.9 | 2,661.1 | 2,898.7 | 3,157.6 | 3,439.6 |
| EBITDA, % | 48.86 | 32.25 | 27.58 | 21.35 | 20.89 | 30.19 | 30.19 | 30.19 | 30.19 | 30.19 |
| Depreciation | 588.0 | 521.0 | 363.0 | 221.0 | 269.0 | 487.6 | 531.1 | 578.6 | 630.3 | 686.5 |
| Depreciation, % | 10.88 | 8.1 | 4.61 | 2.92 | 3.62 | 6.03 | 6.03 | 6.03 | 6.03 | 6.03 |
| EBIT | 2,053.0 | 1,554.0 | 1,811.0 | 1,393.0 | 1,283.0 | 1,955.3 | 2,129.9 | 2,320.2 | 2,527.4 | 2,753.1 |
| EBIT, % | 37.98 | 24.15 | 22.98 | 18.43 | 17.27 | 24.16 | 24.16 | 24.16 | 24.16 | 24.16 |
| Total Cash | 1,499.0 | 3,903.0 | 1,979.0 | 1,232.0 | 1,084.0 | 2,337.0 | 2,545.7 | 2,773.1 | 3,020.7 | 3,290.5 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 306.0 | 148.0 | 240.0 | 226.0 | 224.0 | 275.3 | 299.9 | 326.7 | 355.9 | 387.7 |
| Account Receivables, % | 5.66 | 2.3 | 3.04 | 2.99 | 3.02 | 3.4 | 3.4 | 3.4 | 3.4 | 3.4 |
| Inventories | 1,287.0 | 1,273.0 | 709.0 | 709.0 | 710.0 | 1,157.7 | 1,261.1 | 1,373.7 | 1,496.4 | 1,630.0 |
| Inventories, % | 23.81 | 19.79 | 9 | 9.38 | 9.56 | 14.31 | 14.31 | 14.31 | 14.31 | 14.31 |
| Accounts Payable | 647.0 | 345.0 | 435.0 | 455.0 | 380.0 | 550.0 | 599.2 | 652.7 | 711.0 | 774.5 |
| Accounts Payable, % | 11.97 | 5.36 | 5.52 | 6.02 | 5.12 | 6.8 | 6.8 | 6.8 | 6.8 | 6.8 |
| Capital Expenditure | -458.0 | -228.0 | -270.0 | -328.0 | -298.0 | -385.1 | -419.5 | -456.9 | -497.8 | -542.2 |
| Capital Expenditure, % | -8.47 | -3.54 | -3.43 | -4.34 | -4.01 | -4.76 | -4.76 | -4.76 | -4.76 | -4.76 |
| Tax Rate, % | 14.01 | 14.01 | 14.01 | 14.01 | 14.01 | 14.01 | 14.01 | 14.01 | 14.01 | 14.01 |
| EBITAT | -1,235.9 | 1,169.0 | 1,696.5 | 1,066.4 | 1,103.3 | 1,296.2 | 1,411.9 | 1,538.0 | 1,675.4 | 1,825.0 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -2,051.9 | 1,332.0 | 2,351.5 | 993.4 | 1,000.3 | 1,069.7 | 1,444.7 | 1,573.7 | 1,714.3 | 1,867.4 |
| WACC, % | 7.84 | 9.65 | 10.09 | 9.68 | 9.91 | 9.43 | 9.43 | 9.43 | 9.43 | 9.43 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 5,769.7 | |||||||||
| Long Term Growth Rate, % | 1.00 | |||||||||
| Free cash flow (T + 1) | 1,886 | |||||||||
| Terminal Value | 22,361 | |||||||||
| Present Terminal Value | 14,247 | |||||||||
| Enterprise Value | 20,017 | |||||||||
| Net Debt | 4,489 | |||||||||
| Equity Value | 15,528 | |||||||||
| Diluted Shares Outstanding, MM | 229 | |||||||||
| Equity Value Per Share | 67.81 |
What You Will Get
- Editable Forecast Inputs: Easily modify key assumptions (growth %, margins, WACC) to develop various scenarios.
- Real-World Data: Bath & Body Works, Inc. (BBWI) financial information pre-filled to kickstart your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically for you.
- Customizable and Professional: A refined Excel model designed to meet your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.
Key Features
- Real-Life BBWI Data: Pre-filled with Bath & Body Works' historical financials and forward-looking projections.
- Fully Customizable Inputs: Adjust revenue growth, margins, WACC, tax rates, and capital expenditures.
- Dynamic Valuation Model: Automatic updates to Net Present Value (NPV) and intrinsic value based on your inputs.
- Scenario Testing: Create multiple forecast scenarios to analyze different valuation outcomes.
- User-Friendly Design: Simple, structured, and designed for professionals and beginners alike.
How It Works
- Download the Template: Gain immediate access to the Excel-based BBWI DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model automatically recalculates Bath & Body Works’ intrinsic value.
- Test Scenarios: Experiment with different assumptions to assess potential valuation changes.
- Analyze and Decide: Leverage the results to inform your investment or financial analysis.
Why Choose This Calculator for Bath & Body Works, Inc. (BBWI)?
- User-Friendly Interface: Tailored for both novices and seasoned professionals.
- Customizable Inputs: Adjust parameters effortlessly to suit your analysis needs.
- Real-Time Feedback: Observe immediate updates to Bath & Body Works' valuation as you tweak inputs.
- Pre-Loaded Data: Comes with Bath & Body Works' actual financial metrics for rapid evaluation.
- Widely Endorsed: Favored by investors and analysts for making well-informed choices.
Who Should Use This Product?
- Individual Investors: Gain insights to make informed decisions about buying or selling Bath & Body Works stock (BBWI).
- Financial Analysts: Enhance valuation processes with ready-to-use financial models tailored for Bath & Body Works (BBWI).
- Consultants: Provide clients with accurate and timely valuation insights related to Bath & Body Works (BBWI).
- Business Owners: Learn about the valuation strategies of successful companies like Bath & Body Works (BBWI) to inform your own business decisions.
- Finance Students: Explore valuation techniques through real-world data and case studies involving Bath & Body Works (BBWI).
What the Template Contains
- Pre-Filled Data: Includes Bath & Body Works' historical financials and projections.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze Bath & Body Works' profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.