Walgreens Boots Alliance, Inc. (WBA) 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
Walgreens Boots Alliance, Inc. (WBA) Bundle
Looking to determine the intrinsic value of Walgreens Boots Alliance, Inc.? Our WBA DCF Calculator integrates real-world data with comprehensive customization features, enabling you to refine your forecasts and enhance your investment choices.
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 | 121,982.0 | 132,509.0 | 132,703.0 | 139,081.0 | 147,658.0 | 154,948.4 | 162,598.8 | 170,626.9 | 179,051.4 | 187,891.9 |
| Revenue Growth, % | 0 | 8.63 | 0.14641 | 4.81 | 6.17 | 4.94 | 4.94 | 4.94 | 4.94 | 4.94 |
| EBITDA | 2,843.0 | 5,958.0 | 4,955.0 | 3,479.0 | -11,278.0 | 1,681.0 | 1,764.0 | 1,851.1 | 1,942.5 | 2,038.4 |
| EBITDA, % | 2.33 | 4.5 | 3.73 | 2.5 | -7.64 | 1.08 | 1.08 | 1.08 | 1.08 | 1.08 |
| Depreciation | 1,627.0 | 1,689.0 | 1,683.0 | 1,886.0 | 2,459.0 | 2,137.7 | 2,243.2 | 2,354.0 | 2,470.2 | 2,592.2 |
| Depreciation, % | 1.33 | 1.27 | 1.27 | 1.36 | 1.67 | 1.38 | 1.38 | 1.38 | 1.38 | 1.38 |
| EBIT | 1,216.0 | 4,269.0 | 3,272.0 | 1,593.0 | -13,737.0 | -456.7 | -479.2 | -502.9 | -527.7 | -553.8 |
| EBIT, % | 0.99687 | 3.22 | 2.47 | 1.15 | -9.3 | -0.29474 | -0.29474 | -0.29474 | -0.29474 | -0.29474 |
| Total Cash | 516.0 | 1,193.0 | 2,472.0 | 739.0 | 3,109.0 | 1,804.5 | 1,893.6 | 1,987.1 | 2,085.2 | 2,188.2 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 3,010.0 | 5,663.0 | 5,017.0 | 5,381.0 | 5,851.0 | 5,687.7 | 5,968.5 | 6,263.2 | 6,572.4 | 6,896.9 |
| Account Receivables, % | 2.47 | 4.27 | 3.78 | 3.87 | 3.96 | 3.67 | 3.67 | 3.67 | 3.67 | 3.67 |
| Inventories | 9,451.0 | 8,159.0 | 8,353.0 | 8,257.0 | 8,320.0 | 9,845.8 | 10,331.9 | 10,842.0 | 11,377.3 | 11,939.1 |
| Inventories, % | 7.75 | 6.16 | 6.29 | 5.94 | 5.63 | 6.35 | 6.35 | 6.35 | 6.35 | 6.35 |
| Accounts Payable | 10,145.0 | 11,136.0 | 11,255.0 | 12,635.0 | 14,082.0 | 13,580.8 | 14,251.3 | 14,955.0 | 15,693.4 | 16,468.2 |
| Accounts Payable, % | 8.32 | 8.4 | 8.48 | 9.08 | 9.54 | 8.76 | 8.76 | 8.76 | 8.76 | 8.76 |
| Capital Expenditure | -1,374.0 | -1,379.0 | -1,734.0 | -2,117.0 | -1,381.0 | -1,838.0 | -1,928.8 | -2,024.0 | -2,124.0 | -2,228.8 |
| Capital Expenditure, % | -1.13 | -1.04 | -1.31 | -1.52 | -0.93527 | -1.19 | -1.19 | -1.19 | -1.19 | -1.19 |
| Tax Rate, % | 39.19 | 39.19 | 39.19 | 39.19 | 39.19 | 39.19 | 39.19 | 39.19 | 39.19 | 39.19 |
| EBITAT | 1,162.5 | 4,138.7 | 3,516.0 | 911.0 | -8,353.2 | -375.0 | -393.5 | -412.9 | -433.3 | -454.7 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -900.5 | 4,078.7 | 4,036.0 | 1,792.0 | -6,361.2 | -1,939.0 | -175.5 | -184.1 | -193.2 | -202.8 |
| WACC, % | 4.93 | 4.98 | 5.09 | 3.57 | 3.69 | 4.45 | 4.45 | 4.45 | 4.45 | 4.45 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -2,504.2 | |||||||||
| Long Term Growth Rate, % | 3.00 | |||||||||
| Free cash flow (T + 1) | -209 | |||||||||
| Terminal Value | -14,388 | |||||||||
| Present Terminal Value | -11,573 | |||||||||
| Enterprise Value | -14,077 | |||||||||
| Net Debt | 31,533 | |||||||||
| Equity Value | -45,610 | |||||||||
| Diluted Shares Outstanding, MM | 863 | |||||||||
| Equity Value Per Share | -52.84 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real WBA financials.
- Real-World Data: Historical data and forward-looking estimates (as highlighted in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe how your inputs affect Walgreens Boots Alliance’s valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.
Key Features
- 🔍 Real-Life WBA Financials: Pre-filled historical and projected data for Walgreens Boots Alliance, Inc. (WBA).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Walgreens' intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Walgreens' valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Download the Template: Get instant access to the Excel-based WBA DCF Calculator.
- Input Your Assumptions: Adjust yellow-highlighted cells for growth rates, WACC, margins, and more.
- Instant Calculations: The model automatically updates Walgreens Boots Alliance's intrinsic value.
- Test Scenarios: Simulate different assumptions to evaluate potential valuation changes.
- Analyze and Decide: Use the results to guide your investment or financial analysis.
Why Choose This Calculator?
- Accurate Data: Real Walgreens Boots Alliance, Inc. (WBA) financials ensure reliable valuation results.
- Customizable: Adjust key parameters like growth rates, WACC, and tax rates to align with your projections.
- Time-Saving: Pre-built calculations save you from starting from scratch.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants.
- User-Friendly: Intuitive design and step-by-step guidance make it accessible for all users.
Who Should Use Walgreens Boots Alliance, Inc. (WBA)?
- Investors: Make informed decisions with insights from a leading pharmacy and health retailer.
- Financial Analysts: Streamline your analysis with access to comprehensive financial data and reports.
- Consultants: Customize strategies and presentations utilizing the robust offerings of WBA.
- Healthcare Enthusiasts: Enhance your knowledge of the retail pharmacy landscape and its impact on health.
- Educators and Students: Utilize WBA as a case study in courses focused on finance and healthcare management.
What the Template Contains
- Pre-Filled Data: Includes Walgreens Boots Alliance’s historical financials and forecasts.
- 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 Walgreens Boots Alliance’s profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.