Ingles Markets, Incorporated (IMKTA) 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
Ingles Markets, Incorporated (IMKTA) Bundle
Evaluate Ingles Markets, Incorporated's (IMKTA) financial outlook like a professional! This (IMKTA) DCF Calculator provides you with pre-filled financial data and the flexibility to modify revenue growth, WACC, margins, and other crucial assumptions to align with your projections.
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 | 4,610.6 | 4,987.9 | 5,678.8 | 5,892.8 | .0 | .0 | .0 | .0 | .0 | .0 |
Revenue Growth, % | 0 | 8.18 | 13.85 | 3.77 | -100 | 2.61 | 2.61 | 2.61 | 2.61 | 2.61 |
EBITDA | 400.9 | 477.1 | 508.5 | 416.6 | .0 | .0 | .0 | .0 | .0 | .0 |
EBITDA, % | 8.7 | 9.56 | 8.95 | 7.07 | 100 | 26.86 | 26.86 | 26.86 | 26.86 | 26.86 |
Depreciation | 125.4 | 125.1 | 125.7 | 116.0 | .0 | .0 | .0 | .0 | .0 | .0 |
Depreciation, % | 2.72 | 2.51 | 2.21 | 1.97 | 100 | 21.88 | 21.88 | 21.88 | 21.88 | 21.88 |
EBIT | 275.6 | 351.9 | 382.8 | 300.6 | .0 | .0 | .0 | .0 | .0 | .0 |
EBIT, % | 5.98 | 7.06 | 6.74 | 5.1 | 100 | 24.97 | 24.97 | 24.97 | 24.97 | 24.97 |
Total Cash | 6.9 | 75.3 | 267.2 | 328.5 | .0 | .0 | .0 | .0 | .0 | .0 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 81.4 | 95.1 | 101.4 | 107.6 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables, % | 1.76 | 1.91 | 1.78 | 1.83 | 100 | 21.46 | 21.46 | 21.46 | 21.46 | 21.46 |
Inventories | 366.8 | 390.0 | 457.9 | 493.9 | .0 | .0 | .0 | .0 | .0 | .0 |
Inventories, % | 7.96 | 7.82 | 8.06 | 8.38 | 100 | 26.44 | 26.44 | 26.44 | 26.44 | 26.44 |
Accounts Payable | 204.1 | 189.4 | 213.4 | 204.0 | .0 | .0 | .0 | .0 | .0 | .0 |
Accounts Payable, % | 4.43 | 3.8 | 3.76 | 3.46 | 100 | 23.09 | 23.09 | 23.09 | 23.09 | 23.09 |
Capital Expenditure | -122.8 | -140.6 | -119.6 | -173.6 | -210,855.6 | .0 | .0 | .0 | .0 | .0 |
Capital Expenditure, % | -2.66 | -2.82 | -2.11 | -2.95 | 100 | -2.11 | -2.11 | -2.11 | -2.11 | -2.11 |
Tax Rate, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
EBITAT | 209.4 | 268.3 | 289.0 | 227.5 | .0 | .0 | .0 | .0 | .0 | .0 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -32.1 | 201.3 | 244.8 | 118.4 | -210,458.2 | .0 | .0 | .0 | .0 | .0 |
WACC, % | 7.83 | 7.83 | 7.83 | 7.83 | 7.83 | 7.83 | 7.83 | 7.83 | 7.83 | 7.83 |
PV UFCF | ||||||||||
SUM PV UFCF | .0 | |||||||||
Long Term Growth Rate, % | 0.50 | |||||||||
Free cash flow (T + 1) | 0 | |||||||||
Terminal Value | 0 | |||||||||
Present Terminal Value | 0 | |||||||||
Enterprise Value | 0 | |||||||||
Net Debt | 0 | |||||||||
Equity Value | 0 | |||||||||
Diluted Shares Outstanding, MM | 19 | |||||||||
Equity Value Per Share | 0.00 |
What You Will Get
- Real IMKTA Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Automated Calculations: Intrinsic value and NPV are calculated in real-time.
- Scenario Analysis: Evaluate various scenarios to assess Ingles Markets' future performance.
- User-Friendly Design: Designed for professionals while remaining approachable for newcomers.
Key Features
- 🔍 Real-Life IMKTA Financials: Pre-filled historical and projected data for Ingles Markets, Incorporated.
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Ingles Markets’ intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Ingles Markets’ valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Download: Obtain the pre-configured Excel file featuring Ingles Markets, Incorporated's (IMKTA) financial data.
- Customize: Modify projections, such as revenue growth, EBITDA %, and WACC.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop various projections and instantly compare results.
- Make Decisions: Utilize the valuation findings to inform your investment strategy.
Why Choose Ingles Markets, Incorporated (IMKTA)?
- Save Time: Quickly access essential financial metrics without starting from scratch.
- Enhance Accuracy: Dependable financial data and calculations minimize valuation discrepancies.
- Fully Adaptable: Modify the model to align with your specific forecasts and assumptions.
- Simple to Understand: Intuitive charts and outputs facilitate straightforward analysis of results.
- Endorsed by Professionals: Crafted for experts who prioritize both precision and ease of use.
Who Should Use Ingles Markets, Incorporated (IMKTA)?
- Investors: Gain insights and make informed decisions with a reliable market analysis tool.
- Financial Analysts: Streamline your work with an easily customizable financial model tailored for retail analysis.
- Consultants: Effortlessly modify reports and presentations for your clients in the grocery sector.
- Finance Enthusiasts: Enhance your knowledge of retail valuation strategies through practical examples.
- Educators and Students: Utilize this resource as a hands-on tool in courses focused on finance and market dynamics.
What the Template Contains
- Pre-Filled Data: Contains Ingles Markets' historical financials and projections.
- Discounted Cash Flow Model: An editable DCF valuation model featuring automatic calculations.
- Weighted Average Cost of Capital (WACC): A specific sheet for calculating WACC using customized inputs.
- Key Financial Ratios: Evaluate Ingles Markets' profitability, efficiency, and leverage metrics.
- Customizable Inputs: Easily modify revenue growth rates, profit margins, and tax rates.
- Clear Dashboard: Visual representations and tables summarizing essential valuation outcomes.