Weis Markets, Inc. (WMK) 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
Weis Markets, Inc. (WMK) Bundle
Assess Weis Markets, Inc.'s financial outlook like an expert! This (WMK) DCF Calculator provides pre-filled financial data along with 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 | 3,543.3 | 4,112.6 | 4,224.4 | 4,695.9 | 4,697.0 | 5,048.9 | 5,427.1 | 5,833.8 | 6,270.8 | 6,740.7 |
Revenue Growth, % | 0 | 16.07 | 2.72 | 11.16 | 0.02144404 | 7.49 | 7.49 | 7.49 | 7.49 | 7.49 |
EBITDA | 178.3 | 262.5 | 249.5 | 261.1 | 245.6 | 283.9 | 305.1 | 328.0 | 352.6 | 379.0 |
EBITDA, % | 5.03 | 6.38 | 5.91 | 5.56 | 5.23 | 5.62 | 5.62 | 5.62 | 5.62 | 5.62 |
Depreciation | 93.7 | 99.4 | 102.8 | 104.0 | 108.4 | 121.4 | 130.5 | 140.2 | 150.7 | 162.0 |
Depreciation, % | 2.64 | 2.42 | 2.43 | 2.22 | 2.31 | 2.4 | 2.4 | 2.4 | 2.4 | 2.4 |
EBIT | 84.6 | 163.2 | 146.7 | 157.1 | 137.2 | 162.5 | 174.7 | 187.8 | 201.9 | 217.0 |
EBIT, % | 2.39 | 3.97 | 3.47 | 3.34 | 2.92 | 3.22 | 3.22 | 3.22 | 3.22 | 3.22 |
Total Cash | 149.3 | 271.2 | 318.9 | 367.1 | 436.9 | 358.2 | 385.1 | 413.9 | 444.9 | 478.3 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 55.8 | 56.8 | 52.1 | 50.9 | 65.1 | 67.2 | 72.3 | 77.7 | 83.5 | 89.7 |
Account Receivables, % | 1.57 | 1.38 | 1.23 | 1.08 | 1.39 | 1.33 | 1.33 | 1.33 | 1.33 | 1.33 |
Inventories | 279.8 | 269.0 | 269.6 | 293.3 | 296.2 | 337.0 | 362.2 | 389.3 | 418.5 | 449.9 |
Inventories, % | 7.9 | 6.54 | 6.38 | 6.25 | 6.31 | 6.67 | 6.67 | 6.67 | 6.67 | 6.67 |
Accounts Payable | 180.7 | 221.6 | 218.8 | 206.8 | 226.2 | 251.3 | 270.1 | 290.4 | 312.1 | 335.5 |
Accounts Payable, % | 5.1 | 5.39 | 5.18 | 4.4 | 4.82 | 4.98 | 4.98 | 4.98 | 4.98 | 4.98 |
Capital Expenditure | -102.9 | -131.1 | -152.0 | -123.0 | -105.1 | -146.9 | -157.9 | -169.7 | -182.5 | -196.1 |
Capital Expenditure, % | -2.91 | -3.19 | -3.6 | -2.62 | -2.24 | -2.91 | -2.91 | -2.91 | -2.91 | -2.91 |
Tax Rate, % | 29.22 | 29.22 | 29.22 | 29.22 | 29.22 | 29.22 | 29.22 | 29.22 | 29.22 | 29.22 |
EBITAT | 64.9 | 118.6 | 107.7 | 122.3 | 97.1 | 120.7 | 129.8 | 139.5 | 149.9 | 161.2 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -99.2 | 137.4 | 59.8 | 69.0 | 102.7 | 77.4 | 90.8 | 97.7 | 105.0 | 112.8 |
WACC, % | 6.36 | 6.35 | 6.35 | 6.37 | 6.34 | 6.35 | 6.35 | 6.35 | 6.35 | 6.35 |
PV UFCF | ||||||||||
SUM PV UFCF | 399.2 | |||||||||
Long Term Growth Rate, % | 1.00 | |||||||||
Free cash flow (T + 1) | 114 | |||||||||
Terminal Value | 2,128 | |||||||||
Present Terminal Value | 1,564 | |||||||||
Enterprise Value | 1,963 | |||||||||
Net Debt | -1 | |||||||||
Equity Value | 1,964 | |||||||||
Diluted Shares Outstanding, MM | 27 | |||||||||
Equity Value Per Share | 73.03 |
What You Will Get
- Pre-Filled Financial Model: Weis Markets’ actual data enables precise DCF valuation.
- Full Forecast Control: Adjust revenue growth, margins, WACC, and other key drivers.
- Instant Calculations: Automatic updates ensure you see results as you make changes.
- Investor-Ready Template: A refined Excel file designed for professional-grade valuation.
- Customizable and Reusable: Tailored for flexibility, allowing repeated use for detailed forecasts.
Key Features
- Comprehensive Financial Data: Weis Markets, Inc.'s (WMK) historical financial statements and detailed forecasts.
- Customizable Parameters: Modify WACC, tax rates, revenue growth, and EBITDA margins to suit your analysis.
- Real-Time Valuation: Observe the intrinsic value of Weis Markets, Inc. (WMK) update instantly.
- Intuitive Visualizations: Engaging dashboard charts illustrate valuation outcomes and essential metrics.
- Designed for Precision: A reliable tool tailored for analysts, investors, and finance professionals.
How It Works
- Step 1: Download the prebuilt Excel template with Weis Markets, Inc. (WMK) data included.
- Step 2: Explore the pre-filled sheets and familiarize yourself with the key metrics.
- Step 3: Update forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly view recalculated results, including Weis Markets, Inc. (WMK)'s intrinsic value.
- Step 5: Make informed investment decisions or generate reports using the outputs.
Why Choose This Calculator?
- Designed for Experts: A sophisticated tool utilized by financial analysts, CFOs, and industry consultants.
- Up-to-Date Data: Weis Markets, Inc. (WMK) historical and projected financials included for reliable insights.
- What-If Analysis: Effortlessly test various scenarios and assumptions.
- Concise Results: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly: Comprehensive step-by-step guidance to assist you throughout the process.
Who Should Use Weis Markets, Inc. (WMK)?
- Investors: Gain insights into the grocery retail sector with comprehensive market analysis.
- Financial Analysts: Utilize detailed financial reports to enhance your market assessments.
- Consultants: Tailor reports and presentations using data-driven insights from Weis Markets, Inc. (WMK).
- Retail Enthusiasts: Explore the operational strategies of a leading grocery chain through case studies.
- Educators and Students: Apply real-world examples in coursework related to retail management and finance.
What the Template Contains
- Pre-Filled DCF Model: Weis Markets, Inc.'s (WMK) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Weis Markets, Inc.'s (WMK) 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.