El Pollo Loco Holdings, Inc. (LOCO) 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
El Pollo Loco Holdings, Inc. (LOCO) Bundle
Evaluate the financial outlook of El Pollo Loco Holdings, Inc. (LOCO) like a pro! This (LOCO) DCF Calculator comes with pre-filled financials and offers you the complete flexibility to modify revenue growth, WACC, margins, and other essential assumptions to align with your predictions.
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 | 442.3 | 426.1 | 454.4 | 470.0 | 468.7 | 475.8 | 483.1 | 490.5 | 498.0 | 505.6 |
Revenue Growth, % | 0 | -3.67 | 6.64 | 3.43 | -0.27556 | 1.53 | 1.53 | 1.53 | 1.53 | 1.53 |
EBITDA | 59.5 | 56.2 | 59.9 | 44.5 | 55.1 | 58.1 | 59.0 | 59.9 | 60.8 | 61.8 |
EBITDA, % | 13.46 | 13.2 | 13.19 | 9.47 | 11.76 | 12.21 | 12.21 | 12.21 | 12.21 | 12.21 |
Depreciation | 17.9 | 16.9 | 15.2 | 14.4 | 15.2 | 16.8 | 17.1 | 17.3 | 17.6 | 17.9 |
Depreciation, % | 4.04 | 3.96 | 3.34 | 3.07 | 3.25 | 3.53 | 3.53 | 3.53 | 3.53 | 3.53 |
EBIT | 41.7 | 39.4 | 44.7 | 30.1 | 39.9 | 41.3 | 41.9 | 42.6 | 43.2 | 43.9 |
EBIT, % | 9.42 | 9.24 | 9.85 | 6.4 | 8.5 | 8.68 | 8.68 | 8.68 | 8.68 | 8.68 |
Total Cash | 8.1 | 13.2 | 30.0 | 20.5 | 7.3 | 16.6 | 16.9 | 17.1 | 17.4 | 17.7 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 8.9 | 12.5 | 13.4 | 10.9 | 10.3 | 11.8 | 12.0 | 12.2 | 12.3 | 12.5 |
Account Receivables, % | 2.01 | 2.93 | 2.95 | 2.31 | 2.2 | 2.48 | 2.48 | 2.48 | 2.48 | 2.48 |
Inventories | 2.0 | 2.1 | 2.3 | 2.4 | 1.9 | 2.3 | 2.3 | 2.3 | 2.4 | 2.4 |
Inventories, % | 0.45419 | 0.49286 | 0.51016 | 0.51962 | 0.40775 | 0.47692 | 0.47692 | 0.47692 | 0.47692 | 0.47692 |
Accounts Payable | 5.6 | 7.5 | 10.6 | 12.7 | 12.5 | 10.2 | 10.4 | 10.5 | 10.7 | 10.9 |
Accounts Payable, % | 1.27 | 1.75 | 2.34 | 2.71 | 2.68 | 2.15 | 2.15 | 2.15 | 2.15 | 2.15 |
Capital Expenditure | -15.4 | -6.7 | -17.0 | -19.9 | -21.3 | -16.8 | -17.0 | -17.3 | -17.5 | -17.8 |
Capital Expenditure, % | -3.49 | -1.57 | -3.75 | -4.24 | -4.55 | -3.52 | -3.52 | -3.52 | -3.52 | -3.52 |
Tax Rate, % | 26.73 | 26.73 | 26.73 | 26.73 | 26.73 | 26.73 | 26.73 | 26.73 | 26.73 | 26.73 |
EBITAT | 30.0 | 32.0 | 33.0 | 21.7 | 29.2 | 30.8 | 31.2 | 31.7 | 32.2 | 32.7 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 27.2 | 40.3 | 33.2 | 20.7 | 24.0 | 26.7 | 31.2 | 31.7 | 32.2 | 32.7 |
WACC, % | 7.96 | 8.13 | 8 | 7.96 | 7.99 | 8.01 | 8.01 | 8.01 | 8.01 | 8.01 |
PV UFCF | ||||||||||
SUM PV UFCF | 122.5 | |||||||||
Long Term Growth Rate, % | 1.00 | |||||||||
Free cash flow (T + 1) | 33 | |||||||||
Terminal Value | 471 | |||||||||
Present Terminal Value | 321 | |||||||||
Enterprise Value | 443 | |||||||||
Net Debt | 266 | |||||||||
Equity Value | 177 | |||||||||
Diluted Shares Outstanding, MM | 34 | |||||||||
Equity Value Per Share | 5.15 |
What You Will Receive
- Pre-Filled Financial Model: El Pollo Loco’s actual data provides accurate DCF valuation.
- Full Forecast Control: Modify revenue growth, profit margins, WACC, and other essential drivers.
- Instant Calculations: Automatic updates allow you to see results in real-time as you make adjustments.
- Investor-Ready Template: A polished Excel file crafted for professional-level valuation.
- Customizable and Reusable: Designed for adaptability, facilitating repeated use for comprehensive forecasts.
Key Features
- Authentic El Pollo Loco Financials: Access precise pre-loaded historical data and future forecasts for [LOCO].
- Tailored Forecast Assumptions: Modify yellow-highlighted cells such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Automatic updates to DCF, Net Present Value (NPV), and cash flow evaluations.
- Interactive Dashboard: User-friendly charts and summaries to visualize your valuation insights.
- Designed for All Skill Levels: A straightforward, intuitive layout suitable for investors, CFOs, and consultants alike.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review El Pollo Loco's pre-filled financial data and forecasts.
- Step 3: Modify key inputs like revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you adjust assumptions.
- Step 5: Analyze the outputs and leverage the results for investment decisions.
Why Choose This Calculator for El Pollo Loco Holdings, Inc. (LOCO)?
- Accurate Data: Real El Pollo Loco 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 in the food industry.
- User-Friendly: Intuitive design and clear instructions make it accessible for all users.
Who Should Use This Product?
- Restaurant Investors: Develop comprehensive valuation models for assessing El Pollo Loco Holdings, Inc. (LOCO) stock.
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the company.
- Consultants and Advisors: Deliver precise valuation analyses and insights for clients interested in El Pollo Loco Holdings, Inc. (LOCO).
- Students and Educators: Utilize real-time data to enhance learning and practice in financial modeling.
- Food Industry Enthusiasts: Gain insights into how restaurant chains like El Pollo Loco Holdings, Inc. (LOCO) are valued in the marketplace.
What the Template Contains
- Preloaded LOCO Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.